带有 LEFT JOIN 的 MySQL WHERE 子句

Question

在下面的 SQL 查询中使用 WHERE 子句时出现语法错误。该查询在没有 where 子句的情况下工作，where 子句适用于没有连接的简单“SELECT * FROM”查询。原始查询使用 PDO 和绑定(bind)参数，但我在此示例中使用直接 SQL，因此我可以首先获得正确的语法。我哪里错了？

SELECT bk.*, au.author_firstname, au.author_surname, pu.publisher_name
FROM books bk
LEFT JOIN authors au ON bk.author_id = au.author_id
LEFT JOIN publishers pu ON bk.publisher_id = pu.publisher_id
ORDER BY title
WHERE bk.author_id = 13

Answer 1

   SELECT bk.*, au.author_firstname, au.author_surname, pu.publisher_name
     FROM books bk
LEFT JOIN authors au 
       ON bk.author_id = au.author_id
LEFT JOIN publishers pu 
       ON bk.publisher_id = pu.publisher_id
    WHERE bk.author_id = 13
 ORDER BY title

哪里在ORDER BY之前。