FILTER YOUR RESULTS TO THE LEFT.
MySQL SERVER ERROR
25/06/2017 11:24:42
SQL Server Details
Host: db1.citizenticket.co.uk
Database: ct_db
Username: ct_db
Website Details
URL: www.citizenticket.co.uk/all-events/?tag%5B%5D=107/
Method: GET
User Details
IP: 54.167.225.62
User Agent: CCBot/2.0 (http://commoncrawl.org/faq/)
SQL
SELECT SQL_CALC_FOUND_ROWS e.e_id FROM event e LEFT JOIN event_date ed ON e.e_id = ed.ed_e_id LEFT OUTER JOIN venue v ON v.v_id = e.e_v_id LEFT OUTER JOIN event_admin_access eaa ON eaa.event_id = e.e_id LEFT JOIN event_to_category e2c ON e.e_id = e2c.e_id WHERE e2c.c_id IN ( 107/ ) AND e.e_active = 1 AND ed.ed_active = 1 AND e.e_deleted = 0 AND ed.ed_deleted = 0 AND ed.ed_start >= "2017-06-25 00:00:00" GROUP BY e.e_id ORDER BY ed.ed_start ASC LIMIT 0,12
Errors
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 e.e_active = 1 AND ed.ed_active = 1 AND e.e_deleted = 0 AND ed.ed_deleted ' at line 4