分类: Mysql/postgreSQL
2010-10-12 18:09:50
sql_query = \ SELECT `estate_id` , `estate_id` as `id` , `estate_order` , `estate_index_order`*(-1) as estate_index_order, `estate_name` , `estate_state` , `estate_with_newhouse` , `estate_type` , `estate_build_type` , `estate_special` , `estate_district` , \ `estate_sector` , `estate_address` , `estate_main_area_from` , `estate_main_area_to` , `estate_newhouse_price` , `estate_price_from` , `estate_price_to` , `estate_fitment` , `estate_longitude` , \ `estate_latitude` , `estate_map_level` , `estate_video_url` , `estate_netsell_url` , `estate_metro` , `estate_metro_station` , `estate_visable` , `estate_complete_year` \ FROM `house_estate`
sql_attr_uint = estate_index_order