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='201') 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
Close Brothers Aviation and Marine provides flexible funding for General Aviation aircraft and a wide range of leisure and commercial vessels. We have been at the forefront of General Aviation finance since 1976, originally trading as Air and General Finance Limited and we have over 5 years experience providing marine finance. In that time, we have funded thousands of aircraft and boats. Our aim is to make the process of buying an aircraft or boat as fast and easy as possible. Our professional approach is designed to achieve this whilst minimising risks along the way. We can help you raise finance using your existing aircraft or boat as security.