Database Queries

SHOW FULL COLUMNS FROM `cities`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'cities' AND kcu.table_name = 'cities'

SELECT * FROM `cities`

SELECT * FROM `flights_dashboard` WHERE (`departure_time` BETWEEN 1752174000 AND 1752274800) AND ((`delete`=FALSE) OR (`delete` IS Null)) ORDER BY `departure_time`

SHOW FULL COLUMNS FROM `flights_dashboard`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'flights_dashboard' AND kcu.table_name = 'flights_dashboard'

SELECT * FROM `airports` WHERE `code` IN ('SSH', 'AYT', 'STN', 'HRG', 'RMF', 'HER', 'KTW', 'VNO', 'WRO', 'OTP', 'RMO', 'EVN', 'SCV', 'BGY', 'BVA', 'VIE', 'ATH', 'BOJ', 'LCA', 'NBE', 'POZ', 'BER', 'ALC', 'CLJ', 'LIS', 'IST', 'RZE')

SHOW FULL COLUMNS FROM `airports`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'airports' AND kcu.table_name = 'airports'

SELECT * FROM `airports` WHERE `code` IN ('VNO', 'RMO', 'WRO', 'SSH', 'OTP', 'HRG', 'SCV', 'VIE', 'RMF', 'AYT', 'BVA', 'BGY', 'ATH', 'KTW', 'POZ', 'NBE', 'BOJ', 'STN', 'LCA', 'ALC', 'BER', 'CLJ', 'LIS', 'RZE', 'IST', 'HER')

SELECT * FROM `aircrafts` WHERE `tech_code` IN ('UR-SQJ', 'UR-SQO', 'UR-SQG', 'UR-SKB', 'UR-SQF', 'UR-SQD', 'UR-SQM', 'UR-SQL', 'UR-SQB', 'UR-SAT', 'UR-SQC', 'UR-SLW', 'UR-SQE', 'UR-SAS', 'UR-SQK', 'UR-SAU', 'UR-SQA', 'UR-SQI', 'UR-SLG', 'UR-SKC')

SHOW FULL COLUMNS FROM `aircrafts`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'aircrafts' AND kcu.table_name = 'aircrafts'

SELECT * FROM `flights_dashboard` WHERE (`departure_time` BETWEEN 1752260400 AND 1752361200) AND ((`delete`=FALSE) OR (`delete` IS Null)) ORDER BY `departure_time`

SELECT * FROM `airports` WHERE `code` IN ('SSH', 'LCA', 'BOJ', 'LIS', 'IST', 'RMF', 'AYT', 'RZE', 'RMO', 'KTW', 'HRG', 'HER', 'OTP', 'BEG', 'BJV', 'CLJ', 'PRG', 'WAW', 'STN', 'BCN', 'BAY', 'PMI', 'GDN', 'LEJ', 'FRA', 'VAR', 'SKG', 'NCE', 'DJE')

SELECT * FROM `airports` WHERE `code` IN ('KTW', 'OTP', 'RMO', 'HRG', 'HER', 'AYT', 'SSH', 'BEG', 'RMF', 'BJV', 'CLJ', 'WAW', 'STN', 'BCN', 'PRG', 'BAY', 'GDN', 'LEJ', 'PMI', 'FRA', 'NCE', 'SKG', 'VAR', 'DJE', 'RZE')

SELECT * FROM `aircrafts` WHERE `tech_code` IN ('UR-SQG', 'UR-SQM', 'UR-SLG', 'UR-SQD', 'UR-SQF', 'UR-SQE', 'UR-SAT', 'UR-SKB', 'UR-SQB', 'UR-SQQ', 'UR-SQO', 'UR-SQC', 'UR-SQJ', 'UR-SQL', 'UR-SKC', 'UR-SQK', 'UR-SLW', 'UR-SAS', 'UR-SQP', 'UR-SAU', 'UR-SQH', 'UR-SQA')

SELECT * FROM `flights_dashboard` WHERE (`departure_time` BETWEEN 1752346800 AND 1752447600) AND ((`delete`=FALSE) OR (`delete` IS Null)) ORDER BY `departure_time`

SELECT * FROM `airports` WHERE `code` IN ('DJE', 'AYT', 'RMF', 'RMO', 'RZE', 'SSH', 'HRG', 'HER', 'KTW', 'OTP', 'EVN', 'BEG', 'LCA', 'DLM', 'NBE', 'CLJ', 'TIA', 'BCN', 'TSR', 'WAW', 'SCV', 'IST', 'TIV', 'DUS', 'NYO', 'OMR', 'TLV')

SELECT * FROM `airports` WHERE `code` IN ('KTW', 'RMO', 'AYT', 'HER', 'SSH', 'EVN', 'BEG', 'LCA', 'NBE', 'CLJ', 'DLM', 'RMF', 'BCN', 'HRG', 'WAW', 'TIA', 'TSR', 'SCV', 'DUS', 'IST', 'TIV', 'NYO', 'RZE', 'OMR', 'TLV', 'OTP')

SELECT * FROM `aircrafts` WHERE `tech_code` IN ('UR-SQD', 'UR-SQA', 'UR-SQF', 'UR-SQL', 'UR-SLW', 'UR-SQB', 'UR-SQE', 'UR-SQG', 'UR-SQC', 'UR-SLG', 'UR-SQH', 'UR-SQJ', 'UR-SQQ', 'UR-SAS', 'UR-SQO', 'UR-SAU', 'UR-SQM', 'UR-SQK')

SELECT * FROM `flights_dashboard` WHERE (`departure_time` BETWEEN 1752433200 AND 1752534000) AND ((`delete`=FALSE) OR (`delete` IS Null)) ORDER BY `departure_time`

SELECT * FROM `airports` WHERE `code` IN ('SSH', 'TLV', 'AYT', 'RMO', 'RMF', 'HER', 'KTW', 'HRG', 'OTP', 'EVN', 'BOJ', 'LCJ', 'BCM', 'IST', 'RZE', 'BVA', 'ZRH', 'WAW', 'ATH', 'IAS', 'OMR', 'SCV', 'GDN', 'FRA', 'TIV', 'PRG', 'ALC', 'POZ', 'BCN')

SELECT * FROM `airports` WHERE `code` IN ('KTW', 'RMO', 'AYT', 'HER', 'LCJ', 'EVN', 'SSH', 'BOJ', 'ZRH', 'RZE', 'HRG', 'BCM', 'BVA', 'IST', 'WAW', 'RMF', 'ATH', 'IAS', 'GDN', 'OMR', 'SCV', 'FRA', 'POZ', 'ALC', 'BCN', 'PRG', 'TIV', 'OTP', 'TLV', 'TLL', 'NBE')

SELECT * FROM `aircrafts` WHERE `tech_code` IN ('UR-SQD', 'UR-SQG', 'UR-SQO', 'UR-SQF', 'UR-SAU', 'UR-SQJ', 'UR-SQB', 'UR-SQC', 'UR-SQE', 'UR-SQK', 'UR-SLG', 'UR-SQQ', 'UR-SAS', 'UR-SQA', 'UR-SLW', 'UR-SQL', 'UR-SAT', 'UR-SQI', 'UR-SKC', 'UR-SQP')