Здравствуйте!
Подскажите, пожалуйста, что здесь не так с кодом, что выдаёт ошибку
Exception: Query error 1052: Column 'id' in where clause is ambiguous.
Указано же у какой таблицы брать id
$Shop_Controller_Show
->shopItems()
->queryBuilder()
->leftJoin('shop_warehouse_items', 'shop_warehouse_items.shop_item_id', '=', 'shop_items.id')
->having('SUM(shop_warehouse_items.count)', '>', 0)
->groupBy('shop_items.id');
Я так понимаю, что речь идёт в ошибке про этот id
Query: SELECT SQL_CALC_FOUND_ROWS `shop_items`.* FROM `shop_items` LEFT OUTER JOIN `shop_items` AS `modifications` ON `modifications`.`modification_id` = `shop_items`.`id` LEFT OUTER JOIN `shop_warehouse_items` AS `modifications_shop_warehouse_items` ON `modifications_shop_warehouse_items`.`shop_item_id` = `modifications`.`id` LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_items`.`id` WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2018-09-25 09:51:19' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2018-09-25 09:51:19' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`active` = 1 AND `id` IN ('37018', '38107', '38683', '38323', '38628', '39492', '37657', '37019', '37017', '37656', '37020', '37948', '38509', '38211', '38681', '38381', '38389', '38374', '38585', '38372', '38040', '38338', '38591', '38626', '38685', '38502', '38112', '38121', '38216', '38157', '38347', '38682', '37949', '38680', '38503', '37950', '38393', '37925', '38386', '38387', '38686', '38122', '38032', '38488', '37989', '38158', '38134', '38094', '38364', '38025', '38684', '38210', '38244', '37935', '38592', '38037', '38337', '38257', '38324', '38510', '38377', '38322', '37926', '37964', '38388', '38487', '37951', '37952', '37953', '37954', '37955', '37956', '37957', '37958', '38095', '38096', '38362', '38363', '38629', '38627', '38541', '39260', '39263', '39265', '39264', '39256', '39261', '39258', '39259', '39257', '39262', '39488', '39483', '39490', '39489', '39494', '39477', '39491', '39493', '39479') AND `shop_items`.`deleted` = 0 GROUP BY `shop_items`.`id` HAVING ( SUM(`shop_warehouse_items`.`count`) > 0 OR SUM(`modifications_shop_warehouse_items`.`count`) > 0 ) ORDER BY `shop_items`.`sorting` ASC, `shop_items`.`name` ASC LIMIT 30 OFFSET 0
но откуда он взялся?