How to build subqueries in Laravel-5 [duplicate]

Question

How can I build the following MySQL query using Laravel-5?

select orders.*, oi.items from orders 
inner join (select order_id, group_concat(item_name SEPARATOR ', ') as items 
from orders_items group by order_id) as oi on oi.order_id = orders.id;

EDIT

The suggested link did not resolve my problem, however I did find a solution and will post it below for others.

V4n1ll4 · Accepted Answer · 2015-07-20 08:42:06Z

2

$order  = $order->select('orders.*', 'oi.items');
$order->join(DB::raw('(select order_id, group_concat(item_name SEPARATOR ",") as items from orders_items group by order_id) as oi'), function($join)
{
    $join->on('oi.order_id', '=', 'orders.id');
});
$order->whereRaw('find_in_set ("'.$value.'", oi.items)');

$rows = $order->get();

answered Jul 20, 2015 at 8:42

V4n1ll4

6,12914 gold badges57 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to build subqueries in Laravel-5 [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related