SELECT count(*) as `count` FROM `xxx_9_media_main` as `main_table` left join `xxx_9_media_props` as `property_table` on `property_table`.`element`=`main_table`.`id` left join `xxx_8_video_main` as `video_id_table_main` on `video_id_table_main`.`id`=`property_table`.`video_id` left join `xxx_8_video_props` as `video_id_table_props` on `video_id_table_main`.`id`=`video_id_table_props`.`element` left join `xxx_sections` as `gallery_table_main` on `property_table`.`gallery_id`=`gallery_table_main`.`id` and `gallery_table_main`.`category`='7' left join `xxx_section_add_file` as `gallery_table_props_cover` on `gallery_table_props_cover`.`element`=`gallery_table_main`.`id` and `gallery_table_props_cover`.`add`='2' WHERE ( (`main_table`.`published` = '1') and (`property_table`.`date` >= '%7B%7Bsrc%7D%7D-01-01 00:00:00') and (`property_table`.`date` <= '%7B%7Bsrc%7D%7D-12-31 23:59:59')) Incorrect DATETIME value: '%7B%7Bsrc%7D%7D-01-01 00:00:00'DB error