SELECT * FROM ( SELECT TS.MTYPE, TS.UID, TS.LIKECNT, TS.REGDATE, TSF.PATH, TSF.FILENAME, TS.USERID, NAME, TS.AIOPTION FROM T_STORY TS INNER JOIN T_STORY_FILE TSF ON TS.UID = TSF.STORYUID INNER JOIN T_MEMBER M ON M.SITEID=TS.SITEID AND M.USERID = TS.USERID WHERE TS.SITEID = 'METACELEB' AND TS.USERID = ? AND TS.MTYPE='REELS' AND TS.STYPE = 'VIDEO' AND TS.ISTRASH = 'F' AND TSF.FILETYPE = 'VIDEO' UNION ALL SELECT MTYPE, T_LIVE.UID, LIKECNT, T_LIVE.REGDATE, '' AS PATH, VIDEOCODE AS FILENAME, T_LIVE.USERID, NAME FROM T_LIVE INNER JOIN T_MEMBER M ON M.SITEID=T_LIVE.SITEID AND M.USERID = T_LIVE.USERID WHERE T_LIVE.SITEID = 'METACELEB' AND T_LIVE.USERID = ? AND MTYPE='SHORTS' AND ISTRASH = 'F' ) A ORDER BY A.REGDATE DESC
