SELECT pos.id_posgrado, pos.grado, pos.nombre, pos.name, menu_joomla.path AS alias, pos.id_cms, de.nombre AS nombre_decanato, de.name as name_decanato, menu_joomla_de.path AS alias_decanato, de.datos AS color, sa.id_sistemas, pos.modalidad, pos.nueva, (SELECT group_concat('{"nombre_modalidad":"',IF(modalidad != 'Tehuacán', modalidad, NULL),'","alias":"', tyhu8_menu.path,'"}' ) FROM posgrado INNER JOIN joomladb.tyhu8_menu ON tyhu8_menu.id = posgrado.id_cms WHERE nombre = pos.nombre AND publicado_web = 1 AND grado='M' ) AS lista_modalidad, (SELECT count(DISTINCT IF(modalidad != 'Tehuacán', modalidad, NULL)) FROM posgrado WHERE nombre = pos.nombre AND publicado_web = 1 AND grado='M' ) AS num_modalidad FROM posgrado AS pos INNER JOIN joomladb.tyhu8_menu AS menu_joomla ON menu_joomla.id = pos.id_cms INNER JOIN decanato AS de ON de.id_decanato = pos.id_decanato LEFT JOIN joomladb.tyhu8_menu AS menu_joomla_de ON menu_joomla_de.id = de.alias INNER JOIn sistemas_academicos AS sa ON sa.id_sistemas = de.id_sistemas WHERE grado="M" AND publicado_web=1 AND modalidad != "Tehuacán" AND modalidad="Presencial" group by pos.nombre ORDER BY de.id_decanato, pos.nombre