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