Impossible WHERE

[snapbackz]

EXPLAIN SELECT *  FROM `userlist` LEFT JOIN ( `users`, `userlist_views`) ON (userlist.userid = users.id  AND userlist.id = userlist_views.listid) WHERE `userlist`.`id` = '1' LIMIT 1;

Returns "Impossible WHERE noticed after reading const table..."

This only happens if table userlist_views does NOT have an entry but I thought LEFT JOIN was s'posed to return empty on non-matching rows? What I would like to happen is to return userlist AND users tables even if userlist_views has no data to match.

[illzz]

What are the results if you don't add the WHERE and LIMIT clauses?
Is there an entry that matches {userlist.id = '1'}??

[snapbackz]

Yes, userlist.id = 1 does exist.... Only the data from userlist_views is missing which is why im confused.