drupal 7.1 doc

https://www.drupal.org/docs/8/api/database-api/dynamic-queries/count-queries

https://www.drupal.org/docs/7/api/database-api/dynamic-queries/joins

https://api.drupal.org/api/drupal/includes%21database%21database.inc/function/db_truncate/7.x