Как создать этот запрос с помощью Eloquent?
SELECT
*
FROM
`contents`
WHERE
`id` NOT IN (
SELECT
`id`
FROM
`contents` AS `laravel_reserved_0`
WHERE
`laravel_reserved_0`.`parent_id` IN (
SELECT
`id`
FROM
`contents` AS `laravel_reserved_1`
WHERE
`laravel_reserved_1`.`type` IN ( 'pro' )
)
)
AND `is_active` = 1
AND `type` IN ( 'stars', 'video', 'article' )
GROUP BY
`slug`
ORDER BY
`created_at` DESC
LIMIT 10