1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| select
`apaptalrqdsgh`.`company_airport_id` AS `company_airport_id`,
`ap`.`sf_account` AS `company_airport_sf_account`,
`ap`.`iata_code` AS `company_airport_iata_code`,
`ap`.`name` AS `airport_name`,
`apaptalrqdsgh`.`airport_terminal_id` AS `airport_terminal_id`,
`apt`.`sf_account` AS `airport_terminal_sf_account`,
`apt`.`name` AS `airport_terminal_name`,
`bcat`.`name` AS `airport_terminal_color`,
`apaptalrqdsgh`.`company_airline_id` AS `company_airline_id`,
`al`.`sf_account` AS `company_airline_sf_account`,
`al`.`iata_code` AS `company_airline_iata_code`,
`al`.`name` AS `airline_name`,
`bcal`.`name` AS `airline_color`,
`apaptalrqdsgh`.`reader` AS `reader`,
`apaptalrqdsgh`.`bcbp_read` AS `bcbp_read_capable`,
`apaptalrqdsgh`.`printer` AS `printer`,
`apaptalrqdsgh`.`bcbp_print` AS `bcbp_print_capable`,
`apaptalrqdsgh`.`request_id` AS `request_id`,
`rq`.`req_status` AS `request_status`,
`rq`.`bcbp_live_date` AS `request_live_date`,
`apaptalrqdsgh`.`equipment_dcs_id` AS `equipment_dcs_id`,
`ds`.`name` AS `dcs_name`,
`apaptalrqdsgh`.`company_ground_handler_id` AS `company_ground_handler_id`,
`gh`.`short_name` AS `ground_handler_name`,
`al`.`bcbp_scope` AS `airline_scope`,
`country`.`iso` AS `airline_sf_coutry_iso`,
`country`.`name` AS `airline_sf_coutry_name`,
`country`.`region` AS `airline_sf_region`,
IF(SUM(
SELECT is_active
FROM admin_by_airport
LEFT JOIN contact ON contact.id = admin_by_airport.contact_id
LEFT JOIN sf_guard_user ON contact.user_id = sf_guard_user.id
WHERE admin_by_airport.company_id =411
) > 1, 1,0) as toto
from
`flies_to` `apaptalrqdsgh`
left join `company_airport` `ap` on `apaptalrqdsgh`.`company_airport_id` = `ap`.`id`
left join `airport_terminal` `apt` on `apaptalrqdsgh`.`airport_terminal_id` = `apt`.`id`
left join `company_airline` `al` on `apaptalrqdsgh`.`company_airline_id` = `al`.`id`
left join `country` on `al`.`country_id` = `country`.`id`
left join `bcbp_color` `bcal` on `al`.`bcbp_color_id` = `bcal`.`id`
left join `bcbp_color` `bcat` on `apt`.`bcbp_color_id` = `bcat`.`id`
left join `request` `rq` on `apaptalrqdsgh`.`request_id` = `rq`.`id`
left join `equipment_dcs` `ds` on `apaptalrqdsgh`.`equipment_dcs_id` = `ds`.`id`
left join `company_ground_handler` `gh` on `apaptalrqdsgh`.`company_ground_handler_id` = `gh`.`id` |
Partager