#4. |
include\Meldeliste_events.php:199 |
eventclass_Meldeliste->BeforeQueryList |
1. select
[Meldeliste].[ID_Teams], [Meldeliste].[A_ID_Turnier], [Meldeliste].[T_Datum_AOA], [Meldeliste].[HF_Name_AOA], [Meldeliste].[HF_Vorname_AOA], [Meldeliste].[HF_Land_AOA], [Meldeliste].[S_SektionsKurzname], [Meldeliste].[HF_Vereinnr_AOA], [Meldeliste].[H_Lizenz_AOA], [Meldeliste].[H_Name_AOA], [Meldeliste].[H_Kategorie_AOA], [Meldeliste].[H_Kategorie_Sort], [Meldeliste].[H_Klasse_AOA], [Meldeliste].[H_Klasse_Sort], [Meldeliste].[H_Kateg_Kl_AOA], [Meldeliste].[H_Kateg_Kl_AOA_Sort], [Meldeliste].[H_Rasse_AOA], [Meldeliste].[ASMV_Nr_Mannschaft_AOA], [Z_ASMV_alle].[ASMV_Name_Mannschaft_AOA], [Meldeliste].[ASMV_Status], [Meldeliste].[S_Agility_Jumping_AOA], [Meldeliste].[S_Spiele_AOA], [Meldeliste].[S_WMQ_AOA], [Meldeliste].[S_SMQ_AOA], [Meldeliste].[S_EOQ_AOA], [Meldeliste].[T_Wohnwagen_AOA], [teams_camping].[Vergleichswert], [Meldeliste].[T_Strom_AOA], [stamm].[Homepage], [Meldeliste].[S_Jumping_AOA], [Meldeliste].[Waitinglist], [Meldeliste].[AOA_Abo_Hauptlizenz], [Turniere].[Zahlungsmethode]
FROM (((([Meldeliste]) LEFT OUTER JOIN [stamm] ON [Meldeliste].[H_Lizenz_AOA] = stamm.H_Lizenz_AOA) LEFT OUTER JOIN [Z_ASMV_alle] ON [Meldeliste].[ASMV_Nr_Mannschaft_AOA] = Z_ASMV_alle.ASMV_Nr_Mannschaft_AOA) LEFT OUTER JOIN [teams_camping] ON [Meldeliste].[Vergleichswert] = teams_camping.Vergleichswert) INNER JOIN [Turniere] ON [Meldeliste].[A_ID_Turnier] = Turniere.A_ID_Turnier WHERE ( ( ( ( ( Meldeliste.H_Klasse_AOA='A' ) ) ) ) ) and ( ([Meldeliste].[abgemeldet] is null) OR ([Meldeliste].[abgemeldet] =0) ) ; 2. ( ( ( Meldeliste.H_Klasse_AOA='A' ) ) ); 3. ORDER BY 12 ASC, 14 ASC, 4 ASC, 2 ASC; 4. ListPage_Simple; |