FATAL ERROR
SELECT COUNT(*) FROM lovin_events WHERE city_id = 194797 AND date > NOW() AND e.category = ';_new_date_tentative_198168'
ERROR: missing FROM-clause entry for table "e"
LINE 1: ...vents WHERE city_id = 194797 AND date > NOW() AND e.category...
^