SQL ERROR: Unknown column 'code' in 'where clause'
STATEMENT: SELECT COUNT(*) AS ret FROM fotos,registrations,aircrafts,airlines WHERE userid = 1 AND fotos.regid = registrations.regid AND registrations.aircraftid = aircrafts.aircraftid AND registrations.airlineid = airlines.airlineid AND upper(code) LIKE '%SZG%'
SQL ERROR: Unknown column 'code' in 'where clause'
STATEMENT: SELECT airports.airportid,fotoid AS id,comment,imagename,country,aircraft AS type,airports.icao AS codeo,airports.iata AS code,subtype,month,day,year,registration,name AS city,cn,airline FROM fotos,registrations,airlines,airports,aircrafts WHERE userid = 1 AND upper(code) LIKE '%SZG%' AND fotos.regid = registrations.regid AND registrations.aircraftid = aircrafts.aircraftid AND registrations.airlineid = airlines.airlineid AND fotos.airportid = airports.airportid ORDER BY added DESC LIMIT 0,8