表示エラー
ご指定のページを表示中にエラーが発生しました。
お手数をおかけして大変申し訳ございませんが、貸事務所ドットコムさいたまの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 AS areacode,A.area_name AS subarea_name,COUNT(DISTINCT F.buil_code) AS bcnt,COUNT(DISTINCT F.bukken_code) AS fcnt,GET_FEELEVEL_WITH_PUB(0,F.fee_code,F.fee_t,F.pubfee_code,F.pubfee_t,F.aboutfee,3) AS feelevel 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>='2024-10-19') GROUP BY feelevel ORDER BY feelevel