Fjord Boats For Sale

Model

• 41 XL

  (6)
• 42 Open

  (3)
• 48 Open

  (3)
• 53 XL

  (2)
• 38 Open

  (1)
• 39 XL

  (1)
• 39XP

  (1)
• 41 XP

  (1)
• 41XL

  (1)
• 42

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