Saiko,
Citytable t2 is the city table given an alias so it can be compared in the subquery against the same table in the outer query. This is known as a correlated subquery in SQL Server. Short of some kind of subquery, I don't know that you can pull this one off using a single select statment. I also am not aware that mySql supports the TOP keyword, which is specific to SQL Server.

You might try handling it in your application as opposed to your sql query. Here is some pseudo code:

open.recordset (a distinct list of cities)
while not recordset eof
open.nextrecordset (a list of all members for that city in order)
for i = 1 to 5
display a member
next
wend


Jeff