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

Notícias Voltar