福井県不動産のれん会ホームページへようこそ！　福井の選び抜かれた不動産業者が集まった福井県不動産のれん会に不動産のことならおまかせ！ 賃貸アパート、賃貸マンション、貸店舗、貸事務所、貸倉庫、貸工場、月極駐車場、売土地、売戸建、分譲マンション、注文住宅と不動産情報満載！物件情報鮮度も抜群！

SELECT n_new2.f_name, n_new2.STR, n_new2.STR_DATE, n_new2.alias FROM ( SELECT `member`.f_name as f_name, n_new2.STR1 as STR, n_new2.STR_DATE1 as STR_DATE, `member`.alias FROM n_new2 left join `member` on n_new2.GYOSYA_CD = `member`.id_code WHERE n_new2.str1_chk = 'CHECKED' union all SELECT `member`.f_name as f_name, n_new2.STR2 as STR, n_new2.STR_DATE2 as STR_DATE, `member`.alias FROM n_new2 left join `member` on n_new2.GYOSYA_CD = `member`.id_code WHERE n_new2.str2_chk = 'CHECKED' union all SELECT `member`.f_name as f_name, n_new2.STR3 as STR, n_new2.STR_DATE3 as STR_DATE, `member`.alias FROM n_new2 left join `member` on n_new2.GYOSYA_CD = `member`.id_code WHERE n_new2.str3_chk = 'CHECKED' ) AS n_new2 WHERE REPLACE(STR_DATE, '/', '') >= '20210430' AND REPLACE(STR_DATE, '/', '') <= '20210730' ORDER BY CAST(n_new2.STR_DATE AS DATETIME) desc