| VOM Calendar

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 >= 1734789892 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 >= 1734789892 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 >= 1734789892 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 14| VOM Calendar

Data

Practical information

« Back to overview