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 0,10
Current registration info. list1 to 10 of 501 helicopters found in the database
| ||||||||||||||||||||||||||||||||||