Rewrite SQL on a specific content type node on Drupal 7
While the question is vague as to your purpose, you may be interested in 


hook_query_alter
hook_query_TAG_alter


to alter queries in Drupal 7.