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