How to do this in Laravel, subquery where in

by

Consider this code:

Products::whereIn('id', function($query){
    $query->select('paper_type_id')
    ->from(with(new ProductCategory)->getTable())
    ->whereIn('category_id', ['223', '15'])
    ->where('active', 1);
})->get();

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. Laravel OrderBy relationship count
  3. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  4. Laravel $q->where() between dates
  5. Eloquent many-to-many-to-many – how to load distant relation easily
  6. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  7. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  8. Automatically deleting related rows in Laravel (Eloquent ORM)
  9. Get Specific Columns Using “With()” Function in Laravel Eloquent
  10. Laravel Check If Related Model Exists
  11. Laravel migration: unique key is too long, even if specified
  12. Laravel: PDOException: could not find driver
  13. Laravel Eloquent select all rows with max created_at
  14. How can I convert many statement mysql to laravel eloquent?
  15. Eloquent ORM Code Hinting in PhpStorm
  16. How to set a default attribute value for a Laravel / Eloquent model?
  17. “No such file or directory” or “No such host is known” when running migrations
  18. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  19. How to create a subquery using Laravel Eloquent?
  20. Eloquent model mass update
  21. Difference between Eloquent\Model::get() and all()
  22. Laravel Eloquent get results grouped by days
  23. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  24. Change name of Laravel’s created_at and updated_at
  25. How do I get database column names in Laravel?
  26. Laravel Eloquent: How to get only certain columns from joined tables
  27. Mysql InnoDB engine in Laravel
  28. How to get last insert id in Eloquent ORM laravel
  29. Laravel Many to many self referencing table only works one way
  30. Merge ‘with’ and ‘whereHas’ in Laravel 5

Leave a Comment