SELECT O.* FROM operatorixy O WHERE 1=1 AND O.id_regione = '20' AND O.Provincia = 'CA'  ORDER BY pagosp DESC, CAP, localita, Tipologia, Stelle DESC, knominativo