Q&A about the site for administrators, end users, developers and designers for Craft CMS
-- Enter Query Title -- Enter Query Description select p.id as postId, p.parentid, p.ownerdisplayname, pt.name as postType, vt.name as voteType, u.displayname as displayName from posts p left join posttypes pt on pt.id = p.posttypeid left join votes v on v.postid = p.id left join votetypes vt on vt.id = v.votetypeid left join users u on u.id = v.userid where p.owneruserid = 273657 and p.creationdate > dateadd(day, -2, getdate())