Сырой запрос в ORM Laravel

Как переписать этот запрос на ORM DB Laravel?

SELECT * FROM products AS P
LEFT JOIN category_products AS CP ON CP.product_id = P.id
WHERE
CP.category_id = 3
AND
(
    SELECT COUNT(*) FROM product_attributes AS PA
    LEFT JOIN features AS F ON F.id = PA.feature_id
    LEFT JOIN properties AS P ON P.id = PA.property_id
    WHERE
    (
        F.slug = 'cvet' AND P.slug IN ('cernyi', 'bezevyi')
    )
    OR
    (
        F.slug = 'sezon' AND P.slug IN ('leto')
    )
) >= 2

Что я сделал

$products = DB::table('products AS P')
                ->leftJoin('category_products AS CP', 'CP.product_id', '=', 'P.id')
                ->where('CP.category_id', $category->id);

Дальше не знаю как делать, спасибо!