select fd_prikey, fd_datatype, fd_chksubkey1, fd_chksubkey2, fd_chksubkey3,(INDATE >= 20230301000000 AND INDATE <= 20260318235959) AS DATECHECK from mainschrt,olddataschrt WHERE match(' (@fd_mediatype "80") (@fd_datatype "1") !(@fd_ismsave "1") (@fd_iswebout "1") ( ((@(fd_tag1,fd_tag2,fd_tag3,fd_tag4,fd_tag5) "^HHL$"))) !(@(fd_sortcode1,fd_sortcode2,fd_sortcode3,fd_sortcode4,fd_sortcode5,fd_sortcode6,fd_sortcode7,fd_sortcode8,fd_sortcode9,fd_sortcode10,fd_sortcode11,fd_sortcode12,fd_sortcode13,fd_sortcode14,fd_sortcode15) ^8012$)') AND DATECHECK=1 group by fd_prikey order by OUTDATE desc LIMIT 0,21 option max_matches=20001