2012-02-19, 03:09
neilperrya Wrote:Both of these 'work'. The first one seems to the be 'best' because it pulls the playCount and lastPlayed
Ok, those results seem correct. Try the whole query that same way.
Code:
UPDATE files SET playcount=1 WHERE idFile IN ( SELECT idFile FROM episode INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow WHERE tvshow.c12='76156' AND episode.c12='9' AND episode.c13='3' )