0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Tridion developers and administrators

SELECT DISTINCT P.OWNERUSERID, P.OWNERDISPLAYNAME, P.CREATIONDATE 
FROM USERS U, (SELECT CREATIONDATE,
OWNERUSERID, OWNERDISPLAYNAME FROM POSTS WHERE YEAR(CREATIONDATE) != 2015 AND 
YEAR(CREATIONDATE) = 2010) P WHERE U.ID = P.OWNERUSERID

view current version

edited dec 1 20

created dec 1 20 jon.doe34939