SELECT bm.article_id building_id, concat(lpad(dsp_year, 4, '0'),'/', lpad(dsp_month, 2, '0'),'/', lpad(dsp_day, 2, '0')) dsp_date, bm.*, rm.*, jm.* FROM room_mst rm LEFT JOIN building_mst bm on bm.building_seq = rm.building_seq LEFT JOIN jgdc_post_mst jm on bm.jgdc_seq = jm.jgdc_seq WHERE (rm.del_flg is null or rm.del_flg = '0' or rm.del_flg = '') AND rm.redirect_article_id in ('10416196830012') limit 1
Fatal error: Uncaught mysqli_sql_exception: Unknown column 'rm.redirect_article_id' in 'where clause' in /home/www/config/ieselect_front/front_db.php:137 Stack trace: #0 /home/www/config/ieselect_front/front_db.php(137): mysqli_query() #1 /home/www/config/ieselect_front/front_db.php(3900): sql_select() #2 /home/www/cjs.ne.jp/public_html/campus/controllers/detail_room.php(67): getDetailRoomAllDBRedirect() #3 /home/www/cjs.ne.jp/public_html/campus/search/index.php(363): require_once('...') #4 {main} thrown in /home/www/config/ieselect_front/front_db.php on line 137