Fairline Yachts For Sale

Model

• (6)
• Squadron

  (2)
• Squadron 65

  (2)
• Targa 53 Open

  (2)
• 50

  (1)
• 50 Squadron

  (1)
• 66

  (1)
• F Line 33

  (1)
• Phantom 65

  (1)
• Squadron 53

  (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 = '446' 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