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=2685 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
Register for Free
Join now to browse and connect with companies in your industry.
Register for Free
Join now to browse and connect with companies in your industry.
Growing business connections with our digital platform and trade show solutions.
© 2022 onwards Online Expos LLC. All rights reserved.
Socials