SELECT * FROM news.cs AS cs JOIN news.cs_opt AS cso ON (cs.id = cso.id_cs) WHERE ometti = '0' AND rs!=1 AND id_lingua='it' AND cso.molise = '1' ORDER BY data DESC, id DESC LIMIT -10, 10