Listings for: Z

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 'z%' AND (du.type = 'Logo' || du.type IS NULL) ORDER BY curExp DESC,`Organisation` ASC1 2 3 4

DenmarkZacho Products A/S

Address: Ostermarksvej 12 , Bjedstrup , Skanderborg , DK-8660

Phone: +45 8657 7222

Products and Services

CroatiaZadar Airport

Address: PO Box 367 , 23000 Zadar

Phone: +38 5 2331 3311

Products and Services

United KingdomZafire Aviation Software Limited

Address: 10 Manor Park , Banbury , OX16

Phone: +44 12 9570 1810

Products and Services

CroatiaZagreb Airport

Address: Pleso b b , 10150 Zagreb

Phone: +38 5 1456 2222

Products and Services

GreeceZakinthos - Dionysios Solomos Airport

Address: , 291 00 Zakinthos

Phone: +30 26 9502 3970

Products and Services

Zambia Zambia Air Services Training Institute

Address: PO Box 310198 , Lusaka

Phone: +26 0127 1043

Products and Services

1 2 3 4