[support] How to select the nodes that haven't been read by a specific user?

[Pat Collins]

On Wed, 14 Dec 2005 08:36:09 -0800, Earl Miles <merlin at logrus.com> wrote :
> You want to enable the statistics module. Then you can do a LEFT JOIN on the 
> accesslog module with a WHERE clause on accesslog.uid = youruser AND 
> accesslog.nid = NULL

= NULL is just wrong.  IS NULL is the correct syntax.  

Pat