Nije testirano ali čisto da ti ukažem na drugačiji pristup pa ti napravi izmene kako tebi odgovara:
Citat:
SELECT u.`id`, u.`username`, u.`email`, u.`first_name`, u.`last_name`, mb.`moneybookers_email`, m.payments_count
FROM `users` u
INNER JOIN (
SELECT `user_id`, count(*) as payments_count, `moneybookers_email` FROM `payment`
GROUP BY `moneybookers_email` HAVING payments_count>1
) mb ON u.id=mb.`user_id`
ORDER BY mb.`moneybookers_email`
|