2021 Derpibooru Community Collab

Chopsticks
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
Twinkling Balloon - Took part in the 2021 community collab.
A Really Hyper Artist - 500+ images under their artist tag
My Little Pony - 1992 Edition
A Really Classy Artist - 250+ images under their artist tag
A Tale For The Ages - Celebrated MLP's 35th Anniversary and FiM's 8th Anniversary
An Artist Who Rocks - 100+ images under their artist tag

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?
Posted Report
Frown Factory
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.
A Really Hyper Artist - 500+ images under their artist tag
My Little Pony - 1992 Edition
Friendship, Art, and Magic (2020) - Took part in the 2020 Community Collab
Wallet After Summer Sale -

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
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 -
Kinship Through Differences - Celebrated the 11th anniversary of MLP:FIM!
Twinkling Balloon - Took part in the 2021 community collab.
Artist -

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 ()
Posted Report
Joey
Dawnsong - Derpi Supporter
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!
Preenhub - We all know what you were up to this evening~
Philomena - For helping others attend the 2021 community collab
Twinkling Balloon - Took part in the 2021 community collab.
Ten years of changes - Celebrated the 10th anniversary of MLP:FiM!

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
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 -
Speaking Fancy - Badge given to members that help with translations
Kinship Through Differences - Celebrated the 11th anniversary of MLP:FIM!
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
Twinkling Balloon - Took part in the 2021 community collab.

Floofy & Friendly Plone
@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.
Posted Report
Luna
Luna - For Patreon supporters
Woona - Derpi Supporter
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 -
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
Twinkling Balloon - Took part in the 2021 community collab.

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;
Posted Report
Interested in advertising on Derpibooru? Click here for information!
My Little Ties crafts shop

Derpibooru costs over $25 a day to operate - help support us financially!

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

Locked

Lock reason: Time for a new one