Listings for: Y

Company Search: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

SELECT DISTINCT dcc.id_company, dc.Organisation, dc.Address1, dc.Address2, dc.Address3, dc.Town, dc.County, dc.PostCode, dc.Tel, dc.countryID, dctry.Country, `enhanced`, `expiry_date`, IF(`expiry_date`>NOW(),'Yes','')AS curExp, du.file_name FROM wp_d_company_category dcc INNER JOIN wp_d_category dct ON dcc.id_category=dct.id_category INNER JOIN wp_d_company dc ON dcc.id_company = dc.id_company LEFT JOIN wp_d_uploads du ON dc.id_company=du.id_company INNER JOIN wp_d_country dctry ON dc.countryID=dctry.ID WHERE `approved` = 'Yes' AND Organisation LIKE 'y%' AND (du.type = 'Logo' || du.type IS NULL) ORDER BY curExp DESC,`Organisation` ASC1 2 3

RussiaYakutsk International Airport

Address: 10 Gagarin St , 677014 Yakutsk , Republic of Sakha (Yakutia)

Phone: +7 41 1249 5353

Products and Services

JapanYamagata Airport

Address: , Yamagata

Phone: +81 2 3747 3111

Products and Services

MyanmarYangon International Airport

Address: Mingaladon , Yangon

Phone: +9516 2712

Products and Services

Republic of Korea (South)Yangyang International Airport

Address: 281-1 Dongho-ri , Sonyang-myeon , Yangyang County , Gangwon-do

Phone: +82 3 3670 7114

Products and Services

United StatesYankee Environmental Systems, Inc.

Address: Airport Industrial Park , 101 Industrial Boulevard , Turners Falls , Massachusetts , 01376

Phone: +1 41 3863 0200

Products and Services

CameroonYaounde-Nsimalen International Airport

Address: BP 13615 , Yaounde

Phone: +2 3723 3602

Products and Services

NetherlandsYAPsystems

Address: Eemnesserweg 11-05 , 1251NA Laren

Phone: +31 (0)85 00 20 850

Products and Services

United KingdomYED Limited

Address: Thorne House , Eastville , Yeovil , Somerset , BA21 4JD

Phone: +44 11 7907 4761

Products and Services

1 2 3