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
  • Over ons
  • Promosurf
  • Links
  • Contact
  • Online Tools
  • Vacatures
Account iconLogin voor leden
  • NL
  • FR
  • EN
  • NL
  • FR
  • EN
  • Leden
  • Nieuws
  • Agenda
  • Opleidingen
  • Kenniscentrum
  • Login voor leden
  • Over ons
  • Promosurf
  • Links
  • Contact
  • Vacatures
  • Online Tools
  • Kwaliteitslabels
  • Young VOM

  1. Home
  2. Agenda

Meer Events

Data

Praktische informatie

« Terug naar overzicht
  • Share

Navigatie

  • Leden
  • Nieuws
  • Agenda
  • Opleidingen
  • Kwaliteitslabels
  • Kenniscentrum
  • Online tools
  • Over ons
  • Promosurf
  • Links
  • Contact
  • Vacatures

Vacatures

  • VOM vzwFreelance verkoopmedewerker: Zet u een lead om in een deal?
  • VOM vzwcompetente lesgevers (m/v) in oppervlaktebehandeling
  • Bega Gantenbrink BuitenverlichtingMedewerker voorbehandeling
Meer vacatures

Nieuwsbrief

Schrijf u in op de VOM nieuwsbrief door het invullen van uw e-mailadres!

© 2021 . Alle rechten voorbehouden - Disclaimer - Privacy

Website by Webatvantage