'; $request="select num from (select * from (select distinct(ref) ref,count(ref) num from wp_bstat_refs WHERE ref not like 'http%' and ref not like 'www%' AND bstat_date > '$date' $post_id group by ref) t1 order by num desc limit 0,$maxresults) t2 order by num asc limit 0,1"; if($row=$wpdb->get_results($request)) { $divisor=ceil($row[0]->num/$starting_font_size); $request = "select * from (select * from (select distinct(ref) ref,count(ref) num from wp_bstat_refs WHERE ref not like 'http%' and ref not like 'www%' AND bstat_date > '$date' $post_id group by ref) t1 order by num desc limit 0,$maxresults) t2 order by ref"; $rows = $wpdb->get_results($request); foreach($rows as $row) { $tag=array( 'ref'=>$row->ref, 'num'=>$row->num ); $rows2 = $wpdb->get_results("SELECT * FROM wp_bstat_refs WHERE ref='".$tag['ref']."'"); $tag['link']=get_permalink($rows2[0]->post_id); $tag['size']=10; $tag['size']+=(floor(($tag['num']/$divisor)/$starting_font_size)*2); $tag['size']=($tag['size']>30)?30:$tag['size']; $tag['ref']=str_replace($search,$replace,$tag['ref']); $text.=''.$tag['ref'].'  '."\n"; }//end foreach $text.=''; echo $text; }//end if }//end bstat_search_cloud ?>