I like the idea of searching for up and coming Movies. I'm currently using Freeview DVB EPG as a TV Guide source - does this have the info required perform this kind of search?
SearchWiz creates SQL queries linking tables PROGRAMME, PROGRAMME_GENRE, GENRE and CHANNEL based on the criteria you enter.
For movie searches I usually create the following type of Filters:
- Filter Name: What's On Today
- Criteria: spaces
- SearchBy: Title, Episode and Prog Desc
- Times: Today (will retrieve anything starting now thru midnight)
- Genres: Movies
This will pull all movies on today IF in the EPG the Genre contains Movie. If Freeview EPG loads genres into the GBPVR db, you should be able to create a filter like this to pull movies.
The following SQL will list every program with it's associated genres:Code:SELECT p.name, g.genre_name FROM PROGRAMME p, GENRE g, PROGRAMME_GENRE pg WHERE pg.programme_oid = p.oid and pg.genre_oid = g.oid