search

iftechfoundation / ifdb

The software behind the Interactive Fiction Database (IFDB)
Other
23 stars 18 forks source link

Negating tag search is broken #453

Closed dfabulich closed 9 months ago

dfabulich commented 9 months ago

https://ifdb.org/search?type=game&searchfor=system%3Atwine+-tag%3Asexual%20content+-genre%3Apornographic&sortby=rand

This is the search that the Twine homepage would use to query IFDB, excluding sexual content. It now returns 0 results.

dfabulich commented 9 months ago

@salty-horse

dfabulich commented 9 months ago

Before:

where system RLIKE 'twine' AND  NOT (tags rlike '[[:<:]]sexual content[[:>:]]') AND  NOT (genre RLIKE 'pornographic')

Now:

where system RLIKE 'twine' AND  NOT (1) AND  NOT (genre RLIKE 'pornographic')

NOT(1) 😬