[Developers] Computer games not released on a specific platform

[Christopher R. Maden]

Philip Kendall wrote:
> I'm trying to get a list of computer games which *weren't* released on a
> specific platform, but I'm having trouble formulating the query. I've
> tried:

[...]

> which I hoped would exclude /en/double_dragon as that was released on the
> Spectrum, but it obviously isn't. Is there any way to write this query?

CVTs make this a little tricky.  What you need to do is *require* the 
CVT to include the ZX Spectrum, and then *forbid* any such matching 
CVTs.  When the Spectrum itself is forbidden, you can still get any CVTs 
that *don’t* have the Spectrum; you get a list of games that were 
released *at least* on any other platform.  This query does what you want:

[
   {
     "id" : null,
     "name" : "Double Dragon",
     "type" : "/cvg/computer_videogame",
     "versions" : [
       {
         "optional" : "forbidden",
         "platform" : {
           "name" : "ZX Spectrum"
         },
         "type" : "/cvg/game_version"
       }
     ]
   }
]

~Chris
-- 
Christopher R. Maden
Data Architect
Freebase.com: <URL: http://www.freebase.com/ >
Metaweb Technologies, Inc. <URL: http://www.metaweb.com/ >