Explanations / Notes:
Song Name checks against Japanese, transliterated, or translated names. % is the wildcard, so a search for %love% will find songs that used love or words that translated to love.
Credits: Probably quicker to show a few examples than try to explain it in full. != is the way to express "not".
[Artist=%Musume%] and [Artist!=Coconuts Musume]
[Vocals=Tsuji Nozomi] and [Lyrics!=Tsunku]
Release Date: Use YYYY-MM-DD date format.
Song Types: It's inclusive. Even if you have A-sides unchecked, if you have Covers checked you'll still see songs that are both A-sides and Covers. This may change in the future to allow more specific searches.
Order By: Usually just clicking on the column headers will be fine, but you can also combine them here, like
Lyrics ASC, Music ASC
Artist ASC, Seconds DESC