SELECT COUNT(y.yref) as count
FROM cni_view_yacht y, c4_builder b, (SELECT MIN(base_price_low) AS base_price, s_id, s_lowrate, s_currency, s_year, yref FROM cni_view_season WHERE s_year = '2019' GROUP BY yref) as s , c4_season_regions ia
WHERE y.g_charter = '1'
AND y.status = 1
AND y.yref = s.yref
AND (ia.sr_region = )
AND ia.sr_season = s.s_id
AND b.bu_id = y.s_builder_c
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND ia.sr_season = s.s_id
' at line 4
