Skip to content

Instantly share code, notes, and snippets.

frals / gist:3475929
Created August 26, 2012 07:56
Fixed version of to compile against master
* Copyright (C) 2005-2008 Team XBMC
* This Program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2, or (at your option)
* any later version.
* This Program is distributed in the hope that it will be useful,
select `episode`.`idEpisode`
from `tvshow`, `episode`
`episode`.`idShow` = `tvshow`.`idShow` AND
`tvshow`.idShow = XX
into outfile '/tmp/alleps';
select `episode`.`idEpisode`
from `tvshow`, `episode`, `files`