A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND cars.TYP_ID =' at line 61

SELECT cars.*, fuel.fuel_web_name, engines.ENG_ID as ENG_ID, engines.ENG_MFA_ID as ENG_MFA_ID, engines.ENG_CODE as ENG_CODE, engines.ENG_PCON_START as ENG_PCON_START, engines.ENG_PCON_END as ENG_PCON_END, engines.ENG_KW_FROM as ENG_KW_FROM, engines.ENG_KW_UPTO as ENG_KW_UPTO, engines.ENG_HP_FROM as ENG_HP_FROM, engines.ENG_HP_UPTO as ENG_HP_UPTO, engines.ENG_VALVES as ENG_VALVES, engines.ENG_CYLINDERS as ENG_CYLINDERS, engines.ENG_CCM_FROM as ENG_CCM_FROM, engines.ENG_CCM_UPTO as ENG_CCM_UPTO, engines.ENG_DESCRIPTION as ENG_DESCRIPTION, engines.ENG_KW_RPM_FROM as ENG_KW_RPM_FROM, engines.ENG_KW_RPM_UPTO as ENG_KW_RPM_UPTO, engines.ENG_TORQUE_FROM as ENG_TORQUE_FROM, engines.ENG_TORQUE_UPTO as ENG_TORQUE_UPTO, engines.ENG_TORQUE_RPM_FROM as ENG_TORQUE_RPM_FROM, engines.ENG_TORQUE_RPM_UPTO as ENG_TORQUE_RPM_UPTO, engines.ENG_COMPRESSION_FROM as ENG_COMPRESSION_FROM, engines.ENG_COMPRESSION_UPTO as ENG_COMPRESSION_UPTO, engines.ENG_DRILLING as ENG_DRILLING, engines.ENG_EXTENSION as ENG_EXTENSION, engines.ENG_CRANKSHAFT as ENG_CRANKSHAFT, engines.ENG_CCM_TAX_FROM as ENG_CCM_TAX_FROM, engines.ENG_CCM_TAX_UPTO as ENG_CCM_TAX_UPTO, engines.ENG_LITRES_TAX_FROM as ENG_LITRES_TAX_FROM, engines.ENG_LITRES_TAX_UPTO as ENG_LITRES_TAX_UPTO, engines.ENG_LITRES_FROM as ENG_LITRES_FROM, engines.ENG_LITRES_UPTO as ENG_LITRES_UPTO, ENG_KV_DESIGN_DES_ID_designation_text.TEX_TEXT as ENG_KV_DESIGN, ENG_KV_FUEL_TYPE_DES_ID_designation_text.TEX_TEXT as ENG_KV_FUEL_TYPE, ENG_KV_FUEL_SUPPLY_DES_ID_designation_text.TEX_TEXT as ENG_KV_FUEL_SUPPLY, ENG_KV_ENGINE_DES_ID_designation_text.TEX_TEXT as ENG_KV_ENGINE, ENG_KV_CHARGE_DES_ID_designation_text.TEX_TEXT as ENG_KV_CHARGE, ENG_KV_GAS_NORM_DES_ID_designation_text.TEX_TEXT as ENG_KV_GAS_NORM, ENG_KV_CYLINDERS_DES_ID_designation_text.TEX_TEXT as ENG_KV_CYLINDERS, ENG_KV_CONTROL_DES_ID_designation_text.TEX_TEXT as ENG_KV_CONTROL, ENG_KV_VALVE_CONTROL_DES_ID_designation_text.TEX_TEXT as ENG_KV_VALVE_CONTROL, ENG_KV_COOLING_DES_ID_designation_text.TEX_TEXT as ENG_KV_COOLING, ENG_KV_USE_DES_ID_designation_text.TEX_TEXT as ENG_KV_USE FROM engines LEFT JOIN designations AS ENG_KV_DESIGN_DES_ID_designation ON engines.ENG_KV_DESIGN_DES_ID = ENG_KV_DESIGN_DES_ID_designation.DES_ID AND ENG_KV_DESIGN_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_DESIGN_DES_ID_designation_text ON ENG_KV_DESIGN_DES_ID_designation.DES_TEX_ID = ENG_KV_DESIGN_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_FUEL_TYPE_DES_ID_designation ON engines.ENG_KV_FUEL_TYPE_DES_ID = ENG_KV_FUEL_TYPE_DES_ID_designation.DES_ID AND ENG_KV_FUEL_TYPE_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_FUEL_TYPE_DES_ID_designation_text ON ENG_KV_FUEL_TYPE_DES_ID_designation.DES_TEX_ID = ENG_KV_FUEL_TYPE_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_FUEL_SUPPLY_DES_ID_designation ON engines.ENG_KV_FUEL_SUPPLY_DES_ID = ENG_KV_FUEL_SUPPLY_DES_ID_designation.DES_ID AND ENG_KV_FUEL_SUPPLY_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_FUEL_SUPPLY_DES_ID_designation_text ON ENG_KV_FUEL_SUPPLY_DES_ID_designation.DES_TEX_ID = ENG_KV_FUEL_SUPPLY_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_ENGINE_DES_ID_designation ON engines.ENG_KV_ENGINE_DES_ID = ENG_KV_ENGINE_DES_ID_designation.DES_ID AND ENG_KV_ENGINE_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_ENGINE_DES_ID_designation_text ON ENG_KV_ENGINE_DES_ID_designation.DES_TEX_ID = ENG_KV_ENGINE_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_CHARGE_DES_ID_designation ON engines.ENG_KV_CHARGE_DES_ID = ENG_KV_CHARGE_DES_ID_designation.DES_ID AND ENG_KV_CHARGE_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_CHARGE_DES_ID_designation_text ON ENG_KV_CHARGE_DES_ID_designation.DES_TEX_ID = ENG_KV_CHARGE_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_GAS_NORM_DES_ID_designation ON engines.ENG_KV_GAS_NORM_DES_ID = ENG_KV_GAS_NORM_DES_ID_designation.DES_ID AND ENG_KV_GAS_NORM_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_GAS_NORM_DES_ID_designation_text ON ENG_KV_GAS_NORM_DES_ID_designation.DES_TEX_ID = ENG_KV_GAS_NORM_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_CYLINDERS_DES_ID_designation ON engines.ENG_KV_CYLINDERS_DES_ID = ENG_KV_CYLINDERS_DES_ID_designation.DES_ID AND ENG_KV_CYLINDERS_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_CYLINDERS_DES_ID_designation_text ON ENG_KV_CYLINDERS_DES_ID_designation.DES_TEX_ID = ENG_KV_CYLINDERS_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_CONTROL_DES_ID_designation ON engines.ENG_KV_CONTROL_DES_ID = ENG_KV_CONTROL_DES_ID_designation.DES_ID AND ENG_KV_CONTROL_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_CONTROL_DES_ID_designation_text ON ENG_KV_CONTROL_DES_ID_designation.DES_TEX_ID = ENG_KV_CONTROL_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_VALVE_CONTROL_DES_ID_designation ON engines.ENG_KV_VALVE_CONTROL_DES_ID = ENG_KV_VALVE_CONTROL_DES_ID_designation.DES_ID AND ENG_KV_VALVE_CONTROL_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_VALVE_CONTROL_DES_ID_designation_text ON ENG_KV_VALVE_CONTROL_DES_ID_designation.DES_TEX_ID = ENG_KV_VALVE_CONTROL_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_COOLING_DES_ID_designation ON engines.ENG_KV_COOLING_DES_ID = ENG_KV_COOLING_DES_ID_designation.DES_ID AND ENG_KV_COOLING_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_COOLING_DES_ID_designation_text ON ENG_KV_COOLING_DES_ID_designation.DES_TEX_ID = ENG_KV_COOLING_DES_ID_designation_text.TEX_ID LEFT JOIN designations AS ENG_KV_USE_DES_ID_designation ON engines.ENG_KV_USE_DES_ID = ENG_KV_USE_DES_ID_designation.DES_ID AND ENG_KV_USE_DES_ID_designation.DES_LNG_ID = 4 LEFT JOIN des_texts AS ENG_KV_USE_DES_ID_designation_text ON ENG_KV_USE_DES_ID_designation.DES_TEX_ID = ENG_KV_USE_DES_ID_designation_text.TEX_ID INNER JOIN link_typ_eng ON link_typ_eng.LTE_ENG_ID = engines.ENG_ID INNER JOIN cars ON link_typ_eng.LTE_TYP_ID = cars.TYP_ID INNER JOIN fuel ON cars.FUEL_ID = fuel.FUEL_ID WHERE engines.ENG_ID = AND cars.TYP_ID =

Filename: models/Home_model.php

Line Number: 294