Actualitat Foneria Barberí > Ventdelpla

select n.id, n.tipus_id, nd.titular, nd.destacat, nd.text, n.thumb, n.active, n.published, n.entered from noticies n left join noticies_description nd on n.id = nd.noticies_id and nd.titular<>'' and nd.language_id = '1' where ( nd.tags LIKE '%ventdelpla%') and (TO_DAYS(NOW()) - TO_DAYS(n.published) >= 0) and (n.finished IS NULL or TO_DAYS(n.finished) - TO_DAYS(NOW()) >= 0) and n.active='1' and nd.text !='' order by n.published desc, n.modified desc