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

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
  LEFT JOIN smb_partners_partner_entity_varchar AS pv2 ON pv2.entity_id = main.entity_id
  LEFT JOIN sales_flat_order AS ord ON ord.partner_id = main.entity_id
WHERE main.entity_id = pv.entity_id AND
pv.attribute_id = 235 AND
pv1.attribute_id = 233 AND pv2.attribute_id = 232
  AND ord.entity_id = 30;