select GROUP_CONCAT(psa.advertiser_id) from wp_pods_advertiser advertiser inner join wp_podsrel_advertiser_product_service_advertiser psa ON (psa.advertiser_id = advertiser.id) inner join wp_podsrel_advertiser_product_service_service_type cat_type ON (cat_type.advertiser_product_service_id = psa.advertiser_product_service_id and cat_type.service_type_id='222') inner join wp_pods_product_service_type cat ON (cat.id = cat_type.service_type_id) where advertiser.active=1 AND advertiser.product_services_supplier=1
Jeppesen- the leading international aviation information services company provides: - A worldwide coverage of navigation charts in digital format or on paper - An electronic database for use in FMS or GPS equipment - Different computer flight planning- weather and performance calculation services - Document management services for aircraft maintenance as well as JAR OPS based Operation Manuals - Plus various pilot training materials and training courses.
Satcom Direct is a privately held company founded in 1997, headquartered in Satellite Beach, Florida. The company provides global satellite communications to business aviation, military aviation - including Heads of State, NATO and DOD - general aviation, land mobile and maritime customers. The company also provides land mobile and handheld satellite equipment to emergency response and media outlets as well as recreational users travelling to remote locations with limited cellular and data network coverage.