These keywords have special meaning in a query and they must be uppercase:

When you use the OR keyword, it changes the conditions of the search. For example, the search

changes the normal search operation to select each item containing either the word Aoi or the word Bunko in its details.

You can use the NOT keyword to negate a term. In other words, you can select items that do not contain a term. For example, the search

will select any item with details not containing the word nakadashi

The AND keyword requires both terms on either side of it to be in an item's details for it to be selected. This is like the default functionality of a search, but can modify a search when used in conjunction with the OR keyword. For example,

will select items containing either just the word Aoi and/or both of the words Bunko and gansha.

Note that the AND and OR operators apply only to the the terms directly on either side of them and the NOT operator applies only to the term directly to its right. For example,

will create a search for items that must include the term public, must not include the term amateur, and must include at least one of the terms nanpa or reverse nanpa.

If instead of searching all details of an item for your query you would like to search a specific field, you can specify which field should be searched. The format for using a field specifier is

where <search_term> is your search term (remember to use quotes if there are multiple words in the term) and <field> is one of the following: Note that there must be no space on either side of the colon (:) when using a field specifier. The different field specifiers allow you to search for your search term only in item ID, item title, idol name, movie studio name, media format, category/genre of movie, subtitle languages, or audio languages, respectively. If, for example, you want to search for items available on DVD and featuring JAV idol Nanami Nanase, you could use the following query: Note that if you specify an idol's first and last names as a search term for the idol field, they will be searched in either order because the order of Japanese names are sometimes reversed when translated into English. So, the previous example would search for items featuring either Nanase Nanami or Nanami Nanase. Also note that the preceding rules still apply and the body of a field specification is considered a single term.