ERROR - MySql Query

FILE: /var/www/html/ardesia1952.com/application/variant/variant.model.php

LINE: 577

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` AS width, `height` AS height, `height_fascia` AS height_fascia, `depth` AS depth, ve.version_title_en AS version, `levels`, `design`, `gas_burners`, `gas_brass_burners`, `wok_burner_ss` AS wok_burner_ss, `wok_burner` AS wok_burner, `rapid` AS rapid, `semi_rapid` AS semi_rapid, `auxiliary` AS auxiliary, `total_gas_power` 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` AS normal_180mm, `rapid_180mm` AS rapid_180mm, `normal_145mm` AS normal_145mm, `rapid_145mm` AS rapid_145mm, `total_electric_power_plates` AS total_electric_power_plates, `hob_operating_warning_light`, `ceramic_zones`, `hilight_210mm` AS hilight_210mm, `hilight_180mm` AS hilight_180mm, `hilight_140mm` AS hilight_140mm, `hilight_extensible_140_210mm` AS hilight_extensible_140_210mm, `hilight_extensible_120_180mm` AS hilight_extensible_120_180mm, `hilight_oval_190_285mm` AS hilight_oval_190_285mm, `hilight_oval_145_250mm` AS hilight_oval_145_250mm, `total_electric_power_ceramic` AS total_electric_power_ceramic, `induction_zones`, `induction_160mm` AS induction_160mm, `induction_180mm` AS induction_180mm, `induction_210mm` AS induction_210mm, `induction_145mm` AS induction_145mm, `induction_260mm` AS induction_260mm, `induction_200mm` AS induction_200mm, `induction_210_180mm` AS induction_210_180mm, `total_induction_power` AS 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` AS 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` AS overall_cavity_volume, `net_cavity_volume` AS net_cavity_volume, `main_interior_dimension` AS main_interior_dimension, `auxiliary_interior_dimension` 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` AS maximum_oven_power, `grill_power` AS grill_power, `maximum_cooking_temperature` 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` 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_en = 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 183