How to convert this sql query to Eloquent ORM.

SQL Query

SELECT v.product_id
  FROM (
      SELECT product_id, count(*) AS matches 
        FROM product where filter_id IN (2,4)
    GROUP BY product_id
  ) AS v
WHERE v.matches = 2

I want to convert this query to Eloquent ORM.

jlrdw

6 years ago

Level 75

If you look at the query Builder chapter it will guide you.

Eloquent has all of query Builder methods.

Plus it's going to be similar to the question here https://laracasts.com/discuss/channels/eloquent/eloquent-query-to-filter-same-column-values

You could probably work some of the examples.

Also have you considered setting up eloquent relations in which Jeffrey has free videos in his introductory course.

jlrdw

6 years ago

Level 75

Also many queries like that I use as is using DB facade with proper bindings, see https://laracasts.com/discuss/channels/laravel/sql-native-to-query-builder

Please or to participate in this conversation.