SELECT ID,(SELECT datei FROM photos WHERE photos.ID=exdaten.photo AND userstat<='1') AS datei,serial,milreg,civilreg,typ,mfd,country,CASE WHEN hidedat='1' THEN operator END AS operator,DATE_FORMAT(incidentdate,'%d.%m.%Y') FROM exdaten WHERE userstat<='1' ORDER BY civilreg ASC LIMIT 50,10
| ||||||||||||||||||||
Current registration info. list51 to 60 of 501 helicopters found in the database
| ||||||||||||||||||||