-
Notifications
You must be signed in to change notification settings - Fork 20
Closed
Description
SELECT
order_notes.*
FROM
order_new
LEFT JOIN order_notes
ON order_notes.order_id = order_new.id AND order_notes.parent_order_note_id = 0 AND
order_notes.order_note_nr = 0
LEFT JOIN mrt
ON mrt.id = order_notes.serial_id AND order_notes.serial_id > 0
LEFT JOIN label
ON label.id = mrt.label_id AND mrt.label_id > 0
LEFT JOIN id
ON id.id = label.id
WHERE
order_new.id = 114produces:
DB::table('order_new')
->select('order_notes.*')
->leftJoin('order_notes',function($join) {
$join->on('order_notes.order_id','=','order_new.id')
->where('order_notes.parent_order_note_id','=',0)
->where('order_notes.order_note_nr','=',0);
}
->leftJoin('mrt',function($join) {
$join->on('mrt.id','=','order_notes.serial_id')
->where('order_notes.serial_id','>',0);
}
->leftJoin('label',function($join) {
$join->on('label.id','=','mrt.label_id')
->where('mrt.label_id','>',0);
}
->leftJoin('id','id.id','=','label.id')
->where('order_new.id','=',114)
->get();There's a ) misssing after each leftJoin
Metadata
Metadata
Assignees
Labels
No labels