[avoova]

v databázi, pokud playCount není null, pak se jedná o shlédnutý film/epizodu:

Kód:

SELECT * FROM files WHERE `playCount` IS NOT NULL;

resp.:

SELECT * FROM episode_view WHERE `playCount` IS NOT NULL;

nebo

SELECT * FROM movie_view WHERE `playCount` IS NOT NULL

info: