<!-- 
        SELECT	RT.id, RT.id_mae
            FROM		(SELECT	IT.id, IT.catid, IT.id_mae, IT.mr_midia_tipo_midia_id, IT.publish_up, IT.ordering, 2 as rank, IT.state, IT.alias, IT.introtext, IT.likes, IT.title
                            FROM		#__content IT WHERE IT.introtext like '%%'       UNION
                            SELECT	FT.id, FT.catid, FT.id_mae, FT.mr_midia_tipo_midia_id, FT.publish_up, FT.ordering, 1 as rank, FT.state, FT.alias, FT.introtext, FT.likes, FT.title
                            FROM		#__content FT WHERE FT.fulltext like '%%' 
                            UNION
                            SELECT	T.id, T.catid, T.id_mae, T.mr_midia_tipo_midia_id, T.publish_up, T.ordering, IF(T.catid = 58 OR T.catid = 59, 18, 6), T.state, T.alias, T.introtext, T.likes, T.title
                            FROM		#__content T WHERE T.title like '%%' 
                                UNION
                                SELECT	ARS.id, ARS.catid, ARS.id_mae, ARS.mr_midia_tipo_midia_id, ARS.publish_up, ARS.ordering, 5 as rank, ARS.state, ARS.alias, ARS.introtext, ARS.likes, ARS.title
                                FROM		#__content ARS
                                WHERE ARS.id_mae in (2496,2497,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,2508,2509,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2521,2522,2523,2524,2525,2526,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553,2554,2555,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2715,2716,2717,2718,2719,2720,2721,2722,2723,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2831,2942,2954,2988,3009,3013,3027,3028,3394,3395,3399,3400,3401,3403,3404,3405,3407,3408,3426,3427,3435,3439,3445,3471,3472,6603,6613,6618,6619,6629,8277,8316,8329,8334,8338,8341,8345,8347,8359,8364,8370,8373,8397,8472,8474,8475,8505,8540,8639,8640,8650,8662,8673,8681,8808,8819,8831,8832,8866,8987,8988,8989,9007,9040,9082,9083,9084,9085,9086,9163,9202,9203,9205,9209,9214,9251,9252,9275,9302,9310,9375,9402,9411,9489,9525,9595,9621,9634,9639,9681,9691,9695,9699,9703,9760,9908,10116,10178,10209,10240,10275,10276,10330,10407,10418,10427,10437,10443,10448,10454,10460,10478,10490,10557,10566,10572,10601,10602,10613,10620,10647,10669,10677,10686,10703,10719,10743,10759,10768,10838,10893,10894,10895,10932,10955,10968,11042,11043,11056,11127,11138,11159,11160,11181,11204,11215,11222,11224,11235,11252,11275,11346,11614,11659,11714,11729,11888,11890,11928,11930,11960,12002,12040,12097,12128,12151,12293,12310,12320,12347,12348,12465,12479,12541,12563,12590,12591,12631,12632,12633,12634,12635,12698,12699,12700,12716,12725,12737,12743,12751,12753,12759,12789,12790,12936,12956,12961,13057,13129,13159,13253,13255,13278,13320,13332,13520,13526,13567,13620,13621,13747,13828,13829,13830,13875,13888,13899,13905,13916,13945,13947,13966,13971,13982,14075,14081,14099,14141,14156,14168,14180,14211,14212,14213,14214,14215,14216,14217,14218,14400,14419,14433,14434,14435,14448,14449,14450,14471,14482,14485,14496,14624,14628,14704,14722,14728,14756,14773,14877,14917,14965,15028,15035,15043,15052,15064,15071)
                            UNION
                            SELECT	PC.id, PC.catid, PC.id_mae, PC.mr_midia_tipo_midia_id, PC.publish_up, PC.ordering, 3 as rank, PC.state, PC.alias, PC.introtext, PC.likes, PC.title
                            FROM		#__content PC, vw_mr_arvore_palavra_chave PCC WHERE PC.id = PCC.id_artigo AND PCC.palavra like '%,%' 
                            UNION
                            SELECT	MK.id, MK.catid, MK.id_mae, MK.mr_midia_tipo_midia_id, MK.publish_up, MK.ordering, 4 as rank, MK.state, MK.alias, MK.introtext, MK.likes, MK.title
                            FROM		#__content MK WHERE MK.metakey like '%%' 
                            ) as RT
        WHERE		RT.state = 1  AND             RT.catid in (20,31,32) AND             RT.id not in (SELECT SDI.id FROM #__content SDI WHERE SDI.catid in (35,33,34,67) AND SDI.publish_up < '2019-04-15') AND		(RT.mr_midia_tipo_midia_id in(1,5,7)
            OR RT.id in (SELECT id FROM vw_mr_serie_tipo_midia WHERE mr_midia_tipo_midia_id in(1,5,7))) AND		RT.id in (	SELECT	TM.content_item_id
                                        FROM		#__contentitem_tag_map as TM
                                        WHERE		TM.tag_id in (5,21,22,23,24,25,93))
        GROUP BY	RT.id  ORDER BY	sum(RT.rank) DESC, RT.publish_up DESC -->