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=3428 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
Details
People
Description
Korean Air opened this year’s Farnborough air show with an eye-catching commitment for up to 50 Boeing widebodies, provisionally signing up for 777-9s and 787-10s. The SkyTeam carrier signed a memorandum of understanding covering 20 firm orders for both the 777-9s and 787-10, as well as taking options on 10 more Dreamliners.
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