Listings for: S

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

NetherlandsS-P-S Group

Address: Uiverweg 2-6 , 1118 DS Schiphol

Phone: +31 02 0354 0063

Products and Services

ItalyS.I.T.I Srl

Address: Via Dante 35 , Ponte Lambro (CO) , I-22037

Phone: +39 0 3162 3363

Products and Services

SwedenSaab AB

Address: Saab ATM , Solhusgatan , Gothenburg , S-412 76

Phone: +46 8 5808 4459

Products and Services

SwedenSaab AB

Address: PO Box 1026 , SE-831 29 , Ostersund

Phone: +46 1318 5521

Products and Services

SwedenSaab ATM

Address: Solhusgatan , Gothenburg , SE-412 76

Phone: +46 8 5808 4459

Products and Services

SwedenSaab ATM

Address: Solhusgaten , Gothenburg , SE-412 76

Phone: +46 3 1739 0326

Products and Services

South AfricaSaab Grintek Aviation Systems

Address: 44 Oak Avenue , Highveld Techno Park (West Park Entrance) , Centurion

Phone: +27 1 2672 8300

Products and Services

SwedenSaab Systems

Address: Nettovagen 6 , Jarfalla , SE-175 88

Phone: +46 8 5808 4000

Products and Services

GermanySaarbrucken Airport

Address: Postfach 500145 , D-66063 Saarbrucken

Phone: +49 6 8938 3204

Products and Services

1 2 3 44