1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

--site name as per query 516017 for SEDE URLs
DECLARE @siteinit VARCHAR(100), @site VARCHAR(100)
SET @siteinit=REPLACE(LOWER( (SELECT DB_NAME() AS [Current Database]) ),'StackExchange.','')
SET @site = REPLACE(REPLACE(REPLACE( --REPLACE(
CASE
  WHEN @siteinit NOT LIKE '%.Meta' THEN @siteinit
  ELSE 'meta.'+REPLACE(@siteinit,'.Meta','')
  END
  ,'audio','avp') ,'stackoverflow.br','stackoverflow.pt') ,'stackoverflow.','')
  --,'meta.','')+'me' -- Some meta sites require this

-- BadgeClass: Badge class "1 for gold, 2 for silver, 3 for bronze"

SELECT 
  UserId AS [User Link],
  Name,
  Date,
  'http://data.stackexchange.com/'+@site
    +'/query/931395?UserId='+CAST(UserId AS varchar)
    +'&Tag=%27'+CAST(Name AS varchar)
    +'%27&DummyDate='+REPLACE(CONVERT(varchar(25), Date, 120),' ','%20')
    +'#graph|Link' AS 'Tag edit history'
FROM Badges
WHERE Badges.TagBased = 'true'
  AND Badges.Class = ##BadgeClass:int?1##
ORDER BY Date

fork query

edited nov 22 18

created nov 22 18 E.P.