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

[Earl Miles]

Leo Burd wrote:
> Hello there,
> 
> I am implementing an audioblog module and would like to know how to 
> select the nodes that haven't been read by a specific user.  Any 
> suggestions?
> 
> Thanks in advance,
> 
> Leo
> 
> 

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