I'm trying to extract the user movie ratings (e.g. 1-5 stars on Roku) stored in the library db and join that with the actual movie titles (two tables: metadata_item_settings, metadata_item_views).
I executed the following query:
select metadata_item_views.title from metadata_item_settings, metadata_item_views where (metadata_item_settings.rating=2) AND (metadata_item_views.guid = metadata_item_settings.guid);
The metadata_item_settings table (containing the rating) had 16 hits but only 11 were returned from the metadata_item_views table (containing the title). I discovered that the missing rows in the metadata_item_views table are all movies that I deleted awhile ago AND the metadata_item_settings.view_offset column is non-empty for those 5 rows (e.g. values of 685000, 1419000, etc).
Two questions:
1) Does the metadata_item_settings table ever get truncated on obsolete (missing) shows? (if yes, how?)
2) How is the view_offset column utilized in the metadata_item_settings table?
