SELECT
Calendars.*,
CONCAT_WS(' ',MONTHNAME(FROM_UNIXTIME(Calendars.DateStart)),YEAR(FROM_UNIXTIME(Calendars.DateStart))) AS StartMonthName,
MONTH(FROM_UNIXTIME(Calendars.DateStart)) AS StartMonth,
YEAR(FROM_UNIXTIME(Calendars.DateStart)) AS StartYear,
DAY(FROM_UNIXTIME(Calendars.DateStart)) AS StartDay,
CalendarCategories.Name as CategoryName,
CalendarCategories.NameTranslations as CategoryNameTranslations,
CalendarMainCategories.Name as MainCategoryName,
CalendarMainCategories.NameTranslations as MainCategoryNameTranslations
FROM Calendars
LEFT JOIN CalendarCategories ON CalendarCategories.CalendarCategoryID = Calendars.CalendarCategoryID
LEFT JOIN CalendarMainCategories ON CalendarMainCategories.CalendarMainCategoryID = CalendarCategories.CalendarMainCategoryID WHERE Calendars.Website = 1 AND Calendars.SessionPart = 0 AND Calendars.CalendarID != AND Calendars.DateEnd >= 1615073628 GROUP BY Calendars.DateStart ASC LIMIT 3
SELECT
Calendars.*,
CONCAT_WS(' ',MONTHNAME(FROM_UNIXTIME(Calendars.DateStart)),YEAR(FROM_UNIXTIME(Calendars.DateStart))) AS StartMonthName,
MONTH(FROM_UNIXTIME(Calendars.DateStart)) AS StartMonth,
YEAR(FROM_UNIXTIME(Calendars.DateStart)) AS StartYear,
DAY(FROM_UNIXTIME(Calendars.DateStart)) AS StartDay,
CalendarCategories.Name as CategoryName,
CalendarCategories.NameTranslations as CategoryNameTranslations,
CalendarMainCategories.Name as MainCategoryName,
CalendarMainCategories.NameTranslations as MainCategoryNameTranslations
FROM Calendars
LEFT JOIN CalendarCategories ON CalendarCategories.CalendarCategoryID = Calendars.CalendarCategoryID
LEFT JOIN CalendarMainCategories ON CalendarMainCategories.CalendarMainCategoryID = CalendarCategories.CalendarMainCategoryID WHERE Calendars.Website = 1 AND Calendars.SessionPart = 0 AND Calendars.CalendarID != AND Calendars.DateEnd >= 1615073628 GROUP BY Calendars.DateStart ASC LIMIT 3
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND Calendars.DateEnd >= 1615073628 GROUP BY Calendars.DateStart ASC LIMIT 3' at line 13 Bestand " /home/vom/domains/vom.be/public_html/frontend/calandars/calendars.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/vom/domains/vom.be/public_html/frontend/calandars/calendars.php op lijn 96
Implementatie bestand /home/vom/domains/vom.be/public_html/pages/events_detail.php op lijn 16| VOM Agenda
