- print_r: documentation ( source)
- preg_match_all: documentation ( source)
- array_unique: documentation ( source)
<?php
$query = "SELECT r.revision_id, r.content_id, r.user_id, r.entry_name, r.entry_description, r.date_added, r.date_modified FROM modules_acls_entries_content_revisions r INNER JOIN modules_acls_entries_content c ON (c.content_id = r.content_id) WHERE r.revision_id = ?;";
if(preg_match_all('/((FROM|JOIN|,) ([_\w]*))/', $query, $matches)) {
$tables = array_unique($matches[3]);
print_r($tables);
}