The below is my query and p.customers is a multi select field. I only want the customers in that customer list (p.customers) that have the checkbox with id custentity_xyz as 'F'

SELECT
			p.id as promo_id, 
			p.customers as customer_list, 
			c.id as group_customer_id 
		FROM 
			promotionCode AS p 
			LEFT OUTER JOIN EntityGroup AS eg ON p.customergroup = eg.id 
			LEFT OUTER JOIN EntityGroupMember AS egm ON eg.id = egm.group 
			LEFT OUTER JOIN customer AS c on egm.member = c.id 
		WHERE 
			p.isinactive = 'F' 
			AND p.isPublic = 'F' 
			AND p.custrecord_promotion_do_not_sync = 'F'
            AND p.name NOT LIKE '%PROJECT%'
            AND p.name NOT LIKE '%project%'
			AND (
				(
				egm.member is NOT NULL 
				AND c.isinactive = 'F'
				) 
				OR egm.member is NULL
			)

@Shai Coleman Can you help with this, got little distracted but unable to figure it out. The very first join is not working (map_promotioncode_customers ). Basically need the correct mapping table name, but unsure on how to identify it.

SELECT
    p.id as promo_id,
    p.customers as customer_list,
FROM
    promotioncode AS p
    JOIN map_promotioncode_customers AS MAP on MAP.mapone = p.id
    JOIN customer AS cust on MAP.maptwo = cust.id
WHERE
    p.id = '181'

Getting Error : Invalid search type: map_promotioncode_customers Also tried promotionCodeEntityMap but seems its also incorrect or not available in SuiteQL not really sure on it.