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:
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.
- 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
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