Как сформировать из SQL запроса Laravel Builder?

Question

[thisall]

У меня есть SQL запрос, как можно переписать его в Laravel Query Builder?

Запрос:

SELECT cat.ID AS ID, cat.Platform AS Platform, cat.Create_Date AS Create_Date, cat.Name AS Name, cat.Status AS Status, cat.Image AS Image, count(*) AS item_count FROM items AS it INNER JOIN category AS cat ON it.Item LIKE CONCAT('%"category":"', cat.ID, '"%') WHERE cat.Platform = '5f771d465f4191.76733056' GROUP BY cat.ID

Comments

[Илья]

Вручную. Глазами смотришь, руками пишешь. Проще всего

Answer 1

[Loli E1ON]

DB::select(`cat.ID as ID`,`cat.Platform as Platform`,`cat.Create_Date as Create_Date`,`cat.Name as Name`,`cat.Status as Status`,`cat.Image as Image`)
		->addSelect(DB::raw(`count(*) as item_count`))
		->from(`items as it`)
		->join(`category as cat`, function($join) {
			$join->on(`it.Item`, `LIKE`, `CONCAT('%"category":"', cat.ID, '"%')`);
			})
		->where(`cat.Platform`, `=`, `5f771d465f4191.76733056`)
		->groupBy(`cat.ID`)
		->get();

Comments

[thisall]

Argument 1 passed to Illuminate\Database\Connection::prepareBindings() must be of the type array, null given, called in Перегуглил всё и ничего толкового(