Error Number: 1054
Unknown column 'Add_Bai_Bkn_Shu_Moku' in 'having clause'
#topic 202 SELECT #SQL_NO_CACHE #----------------------------------------- # 生カラムデータ raw data #----------------------------------------- * #----------------------------------------- # 加工カラムデータ add data #----------------------------------------- #物件種類(拡張用) ,Chi_Bkn_Shu_Moku_Fix as Add_Chi_Bkn_Shu_Moku #賃料 #FORMAT( (Chi_Chinryou/10000),0) ,IF( ( FORMAT((Chi_Chinryou/10000), 1) - FORMAT((Chi_Chinryou/10000),2)) != 0 ,concat(FORMAT((Chi_Chinryou/10000),2),'') ,concat(FORMAT((Chi_Chinryou/10000),1),'') ) as Add_Chi_Chinryou #旧賃料 ,IF( ( FORMAT((Chi_KyuuChinryou/10000), 1) - FORMAT((Chi_KyuuChinryou/10000),2)) != 0 ,concat(FORMAT((Chi_KyuuChinryou/10000),2),'') ,concat(FORMAT((Chi_KyuuChinryou/10000),1),'') ) as Add_Chi_KyuuChinryou #旧価格との差額 ,FORMAT(Chi_Chinryou - Chi_KyuuChinryou,0) as Add_Chi_Sagaku #賃料以外費用 #※管理費 共益費 保険料について 拡張性を考慮して 単位を含める ,concat(FORMAT(Chi_Kanrihi ,0), '円') as Add_Chi_Kanrihi ,concat(FORMAT(Chi_Songai_Hokenryou ,0), '円') Add_Chi_Songai_Hokenryou ,concat(FORMAT(Chi_Kyouekihi ,0) , '円') as Add_Chi_Kyouekihi ,IF(Chi_Shikibiki = 0 , '0円' ,concat(FORMAT(Chi_Shikibiki ,0), Chi_Shikibiki_Tani_Fix ) ) as Add_Chi_Shikibiki ,IF(Chi_Reikin_Nashi_Fix = 'なし' ,'礼金なし', concat( FORMAT(Chi_Reikin_Kingaku,0) , Chi_Reikin_Kingaku_Tani_Fix ) ) as Add_Chi_Reikin_Kingaku ,IF(Chi_Kenrikin_Nashi_Fix = 'なし' ,'権利金なし', concat(FORMAT(Chi_Kenrikin_Kingaku,0),Chi_Kenrikin_Kingaku_Tani_Fix) ) as Add_Chi_Kenrikin_Kingaku ,IF(Chi_Shikikin_Nashi_Fix = 'なし' ,'敷金なし', concat(FORMAT(Chi_Shikikin_Kingaku,0),Chi_Shikikin_Kingaku_Tani_Fix) ) as Add_Chi_Shikikin_Kingaku ,IF(Chi_Hosyoukin_Nashi_Fix = 'なし' ,'保証金なし', concat(FORMAT(Chi_Hosyoukin_Kingaku,0),Chi_Hosyoukin_Kingaku_Tani_Fix) ) as Add_Chi_Hosyoukin_Kingaku ,IF(Chi_Chukai_Tesuuryou_Nashi_Fix = 'なし' ,'手数料なし', concat(FORMAT(Chi_Chukai_Tesuuryou_Kingaku,0),Chi_Chukai_Tesuuryou_KingakuTani_Fix) ) as Add_Chi_Tesuuryou_Kingaku ,IF(Chi_Koushinryou_Nashi_Fix = 'なし' ,'更新料なし', concat(FORMAT(Chi_Koushinryou_Kingaku,0),Chi_Koushinryou_Kingaku_Tani_Fix) ) as Add_Chi_Koushinryou_Kingaku #所在地 ,IF( Chi_Syozaichi_BanchiIka_Koukai_Fix = '番地以下を公開する' ,concat('',Chi_Syozaichi_Todoufuken,Chi_Syozaichi_Shikutyouson,Chi_Syozaichi_Oaza_Tsuusyou,Chi_Syozaichi_Azana_Chyoume,Chi_Syozaichi_Banchi_Ika) ,concat('',Chi_Syozaichi_Todoufuken,Chi_Syozaichi_Shikutyouson,Chi_Syozaichi_Oaza_Tsuusyou,Chi_Syozaichi_Azana_Chyoume) )as Add_Chi_Syozaichi #築年月 ,IF(`Chi_Chiku_Nen_Fusyou_Fix` = '不詳' ,'築年数不詳' , IF( Chi_Chiku_YM_Date = '0000-00-00' ,'' ,DATE_FORMAT(`Chi_Chiku_YM_Date`,'%Y年%m月') ) ) as Add_Chi_Chiku_Date #築年経過年数計算 ,IF(`Chi_Chiku_Nen_Fusyou_Fix` = '不詳' ,'' ,TIMESTAMPDIFF(YEAR,`Chi_Chiku_YM_Date`,CURDATE() )) as Add_Chi_Chiku_Keika #セールスポイント ,IF(`Chi_Sales_Point_200` = '' ,IF(`Chi_Sales_Point_100` = '' ,`Chi_Sales_Point_50` ,`Chi_Sales_Point_100` ) ,`Chi_Sales_Point_200` ) as Add_Chi_Sales_Point #棟番号 部屋番号 ,IF(`Chi_Heyabangou_Koukai_Toubangou_Koukai_Fix` = '部屋番号を公開する' ,`Chi_Heyabangou_Toubangou` , '棟番号部屋番号非公開' ) as `Add_Chi_Heyabangou_Toubangou` ,IF(`Chi_Bkn_Name_Koukai_Fix` = '公開' ,`Chi_Bkn_Name_Koukai_Fix` , '' ) as `Add_Chi_Bkn_Name_Koukai_Fix` #物件名 ,IF(Chi_Bkn_Name_Koukai_Fix = '公開' ,Chi_Bkn_Name,'物件名非公開') as Add_Chi_Bkn_Name #備考 ,concat(Chi_Bikou_200) Add_Chi_Bikou #2017年12月15日以前は、設備が150文字以上に未対応 #2017年12月15日以前の設備データは150だと最後の設備をカット ,IF(`Chi_TimeStamp` < '2017-12-15' AND CHAR_LENGTH(`Chi_Setsubi`) = 150 , REPLACE( `Chi_Setsubi` ,concat(';',SUBSTRING_INDEX(`Chi_Setsubi`,';',-1)) ,'' ) , `Chi_Setsubi` ) as Chi_Setsubi ,Chi_Tousya_Torihiki_Taiyou_Fix as Add_Chi_Tousya_Torihiki_Taiyou,IF(TO_DAYS(NOW()) - TO_DAYS(`Chi_Bkn_Toroku_Date`) <= 3 ,1,0) as Add_Chi_Flag_New ,IF(`Chi_KyuuChinryou` != 0 AND `Chi_KyuuChinryou` IS NOT NULL, 1, 0 ) as Add_Chi_Flag_Kyuu_Chinryou ,IF(`Chi_Shikikin_Nashi_Fix` = 'なし' AND `Chi_Reikin_Nashi_Fix` ='なし', 1, 0 ) as Add_Chi_Flag_Shikirei ,IF(`Chi_Tantousya` != '', 1, 0) as Add_Chi_Flag_Osusume ,IF(`Chi_Douga_Koukai_Fix` = '公開', 1 ,0) as Add_Chi_Flag_Movie ,0 as Add_Chi_Flag_360 ,IF(`Chi_Hikiwatashi_Jiki_Fix` = '即引渡し可' , 1 ,0) as Add_Chi_Flag_Sokuiri ,0 as Add_Chi_Flag_Seiyaku ,0 as Add_Chi_Flag_Auth FROM #メインテーブル `v4_Chi_Main` WHERE #基本条件 (Chi_Kameiten_Code IN(025901) AND ( `Chi_FlagView`=1 AND `Chi_Genkyou_Fix` IN('空き','建築中','改築中','空き予定') AND `Chi_Chinryou` != 0 AND `Chi_Internet_Keisai_Keisai_Shitei_Fix` = '公開' )) AND 1=1 HAVING ( 1=1 AND ( 1=1 )) AND ( `Add_Bai_Bkn_Shu_Moku`='中古マンション' ) ORDER BY substring(`Chi_Add_Priority_Bit`,-2,1) desc,`Chi_Bkn_Koshin_Date` desc LIMIT 0,4
Filename: views/rwd_widget/rwd_chi_topic/chi_topic_base.php
Line Number: 60