Как изменить запрос sql?

<?php
/**
* Вывод лучших тегов
*
* @link https://lazydev.pro/
* @author LazyDev <email@lazydev.pro>
**/

defined('DATALIFEENGINE') || die('see ya');

$whereTopTags = [];
if ($period == 'today') {
    $whereTopTags[] = 'DATE(p.date) = CURDATE()';
} elseif ($period == 'week') {
    $whereTopTags[] = 'DATE(p.date) > DATE_SUB(curdate(), INTERVAL 7 DAY)';
} elseif ($period == 'month') {
    $whereTopTags[] = 'DATE(p.date) > DATE_SUB(curdate(), INTERVAL 1 MONTH)';
} elseif (is_int($period) && ($period = intval($period)) > 0) {
    $whereTopTags[] = 'DATE(p.date) > DATE_SUB(curdate(), INTERVAL ' . $period . ' DAY)';
}

if ($approve) {
    $whereTopTags[] = 'p.approve';
}

$limit = intval($limit ?: 10);

if ($cat) {
    $cat = explode(',', $cat);
    $cat = array_map('intval', $cat);
    if ($config['allow_multi_category']) {
        $whereTopTags[] = "p.category NOT REGEXP '[[:<:]](" . implode('|', $cat) . ")[[:>:]]'";
    } else {
        $whereTopTags[] = "p.category NOT IN ('" . implode("','", $cat) . "')";
    }
}

if ($tag) {
    $tag = explode(',', $tag);
    $tag = array_map(function($n) {
        return strip_tags(stripslashes($n));
    }, $tag);
    $whereTopTags[] = "t.tag NOT IN ('" . implode("','", $tag) . "')";
}

$whereTopTags = $whereTopTags ? 'WHERE ' . implode(' AND ', $whereTopTags) : '';

$tpl->result['toptags_block'] = dle_cache('news_top_tags', $config['skin'] . $cacheHash);

if (!$tpl->result['toptags_block']) {
	$topTagsArray = $db->super_query("SELECT t.tag, COUNT(t.tag) as count FROM " . PREFIX . "_tags t LEFT JOIN " . PREFIX . "_post p ON(t.news_id=p.id) {$whereTopTags} GROUP BY tag ORDER BY count DESC", true);
    $tpl->load_template('toptags.tpl');
    if ($topTagsArray) {
        $topTagsArray = array_slice($topTagsArray, 0, $limit);
        foreach($topTagsArray as $value) {
            $value['tag'] = strip_tags(stripslashes($value['tag']));
			$tpl->set('', [
                '{tag}' => $value['tag'],
                '{url}' => $config['http_home_url'] . 'tags/' . urlencode($value['tag']),
                '{count}' => $value['count']
            ]);
			$tpl->compile('toptags');
		}
        $tpl->clear();
    }
    
    $tpl->load_template('toptags_block.tpl');
    if ($tpl->result['toptags']) {
        $tpl->set_block('', ["'\\[tags\\](.*?)\\[/tags\\]'si" => '\\1', "'\\[not-tags\\](.*?)\\[/not-tags\\]'si" => '']);
        $tpl->set('{tags}', $tpl->result['toptags']);
    } else {
        $tpl->set_block('', ["'\\[tags\\](.*?)\\[/tags\\]'si" => '', "'\\[not-tags\\](.*?)\\[/not-tags\\]'si" => '\\1']);
    }
    $tpl->compile('toptags_block');
	create_cache('news_top_tags', $tpl->result['toptags_block'], $config['skin'] . $cacheHash);
}

echo $tpl->result['toptags_block'];
?>

<li><a href="{url}">{tag} [Всего: {count}]</a></li>

[tags]Топовые теги: <ul>{tags}</ul>[/tags]
[not-tags]Тегов нет[/not-tags]