hi, thuc hien cau query nay:
SELECT l.subscriberid AS subscriberid
FROM email_list_subscribers AS l,
email_queues AS q
WHERE q.recipient = l.subscriberid
AND q.queueid = 4
AND queuetype = 'send'
AND l.listid IN (1)
GROUP BY l.emailaddress
HAVING COUNT(l.emailaddress) > 1;
no bao loi:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'emarketing_data.l.subscriberid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
pro nao huong cach khac phuc