SELECT j.id, j.title,introtext as description,j.created as pubDate, j.alias as slug, c.name as categoria, x.tagID FROM siteCNM_k2_items j LEFT JOIN siteCNM_k2_categories c ON c.id = j.catid LEFT JOIN siteCNM_k2_tags_xref x ON x.itemID = j.id WHERE j.published = 1 AND (c.alias = 'marcha-2017' or x.tagID = '40') ORDER BY pubDate DESC LIMIT 0,10

Notícias Voltar