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, cs.scadenza FROM news.cs AS cs, news.cs_opt as cs_opt WHERE cs.concorsi = 1 AND cs_opt.id_cs = cs.id AND id_lingua='it' AND scadenza >= '2018-11-18' ORDER BY scadenza ASC, data DESC, id DESC, titolo ASC LIMIT -10, 10