Vaši ATC / Your ATC
Aktivní členové a řídící VACC-CZ / Active members and ATCs of the VACC-CZ
| Jméno / Name | Rating | LKPR Approval | Solo validation |
|---|---|---|---|
| Bedrich Schindler | CTR1: Enroute | TWR / APP | |
| Jáchym Vohryzek | CTR1: Enroute | TWR / APP | |
| Jakub Kolar | CTR1: Enroute | TWR / APP | |
| Jindrich Machalinek | CTR1: Enroute | TWR / APP | |
| Jiří Dubina | CTR1: Enroute | TWR / APP | |
| Matej Quarda | CTR1: Enroute | TWR / APP | |
| Pavel Brodsky | CTR1: Enroute | TWR / APP | |
| Petra Ondráčková | CTR1: Enroute | TWR / APP | |
| Prokop Lamser | CTR1: Enroute | TWR / APP | |
| Matyas Svoboda | CTR1: Enroute (Student) | TWR / APP | |
| Ondrej Penicka | CTR1: Enroute (Student) | TWR / APP | LKAA_CTR |
| Marek Kmet | STU3: Approach | TWR | |
| Petr Popule | STU3: Approach | TWR / APP | |
| Radek Ruban | STU3: Approach | TWR / APP | |
| Radomír Věncek | STU3: Approach | TWR / APP | |
| Tomas Janovsky | STU3: Approach | TWR / APP | |
| Michal Safranek | STU3: Approach (Student) | TWR | |
| Pavel Kubac | STU3: Approach (Student) | TWR | |
| Petr Hruza | STU3: Approach (Student) | TWR | LKPR_APP |
| Adam Parma | STU2: Tower | TWR | |
| Aleš Matušík | STU2: Tower | ||
| Daniel Tůma | STU2: Tower | TWR | |
| Eduard Horák | STU2: Tower | TWR | |
| Jakub Pekař | STU2: Tower | TWR | |
| Jan Koranda | STU2: Tower | TWR | |
| Lukáš Krasňan | STU2: Tower | TWR | |
| Marek Sobaniec | STU2: Tower | TWR | |
| Martin Dvořák | STU2: Tower | TWR | |
| Matěj Borovka | STU2: Tower | TWR | |
| Matyáš Perner | STU2: Tower | LKPR_GND | |
| Michal Zika | STU2: Tower | TWR | |
| Pavel Zeman | STU2: Tower | TWR | |
| Petr Bílý | STU2: Tower | TWR | |
| Radim Bradáč | STU2: Tower | TWR | |
| Stanislav Horký | STU2: Tower | TWR | |
| Tomáš Slončík | STU2: Tower | TWR | |
| Vojtěch Javorský | STU2: Tower | TWR | |
| Adam Gatner | STU2: Tower (Student) | ||
| Stepan Simecek | STU2: Tower (Student) | LKPR_TWR | |
| Vojtěch Štrupl | STU2: Tower (Student) | ||
| Zdenek Votava | STU2: Tower (Student) | LKPR_GND | |
| Filip Točík | STU1: Delivery / Ground | AFIS LKBE/LT/MH | |
| Honza Adam | STU1: Delivery / Ground | AFIS LKBE/LT/MH | |
| Ivo Hrdlička | STU1: Delivery / Ground | AFIS LKBE/LT/MH | |
| Jakub Jiřička | STU1: Delivery / Ground | LKPR_GND | |
| Marek Novotný | STU1: Delivery / Ground | AFIS LKBE/LT/MH | |
| Robert Skirbuckij | STU1: Delivery / Ground | AFIS LKBE/LT/MH | |
| Tomáš Kulhavý | STU1: Delivery / Ground | AFIS LKBE/LT/MH | |
| Vojtěch Stehlík | STU1: Delivery / Ground | AFIS LKBE/LT/MH | |
| David Netymach | STU1: Delivery / Ground (Student) | ||
| Felix Riehle | STU1: Delivery / Ground (Student) | ||
| Jan Podlipsky | STU1: Delivery / Ground (Student) | ||
| Jan Říha | STU1: Delivery / Ground (Student) | ||
| Marek Veselý | STU1: Delivery / Ground (Student) | ||
| Martin Bernict | STU1: Delivery / Ground (Student) | ||
| Martin Mikuláš | STU1: Delivery / Ground (Student) | ||
| Ondřej Gelbič | STU1: Delivery / Ground (Student) | ||
| Sebastian Zvonař | STU1: Delivery / Ground (Student) |
SELECT name,r_name,ur_student,ur_comments,profile_value FROM b_userrating JOIN j17_users ON id = ur_user JOIN b_ratings ON ur_rating = r_id INNER JOIN j17_user_profiles ON id = ur_user WHERE ur_rating > 0 AND id = user_id ORDER BY ur_rating DESC, ur_student ASC, name ASC
