SELECT g.* FROM (SELECT make, COUNT(id) AS cnt FROM listings WHERE active = 'A' AND industry = 2 AND TRIM(make) <> '' AND site_code = 'bbrvs' GROUP BY make ORDER BY cnt DESC LIMIT 0,20) g ORDER BY make ASC New and Used Motorcycles For Sale in Louisiana and Mississippi - BBRVS.com

Motorcycles for Sale By Manufacturer