Interesting challenge!
-
-
Hi there,
I thought I'd give this a go... seems an intriguing way to learn MQL/MJT. It does turn out to be surprisingly difficult!
One thing that's implicit in the wikipedia article is every spin-off only has one 'parent' show, which isn't necessarily true in freebase. For example:
http://www.freebase.com/view/guid/9202a8c04000641f8000000000035c8d
(Star Trek Voyager) lists its entire 'heritage' in the spun-off-from field (and arguably that's correct). I've managed to run into a few other curios as well:
http://www.freebase.com/view/en/torchwood
was listed as 'spun-off-from' itself (I just fixed that one).
Nevertheless, this certainly looks possible, although I can't see an straight MQL way to do it, it'll take some heavy lifting in javascript to post-process the query results. I'm looking forward to giving it a try!
-