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 80,10
Search result from the previous registration information as a list81 to 90 of 501 helicopters found in the database.
Please note, it could be the case that not all helicopter informations are complete in this database. So if you like to share some information regarding a helicopter, we would be very happy to add your additional info to the database. Please contact me via Email.
| ||||||||||||||||||||