Code: Select all
id | account_id | meta_key | meta_valueHere is my code so far...
Code: Select all
SELECT a.* FROM accounts AS a
LEFT JOIN accounts_meta AS am ON a.id = am.account_id AND am.meta_key != 'referrer_paid'
WHERE a.account_referrer != ''
GROUP BY a.id