Bertram Yachts For Sale

Model

• 510 Convertible

  (7)
• Convertible

  (4)
• 670E

  (3)
• 39 CC

  (2)
• 51 Convertible

  (2)
• 510

  (2)
• 570

  (2)
• 60 Convertible

  (2)
• 630

  (2)
• 67 Convertible

  (2)
• 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 = '195' 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