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='3968' and property_keywords.property_id=properties_s_h.id and properties_s_h.id!='1394555' 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='3968' and properties_s_h.block is null and properties_s_h.status ='n' and properties_s_h.id!='1394555' 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 = '13675139379' and block is null

Error: 0

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

南京玄武南京二手房-银城东苑中心湖跃层景观房
在南京买二手房  南京找房子：  非中介  

南京二手房-银城东苑中心湖跃层景观房

    发布日期：2008年04月15日
  • 玄武
  • 银城东苑中心湖跃层景观房 内部编号：sf
  • 5室2厅
  • 第8层/总11层
  • 206平方米
  • 257.0万元
  • 4/52/84/87/
    		•
  • 水电,宽带,管道煤气,有线电视,电梯,车位
  • 城东高档住宅区，王者楼盘，经典小区！！小区环境绝佳，小区中心湖清澈怡人，绿化清爽舒适！！物业极佳，安全舒适！！小区配套设施齐全，娱乐场健身会所一应齐全，生活方便，出行便利！！靠近紫金山，风水绝佳！！靠近地铁二号线，交通及其便利！周边高校云集，人文素质极佳！！小区旁边就是幼儿园小学中学！！房型佳，经典跃层。视野极佳，景色秀美。前后无遮挡，采光相当的好。房子在小区中心湖边，景观大房！价格便宜，精装修含税，性价比高！详情请咨询1＋2联合不动产紫金路店孙先生：13675139379 84876012 全程为您服务！！！！

  • 房主联系方式：

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