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

On Wed, 14 Dec 2005 08:36:09 -0800, Earl Miles <merlin@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