If the date range is changed to overlap the first 100 pages then just those occurring in the first 100 pages are reported. It appears that the openings qualified query starts with the first 100 pages then applies the date filter yielding No results found, If the date range is prior to the last date of the first 100 pages then there are no results to be filtered by date.
A single query:
select Gametype="Live Games" and game date between start date and end date and openings ="Ruy Lopez"

There are a number of Issues with the date qualified query.
1. Date format choices other than Year + Month + Date don't get considered. For example choosing Year Month Only
And doing a live query reports games out of range. For example 01/2013 to 01/2015 yields recent games as if the date qualifier is ignored:
2. When using Year + Month + Date in conjunction with an Opening qualifier yields No Results:
Just a date qualified 1/1/12 : 1/1/13 live query yields 41 pages:
Adding an opening qualifier yields: "No Results found":