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 >= 1725083170 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 >= 1725083170 GROUP BY Calendars.DateStart ASC LIMIT 3You 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 >= 1725083170 GROUP BY Calendars.DateStart ASC LIMIT 3' at line 13