Добрый день. Не могу сообразить как такой запрос описать в Query Builder или Eloquent Помогите пожалуйста
SELECT DISTINCT m.title, COUNT(DISTINCT
p.id) AS
total
FROM its_menu AS m
LEFT JOIN its_menu AS sm ON sm.parent_id =
m.idLEFT JOIN its_products AS p ON
p.menu =
sm.id OR
sm.id IN (SELECT pc.category_id FROM its_product_category AS pc WHERE pc.product_id =
p.id)
WHERE m.vertical_menu = 1 AND m.has_products > 0
AND
p.id IN (256359,256344)
GROUP BY
m.idORDER BY
total
DESC