SELECT * FROM news.cs, news.cs_opt WHERE id_ap = 'PNATE' AND id_lingua = 'it' AND (rs IS NULL or rs = '0') AND (scadenza IS NULL or scadenza = '') AND `cs`.`id`=`cs_opt`.`id_cs` AND `cs_opt`.`su7`='1' ORDER BY data DESC, id DESC, titolo ASC LIMIT -10, 10