Actualitat Foneria Barberí > Febrer 2012

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 n.active='1' and nd.text !='' and MONTH(n.published) = '2' and YEAR(n.published) = '2012' order by n.published desc, n.modified desc