Could Not Get Vehicle Data
DEBUG MODE
SQL Error : 1064 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 'GROUP BY g.id' at line 9
SELECT g.*, ROUND(g.weighted_rating, 2) as weighted_rating, images.*, makes.make, models.model, CONCAT_WS(' ', g.made_year, makes.make, models.model) AS vehicle, count(mods.id) AS total_mods, ( SUM(mods.price) + SUM(mods.install_price) ) AS total_spent, user.username, user.user_avatar_type, user.user_allowavatar, user.user_avatar, user.user_id
FROM garage AS g
LEFT JOIN users AS user ON g.member_id = user.user_id
LEFT JOIN garage_makes AS makes ON g.make_id = makes.id
LEFT JOIN garage_models AS models ON g.model_id = models.id
LEFT JOIN garage_mods AS mods ON g.id = mods.garage_id
LEFT JOIN garage_images AS images ON images.attach_id = g.image_id
WHERE g.id =
GROUP BY g.id
Line : 1678
File : class_garage_vehicle.php |
| |
