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=2285 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
About Future Forces Forum
FUTURE FORCES FORUM (FFF) is a highly recognized and widely endorsed international platform for defence & security information exchange and for promotion of the allied countries and their partners’ objectives within national and global security. All events are primarily focused on the presentation of current and future needs of the armed and security forces, state-of-the-art technologies and R&D programmes with interactions between all involved participants due to the interconnected topics on the military and also civilian level.
Description
People
No Entries
Description
FUTURE FORCES FORUM (FFF) is a highly recognized and widely endorsed international platform for defence & security information exchange and for promotion of the allied countries and their partners’ objectives within national and global security. All events are primarily focused on the presentation of current and future needs of the armed and security forces, state-of-the-art technologies and R&D programmes with interactions between all involved participants due to the interconnected topics on the military and also civilian level.
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