string(1320) "SELECT
n.*,
nt.news_title, nt.news_title_x, nt.news_title_fb,
nu.news_url,
nd.news_description,
nk.news_keyword,
ni.news_images_url,
nst.news_short_title, nst.news_short_title_translit,
nc.*,
nm.*
/*,CONVERT_TZ(n.news_date, '+00:00', '-03:00') AS news_date*/
FROM (
SELECT news_id
FROM news n
INNER JOIN news_images ni ON n.news_id = ni.news_images_news_id AND ni.news_images_ok = 1
WHERE news_date> DATE_SUB(NOW(), INTERVAL 7 DAY)
ORDER BY n.news_views DESC, n.news_id DESC/*popular_news*/
LIMIT 0,8
) AS filtered_news
INNER JOIN news n ON filtered_news.news_id = n.news_id
INNER JOIN news_title nt ON n.news_id = nt.news_title_news_id
INNER JOIN news_url nu ON n.news_id = nu.news_url_news_id
INNER JOIN news_description nd ON n.news_id = nd.news_description_news_id
INNER JOIN news_keyword nk ON n.news_id = nk.news_keyword_news_id
INNER JOIN news_images ni ON n.news_id = ni.news_images_news_id AND ni.news_images_ok = 1
INNER JOIN news_short_title nst ON n.news_id = nst.news_short_title_news_id
INNER JOIN news_category nc ON n.news_category_id = nc.news_category_id AND nc.news_category_status = 1
INNER JOIN news_menu nm ON nc.news_category_news_menu_id = nm.news_menu_id
"
string(1286) "SELECT
n.*,
nt.news_title, nt.news_title_x, nt.news_title_fb,
nu.news_url,
nd.news_description,
nk.news_keyword,
ni.news_images_url,
nst.news_short_title, nst.news_short_title_translit,
nc.*,
nm.*
/*,CONVERT_TZ(n.news_date, '+00:00', '-03:00') AS news_date*/
FROM (
SELECT news_id
FROM news n
INNER JOIN news_images ni ON n.news_id = ni.news_images_news_id AND ni.news_images_ok = 1
WHERE news_id IN (19919,15720,17778,18901,19941)
ORDER BY n.news_id DESC
LIMIT 0,30
) AS filtered_news
INNER JOIN news n ON filtered_news.news_id = n.news_id
INNER JOIN news_title nt ON n.news_id = nt.news_title_news_id
INNER JOIN news_url nu ON n.news_id = nu.news_url_news_id
INNER JOIN news_description nd ON n.news_id = nd.news_description_news_id
INNER JOIN news_keyword nk ON n.news_id = nk.news_keyword_news_id
INNER JOIN news_images ni ON n.news_id = ni.news_images_news_id AND ni.news_images_ok = 1
INNER JOIN news_short_title nst ON n.news_id = nst.news_short_title_news_id
INNER JOIN news_category nc ON n.news_category_id = nc.news_category_id AND nc.news_category_status = 1
INNER JOIN news_menu nm ON nc.news_category_news_menu_id = nm.news_menu_id
"
string(1285) "SELECT
n.*,
nt.news_title, nt.news_title_x, nt.news_title_fb,
nu.news_url,
nd.news_description,
nk.news_keyword,
ni.news_images_url,
nst.news_short_title, nst.news_short_title_translit,
nc.*,
nm.*
/*,CONVERT_TZ(n.news_date, '+00:00', '-03:00') AS news_date*/
FROM (
SELECT news_id
FROM news n
INNER JOIN news_images ni ON n.news_id = ni.news_images_news_id AND ni.news_images_ok = 1
WHERE news_date>DATE_SUB(NOW(), INTERVAL 1 WEEK)
ORDER BY n.news_id DESC
LIMIT 0,4
) AS filtered_news
INNER JOIN news n ON filtered_news.news_id = n.news_id
INNER JOIN news_title nt ON n.news_id = nt.news_title_news_id
INNER JOIN news_url nu ON n.news_id = nu.news_url_news_id
INNER JOIN news_description nd ON n.news_id = nd.news_description_news_id
INNER JOIN news_keyword nk ON n.news_id = nk.news_keyword_news_id
INNER JOIN news_images ni ON n.news_id = ni.news_images_news_id AND ni.news_images_ok = 1
INNER JOIN news_short_title nst ON n.news_id = nst.news_short_title_news_id
INNER JOIN news_category nc ON n.news_category_id = nc.news_category_id AND nc.news_category_status = 1
INNER JOIN news_menu nm ON nc.news_category_news_menu_id = nm.news_menu_id
"
Homem conhecido como 'serial killer' assume autoria do crime contra Danilo Rodrigues em Londrina. Confissão ocorre durante depoimento e revela método cruel utilizado no assassinato.
O Distrito Federal preparou uma programação cultural diversificada para este fim de semana, com shows de Tim Bernardes, Danilo Caymmi, stand-up com Murilo Couto e festas eletrônicas. Não perca!
Rubro-Negro acompanha com atenção situação de Alex Sandro na Seleção Brasileira. Entenda por que a lesão do lateral-esquerdo preocupa mais que a ausência já esperada de Danilo.
