**Microtask - 1 of T304826**
**Task:** Write a SQL query on https://quarry.wmcloud.org/ to get a list of "unique" uploaders to the Wikimedia Commons category: [[ https://commons.wikimedia.org/wiki/Category:Images_from_Wiki_Loves_Earth_2014 | Images from Wiki Loves Earth 2014 ]], who have created their Wikimedia account during the campaign period i.e. May and June 2014. The output should include user_name and their account registration timestamp.
**Submission instructions:** After a successful output, submit the link (copy from url) along with Phabricator username privately to me @KCVelaga on Zulip (//don't// post the link publicly). Along with the code, do write explanatory comments about the approach and purpose of various steps. I will confirm whoever has submitted the micro-task here.
**Hints**:
- Check out how categories work on Wikimedia Commons: https://commons.wikimedia.org/wiki/Commons:Categories
- Tables that will help you to get the required data: [[https://www.mediawiki.org/wiki/Manual:Revision_table | Revision]], [[https://www.mediawiki.org/wiki/Manual:Categorylinks_table | Category links]], [[ https://www.mediawiki.org/wiki/Manual:Actor_table | Actor ]], and [[https://www.mediawiki.org/wiki/Manual:User_table | User ]]
- When a file is uploaded, it is considered as page creation!
**Note**: If during evaluation, if it is identified that the code is copied, the micro-task submission will be considered as invalid.