mysql - SQL:未知列 'items.id'关系查询

Question

我对此查询有疑问。我认为问题在于找不到项目。之后我对其进行 LEFT OUTER JOIN 操作，但在此之前什么也没做。在开头包含 items 表的最佳解决方案是什么？

SELECT COUNT(*) AS `numrows` FROM (`categories_items`) 
LEFT OUTER JOIN `items_stones` `items_stones` ON `items`.`id` = `items_stones`.`item_model_id` 
LEFT OUTER JOIN `items` ON `items`.`id` = `categories_items`.`item_model_id` 
WHERE ( `items_stones`.`stone_model_id` = 1 ) AND `categories_items`.`category_model_id` = 1

Answer 1

将查询更改为如下所示，基本上交换LEFT JOINS

    SELECT COUNT(*) AS `numrows` 
    FROM `categories_items` 
    LEFT OUTER JOIN `items` ON `items`.`id` = `categories_items`.`item_model_id`
   AND `categories_items`.`category_model_id` = 1
    LEFT OUTER JOIN `items_stones` ON `items`.`id` = `items_stones`.`item_model_id` 
 AND `items_stones`.`stone_model_id` = 1;