SELECT `m_bike`.`id`, `b_stock`, `b_order`, `b_featured`, `b_designator`, `b_year`, `b_price`, `des_name`, `img_filename`, `img_primary` FROM `m_bike` LEFT JOIN (m_images2017, m_designator) ON (m_bike.b_stock=m_images2017.m_bike_stock) AND (m_bike.b_designator=m_designator.id) WHERE b_featured AND img_primary AND b_status <> 0 GROUP by b_stock ORDER BY b_order LIMIT 10