Transform simple mysql query to laravel 5.1 query builder

Question

Please any one may help me to make this query in laravel5.1:

SELECT sum(orders.price) - (select sum(orders.price) 
    FROM orders INNER JOIN articles ON articles.id = orders.article_id 
    WHERE articles.forSale = false)
FROM orders INNER JOIN articles ON articles.id = orders.article_id 
     e articles.forSale=true

your answer is just using Query Builder, not eloquent. You should update the question to remove references to Eloquent if you don't need that in the solution. — SlateEntropy
– SlateEntropy, Commented Apr 18, 2016 at 20:32

BKF · Accepted Answer · 2016-04-18 19:37:04Z

1

I got it :

    $query = "select (sum(orders.price) - 
                      (select sum(orders.price) from orders 
                        inner join articles on articles.id = orders.article_id                            
                        where articles.forSale = false)
                      ) as p1 from orders 
                        inner join articles on articles.id = orders.article_id 
                        where articles.forSale = true";        
    return \DB::select($query);

answered Apr 18, 2016 at 19:37

BKF

1,3664 gold badges16 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Transform simple mysql query to laravel 5.1 query builder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related