This content has been marked as final. Show 1 reply
Hello. Wow! You are AND'ing 17 different fields. To get any data back, all 17 will have to match exactly. (And, of course, none can be NULL; you can't test for NULL with =.) I'd start with just one clause (or no clauses) in the WHERE and make sure that you get back something from that. If / when you do get some data back, then you can add a few more clauses back into the WHERE until you find the column(s) causing the problem.
Hint: When something complex gets tricky, start with something small and make sure that works first.