SQL Error: Column 'item_id' in IN/ALL/ANY subquery is ambiguous at /var/www/teplo_trt/data/www/proteplo.me/plugins/dao/classes/modules/catalog/mapper/Catalog.mapper.class.php line 0
Array ( [code] => 1052 [message] => Column 'item_id' in IN/ALL/ANY subquery is ambiguous [query] => SELECT SQL_CALC_FOUND_ROWS ci.* FROM ls_catalog_item as ci JOIN ls_catalog_tag as ct ON ct.item_id = ci.item_id WHERE ct.item_tag_text = 'спектакль' and `item_publish` in ( '1' ) and `catalog_id` = '1' and ((`item_shedule` = 0 AND ((item_date_start >= '2018-12-15 00:00:00' AND item_date_start <= '2018-12-2223:59:59') OR (item_date_end >= '2018-12-15 00:00:00' AND item_date_end <= '2018-12-2223:59:59') OR (item_date_start <= '2018-12-15 00:00:00' AND item_date_end >= '2018-12-2223:59:59'))) OR (`item_shedule` = 1 AND `item_id` IN (SELECT `shedule_item_from_id` FROM ls_catalog_shedule as j WHERE j.`shedule_datefull` >= '2018-12-15 00:00:00' AND j.`shedule_datefull` <= '2018-12-2223:59:59' GROUP BY j.`shedule_item_from_id`))) ORDER BY `item_date_start` asc LIMIT 0, 10 [context] => /var/www/teplo_trt/data/www/proteplo.me/plugins/dao/classes/modules/catalog/mapper/Catalog.mapper.class.php line 0 )