表示エラー

ご指定のページを表示中にエラーが発生しました。
お手数をおかけして大変申し訳ございませんが、貸事務所ドットコムさいたまのTOPページから再度物件情報をお探しください。

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS areacode,A.area_name AS subarea_name,COUNT(DISTINCT F.buil_code) AS bcnt,C...' at line 1 SELECT CNT.areacode,CNT.subarea_name,MAX(CNT.bcnt) AS bcnt,MAX(CNT.fcnt) AS fcnt,CNT.spacelevel,SUM(FEE.total_fee_t) AS total_fee_t,SUM(FEE.fee_zero_cnt) AS fee_zero_cnt FROM (SELECT AS areacode,A.area_name AS subarea_name,COUNT(DISTINCT F.buil_code) AS bcnt,COUNT(DISTINCT F.bukken_code) AS fcnt,GET_SPACELEVEL_FOR_FEELIST(F.tsubo) AS spacelevel FROM m_aki_bukken AS F JOIN m_aki_buil AS B USING(buil_code) LEFT OUTER JOIN m_aki_buil_subarea AS BSUB USING(buil_code) LEFT OUTER JOIN m_aki_buil_station AS BST ON(BST.buil_code=F.buil_code) LEFT OUTER JOIN m_area_web AS A ON(A.pref_code=0 AND A.area_code=0) LEFT OUTER JOIN `m_aki_buil_station` AS BS ON(BS.buil_code=B.buil_code) WHERE (B.status IN('1','2')) AND (F.status IN('1','2')) AND (F.aki IN ('0','2','3')) AND (F.kai_from<>99) AND (F.tsubo>=30) AND (1 IN (F.yoto1,F.yoto2,F.yoto3)) AND (B.check_date>='2025-03-25') GROUP BY spacelevel ORDER BY spacelevel) AS CNT LEFT OUTER JOIN (SELECT areacode,subarea_name,SUM(bcnt) AS bcnt,SUM(fcnt) AS fcnt,spacelevel,SUM(fee) AS total_fee_t,COUNT(CASE WHEN NOT((fee_code = 9 OR fee_code = 2) AND aboutfee_date >= CURDATE() - INTERVAL 45 DAY) OR aboutfee = 0 THEN 1 END) AS fee_zero_cnt FROM (SELECT AS areacode,A.area_name AS subarea_name,B.buil_code,F.bukken_code,F.fee_code,F.aboutfee,F.aboutfee_date,COUNT(DISTINCT F.buil_code) AS bcnt,COUNT(DISTINCT F.bukken_code) AS fcnt,GET_SPACELEVEL_FOR_FEELIST(F.tsubo) AS spacelevel,CASE WHEN (F.fee_code = 9 OR F.fee_code = 2) AND F.aboutfee_date >= CURDATE() - INTERVAL 45 DAY THEN F.aboutfee ELSE 0 END AS fee FROM m_aki_bukken AS F JOIN m_aki_buil AS B USING(buil_code) LEFT OUTER JOIN m_aki_buil_subarea AS BSUB USING(buil_code) LEFT OUTER JOIN m_area_web AS A ON(A.pref_code=0 AND A.area_code=0) LEFT OUTER JOIN `m_aki_buil_station` AS BS ON(BS.buil_code=B.buil_code) WHERE (B.status IN('1','2')) AND (F.status IN('1','2')) AND (F.aki IN ('0','2','3')) AND (F.kai_from<>99) AND (F.tsubo>=30) AND (1 IN (F.yoto1,F.yoto2,F.yoto3)) AND (B.check_date>='2025-03-25') GROUP BY spacelevel, B.buil_code, F.bukken_code ORDER BY spacelevel, B.buil_code, F.bukken_code ) AS FEE GROUP BY areacode, subarea_name, spacelevel, fee_code, aboutfee ORDER BY areacode, subarea_name, spacelevel) AS FEE ON CNT.areacode = FEE.areacode AND CNT.subarea_name=FEE.subarea_name AND CNT.spacelevel = FEE.spacelevel GROUP BY areacode, subarea_name, spacelevel ORDER BY areacode, spacelevel