ERROR - MySql Query

FILE: /var/www/html/superiore.us/application/variant/variant.model.php

LINE: 507

QUERY: SELECT c.color_title_EN AS color, s.stile_title_EN AS stile, d.deco_accents_title_EN AS deco_accents, fu.fuel_title_EN AS fuel, in.installation_title_EN AS installation, `width_scs` AS width, `height_scs` AS height, `height_fascia_scs` AS height_fascia, `depth_scs` AS depth, ve.version_title_EN AS version, `levels`, `design`, `gas_burners`, `gas_brass_burners`, `wok_burner_ss_scs` AS wok_burner_ss, `wok_burner_scs` AS wok_burner, `rapid_scs` AS rapid, `semi_rapid_scs` AS semi_rapid, `auxiliary_scs` AS auxiliary, `total_gas_power_scs` AS total_gas_power, pa.pan_support_title_EN AS `pan_support`, ig.ignition_title_EN AS `ignition`, g.gas_safety_title_EN AS `gas_safety`, `wok_ring`, `simmer_ring`, `electric_plates`, `normal_180mm`, `rapid_180mm`, `normal_145mm`, `rapid_145mm`, `total_electric_power_plates`, `hob_operating_warning_light`, `ceramic_zones`, `hilight_210mm`, `hilight_180mm`, `hilight_140mm`, `hilight_extensible_140_210mm`, `hilight_oval_190_285mm`, `hilight_oval_145_250mm`, `total_electric_power_ceramic`, `induction_zones`, `induction_160mm`, `induction_180mm`, `induction_210mm`, `induction_145mm`, `induction_260mm`, `induction_200mm`, `induction_210_180mm`, `total_induction_power`, `power_levels`, i.interface_title_EN AS interface, `bridge_function`, `turboboost`, `fast_heatup`, `programmable_cooking_times`, `timer`, `power_management`, `pause_recall`, `child_safety_lock`, `pot_diameter_detection`, `antispill_safety`, `automatic_switchoff`, `residual_heat_indicator`, `backguard`, `island_trim`, /*sp.special_cooking_temp_title_EN AS special_cooking_temp,*/ special_cooking_temp_melting, special_cooking_temp_warming, special_cooking_temp_simmering, eg.electric_griddle_title_EN AS electric_griddle, `total_electric_griddle_power`, `removable_drip_tray`, `teppan_yaki_surface`, `lavic_stone`, `fryer_capacity`, `removable_steel_basket`, `oil_temp_indicator`, `domino_joint_kit`, `scraper`, `glass_lid`, `oven`, o1.oven_type_title_EN AS main_oven_type, o2.oven_type_title_EN AS auxiliary_oven_type, `indipendent_gas_grill_control`, `main_set_function_id`, `auxiliary_set_function_id`, `oven_convection_fans`, `energy_efficiency_class`, `overall_cavity_volume_scs` AS overall_cavity_volume, `net_cavity_volume_scs` AS net_cavity_volume, `main_interior_dimension_scs` AS main_interior_dimension, `auxiliary_interior_dimension_scs` AS auxiliary_interior_dimension, e.enamel_title_EN AS enamel, ec.enamel_color_title_EN AS enamel_color, `smooth_oven_interior`, pr.oven_control_device_title_EN AS oven_control_device, maximum_oven_power, `maximum_oven_power_scs`, grill_power, `grill_power_scs`, `maximum_cooking_temperature_scs` AS maximum_cooking_temperature, `cooling_fan`, dt.door_type_title_EN AS door_type, dd.door_design_title_EN AS door_design, `glasses`, `oven_lights`, `motors`, `max_aspiration_capacity_scs` AS max_aspiration_capacity, `speed`, `halogen_lights`, `noise_level`, `pressure`, fi.filter_title_EN AS filter, co.control_title_EN AS control, `automatic_shutoff_option`, `adjustable_stainless_steel_chimney`, `stainless_steel_towel_bar`, `charcoal_filters`, `roasting_spit_main`, `roasting_spit_auxiliary`, `wire_shelves_main`, `wire_shelves_auxiliary`, `enamelled_trays`, `deep_trays`, `trivet`, `telescopic_runners`, `catalytic_liners`, `meat_probe`, `glass_tray`, `pizza_stone`, st.storage_compartment_title_EN AS storage_compartment, f.feet_title_EN AS feet, `stainless_steel_toekick`, `gas_adjustment_natural_gas`, `gas_adjustment_lpg`, `voltage_frequency`, `max_amp_usage_power_rating`, `certification`, `warranty` FROM tbl_color c, tbl_product p LEFT JOIN tbl_stile s ON p.stile_id = s.stile_id LEFT JOIN tbl_deco_accents d ON p.deco_accents_id = d.deco_accents_id LEFT JOIN tbl_interface i ON p.interface_id = i.interface_id LEFT JOIN tbl_oven_type o1 ON p.main_oven_type_id = o1.oven_type_id LEFT JOIN tbl_oven_type o2 ON p.auxiliary_oven_type_id = o2.oven_type_id LEFT JOIN tbl_oven_control_device pr ON p.oven_control_device_id = pr.oven_control_device_id LEFT JOIN tbl_door_design dd ON p.door_design_id = dd.door_design_id LEFT JOIN tbl_door_type dt ON p.door_type_id = dt.door_type_id LEFT JOIN tbl_feet f ON p.feet_id = f.feet_id LEFT JOIN tbl_pan_support pa ON p.pan_support_id = pa.pan_support_id LEFT JOIN tbl_ignition ig ON p.ignition_id = ig.ignition_id LEFT JOIN tbl_gas_safety g ON p.gas_safety_id = g.gas_safety_id LEFT JOIN tbl_enamel e ON p.enamel_id = e.enamel_id LEFT JOIN tbl_enamel_color ec ON p.enamel_color_id = ec.enamel_color_id LEFT JOIN tbl_storage_compartment st ON p.storage_compartment_id = st.storage_compartment_id LEFT JOIN tbl_fuel fu ON p.fuel_id = fu.fuel_id LEFT JOIN tbl_installation `in` ON p.installation_id = in.installation_id /*LEFT JOIN tbl_special_cooking_temp sp ON p.special_cooking_temp_id = sp.special_cooking_temp_id*/ LEFT JOIN tbl_version ve ON p.version_id = ve.version_id LEFT JOIN tbl_electric_griddle eg ON p.electric_griddle_id = eg.electric_griddle_id LEFT JOIN tbl_filter fi ON p.filter_id = fi.filter_id LEFT JOIN tbl_control co ON p.controls_id = co.control_id WHERE p.is_visible = 1 AND p.product_id= AND c.color_id= GROUP BY p.product_id

ERROR: [1064] 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 c.color_id= GROUP BY p.product_id' at line 184