SELECT ID,(SELECT datei FROM photos WHERE photos.ID=stdaten.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 stdaten WHERE userstat<='1' ORDER BY civilreg ASC LIMIT 70,10
Previous registration info. list71 to 80 of 109 helicopters found in the database
| ||||||||||||||||||||||||||||||||||