Canados Yachts For Sale

Model

• 86

  (3)
• 431 GLADIATOR

  (2)
• 493 Gladiator

  (2)
• (1)
• 110

  (1)
• 143

  (1)
• 435 GLADIATOR

  (1)
• 571

  (1)
• 72 S

  (1)
• 76

  (1)
• More...
  select distinct a.model, a.model_slug, count(distinct a.id) as total from tbl_yacht as a, tbl_manufacturer as b, tbl_yacht_dimensions_weight as c, tbl_yacht_type_assign as d where b.id = a.manufacturer_id and a.manufacturer_id = '262' and a.id = c.yacht_id and a.id = d.yacht_id and ((d.type_id NOT IN (9) and a.category_id = 1 and a.ownboat = 1) OR a.feed_id = 'iqfvvoqavhlo' OR (a.feed_id = '01ef30d3d11ef1076140ca8118e9c50ea6d7fa31' AND d.type_id NOT IN ('9','74') and a.category_id = 1)) and d.type_id NOT IN (74) and a.charter_id IN (1, 3) and a.status_id = '1' and a.display_upto >= CURDATE() and a.boat_slug != '' group by a.model_slug order by total desc limit 0, 11