# Contacts linked to Company in segment are not appearing **URL:** \ **Category:** Product Support\ **Created:** [July 19, 2017, 7:14am UTC](https://forum.mautic.org/t/contacts-linked-to-company-in-segment-are-not-appearing/8988 "2017-07-19T07:14:53Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 19, 2017, 7:14am UTC](https://forum.mautic.org/t/contacts-linked-to-company-in-segment-are-not-appearing/8988/1 "2017-07-19T07:14:53Z")
m having an issue with the contact segment is not making the association between the contact and the company filter field in the segment. For “platform\_\_ABC”, 6,000 contacts appear in the segment based on the value “Yes” on their associated company table which seems correct; however, for “platform\_\_XYZ”, ZERO contacts appear base don their associated company table field even though the SQL query shows the company table has been populated for 1,145 companies properly. None of the linked contacts appear in the segment. Does anyone know whats going on here? SQL * * * 1145 for XYZ Select count(\*) from lead\_map.MAP2q\_companies WHERE lead\_map.MAP2q\_companies.platform\_\_xyz = "Yes" And 2279 for ABC: Select count(\*) from lead\_map.MAP2q\_companies WHERE lead\_map.MAP2q\_companies.platform\_\_abc = "Yes" ---
**Author:** ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)\ **Post date:** [July 19, 2017, 7:14am UTC](https://forum.mautic.org/t/contacts-linked-to-company-in-segment-are-not-appearing/8988/2 "2017-07-19T07:14:53Z")
m having an issue with the contact segment is not making the association between the contact and the company filter field in the segment. For “platform\_\_ABC”, 6,000 contacts appear in the segment based on the value “Yes” on their associated company table which seems correct; however, for “platform\_\_XYZ”, ZERO contacts appear base don their associated company table field even though the SQL query shows the company table has been populated for 1,145 companies properly. None of the linked contacts appear in the segment. Does anyone know whats going on here? ## SQL 1145 for XYZ Select count(\*) from lead\_map.MAP2q\_companies WHERE lead\_map.MAP2q\_companies.platform\_\_xyz = “Yes” And 2279 for ABC: Select count(\*) from lead\_map.MAP2q\_companies WHERE lead\_map.MAP2q\_companies.platform\_\_abc = “Yes”