I am trying this code, that works well.
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.Code: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 = ?
For example, two members by each list (id_lists).
Any idea? thanks