php - MySQL 查询不检查条件

Question

我有一个这样的查询:

    select * from `research_purchases` left join `company_research_articles`
 on `research_purchases`.`researchable_id` = `company_research_articles`.`id` 
and `research_purchases`.`researchable_type` = 'Modules\Analystsweb\Entities
\CompanyResearchArticle'

research_purchases表结构是这样的:

它没有过滤“Modules\Analystsweb\Entities\CompanyResearchArticle”部分并给我整个结果。这是我陷入困境的部分。

最初我想运行一个 Laravel 查询。查询如下:

$sales = DB::table('research_purchases')->select(DB::raw('count(research_purchases.id) as sales_count, research_purchases.created_at'))->leftJoin('company_research_articles', function ($join) {
                                        $join->on('research_purchases.researchable_id', '=', 'company_research_articles.id')
                                            ->where('research_purchases.researchable_type', '=', 'Modules\Analystsweb\Entities\CompanyResearchArticle');
                                    })
                                    ->where('research_purchases.created_at', '>', Carbon::now()->subMonths(11))
                                    ->groupBy(DB::raw("MONTH(research_purchases.created_at)"))
                                    ->get();

如有任何建议，我们将不胜感激。谢谢。

Answer 1

哦，亲爱的，你应该把它放在 where 条件

如果你想左连接右表的where条件上的所有数据，那么你可以将其与连接

select * from `research_purchases` left join `company_research_articles`
 on `research_purchases`.`researchable_id` = `company_research_articles`.`id` 

where  `research_purchases`.`researchable_type` = 'Modules\Analystsweb\Entities
\CompanyResearchArticle'