last login

Number of nodes of specific type created since last login

  1. SELECT COUNT(1) FROM {nodes} n
  2. WHERE n.created > (SELECT login FROM {users} u WHERE uid = %d)
  3. AND n.type = '%s'
Syndicate content