select site_noticias.*, site_categoria_noticias.nome as categoria from (site_noticias left join site_categoria_noticias on site_categoria_noticias.codigo = site_noticias.cod_categoria) where site_noticias.codigo != 'coronavirus' and cod_gestao = '2' and site_noticias.codigo in(2197,2196,2195,2194,2193,2192,2191,2190,2189,2187,2186,2185,2184,2201,2205,2206,2209,2217,2210,2211,2212,2213,2214,2218,2219,2221,2222,2223,2224,2226,2227,2229,2230,2231,2233,2234,2235,2239,2241,2247,2248,2249,2252,2258,2260,2261,2262,2271,2272,2281,2282,2287,2288,23104,23103,23102,23096,23086,23107,23108,23116,23119,23137,23140,23145,23147,23152,23153,23154,23155,23156,23157,23158,23159,23162,23163,23164,23166,23168,23170,23171,23172,23174,23175,23176,23178,23179,23180,23181,23182,23183,23184,23200,23186,23187,23188,23189,23190,23192,23193,23194,23195,23197,23198,23199,23203,23204,23205,23206,23210,23211,23212,23213,23218,23219,23222,23236,23237,23226,23240,23243,23244,23246,23247,23250,23251,23256,23259,23260,23265,23267,23271,23273,23274,23275,23276,23277,23278,23279,23281,23282,23291,23293,23294,23302,23303,23304,23305,23310,23311,23312,23313,23319,23320,23321,23323,23324,23327,23328,23334,23335,23336,23339,23340,23342,23343,23344,23346,23347,23350,23356,23357,23358,23359,23363,23365,23369,23370,23371,23373,23374,23375,23380,23381,23382,23385,23387,23388,23389,23391,23394,23395,23396,23397,23398,23401,23402,23404,23411,23406,23407,23408,23414,23416,23417,23419,23420,23425,23428,23430,23433,23436,23437,23440,23442,23444,23448,23449,23450,23460,23462,23464,23466,23467,23468,23470,23471,23472,23473,23477,23479,23480,23481,23488,23489,23495,23499,23501,23504,23509,23511,23515,23519,23524,23525,23526,23527,23529,23532,23533,23539,23540,23550,23551,23554,23555,23558,23564,23565,23566,23579,23580,23581,23582,23585,23587,23589,23592,23593,23596,23597,23599,23601,23611,23613,23617,23618,23622,23624,23626,23630,23631,23638,23640,23650,23655,23662,23667,23673,23674,23690,23692,23694,23695,23697,23719,23720,23726,23727,23728,23749,23774,23783,23786,23802,23805,23808,23812,23826,23827,23828,23829,23830,23834,23839,23854,23862,23884,23953,23955,23966,23988,24060,24065) and ((concat(site_noticias.data, site_noticias.hora) <= '2022-07-0311:27') or (site_noticias.hora is null)) order by site_noticias.destaque desc, site_noticias.data desc, site_noticias.codigo desc limit 0, 10