Pogledajte određenu poruku
Staro 24. 05. 2014.   #2
ajankovic
Aleksandar Janković
Qualified
 
Avatar ajankovic
 
Datum učlanjenja: 16.10.2010
Lokacija: Bg-Sd
Poruke: 165
Hvala: 70
54 "Hvala" u 36 poruka
ajankovic is on a distinguished road
Default

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`
__________________
ajankovic.com]
ajankovic je offline   Odgovorite uz citat