Actualitat Foneria Barberí > Juliol 2010

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) = '7' and YEAR(n.published) = '2010' order by n.published desc, n.modified desc