Error description: Unknown column 'public' in 'where clause' strSQL=SELECT urlConvertID, note, shortURL, E.eventName, textEventDates, venueAddress,
(SELECT url FROM EventImage B WHERE B.eventID = A.eventID AND type = 'banner') as banner,
CASE
WHEN YEARWEEK(eventStartDate, 1) = YEARWEEK(CURDATE(), 1) THEN 1
ELSE 0
END as thisWeek
FROM UrlConvert U
JOIN EventInstance EI ON U.eventInstanceID = EI.eventInstanceID
JOIN Application A ON U.applicationID = A.applicationID
JOIN Event E ON E.eventID = A.eventID
WHERE EI.active = 1
AND A.active = 1
AND public = 1
AND EI.endDate > CURRENT_TIMESTAMP
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www/html/app/system/SQL/Mysql.php on line 47 Event Horizon | Event listings
