How to execute raw queries with Laravel 5 1

Question

So I have this tiny query to run on my DB and it works fine in MySQL Workbench  Basically  a SELECT with LEFT JOIN and UNION with LEFT JOIN again   SELECT     cards id card      cards hash card      cards  table       users name      0 as total      cards card status      cards created at FROM cards LEFT JOIN users ON users id user   cards id user WHERE hash card NOT IN   SELECT orders hash card FROM orders   UNION SELECT     cards id card      orders hash card      cards  table       users name      sum orders quantity orders product price  as total       cards card status       max orders created at   FROM menu orders LEFT JOIN cards ON cards hash card   orders hash card LEFT JOIN users ON users id user   cards id user GROUP BY hash card ORDER BY id card ASC   In tried to translate it to Laravel  with no success    cards   Card  selectRaw  cards id card  cards hash card  cards table  users name  0 as total  cards card status  cards created at as last update                   - gt leftJoin  users   users id user       cards id user                   - gt whereNotIn   hash card   Order  select  orders hash card  - gt get                     - gt union                          Order  selectRaw  cards id card  orders hash card  cards table  users name  sum orders quantity orders product price  as total  cards card status  max orders created at  as last update                           - gt leftJoin  cards   cards hash card       orders hash card                           - gt leftJoin  users   users id user       cards id user                                     - gt groupBy  hash card                   - gt orderBy  cards id card   asc                   - gt get      I m getting the error      ErrorException in Builder php line 1249  Undefined property    Illuminate Database Eloquent Builder   bindings   How could I execute a completely raw query in Laravel or write the query in the right manner in Laravel

User · Answer

DB  statement  your query     I used it for add index to column in migration

User · Answer

you can run raw query like this way too   DB  table  setting colleges  - gt first

User · Answer

I found the solution in this topic and I code this    cards   DB  select  SELECT         cards id card          cards hash card          cards  table           users name          0 as total          cards card status          cards created at as last update     FROM cards     LEFT JOIN users     ON users id user   cards id user     WHERE hash card NOT IN   SELECT orders hash card FROM orders       UNION     SELECT         cards id card          orders hash card          cards  table           users name          sum orders quantity orders product price  as total           cards card status           max orders created at  last update      FROM menu orders     LEFT JOIN cards     ON cards hash card   orders hash card     LEFT JOIN users     ON users id user   cards id user     GROUP BY hash card     ORDER BY id card ASC

[php] How to execute raw queries with Laravel 5.1?

Examples related to php

Examples related to mysql

Examples related to sql

Examples related to database

Examples related to laravel-5.1