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