Error: 1054 Unknown column 'keyword_relationships.rank' in 'order clause'

The following SQL statement was executed:
select * from (select distinct properties_s_h.* from properties_s_h,property_keywords where property_keywords.keyword_id='24369' and property_keywords.property_id=properties_s_h.id and properties_s_h.id!='1219187' and properties_s_h.block is null and properties_s_h.status!='n' order by property_keywords.rank desc ) sponsors union select * from ( select properties_s_h.* from properties_s_h, keyword_relationships where properties_s_h.keyword_id=keyword_relationships.related_keyword_id and keyword_relationships.keyword_id='24369' and properties_s_h.block is null and properties_s_h.status ='n' and properties_s_h.id!='1219187' order by keyword_relationships.rank desc, properties_s_h.id desc ) normal limit 0,8

Error: 1054 Unknown column 'rank' in 'order clause'

The following SQL statement was executed:
select keywords.* from keywords,keyword_relationships where keywords.id=keyword_relationships.related_keyword_id and keyword_relationships.keyword_id ='24369' order by rank desc limit 16

Error: 0

The following SQL statement was executed:
select * from keywords where district_id='581' and idf2>0 and status is not null and idf2>0 order by idf2 asc limit 16

Error: 1054 Unknown column 'rank' in 'order clause'

The following SQL statement was executed:
select keywords.* from keywords,keyword_relationships where keywords.id=keyword_relationships.related_keyword_id and keyword_relationships.keyword_id ='24369' order by rank desc limit 5

Error: 0

The following SQL statement was executed:
select count(distinct(code)) counter,count(*) total from properties_s_h where telephone = '15951820590' and block is null

Error: 0

The following SQL statement was executed:
select count(*) counter from properties_s_h where telephone = '15951820590' and block is null

南京栖霞南京二手房-天泓山庄
在南京买二手房  南京找房子:  非中介  

南京二手房-天泓山庄

    发布日期:2008年04月07日
  • 栖霞
  • 天泓山庄
  • 3室3厅
  • 第4层/总5层
  • 170平方米
  • 275.0万元
  • 水电,宽带,管道煤气,有线电视,车位
  • 天泓山庄,小区环境就不多说;对于本房,在小区中心花园位置,前后小桥流水、茅屋喷泉。在售楼部,这样的位置已卖到25000元/平方米了(均售完)。观山别墅 楼下还有套3跃4,如果您需要更大的,可以打通(面积总为310方),具体价格面谈; 本公司地址:银城东苑东篱园2栋601室。
  • 房主联系方式:

    您必须登录才能查看房主的联系信息。如果您还不是注册会员,请您现在免费注册!(联络时请说明来自JiPingMi,以获得更好效果)