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='179') 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
Since 1997, Scheme Designers has pioneered the business of exterior design for aircraft of all types, sizes, and models – airline fleets, business jets, piston aircraft, as well as helicopters. Around the globe, there are over 10,500 unique aircraft wearing a Scheme Designers paint scheme. Over half of the OEMs delivering new aircraft work with Scheme Designers to develop the exterior styling for their factory new models, setting the standard for the industry as a whole. The Scheme Designers team of artists and designers work with each customer from inception through application of their paint scheme design at the paint shop, and their job isn’t done until the design is executed perfectly and the customer is completely satisfied.