#1 Australian Yamaha Dealer for 5 years since 2006
#1 WA Yamaha Dealer for 12 years in a row since 2000
FIVE STAR Yamaha
54-58 Rockingham Road
Hamilton Hill, Western Australia
Phone : (08) 9430 4090
Fax : (08) 9430 6212
SELECT `new_bike`.`id`, `new_bike`.`perma`, `models`.`model_name`, `companies`.`company_name`, `new_bike_categories`.`id`, `new_bike_categories`.`category_name`, `new_bike_categories`.`perma_link` FROM `new_bike`
LEFT JOIN `models` ON new_bike.model_id = models.id
LEFT JOIN `companies` ON models.company_id = companies.id
LEFT JOIN `new_bike_categories` ON new_bike_categories.id = new_bike.category_id ORDER BY `new_bike`.`category_id` asc
