AN
Size: a a a
AN
PB
RT
PB
ПЛ
RT
PB
AN
PB
AN
PB
AN
PB
ДК
\DB::from('its_menu AS m')
->select([
\DB::raw('DISTINCT m.title'),
\DB::raw('COUNT(DISTINCT p.id) AS total'),
])
->leftJoin('its_menu AS sm', 'sm.parent_id', 'm.id')
->leftJoin('its_products AS p', static function (Builder $query) {
$query->on('p.menu', '=', 'sm.id');
$query->orWhereIn(
\DB::table('its_product_category AS pc')->select('pc.category_id')->where('pc.product_id', \DB::raw('p.id'))
);
})
->where('m.vertical_menu', 1)
->where('m.has_products' '>', 0)
->whereIn('p.id', [256359,256344])
->groupBy('m.id')
->orderBy('total', 'DESC');
E_
E
E
PB
ДК