SELECT c.*, co.companyName as newCompanyName, cntry.code AS countryCode
FROM fmf6a_showcase_company2contact AS c2c
LEFT JOIN fmf6a_showcase_contact c ON c2c.contactId = c.id
LEFT JOIN fmf6a_showcase_company co ON c.companyId = co.id
LEFT JOIN fmf6a_showcase_country cntry ON c.countryId = cntry.id
WHERE c2c.isDeleted=0 AND c2c.companyId=1507 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
F-5 - S3 AeroDefense
Founded in 2005 by Jeff Wnuk, Aksel Sidem and Sebastien Imbert, S3 AeroDefense began as S3 International with the intent to provide innovative, cost effective Spares, Repairs Services, and Solutions: to become a One Stop Shop for the Commercial and Military aircraft operators around the world.
Description
More Products & Services
Products & Services
What We Do - S3 AeroDefense
S3 Aerodefense
Founded in 2005 by Jeff Wnuk, Aksel Sidem and Sebastien Imbert, S3 AeroDefense began as S3 International with the intent to provide innovative, cost effective Spares, Repairs Services, and Solutions: to become a One Stop Shop for the Commercial and Military aircraft operators around the world.
Solutions - S3 AeroDefense
S3 Aerodefense
Founded in 2005 by Jeff Wnuk, Aksel Sidem and Sebastien Imbert, S3 AeroDefense began as S3 International with the intent to provide innovative, cost effective Spares, Repairs Services, and Solutions: to become a One Stop Shop for the Commercial and Military aircraft operators around the world.
People
Description
Founded in 2005 by Jeff Wnuk, Aksel Sidem and Sebastien Imbert, S3 AeroDefense began as S3 International with the intent to provide innovative, cost effective Spares, Repairs Services, and Solutions: to become a One Stop Shop for the Commercial and Military aircraft operators around the world.
Share
Recent Chats
Share via email
Future: handle WhatsApp here
Future: handle LinkedIn here
Future: handle Twitter here
SUBMENU HERE
Share via Chat
Copy Link