Listings for: L

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

United StatesL-3 Communications ESSCO

Address: 90 Nemco Way , Ayer , Massachusetts , 01432

Phone: +1 97 8568 5100

Products and Services

SpainLa Coruna Airport

Address: Apartado de Correos 10 , Rutis-Vilaboa , E-15180 La Coruna

Phone: +34 9 8118 7200

Products and Services

United StatesLa Crosse Municipal Airport

Address: 2850 Airport Road , La Crosse , WI 54603-1264

Phone: +1 68 0789 7464

Products and Services

Canary IslandsLa Gomera Airport

Address: , La Gomera

Phone: +34 9 2287 3000

Products and Services

CubaLa Havana - Jose Marti International Airport

Address: Rancho Boyeros , Havana

Phone: +5 3649 7063

Products and Services

1 2 3 19