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=165 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
The EOTECH Advantage and Tour
Learn all about The EOTECH Advantage during an EOTECH facility tour with Robert O'Neill.
Description
More Products & Services
Products & Services
Rifle Scopes
EOTECH
The store will not work correctly in the case when cookies are disabled. JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.
View All Holographic Sights - Holographic Sights
EOTECH
The store will not work correctly in the case when cookies are disabled. JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.
View All Hybrid Sights - Hybrid Sights
EOTECH
The store will not work correctly in the case when cookies are disabled. JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.
Magnifiers
EOTECH
The store will not work correctly in the case when cookies are disabled. JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.
Description
Learn all about The EOTECH Advantage during an EOTECH facility tour with Robert O'Neill.
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