select a.* from g1_sale a left join g1_city b on a.ci_ix = b.ci_ix where 1=1 and a.sl_ko_price between 0 and 46909740459 order by a.sl_fix_top desc, a.sl_datetime desc