Level 102
DB::table('products')
->select('products.*', ' as order_items_count')
->whereNull('products.deleted_at')
->orderBy('order_items_count','desc')
->limit(8)
->get();
Converted at https://sql2builder.github.io/
Oct 7, 2022
6
Level 3
Convert SQL query to Laravel QUery Builder
Please can someone help me convert the query below to a LAravel query builder
"select `products`.*, (select count(*) from `order_items` where `products`.`id` = `order_items`.`product_id`) as `order_items_count` from `products` where `products`.`deleted_at` is null order by `order_items_count` desc limit 8 ◀"
Level 3
@Sinnbeck Thank you very much. How can I learn to write queries like this
Level 3
@Sinnbeck However, the count is not in the query
Level 102
@CItyTrader Yeah it isn't perfect that converter so you need to tweak it a bit
DB::table('products')
->selectSub(DB::table('products')->selectRaw('count(*)'), 'order_items_count')
->whereNull('products.deleted_at')
->orderBy('order_items_count','desc')
->limit(8)
->get();
And you learn it by practicing. The more you use laravel the better you get at it
Level 3
@Sinnbeck it didn't work. This is the error
Call to undefined method Illuminate\Database\Query\Builder::toQuery()
Level 102
@CItyTrader Ah maybe that isnt needed with the query builder. Removed it from my example
Please or to participate in this conversation.