Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. $creators = DB::table('creators')
  2. ->select('creators.*','bank.name as bankName',DB::raw("count(products.id) as jml_product"))
  3. ->join('bank', 'bank_id', '=', 'bank.id')
  4. ->join('products', 'creators.id', '=', 'products.creator_id')
  5. ->groupBy('products.id')
  6. ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement