Don't know what I was smoking.

I put “AND” instead of “WHERE”—surprised it worked at all. Also, the
join wasn’t even necessary.