データベースエラーが発生しました。
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-15,15' at line 261
SELECT #SQL_NO_CACHE #----------------------------------------- # 生カラムデータ raw data #----------------------------------------- * #----------------------------------------- # 加工カラムデータ add data #----------------------------------------- #物件種目 ,IF(Bai_Bkn_Shu_Rui_Fix = '土地' ,'土地' , IF(Bai_Bkn_Shu_Moku_Fix = '新築一戸建' ,'新築戸建' , IF(Bai_Bkn_Shu_Moku_Fix = '中古一戸建' ,'中古戸建' ,Bai_Bkn_Shu_Moku_Fix ) ) ) as Add_Bai_Bkn_Shu_Moku #価格 ,IF( (Bai_Kakaku - TRUNCATE(Bai_Kakaku,0)) != 0 ,concat(FORMAT(Bai_Kakaku,2),'') ,concat(FORMAT(Bai_Kakaku,0),'') ) as Add_Bai_Kakaku #旧価格 ,IF( (Bai_Kyuu_Kakaku - TRUNCATE(Bai_Kyuu_Kakaku,0)) != 0 ,concat(FORMAT(Bai_Kyuu_Kakaku,2),'') ,concat(FORMAT(Bai_Kyuu_Kakaku,0),'') ) as Add_Bai_Kyuu_Kakaku #旧価格との差額 ,FORMAT(Bai_Kakaku - Bai_Kyuu_Kakaku,0) as Add_Bai_Sagaku #費用 ,IF(Bai_Kanrihi_Muryou_Fix = '管理費なし' ,'無料', FORMAT(Bai_Kanrihi,0)) as Add_Bai_Kanrihi ,IF(Bai_Syuuzen_Tsumitatekin_Muryou_Fix = '修繕積立費なし' ,'無料', FORMAT(Bai_Syuuzen_Tsumitatekin,0)) as Add_Bai_Syuuzen_Tsumitatekin #所在地 ,IF( Bai_Syozaichi_BanchiIka_Koukai_Fix = '番地以下を公開する' ,concat('',Bai_Syozaichi_Todoufuken,Bai_Syozaichi_Shikutyouson,Bai_Syozaichi_Oaza_Tsuusyou,Bai_Syozaichi_Azana_Chyoume,Bai_Syozaichi_Banchi_Ika) ,concat('',Bai_Syozaichi_Todoufuken,Bai_Syozaichi_Shikutyouson,Bai_Syozaichi_Oaza_Tsuusyou,Bai_Syozaichi_Azana_Chyoume) )as Add_Bai_Syozaichi #築年月 ,IF(`Bai_Chiku_Nen_Fusyou_Fix` = '不詳' ,'築年数不詳' , IF( Bai_Chiku_YD_Date = '0000-00-00' ,'' ,DATE_FORMAT(`Bai_Chiku_YD_Date`,'%Y年%m月') ) ) as Add_Bai_Chiku_Date #築年経過年数計算 ,IF(`Bai_Chiku_Nen_Fusyou_Fix` = '不詳' ,'' ,TIMESTAMPDIFF(YEAR,`Bai_Chiku_YD_Date`,CURDATE() )) as Add_Bai_Chiku_Keika #セールスポイント ,IF(`Bai_Sales_Point_80` = '' ,IF(`Bai_Sales_Point_30` = '' ,`Bai_Sales_Point_100` ,`Bai_Sales_Point_30` ) ,`Bai_Sales_Point_80` ) as Add_Bai_Sales_Point #部屋番号 #※部屋番号には「ネット公開しない」もあるので注意 ,IF(`Bai_Heya_Bangou_Koukai_Fix` = 'ネット公開する' ,`Bai_Heya_Bangou` , '部屋番号 非公開' ) as `Add_Bai_Heya_Bangou_Koukai` #物件名 #※物件名には「ネット公開しない」がないので注意 #※マンションは常にBai_Bkn_Name_Koukai_Fixが空なので注意 ,IF( (Bai_Bkn_Name_Koukai_Fix = 'ネット公開する') OR (Bai_Bkn_Shu_Rui_Fix = 'マンション') OR (Bai_Bkn_Name_30 = '') , Bai_Bkn_Name_30,'' ) as Add_Bai_Bkn_Name #備考 ,concat(Bai_Bikou_300) Add_Bai_Bikou #2017年12月15日以前は、設備が150文字以上に未対応 #2017年12月15日以前の設備データは150だと最後の設備をカット ,IF(`Bai_TimeStamp` < '2017-12-15' AND CHAR_LENGTH(`Bai_Setsubi`) = 150 , REPLACE( `Bai_Setsubi` ,concat(';',SUBSTRING_INDEX(`Bai_Setsubi`,';',-1)) ,'' ) , `Bai_Setsubi` ) as Bai_Setsubi ,Bai_Tousya_Torihiki_Taiyou_Fix as Add_Bai_Tousya_Torihiki_Taiyou,IF(TO_DAYS(NOW()) - TO_DAYS(`Bai_Bkn_Toroku_Date`) <= 100 ,1,0) as Add_Bai_Flag_New ,IF(`Bai_Kyuu_Kakaku` != 0 AND `Bai_Kyuu_Kakaku` IS NOT NULL, 1, 0 ) as Add_Bai_Flag_Kyuu_Kakaku ,IF(`Bai_OpenHouse_Jissi_Fix` = 'オープンハウス開催',1, 0) as Add_Bai_Flag_OpenHouse ,IF(`Bai_Osusume_Hyouji_Fix` = 'おすすめ', 1, 0) as Add_Bai_Flag_Osusume ,IF(`Bai_Douga_Koukai_Fix` = '公開', 1 ,0) as Add_Bai_Flag_Movie ,0 as Add_Bai_Flag_360 ,IF(`Bai_OpenHouse_Jissi_Fix`='オープンハウス開催' AND `Bai_Bkn_Shu_Rui_Fix`='土地' ,1, 0) as Add_Bai_Flag_Genchi ,IF(`Bai_Seiyaku_Flag_Fix`= '売却済み' ,1, 0) as Add_Bai_Flag_Seiyaku ,IF(`Bai_Syoudanchu_Flag_Fix` ='商談中' , 1,0) as Add_Bai_Flag_Syoudan ,IF(Bai_Hanyou_Flag != 'フラグ3' , 0, 0) as Add_Bai_Flag_Auth ,IF(`Inv_Owner_Change_Fix`='オーナーチェンジ物件' , 1,0) as Add_Inv_Flag_Owner FROM #メインテーブル `v4_Bai_Main` WHERE #基本条件 (Bai_Kameiten_Code IN(117201) AND ( `Bai_FlagView`=1 AND IF(TO_DAYS(NOW()) - TO_DAYS(`Bai_Bkn_Koshin_Date`) <= 3, 1=1 ,`Bai_Seiyaku_Flag_Fix` != '売却済み') AND `Bai_Uridome_Flag_Fix` != '売り止め' AND `Bai_Kakaku` != 0 AND `Bai_Internet_Keisai_Keisai_Shitei_Fix` != '' )) AND #追加条件 ( 1=1 AND ( Bai_Bkn_Shu_Rui_Fix = 'マンション' ) AND EXISTS ( SELECT * FROM `v4_Bai_Kotsu` WHERE `Kotsu_Bai_Id` = `Bai_Id` ) AND EXISTS ( SELECT * FROM `v4_Bai_Gazou` WHERE `Gazou_Bai_Id` = `Bai_Id` ) AND EXISTS ( SELECT * FROM `v4_Bai_Heya` WHERE `Heya_Bai_Id` = `Bai_Id` ) AND EXISTS ( SELECT * FROM `v4_Bai_Ichijikin` WHERE `Ichijikin_Bai_Id` = `Bai_Id` ) AND EXISTS ( SELECT * FROM `v4_Bai_Kanren_Homepage` WHERE `Kanren_Homepage_Bai_Id` = `Bai_Id` ) AND EXISTS ( SELECT * FROM `v4_Bai_Running_Cost` WHERE `Running_Cost_Bai_Id` = `Bai_Id` ) AND EXISTS ( SELECT * FROM `v4_Bai_Setsudou` WHERE `Setsudou_Bai_Id` = `Bai_Id` ) AND EXISTS ( SELECT * FROM `v4_Bai_Urinushi` WHERE `Urinushi_Bai_Id` = `Bai_Id` ) ) HAVING ( 1=1 AND ( 1=1 )) AND ( 1=1 ) ORDER BY #no order `Bai_Bkn_Koshin_Date` desc ,`Bai_Id` desc LIMIT -15,15
Filename: views/rwd_widget/rwd_bai_search_list/bai_search_list_main.php
Line Number: 223