SELECT M.*       ,S.dt_site       ,C.dt_category FROM M_CMS AS M      left join m_cmssite S on S.nm_site=M.nm_site      left join m_cmscategory C on C.nm_category=M.nm_category WHERE 1=1 and M.fg_sakujyo='0' and M.kb_public='01' and M.nm_site=2 and M.kb_pref~'(02|03|04|05|06|07)' and (M.da_end is null or to_char(M.da_end,'YYYYMMDD')>='20250813') and to_char(M.da_start,'YYYYMMDD')<='20250806' and to_char(M.da_end,'YYYYMMDD')>='20250806'  ORDER BY M.da_end is null, M.da_end, M.da_start, M.da_entry, M.nm_cms desc limit 2