Skip to content

Instantly share code, notes, and snippets.

@scottgonzalez

scottgonzalez/trac-contributors.sql

Created December 20, 2013 18:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save scottgonzalez/8059481 to your computer and use it in GitHub Desktop.
Save scottgonzalez/8059481 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
trac-contributors.sql
(SELECT DISTINCT `reporter` AS `contributor`
FROM `ticket`
WHERE `resolution` = "fixed"
AND `milestone` = $V )
UNION
(SELECT DISTINCT `author`
FROM `ticket_change`
WHERE `ticket` IN (
SELECT `id`
FROM `ticket`
WHERE `resolution` = "fixed"
AND `milestone` = $V ) )
ORDER BY CAST(`contributor` AS CHAR)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment