SELECT * FROM soggiorni.operatorixy_ap T1 WHERE T1.id_ap='PRBEI' AND  (T1.id_eco1='7' OR T1.id_eco2='7' OR T1.id_eco3='7') ORDER BY pagosp DESC, CAP, localita, Tipologia, Stelle DESC, knominativo