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 prodlist.RegActive IN (1,2,3) ORDER BY MsnCnSort ASC LIMIT 0,100' at line 35SELECT prodlist.*,
									airline.airline_name AS AirlineName,
									airline.airline_urlname AS AirlineURLName,
									airline.airline_iata AS AirlineIATA,
									airline.airline_icao AS AirlineICAO,
									airline.airline_fullname AS AirlineFullName,
									airline.airline_callsign AS AirlineCallsign,
									airline.airline_bcc AS AirlineBoeingCode,
									airlineCountry.country_name AS AirlineCountry,
									airlineCountry.country_urlname AS AirlineCountryURLName,
									airlineLink.link_url AS AirlineURL,
									nextAirline.airline_name AS RegNextAirlineName,
									nextAirline.airline_urlname AS RegNextAirlineURLName,
									regManufacturer.manufacturer_name AS ManufacturerName,
									regManufacturer.manufacturer_name_url AS ManufacturerURLName,
									regType.aircraft_type_name AS TypeName,
									regType.aircraft_type_url AS TypeURLName,
									regType.aircraft_type_prodlist AS TypeProdList,
									regType.aircraft_type_engine AS NrEngines,
									regSubtype.aircraft_subtype_name AS SubtypeName,
									regSubtype.aircraft_subtype_url AS SubtypeURLName,
									regDetail.aircraft_detail_name AS DetailName,
									msnDetail.aircraft_detail_name AS AirframeDetailName,
									engines.engine_name AS EngineName FROM prodlist prodlist
							LEFT JOIN airline ON prodlist.AirlineID = airline.airline_id
							LEFT JOIN location_country airlineCountry ON airline.airline_country = airlineCountry.country_id
							LEFT JOIN link_info airlineLink ON airline.airline_url = airlineLink.link_id
							LEFT JOIN aircraft_detail regDetail ON prodlist.RegTypeID = regDetail.aircraft_detail_id
							LEFT JOIN aircraft_manu_rel regManuRel ON regDetail.aircraft_detail_subtype2 = regManuRel.manu_rel_id
							LEFT JOIN aircraft_subtype regSubtype ON regManuRel.manu_rel_subtype = regSubtype.aircraft_subtype_id
							LEFT JOIN aircraft_type regType ON regManuRel.manu_rel_type = regType.aircraft_type_id
							LEFT JOIN aircraft_manufacturer regManufacturer ON regManuRel.manu_rel_manu = regManufacturer.manufacturer_id
							LEFT JOIN aircraft_detail msnDetail ON prodlist.MsnTypeID = msnDetail.aircraft_detail_id
							LEFT JOIN engine_detail engines ON prodlist.RegEngines = engines.engine_id
							LEFT JOIN airline nextAirline ON prodlist.RegNextAirlineID = nextAirline.airline_id WHERE 1=1 AND RegTypeID IN () AND prodlist.RegActive IN (1,2,3) ORDER BY MsnCnSort ASC LIMIT 0,100