I am having trouble using where() and whereNotIn() clauses together in my SQL query. When I use the where clause alone, I receive my data correctly as shown in this screenshot:
However, when I add the whereNotIn clause (which works alone without the where clause), as shown in this screenshot:
I receive no data, even though I am supposed to receive some. Both of these conditions work alone, but not together.
Here is a detailed result of my query when the where() clause or whereNotIn() clause works alone:
bad-result
Does anyone have any idea why this might be happening? Thank you in advance for your help.