|
Could Select Business Data
DEBUG MODE
SQL Error : 1054 Unknown column 'mods.garage_id' in 'on clause'
SELECT mods.id, mods.garage_id, mods.title AS mod_title, mods.price, mods.product_rating, mods.comments, u.username, u.user_id, makes.make, models.model, g.made_year, b.id as business_id
FROM phpbb_garage_mods AS mods, phpbb_garage_business AS b
LEFT JOIN phpbb_garage AS g ON mods.garage_id = g.id
LEFT JOIN phpbb_users AS u ON mods.member_id = u.user_id
LEFT JOIN phpbb_garage_makes AS makes ON g.make_id = makes.id
LEFT JOIN phpbb_garage_models AS models ON g.model_id = models.id
WHERE mods.business_id = b.id
AND ( b.web_shop =1 OR b.retail_shop =1 )
AND b.pending = 0
AND b.id = 88
AND makes.pending = 0 AND models.pending = 0
ORDER BY mods.id, mods.date_created DESC
LIMIT 20
Line : 2414 File : garage.php |
|
|