Bali Catamarans For Sale

Model

• 4.8

  (12)
• 5.4

  (9)
• 4.2

  (7)
• 4.6

  (7)
• 4.4

  (6)
• 5.8

  (4)
• CATSPACE

  (3)
• BALI 4.6

  (3)
• 4.3

  (2)
• 4.6 OPEN SPACE

  (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 = '2170' and a.id = c.yacht_id and a.id = d.yacht_id and ((d.type_id IN (9,74) and a.category_id IN (1,2) and a.ownboat = 1) OR a.feed_id IN ('90sxtvkwmutb') OR (a.feed_id = '01ef30d3d11ef1076140ca8118e9c50ea6d7fa31' AND d.type_id IN (9,74) and a.category_id IN (1,2))) and a.charter_id IN (1, 3) and a.status_id = 1 and a.boat_slug != '' group by a.model_slug order by total desc limit 0, 11