I am trying this code, that works well.
SELECT U.username, U.update_photo
FROM users U
INNER JOIN lists_has_users H
ON U.id_user = H.users_id_user
INNER JOIN lists L
ON L.id_lists = H.lists_id_lists
WHERE L.users_id_user = ?
Now the problem. This query will select all the users of the lists. What i want is limit the number of output members by list.
For example, two members by each list (id_lists).
Any idea? thanks