求租购
  • 编号
  • 类型
  • 求租求购
  • 城区
  • 面积
  • 价格
Select Req_ID,Req_HouseType,Req_Province,Req_City,Req_Region,Req_ShopA,Req_Type,Req_IsAct,Req_Period,Req_Title,Req_ComName,Req_People,Req_Tel,Req_Area,Req_AreaUnit,Req_Price,Req_PriceUnit,Req_PriceSM,Req_IntoTime,Req_AskAddress,Req_Special,Req_AddTime,Req_Publish,Req_Shop,Req_ShopType,Req_Email,Req_IP,Req_Source,Req_Remind,Req_Userid,Req_inputName,Req_IsOpen,Req_IsGuest,Req_IsService,Req_IsLock,Req_Locktime,Req_LockMan,ucase,ucasetime,Req_CaseUsersid,Req_IsCase,Req_CaseTime,Req_IsDel,Req_FromWeb,Req_FromClass,Req_IsReg,(select ClassName from [Pub_ConfigClass] sw where sw.C_ID=r.Req_Type) as sw_classname,(select ClassName from [Pub_ConfigClass] h where h.C_ID=r.Req_HouseType) as h_classname from [FC_Request] r where r.Req_IsDel=0 and r.Req_IsLock = 1 and r.Req_IsCase=0 and r.req_ID not in (0) and r.Req_city in ('深圳') and Req_housetype in ('100713160906','100713160912') order by Case r.Req_city When '深圳' Then 0 Else 1 End, r.Req_Publish desc