select a.ent_id, a.pub_date, a.ordernum, b.info_id, b.launch_address, b.line_name, b.market_price, b.pre_price, b.cycle, b.count_time, b.line_type, b.earnest, a.minpic, c.cust_name, c.credit, a.click, b.line_img, a.pagerank, a.peoplenum from info_public a,info_travel b, usr_enterprise_c c where b.info_id=a.info_id and a.audi_state=2 and a.state=2 and a.ent_id=c.cust_id and b.line_class<>6 and b.line_class<>9 and b.line_class<>10 and ((b.line_type=0 and b.launch_address like '10031%' ) or (b.line_type=1 and b.launch_address like '10031%')) and exists (select 1 from info_contain where b.info_id=info_contain.info_id and area_id like '10031%') and b.pre_price>0 order by a.pagerank desc, a.pub_date desc to:上海