Array
(
    [description] => SELECT count(*) AS itemsCount FROM (SELECT
            event_id,
            event_name, event_type,
            event_publish, event_register_allowed,
            event_description,
            UNIX_TIMESTAMP(event_date_start) AS event_date_start,
            UNIX_TIMESTAMP(event_date_end) AS event_date_end,
            event_region_id, event_city
            
            FROM events
             LEFT JOIN events_subjects ON events_subjects.fk_event_id=events.event_id
            WHERE 1=1
             AND (events_subjects.event_subject='it')  AND (event_region_id=10)  AND (event_publish!=1 AND event_region_id=)  AND (event_date_end >= CURDATE() AND event_date_start <= DATE_ADD(CURDATE(), INTERVAL 1 MONTH)) 
        ) AS res
    [time] => 0.0001220703125
    [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')  AND (event_date_end >= CURDATE() AND event_date_start <= DATE
)