Forum How to run this sql in laravel?

hs6022841

posted 9 years ago

Database Eloquent

Last updated 2 years ago.

illuminate3

replied 9 years ago

Why use raw?

I do stuff like this at times:

		$makes = DB::table('produced')
			->select(
					'produced.*',
					'catalog.*',
					'productions.*',
					'customers.name as customer'
				)
			->leftJoin('catalog', 'produced.catalog_id', '=', 'catalog.id')
			->leftJoin('productions', 'produced.production_id', '=', 'productions.id')
			->leftJoin('customers', 'productions.customer_id', '=', 'customers.id')
			->where('packed', '=', 0)
			->where('flagged', '=', 0, 'AND')
			->groupBy('production_id')
			->get();

OH! Maybe you are missing: