SELECT main.entity_id, pv.store_id, pv.value as stripe_id, pv1.value as contact_email

FROM smb_partners_partner_entity AS main
  LEFT JOIN smb_partners_partner_entity_varchar AS pv ON pv.entity_id = main.entity_id
  LEFT JOIN smb_partners_partner_entity_varchar AS pv1 ON pv1.entity_id = main.entity_id
WHERE main.entity_id = pv.entity_id AND
pv.attribute_id = 235 AND
pv1.attribute_id = 233

group by entity_id, store_id