php - 混合 OR & AND mysql 查询错误结果 (laravel)

Question

我正在使用 eloquent 查询生成器，这是特定查询生成的结果:

select * from `articles` where (select count(*) from `authors` where `authors`.`article_id` = `articles`.`id` and `author` like ?) >= 1 or `title` LIKE ? and `approved` = ? or (select count(*) from `tags` where `tags`.`article_id` = `articles`.`id` and `tag` like ?) >= 1 or `abstract` LIKE ? or `description` LIKE ? and `year` NOT LIKE ?

问题是此查询仍然会生成与年份类似的结果，而不是如所述年份与年份不相似的结果。

这是我返回$query->toSql()时得到的结果。查询本身是使用 Laravel Eloquent 动态构建的，混合了 where、orWhere、whereHas 和 orWhereHas，但是如果我能理解这个查询出了什么问题，我应该能够更接近问题。

Answer 1

试试这个:

 SELECT *
FROM   `articles`
WHERE   (
        ((SELECT Count(*)
        FROM   `authors`
        WHERE  `authors`.`article_id` = `articles`.`id`
               AND `author` LIKE ?) >= 1)
        OR (`title` LIKE ?)

        OR ((SELECT Count(*)
            FROM   `tags`
            WHERE  `tags`.`article_id` = `articles`.`id`
                   AND `tag` LIKE ?) >= 1)
        OR (`abstract` LIKE ?)
        OR (`description` LIKE ?)
        )
        AND
        (`year` NOT LIKE ?
           AND `approved` = ?)