<?php
$new_sql="select distinct products_id,id,products_tag,count(distinct products_id) as tagct from product_tag where tag_status=1 GROUP BY products_tag order by id desc limit 30";
$new_tags=$db->Execute($new_sql);
$i=0;
$newlist_tags=array();
while(!$new_tags->EOF){ 
$newlist_tags[$i]['id']=$new_tags->fields['id'];
$newlist_tags[$i]['products_tag']=$new_tags->fields['products_tag'];
$newlist_tags[$i]['tag_count']=$new_tags->fields['tagct'];
$i++;
$new_tags->MoveNext();
}
$sql="select id,products_id,products_tag,count(distinct products_id) as tagct from product_tag where tag_status=1 GROUP BY products_tag";
$tags_split=new tags_splitPageResults($sql,'40');
$tags=$db->Execute($tags_split->sql_query);
$row=0;
$list_tags=array();
while(!$tags->EOF){
$list_tags[$row]['id']=$tags->fields['id'];
$list_tags[$row]['products_tag']=$tags->fields['products_tag'];
$list_tags[$row]['tag_count']=$tags->fields['tagct'];
$row++;
$tags->MoveNext();
}
$tpl_page_body = 'tpl_' . $_GET['main_page'] . '_default.php';
require($template->get_template_dir($tpl_page_body, DIR_WS_TEMPLATE, $current_page_base,'templates') . '/' . $tpl_page_body);
?>