Danbooru

Read the rules before proceeding!

help:cheatsheet

This cheatsheet describes how to search and tag posts.

Searching

blonde_hair blue_eyes
Search for posts that have both blonde hair and blue eyes.

~blonde_hair ~blue_eyes
Search for posts that have either blonde hair or blue eyes.

-blonde_hair -blue_eyes
Search for posts that don't have blonde hair or blue eyes.

blonde_hair *_(cosplay)
Search for posts that have blonde hair and at least one tag ending with "_(cosplay)". Note: This won't match every *_(cosplay) tag; the number of matches is limited by your tag limit (see Limitations below).

~blonde_hair ~blue_eyes *_(cosplay)
Doesn't work; wildcard searches do not work when combined with or-searches.

blonde_hair -*_(cosplay)
Doesn't work; wildcards can't be excluded from searches.

Metatags

User qualifiers
Users

user:albert
Search for posts uploaded by the user albert.

-user:albert
Search for posts not uploaded by the user albert.

Favorites

fav:albert
Search for posts favorited by the user albert.

-fav:albert
Search for posts not favorited by the user albert.

ordfav:albert
Search for posts favorited by the user albert ordered in the order they were favorited in, instead of by the date they were uploaded.

favcount:>10
Search for posts with at least 10 favorites.

order:favcount
Order search results by most favorited to least favorited.

Approvers

approver:albert
Search for posts that were approved by the user albert.

-approver:albert
Search for posts that were not approved by the user albert.

approver:any
Search for posts that were approved by anybody (that is, posts that went through the mod queue).

approver:none
Search for posts that were approved by nobody (that is, posts that bypassed the mod queue).

Comments

commenter:albert or comm:albert
Search for posts that were commented on by the user albert.

commenter:any or comm:any
Search for posts that have comments.

commenter:none or comm:none
Search for posts don't have comments.

order:comment
Order search results by most recently commented on. Includes non-bumping comments.

order:comment_bumped
Order search results by most recently bumped.

Notes

noter:albert
Search for posts that have had notes created by the user albert.

noter:any
Search for posts that have notes.

noter:none
Search for posts that don't have notes.

noteupdater:albert
Search for posts that have had notes updated by the user albert.

order:note
Order search results by most recently updated notes.

Flags

status:flagged
Search for posts that are currently flagged.

flagger:albert
Search for posts that have even been flagged by albert (mod only; normal users may only search for flags created by themselves).

flagger:any
Search for posts that have ever been flagged.

flagger:none
Search for posts that have never been flagged.

Appeals

appealer:albert
Search for posts that have even been appealed by albert.

appealer:any
Search for posts that have ever been appealed.

appealer:none
Search for posts that have never been appealed.

Artist commentaries

artcomm:albert
Search for posts that have had artist commentaries created by the user albert.

order:artcomm
Order search results by most recently updated commentaries.

Favorite groups

favgroup:cute
Search for posts in the favgroup "cute" (see help:favorite groups).

-favgroup:cute
Search for posts not in the favgroup "cute".

Saved searches

search:artists
Search for posts in the saved search named "artists" (see /saved_searches).

Range qualifiers
ID number

id:100
Search for posts with an ID number of 100.

id:100.. or id:>=100
Search for posts with an ID number of 100 or greater.

id:>100
Search for posts with an ID number greater than 100.

id:..100 or id:<=100
Search for posts with an ID number of 100 or less.

id:<100
Search for posts with an ID number less than 100.

id:100..200
Search for posts with an ID number between 100 and 200.

id:1000,2000,3000
Search for posts having IDs of 1000, 2000, or 3000. Commas may be used to specify a list of IDs.

order:id or order:id_asc
Order search results in ascending order based on post ID.

order:id_desc
Order search results in descending order based on post ID.

id:3000,1000,2000 order:custom

Search for ID's in a custom order. Can only be used with comma-separated IDs like the above.

Date

date:2007-01-01
Search for posts uploaded on a certain date (uses same syntax as id search - later dates are considered greater).

Age

age:2weeks..1year or age:2w..1y
Search for posts uploaded between 2 weeks and 1 year ago. Available parameters: seconds (s), minutes (mi), hours (h), days (d), weeks (w), months (mo), years (y).

Post qualifiers
Status

status:any or status:all
Show all posts, even deleted posts.

status:deleted
Search for posts that are currently deleted.

-status:deleted
Search for posts that are not currently deleted.

status:pending
Search for posts that are currently pending (posts uploaded in the last three days and not yet approved).

status:flagged
Search for posts that are currently flagged. Use flagger:any to find posts that have ever been flagged.

status:banned
Search for posts that are currently banned. See also: banned artist.

Ratings

rating:explicit or rating:e
Search for posts that are rated explicit.

rating:questionable or rating:q
Search for posts that are rated questionable.

rating:safe or rating:s
Search for posts that are rated safe.

-rating:safe or -rating:s
Search for posts that are not rated safe.

Source

source:none
Search for posts with no source specified.

-source:any
Search for posts with any source.

source:http://pixiv.net
Search for posts with a source that starts with http://pixiv.net.

-source:http://pixiv.net
Search for posts that do not have a source starting with http://pixiv.net.

source:pixiv/artist/
Search for posts with a source from the Pixiv account of "artist". The "artist" is not necessarily their tag on Danbooru, but their login name on Pixiv.

-source:pixiv/artist/
Search for posts that do not have a source from the Pixiv account of "artist". The "artist" is not necessarily their tag on Danbooru, but their login name on Pixiv.

source:*touhou*
Search for posts with a source containing the string "touhou". '*' is a wildcard.

source:"*Kantai Collection*"
Search for posts with a source containing the string "Kantai Collection". Quotes may be used to search for sources containing spaces.

Pixiv ID

pixiv:8314
Search for posts with a Pixiv ID number of 8314.

Parent/child

parent:1
Search for posts that have post #1 as a parent (including post #1).

parent:none
Search for posts that have no parent (that is, exclude child posts).

parent:any
Search for posts that have a parent (that is, include only child posts).

child:none
Search for posts that have no children.

child:any
Search for posts that have at least one child.

Tag counts

tagcount:2
Search for posts with two tags (uses same syntax as id search).

gentags:2
Search for posts with two general tags (uses same syntax as id search).

arttags:2
Search for posts with two artist tags.

chartags:2
Search for posts with two character tags.

copytags:2
Search for posts with two copyright tags.

metatags:2
Search for posts with two meta tags.

Score

score:100
Search for posts with a score of 100 (uses same syntax as id search).

order:score
Order search results in descending order based on post score.

order:score_asc
Order search results in ascending order based on post score.

order:rank
Order search results in descending order based on score and recency of upload.

Locked status

locked:note
Search for posts that are note locked.

locked:rating
Search for posts that are rating locked.

locked:status
Search for posts that are status locked.

Post changes

order:change
Order posts by most recently updated.

Image qualifiers
MD5 hash

md5:d34e4cf0a437a5d65f8e82b7bcd02606
Search for posts with the MD5 hash d34e4cf0a437a5d65f8e82b7bcd02606.

Dimensions

width:100
Search for posts with a width of 100 pixels (uses same syntax as id search).

height:100
Search for posts with a height of 100 pixels (uses same syntax as id search)

Ratio

ratio:4:3
Search for posts with a width:height ratio of 4:3 (uses same syntax as id search).

order:landscape
Order landscape images first.

order:portrait
Order portrait images first.

Megapixels

mpixels:2.5..
Search for posts with 2.5 million pixels or greater (uses same syntax as id search).

order:mpixels
Order search results in descending order based on resolution.

order:mpixels_asc
Order search results in ascending order based on resolution.

Filesize

filesize:200kb..1.5M
Search for posts with a filesize between 200 kilobytes and 1.5 megabytes (uses same syntax as id search).

order:filesize
Order search results in descending order based on file size.

Filetype

filetype:png
Search for posts with a filetype of PNG. Common filetypes: jpg, png, gif, swf, webm, mp4, zip (ugoira).

Pools

pool:4
Search for posts that are in pool #n4.

-pool:4
Search for posts that are not in pool #n4.

pool:none
Search for posts that are not in any pools.

pool:any
Search for posts that are in at least one pool.

pool:series
Search for posts that are in at least one series-category pool.

pool:collection
Search for posts that are in at least one collection-category pool.

-pool:series
Search for posts that are not in any series-category pools.

-pool:collection
Search for posts that are not in any collection-category pools.

pool:boo_boo_kagaboo
Search for posts in the pool with the name Boo Boo Kagaboo. Make sure to replace spaces with underscores.

ordpool:boo_boo_kagaboo
Search for posts in the pool with the name Boo Boo Kagaboo and display them in the order they appear in the pool, instead of the order they were uploaded.

Other

upvote:username (Mod only)
Searches for all upvotes of user.

downvote:username (Mod only)
Searches for all downvotes of user.

limit:5
Change the number of posts that appear on a single page to 5. Does not change the results themselves. The maximum limit is 200.

rating:questionable rating:safe
In general, combining the same metatags (the ones that have colons in them) will not work. Use -rating:explicit instead.

rating:questionable score:100.. id:..1000
You can combine different metatags, however.

Tagging

Many of the above metatags can also be used when tagging posts. For example, tagging a post with rating:safe pool:Disgustingly_Adorable sets the rating to safe and adds the post to the Disgustingly Adorable pool.

These metatags can also be used in tag scripts.

blonde_hair blue_eyes

Tags a post with blonde hair and blue eyes. Use spaces to separate tags. Use underscores to separate words within tags.

-blonde_hair

Removes the blonde hair tag from the post.

tanaka_rie souryuu_asuka_langley

Use LastName FirstName order for characters with Japanese last names, or characters with full Chinese or Korean names. Middle names always follow the first name.

john_smith akira_ferrari tony_leung

Use FirstName LastName order for characters with non-Asian names, or characters with Japanese first names but non-Asian last names, or characters with non-Asian first names but Chinese last names.

general:food

Prefix a tag with general: (or gen:) to set it as a general tag.

artist:wakatsuki_sana

Prefix a tag with artist: (or art:) to set it as an artist tag.

character:gasai_yuno

Prefix a tag with character: (or char:) to set it as a character tag.

copyright:mirai_nikki

Prefix a tag with copyright: (or copy:) to set it as a copyright tag. Copyright tags include things like anime, manga, games, novels, or original doujinshi works.

rating:questionable (or rating:e, rating:q, rating:s)

Rate a post. See howto:rate for rating guidelines.

parent:1234

Sets the post's parent to post #1234.

parent:none, parent:0

Removes the post's parent.

-parent:1234

Removes the post's parent, if the parent was post #1234.

child:1234

Makes post #1234 a child of the current post. Does not directly affect the current post.

pool:10

Adds the post to pool #10.

-pool:10

Removes the post from pool #10.

pool:maria-sama_ga_miteru_manga

Adds the post to the "Maria-sama ga Miteru Manga" pool. Does nothing if the pool doesn't already exist. Make sure to replace spaces with underscores.

newpool:maria-sama_ga_miteru_manga

Adds the post to the "Maria-sama ga Miteru Manga" pool, creating the pool if it does not already exist.

source:https://twitter.com/Shatyo3/status/787104029209874432

Sets the source.

source:"(C90) [Hyper Summer Wars (Bomber Grape)] Admiral Prelude (Kantai Collection -KanColle-)"

Sets the source. Use quotes for sources containing spaces.

source:none

Clears the source.

favgroup:cute

Adds the post to the favorite group named "cute" (see help:favorite groups).

-favgroup:cute

Removes the post from the favorite group named "cute" (see help:favorite groups).

fav:self

Favorites the post.

-fav:self

Unfavorites the post.

upvote:self

Votes up a post.

downvote:self

Votes down a post.

List of available metatags

  • user, -user
  • approver, -approver
  • commenter (alternative: comm)
  • noter
  • artcomm
  • pool, -pool, newpool, ordpool
  • fav, -fav, ordfav
  • favgroup, -favgroup
  • sub
  • search
  • md5
  • rating, -rating
  • locked, -locked
  • width
  • height
  • mpixels
  • ratio
  • score
  • favcount
  • filesize
  • filetype
  • source, -source
  • id
  • date
  • age
  • status, -status
    • pending
    • flagged
    • deleted
    • banned
    • active
    • any (alternative: all)
  • tagcount
  • gentags
  • arttags
  • chartags
  • copytags
  • parent, -parent
  • child, -child
  • pixiv_id, pixiv
  • limit
  • order
    • id (alternative: id_asc)
    • id_desc
    • score (alternative: score_desc)
    • score_asc
    • favcount
    • favcount_asc
    • change, change_desc
    • change_asc
    • comment (alternative: comm)
    • comment_asc (alternative: comm_asc)
    • note
    • note_asc
    • artcomm
    • mpixels (alternative: mpixels_desc)
    • mpixels_asc
    • portrait
    • landscape
    • filesize (alternative: filesize_desc)
    • filesize_asc
    • rank
    • random
  • upvote (mod only)
  • downvote (mod only)

Limitations

Members cannot search for more than two tags at a time. Gold users can search for up to six tags, and Platinum and above users can search for up to twelve tags (see help:users).

The rating:safe, status:deleted, -status:deleted, and limit:200 metatags do not count against the limits above.

The maximum search duration is limited to 3 seconds for Members, 6 seconds for Gold users, and 9 seconds for Platinum and above users. If your search takes longer than this it will be cancelled. You will see a ERROR: canceling statement due to statement timeout error when this happens.

Limiting your search to a smaller range of posts, for example by adding age:<1year or date:2016-01-01..2017-01-01, may prevent timeouts.

Wildcards

The * character acts as a wildcard character. Use \* to match the literal * character.

  • * - wildcard
  • \* - literal *
  • \\ - literal \

See also