How create SQL pagination difficult join query with duplicate data?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I have several tables in the database. Users, profiles and user roles. The relationship of profiles and users one to one. The relationship of roles and users many to many. To select all users, I send the following request: SELECT A.role_id, A.role_name, A.user_id,B.user_username, B.user_password, B.profile_color_text, B.profile_color_menu, B.profile_color_bg FROM (SELECT Roles.role_id, Roles.role_name, UserRoles.user_id FROM Roles INNER JOIN UserRoles ON Roles.role_id = UserRoles.role_id) AS A LEFT JOIN (SELECT Users.user_username, Users.user_password, Profiles.profile_color_text, Profiles.profile_color_menu