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=769 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
More Products & Services
Products & Services
SBF Product Sheet 5 x 4 Final Red
Neil Jones Food Company
TTK rvLj
Neil Jones Food Company
SNAP Pak 4.17.2020
Neil Jones Food Company
EP 12112019
Neil Jones Food Company
OT Fruits 01232017
Neil Jones Food Company
Intoducing NJFC 01212021
Neil Jones Food Company
Retail 06012020 2
Neil Jones Food Company
Description
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