drupal 7

Here is the simple example how to create custom node token in Drupal 7.

All common Drupal 7 database examples here: select, update, delete, insert, join, filter, sorting, limit etc.