データベースエラーが発生しました。

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 'LIMIT 0 , 1 ) != 0 , #ある場合は、ソースIDの物件を使用 ' at line 356

#最大最低値 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_Shu_Moku_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_Koshin_Date`) <= 14 ,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_Kaisaibi_START_Date` > now() AND Bai_OpenHouse_Kaisaibi_END_Date < now(),1, 0) as Add_Bai_Flag_OpenHouse ,IF(`Bai_Tantousya` != '', 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 ,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`= 'フラグ1' , 1, 0) as Add_Bai_Flag_Auth ,Bai_Syougakkou_Meisyou as gakkotest FROM ( SELECT count(*) as count_dummy, BunjyoBukken_Kukaku_Name as Bai_Max_Kakaku_Name, Bai_kakaku as Bai_Max_Kakaku FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE #最高、最低値を抽出サブクエリ ここから `Bai_kakaku` = ( SELECT MAX(`Bai_kakaku`) FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE (`BunjyoBukken_FlagView` = 1 AND `Bai_FlagView` = 1) AND `Bai_Seiyaku_Flag_Fix` != '売却済み' AND `Bai_Bkn_Shu_Rui_Fix` != '土地' AND Bai_Id != '' AND BunjyoBukken_Company_Code IN(053801 ) AND #基本条件 (Bai_Kameiten_Code IN(053801) 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 = '公開' )) ) #最高、最低値を抽出サブクエリ ここまで LIMIT 0 ,1 ) as crossjoin_Bai_Max_Kakaku CROSS JOIN ( SELECT count(*) as count_dummy, BunjyoBukken_Kukaku_Name as Bai_Min_Kakaku_Name, Bai_kakaku as Bai_Min_Kakaku FROM `v4_App_BunjyoBukken`LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE #最高、最低値を抽出サブクエリ ここから `Bai_kakaku` = ( SELECT MIN(`Bai_kakaku`) FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE (`BunjyoBukken_FlagView` = 1 AND `Bai_FlagView` = 1) AND `Bai_Seiyaku_Flag_Fix` != '売却済み' AND `Bai_Bkn_Shu_Rui_Fix` != '土地' AND Bai_Id != '' AND BunjyoBukken_Company_Code IN(053801 ) AND #基本条件 (Bai_Kameiten_Code IN(053801) 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 = '公開' )) ) #最高、最低値を抽出サブクエリ ここまで LIMIT 0 ,1 ) as crossjoin_Bai_Min_Kakaku CROSS JOIN ( SELECT count(*) as count_dummy, BunjyoBukken_Kukaku_Name as Bai_Max_Tochi_Kakaku_Name, BunjyoBukken_Tochi_Kakaku as Bai_Max_Tochi_Kakaku FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE #最高、最低値を抽出サブクエリ ここから `BunjyoBukken_Tochi_Kakaku` = ( SELECT MAX(`BunjyoBukken_Tochi_Kakaku`) FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE (`BunjyoBukken_FlagView` = 1 AND `Bai_FlagView` = 1 ) AND `Bai_Seiyaku_Flag_Fix` != '売却済み' AND Bai_Id != '' AND BunjyoBukken_Company_Code IN(053801 ) AND #基本条件 (Bai_Kameiten_Code IN(053801) 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 = '公開' )) ) #最高、最低値を抽出サブクエリ ここまで LIMIT 0 ,1 ) as crossjoin_BunjyoBukken_Tochi_Max_Kakaku CROSS JOIN ( SELECT count(*) as count_dummy, BunjyoBukken_Kukaku_Name as Bai_Min_Tochi_Kakaku_Name, BunjyoBukken_Tochi_Kakaku as Bai_Min_Tochi_Kakaku FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE #最高、最低値を抽出サブクエリ ここから `BunjyoBukken_Tochi_Kakaku` = ( SELECT MIN(`BunjyoBukken_Tochi_Kakaku`) FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE (`BunjyoBukken_FlagView` = 1 AND `Bai_FlagView` = 1 ) AND `Bai_Seiyaku_Flag_Fix` != '売却済み' AND Bai_Id != '' AND BunjyoBukken_Company_Code IN(053801 ) AND #基本条件 (Bai_Kameiten_Code IN(053801) 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 = '公開' )) ) #最高、最低値を抽出サブクエリ ここまで LIMIT 0 ,1 ) as crossjoin_BunjyoBukken_Tochi_Min_Kakaku CROSS JOIN ( SELECT max(Bai_Tochi_Menseki_M2) as Bai_Max_Tochi_Menseki_M2 ,min(Bai_Tochi_Menseki_M2) as Bai_Min_Tochi_Menseki_M2 FROM `v4_App_BunjyoBukken` LEFT JOIN `v4_Bai_Main` ON `v4_App_BunjyoBukken`.`BunjyoBukken_Bai_Id` = `v4_Bai_Main`.`Bai_Id` WHERE BunjyoBukken_FlagView = 1 AND BunjyoBukken_Seiyakuzumi_Flag != 1 AND Bai_Id != '' #会社コード AND BunjyoBukken_Company_Code IN(053801 ) ) as crossjoin_ETC CROSS JOIN `v4_Bai_Main` WHERE Bai_Id = IF( #ソースIDの物件があるかないか ( SELECT count(Bai_Id) FROM `v4_App_Bunjyo` LEFT JOIN v4_Bai_Main ON v4_App_Bunjyo.Bunjyo_DataSource_Bai_Id = v4_Bai_Main.Bai_Id WHERE Bunjyo_Id = LIMIT 0 , 1 ) != 0 , #ある場合は、ソースIDの物件を使用 ( SELECT Bai_Id FROM `v4_App_Bunjyo` LEFT JOIN v4_Bai_Main ON v4_App_Bunjyo.Bunjyo_DataSource_Bai_Id = v4_Bai_Main.Bai_Id WHERE Bunjyo_Id = LIMIT 0 , 1 ) , #ない場合は、分譲関連物件リストから1件利用 ( SELECT BunjyoBukken_Bai_Id FROM `v4_App_BunjyoBukken` WHERE BunjyoBukken_FlagView = 1 AND BunjyoBukken_Bai_Id != '' AND BunjyoBukken_Bunjyo_Code = LIMIT 0 ,1 ) )

Filename: controllers/Contents.php(83) : eval()'d code

Line Number: 6