OPEN
Install Garage.txt
FIND
Code: Select all
#
#-----[ AFTER, ADD ]------------------------------------------
#
LEFT JOIN " . GARAGE_TABLE ." AS g on g.member_id = p.poster_id and g.main_vehicle = 1
LEFT JOIN " . GARAGE_MAKES_TABLE . " AS makes ON g.make_id = makes.id
LEFT JOIN " . GARAGE_MODELS_TABLE . " AS models ON g.model_id = models.id
Code: Select all
#
#-----[ AFTER, ADD ]------------------------------------------
#
LEFT JOIN " . GARAGE_TABLE ." AS g ON p.poster_id=g.member_id AND g.main_vehicle = 1
LEFT JOIN " . GARAGE_MAKES_TABLE . " AS makes ON g.make_id = makes.id
LEFT JOIN " . GARAGE_MODELS_TABLE . " AS models ON g.model_id = models.id