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='24478' and property_keywords.property_id=properties_s_h.id and properties_s_h.id!='1397099' 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='24478' and properties_s_h.block is null and properties_s_h.status ='n' and properties_s_h.id!='1397099' order by keyword_relationships.rank desc, properties_s_h.id desc ) normal limit 0,8

Error: 0

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

Error: 0

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

南京栖霞南京二手房-仙林大学城 亚东城四期山水名筑(价格含税)
在南京买二手房  南京找房子：  非中介  

南京二手房-仙林大学城 亚东城四期山水名筑(价格含税)

    发布日期：2008年04月16日
  • 栖霞
  • 仙林大学城 亚东城四期山水名筑(价格含税) 内部编号：x
  • 2室2厅
  • 第4层/总18层
  • 94平方米
  • 70.0万元
  • 方便
    		•
  • 水电,宽带,管道煤气,有线电视,电梯
  • 双南,价格含税!房屋详细情况请致电南京朗玛房地产经纪有限公司 ----月苑分店86052351联系人：解先生 中介企业资质证号： 000719 。我们将热忱的为您提供专业的服务，满意在朗玛，至信于巅峰！！！ 另提供房屋价值免费评估，代办过户，房屋抵押贷款，二手房追加贷款等服务!!!

  • 房主联系方式：

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