DB Error: syntax error<br />SELECT
  b_id,
  a_name1, a_name2, 

  b_name, b_redirect,
  path_2, web_copy,
  kakaku_type, kakaku_yotei_flag, kakaku_1, kakaku_2, kakaku_3, kakaku_bikou,
  madori_type, madori_yotei_flag, madori_1, madori_2, madori_3, madori_bikou,
  b_type, menseki_type, menseki_yotei_flag, menseki_1, menseki_2, menseki_3,
  total_kosuu, kosuu_type,
  web_bikou, web_model_open, web_model_nowon, web_model_req,
  eki_status, riyou_kanousu
FROM t_bukken
JOIN t_bukkendata ON t_bukken.b_id = t_bukkendata.bukken_id
JOIN t_bukkenimage ON t_bukken.b_id = t_bukkenimage.bukken_id
JOIN t_address ON t_bukkendata.address_code = t_address.a_id
WHERE b_id IN (SELECT bukken_id FROM t_bukkendata WHERE ())
      AND t_bukkendata.release_flag = '1'
      AND t_bukken.b_sortorder BETWEEN 1 AND 9998
ORDER BY b_sortorder, b_id