Sorry. Not much to report. Plus crazy traffic ate two hours of yesterday because they closed part of the freeway because construction workers punctured a gas line. Plus I had a migraine.

The person who designed and built the database (as well as all of the pages and tools that it interfaces with) gave me SQL query to extract the important things that I need to know.

Just by coincidence, the SQL query worked absolutely perfectly on the small test case that I was using to build the proof of concept. I’ve spent much of the past week or so trying to scale things up to deal with the problem in general, including the case where we don’t have any old data to validate against.

So much time wasted because the query has too many things ANDed into the WHERE clause, so data is missing, but I have no idea how to fix the query.