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(1273) "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 (19660,3224,17845)
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
"
Neste sábado (8), a população de Santarém terá acesso gratuito a serviços da Procuradoria Geral do Município no Mercadão 2000 e Mercado Modelo. Ação oferece emissão de certidões, orientação jurídica e atendimento ao cidadão.
Obra de modernização no tradicional Mercado Municipal leva lojistas para estrutura provisória com toda infraestrutura. Medida garante continuidade dos negócios durante revitalização.