<p>
SELECT
	DISTINCT v.num,
	c.cid,
	g.gos
FROM photo AS p 
	INNER JOIN photo_veh AS pv ON pv.pid=p.pid
	INNER JOIN depot AS d ON d.did=v.did
	INNER JOIN cities AS c ON c.cid=d.cid
	INNER JOIN vehicle AS v ON v.vid=pv.vid
	LEFT JOIN gos_numbers AS g ON g.vid=v.vid
WHERE
	DATE_FORMAT(p.pub,'%Y-%m-%d')='2025-08-07' AND
ORDER BY
	c.num,
	CAST(v.num AS unsigned),
	g.gos</p><p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY
	c.num,
	CAST(v.num AS unsigned),
	g.gos' at line 13</p><p>Ошибочный запрос к БД<p>