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
