0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT myUser.Id, count(myEdit.Id) AS [Edit_before]
  FROM (SELECT DISTINCT Users.Id
    FROM Users
    inner join Posts p on p.owneruserid = Users.Id
    inner join Votes v on p.Id = v.postid
    WHERE (p.PostTypeId =2 AND v.votetypeid =2 AND ((AboutMe LIKE '%buymeacoffee%') OR (AboutMe LIKE '%ko-fi%')) 
    AND reputation > 10)) AS myUser
  left join (SELECT ph.Id AS phid, ph.CreationDate, u.Id
    FROM PostHistory ph
   INNER JOIN posts p ON ph.PostId = p.Id 
   INNER JOIN users u ON p.OwnerUserId = u.Id 
   WHERE p.OwnerUserId = u.Id AND ph.UserId = u.Id
    AND (ph.CreationDate BETWEEN DATEADD(week,-2,'##Date1?2021-10-01##') AND '##Date1?2021-10-01##')
    AND p.PostTypeId =2
    AND ph.PostHistoryTypeId = 5
  ) AS myEdit
  on myUser.Id = myEdit.Id
  GROUP BY myUser.Id
  ORDER BY myUser.Id

fork query

edited jan 27 22

created jan 27 22 anonymous