Aircraft with the highest message count

Started by tarbat, October 12, 2009, 04:00:36 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

tarbat

So I got a bit bored this afternoon (in between conference calls), and wondered which aircraft had the highest message count in MyLog.  Here's my top 10 (from the last month):

G-LGNM   Flybe - British European (Loganair)   SF34   Saab 340B
G-LGNB   British Airways (Loganair)   SF34   Saab 340B
G-FBEA   Flybe - British European   E190   Embraer ERJ-190-200LR 195LR
G-LGNJ   Flybe - British European (Loganair)   SF34   Saab 340B
G-LGNF   Loganair   SF34   Saab 340B
G-STRN   Iceland Express (Astraeus)   B737   Boeing 737-7L9
G-EMBN   BMI Regional   E145   Embraer EMB-145EU (ERJ-145EU)
G-RJXA   BMI Regional   E145   Embraer EMB-145EP (ERJ-145EP)
G-LGNL   Loganair   SF34   Saab 340B
F-GITH   Air France   B744   Boeing 747-428

The only real surprise in my list is the Air France 747.

FYI, here's the SQL:
SELECT
  v_Flights.ModeS,
  SUM(v_Flights.MsgCount) AS FIELD_1,
  Aircraft.Registration,
  Aircraft.AircraftTypeLong,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline
FROM
v_Flights
LEFT OUTER JOIN Aircraft ON (v_Flights.ModeS=Aircraft.ModeS)
GROUP BY
  v_Flights.ModeS,
  Aircraft.Registration,
  Aircraft.AircraftTypeLong,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline
ORDER BY
  FIELD_1 DESC

John Racars

Best Regards from the Netherlands, John Racars
13 NM East of EHAM
-
ANRB:
Version: 3D - 5.00.072
Antenna: outside WiMo GP-1090 (with ECOFLEX 10 cableconnection)
PC: Windows 7 SP 1 - 64 bit
-
RadarBox24 station: EHAM4