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