Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement