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