[support] how to get the list of new nodes since last login?

[Nicolas Tostin]

Something like
SELECT nid
FROM node
WHERE created > ( SELECT MAX( login ) FROM users)
should do the work

----- Original Message ----- 
From: "Haisam K. Ido" <haisam at ido.org>
To: <support at drupal.org>
Sent: Wednesday, May 02, 2007 2:56 PM
Subject: [support] how to get the list of new nodes since last login?


> 
> How can one list all nodes that have been added since a uid's last 
> login?  Which table contains the login information?
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]
>