Skip to content

Instantly share code, notes, and snippets.

@frals
frals / gist:3475929
Created Aug 26, 2012
Fixed version of http://pastebin.com/5qv2CSyc to compile against master
View gist:3475929
/*
* Copyright (C) 2005-2008 Team XBMC
* http://www.xbmc.org
*
* 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,
View diff-watched-all-eps.sql
select `episode`.`idEpisode`
from `tvshow`, `episode`
where
`episode`.`idShow` = `tvshow`.`idShow` AND
`tvshow`.idShow = XX
into outfile '/tmp/alleps';
select `episode`.`idEpisode`
from `tvshow`, `episode`, `files`
where