2021 Derpibooru Community Collab

Chopsticks
Silly Pony - Celebrated the 13th anniversary of MLP:FIM, and 40 years of MLP!
Shimmering Smile - Celebrated the 10th anniversary of Equestria Girls!
Solar Guardian - Refused to surrender in the face of the Lunar rebellion and showed utmost loyalty to the Solar Empire (April Fools 2023).
Betrayal! - Betrayed their team for a badge. Shame forever!
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
Flower Trio - Helped others get their OC into the 2023 Derpibooru Collab.
Non-Fungible Trixie -
Verified Pegasus - Show us your gorgeous wings!
Preenhub - We all know what you were up to this evening~
Philomena - For helping others attend the 2021 community collab

Rice pone
@Joey  
Hey Joey, I was wondering how you get all the tags into the image, as a process. Is there a super easy programming method or is it something more tedious?
Frown Factory
Lunar Supporter - Helped forge New Lunar Republic's freedom in the face of the Solar Empire's oppressive tyrannical regime (April Fools 2023).
Roseluck - Had their OC in the 2023 Derpibooru Collab.
King Sombra - Celebrated the 10th anniversary of The Crystal Empire!
A Lovely Nightmare Night - Celebrated the 12th anniversary of MLP:FIM!
Princess of Love - Extra special version for those who participated in the Canterlot Wedding 10th anniversary event by contributing art.
Elements of Harmony - Had an OC in the 2022 Community Collab
Non-Fungible Trixie -
Verified Pegasus - Show us your gorgeous wings!
Preenhub - We all know what you were up to this evening~
Twinkling Balloon - Took part in the 2021 community collab.

Vectors & Reactions
@Chopsticks  
I think he said last year that he wrote a script to automagically grab all the tags of the individual submissions and slap them into a list.  
Derpibooru has an API after all, so scripting that part is rather trivial. Composing the actual image is the hard part.
 
Though, as an admin he might have quicker ways to access that data, like just running an SQL query.
Lil_VampireCJ
Silly Pony - Celebrated the 13th anniversary of MLP:FIM, and 40 years of MLP!
Shimmering Smile - Celebrated the 10th anniversary of Equestria Girls!
Lunar Supporter - Helped forge New Lunar Republic's freedom in the face of the Solar Empire's oppressive tyrannical regime (April Fools 2023).
Flower Trio - Helped others get their OC into the 2023 Derpibooru Collab.
Crystal Roseluck - Had their OC in the 2023 Derpibooru Collab.
King Sombra - Celebrated the 10th anniversary of The Crystal Empire!
A Lovely Nightmare Night - Celebrated the 12th anniversary of MLP:FIM!
An Artist Who Rocks - 100+ images under their artist tag
Princess of Love - Extra special version for those who participated in the Canterlot Wedding 10th anniversary event by contributing art.
Tree of Harmony - Drew someone's OC for the 2022 Community Collab

Lil_VampireCJ
@Frown Factory  
@Chopsticks
 
Likely by a algorithm that traces all the original posts/images used in the collaboration that contain OC:[example] & Artist:[Example] or something similar…I am hoping they get my tags right and do not misname me with the wrong artist tag but hopefully they do leave a option to get artist/oc tags fixed ()
Joey
Dawnsong - Derpi Supporter
Lunar Supporter - Helped forge New Lunar Republic's freedom in the face of the Solar Empire's oppressive tyrannical regime (April Fools 2023).
Flower Trio - Helped others get their OC into the 2023 Derpibooru Collab.
Roseluck - Had their OC in the 2023 Derpibooru Collab.
A Lovely Nightmare Night - Celebrated the 12th anniversary of MLP:FIM!
Cool Crow - "Caw!" An awesome tagger
Tree of Harmony - Drew someone's OC for the 2022 Community Collab
Elements of Harmony - Had an OC in the 2022 Community Collab
Non-Fungible Trixie -
Verified Pegasus - Show us your gorgeous wings!

PM me your cute OCs
@Chopsticks  
@Frown Factory  
@Lil_VampireCJ
 
I wrote a simple (but very messy) SQL query that can be ran against the site’s database to get everything in one go:
 
SELECT name FROM tags
WHERE id IN (
SELECT tag_id
FROM image_taggings
WHERE image_id IN (
SELECT image_id
FROM image_taggings
WHERE tag_id = 478530
)
AND image_id NOT IN (
SELECT id
FROM images
WHERE hidden_from_users = true
AND id IN (
SELECT image_id
FROM image_taggings
WHERE tag_id = 478530
)
)
)
AND (namespace = ‘oc’ OR namespace = ‘artist’)
GROUP BY name;
 
For those who don’t speak SQL, it basically gets a list of all tag names where:  
  • the tag is on an image that is tagged with tag ID 478530 (2020 Community Collab)  
  • the tag also is on an image that is not deleted  
  • the tag also has an “artist” or “oc” namespace
     
    There’s probably a cleaner and more efficient way to do that, but that’s a query that only has to be ran like once or twice a year, so I didn’t really care.
FliegerFaustToP47
Magical Inkwell - Wrote MLP fanfiction consisting of at least around 1.5k words, and has a verified link to the platform of their choice
Silly Pony - Celebrated the 13th anniversary of MLP:FIM, and 40 years of MLP!
Shimmering Smile - Celebrated the 10th anniversary of Equestria Girls!
Solar Hero - Went above and beyond for the Solar Deity, drawing from the power of the sun itself to bring balance to the fight against the Lunar Insurrection (April Fools 2023).
Flower Trio - Helped others get their OC into the 2023 Derpibooru Collab.
Roseluck - Had their OC in the 2023 Derpibooru Collab.
King Sombra - Celebrated the 10th anniversary of The Crystal Empire!
A Lovely Nightmare Night - Celebrated the 12th anniversary of MLP:FIM!
Princess of Love - Extra special version for those who participated in the Canterlot Wedding 10th anniversary event by contributing art.
Tree of Harmony - Drew someone's OC for the 2022 Community Collab

Laß mich sterben
@Gameplay The Pony
 
There are some reasons why it’s considered hilarious, ranging from the giant mittens to the extremely casual wear in Biden’s inauguration. Other than that I’ll let somebody else explain it for you since I’m not really that experienced with this meme other than it’s funny.
Luna
Luna - For Patreon supporters
Woona - Derpi Supporter
Flower Trio - Helped others get their OC into the 2023 Derpibooru Collab.
Roseluck - Had their OC in the 2023 Derpibooru Collab.
Solar Supporter - Fought against the New Lunar Republic rebellion on the side of the Solar Deity (April Fools 2023).
Lunar Supporter - Helped forge New Lunar Republic's freedom in the face of the Solar Empire's oppressive tyrannical regime (April Fools 2023).
Princess of Love - Extra special version for those who participated in the Canterlot Wedding 10th anniversary event by contributing art.
Tree of Harmony - Drew someone's OC for the 2022 Community Collab
Elements of Harmony - Had an OC in the 2022 Community Collab
Non-Fungible Trixie -

Luna Best Pony~
@Joey  
Fixed it for you  
select t.name from images i inner join image_taggings it on it.image_id = i.id right outer join image_taggings it2 on it2.image_id = i.id inner join tags t on t.id = it2.tag_id where it.tag_id = 478530 and t.namespace in ('oc', 'artist') and i.hidden_from_users = false group by t.name;
 
select t.name from images i
inner join image_taggings it on it.image_id = i.id
right outer join image_taggings it2 on it2.image_id = i.id
inner join tags t on t.id = it2.tag_id
where it.tag_id = 478530 and t.namespace in ('oc', 'artist') and i.hidden_from_users = false
group by t.name;
Interested in advertising on Derpibooru? Click here for information!
My Little Ties crafts shop

Help fund the $15 daily operational cost of Derpibooru - support us financially!

This topic has been locked to new posts from non-moderators.

Locked

Lock reason: Time for a new one