SELECT cs.id, cs.titolo, cs.sottotitolo, cs.data, cs.desc, cs.mitt, cs.fonte, cs.web, cs.ap, cs.webmitt, cs.img, cs.urlimg, cs.didaimg, cs_opt.id_opt, cs_opt.id_cs, cs.id_ap, cs.luogonews FROM news.cs AS cs, news.cs_opt as cs_opt WHERE cs.libri=1 AND cs_opt.id_cs = cs.id AND ometti = '0' AND id_lingua='it' AND cs_opt.molise = '1' ORDER BY data DESC, id DESC, titolo ASC LIMIT -10, 10