メモ：メモ一覧
更新

SELECT DISTINCT S.YMD ,A.BRAND_CODE ,CONCAT(CONCAT(B.YMD,','),A.YMD) AS PRE_YMD FROM EveryDay4Data S INNER JOIN TestEveryDay4Data04 A ON A.YMD = (select MAX(Z.YMD) from TestEveryDay4Data04 Z where Z.BRAND_CODE = S.BRAND_CODE AND Z.YMD < S.YMD) AND A.BRAND_CODE = S.BRAND_CODE INNER JOIN TestEveryDay4Data04 B ON B.YMD = (select MAX(Z.YMD) from TestEveryDay4Data04 Z where Z.BRAND_CODE = S.BRAND_CODE AND Z.YMD < A.YMD) AND B.BRAND_CODE = S.BRAND_CODE INNER JOIN TestEveryDay4Data04 C ON C.YMD = (select MAX(Z.YMD) from TestEveryDay4Data04 Z where Z.BRAND_CODE = S.BRAND_CODE AND Z.YMD < B.YMD) AND C.BRAND_CODE = S.BRAND_CODE INNER JOIN TestEveryDay4Data03 D ON D.BRAND_CODE = S.BRAND_CODE AND D.YMD BETWEEN B.YMD AND A.YMD INNER JOIN EigyoCalendar SS ON SS.YMD = S.YMD INNER JOIN EigyoCalendar AA ON AA.YMD = A.YMD INNER JOIN EigyoCalendar BB ON BB.YMD = B.YMD WHERE S.YMD = '20190524' AND A.HIGH_AMT > B.HIGH_AMT AND B.HIGH_AMT < C.HIGH_AMT AND D.HIGH_AMT > B.HIGH_AMT * 1.15 AND SS.TEMP_NUM > AA.TEMP_NUM + 20 AND A.HIGH_AMT > 300 AND S.LOW_AMT > ((A.HIGH_AMT - B.HIGH_AMT)/(AA.TEMP_NUM - BB.TEMP_NUM)) * (SS.TEMP_NUM - BB.TEMP_NUM) + B.HIGH_AMT AND S.LOW_AMT * 0.96 < ((A.HIGH_AMT - B.HIGH_AMT)/(AA.TEMP_NUM - BB.TEMP_NUM)) * (SS.TEMP_NUM - BB.TEMP_NUM) + B.HIGH_AMT