SELECT jos_reps.*, jos_country.country_name, jos_applications.nombre AS application_name, SUM(jos_applications.prioridad) AS s_prioridad FROM jos_reps JOIN jos_reps_countries ON jos_reps_countries.rep_id = jos_reps.id JOIN jos_country ON jos_country.country_id = jos_reps_countries.country_id LEFT JOIN jos_reps_applications ON jos_reps_applications.rep_id = jos_reps.id LEFT JOIN jos_applications ON jos_applications.id = jos_reps_applications.application_id WHERE jos_reps.activo = 1 AND jos_reps_countries.country_id = '223' GROUP BY jos_reps.id ORDER BY s_prioridad, jos_reps.user