SELECT Q.`id`, Q.`title`, Q.`alias`, Q.`introtext`, Q.`fulltext`, Q.`catid`, Q.`publish_up`, Q.`mr_midia_tipo_midia_id`, Q.`id_mae`, if(Q.`title_serie` is null, CC.`title`, Q.`title_serie`) as title_serie, ifnull(COLECAO.`id_user`, 0) AS favorito, Q.url_youtube FROM ( SELECT 50 as rank, TEMAC.`id`, TEMAC.url_youtube, TEMAC.`title`, TEMAC.`alias`, TEMAC.`introtext`, TEMAC.`fulltext`, TEMAC.`catid`, TEMAC.`publish_up`, TEMAC.`mr_midia_tipo_midia_id`, TEMAC.`id_mae`, TEMAS.`title` as title_serie FROM `wf64l_content` TEMAC LEFT OUTER JOIN `wf64l_content` TEMAS ON TEMAC.`id_mae` = TEMAS.`id` WHERE TEMAC.`state` = 1 AND ( TEMAC.`catid` in (SELECT `id` FROM `wf64l_categories` WHERE `id_pai` in (34)) ) Q INNER JOIN `wf64l_categories` CC ON CC.`id` = Q.`catid` LEFT OUTER JOIN `#__um_artigo` COLECAO ON COLECAO.`id_content` = Q.`id` AND COLECAO.`id_user` = 0 GROUP BY Q.`id` ORDER BY sum(Q.`rank`) DESC, Q.`publish_up` DESC