Listings for: J

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

United StatesJ&B Aviation Services

Address: 907 Cotting Lane Suite A , Vacaville , California , 95688

Phone: +1 70 7469 2600

Products and Services

GermanyJ. Schmalz GmbH

Address: Aacher Str. 29 , 72293 Glatten

Phone: +49 (0) 7443 24030

Products and Services

United StatesJackson Evers International Airport

Address: PO Box 98109 , Jackson , MS 39298-8109

Phone: +1 60 1939 5631

Products and Services

United StatesJackson Hole Airport

Address: PO Box 159 , Jackson , WY 83001

Phone: +1 30 7733 7682

Products and Services

United StatesJacksonville International Airport

Address: PO Box 18018 , Jacksonville , FL 33229-0018

Phone: +1 90 4741 2000

Products and Services

United StatesJacobs Consultancy

Address: 556 Airport Boulevard , Suite 300 , Burlingame , California

Phone: +1 650 579 77 22

Products and Services

United KingdomJacobsGIBB Limited

Address: Jacobs House , London Road , Reading , RG6 1BL

Phone: +44 11 8963 5000

Products and Services

IndiaJaipur Airport

Address: Airport Director , Civil Airport , Sanganer , Jaipur , Rajasthan

Phone: +91 1 4155 0623

Products and Services

IndonesiaJakarta - Halim Perdanakusuma International Airport

Address: Room 244, 2nd Floor , Terminal Building , Bandara Halim Perdanakusuma , Jakarta Timur 13610

Phone: +62 21 8089 9599

Products and Services

1 2 3 7