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