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 ') ORDER BY RegSort 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 MsnCn = '49484' AND RegTypeID IN () ORDER BY RegSort ASC LIMIT 0,100