<h1><strong><?=$style?></strong> - Музыкальный стиль</h1>
<?=advert('pod_h1')?>
<?
$jj = arr_search($com_style, "name=='".mb_strtolower(urlback($sub[1],1), 'utf8')."'");$n_style = $jj[0]['id'];$d_style = styles($n_style, 2);?>
<p class="q"><?=$d_style?></p>
<!--Посмотри <a href="<?=$u?>/stars/style/<?=$style?>">популярных исполнителей</a> или <a href="<?=$u?>/music/style/<?=$style?>">популярные песни</a> этого стиля
-->
<h2>Популярные <strong>исполнители</strong> в стиле <strong><?=$style?></strong></h2>
<?	########################################################################################################################
$ch = 'style_'.$n_style;//cache_delete($ch);if (!$var = $cache->load($ch,$t[1])){cache_start();$sql = mysql_query("SELECT *, count(fv.star) as `count` FROM `favorite_stars` as `fv`
INNER JOIN `stars` ON (stars.id=fv.star)
WHERE stars.style = '".$n_style."'
GROUP BY fv.star
ORDER BY count DESC LIMIT 12");$num = mysql_num_rows($sql);?>
<? $i=0;if ($num>0){?>
<div class="stars_row">
<? while( $row = mysql_fetch_object($sql) ){?>
<a href="<?=$u?>/stars/<?=url($row->singer)?>" rel="s<?=$row->id?>">
<img class="ai" src="<?=u_prev_star($row->id, 'wh90')?>" width="90" height="90" alt="<?=$row->singer?>" /><p><?=$row->singer?></p></a><?}?></div><?}else{echo 'Такого стиля - нет, в нашей библиотеке!'}?>
<?	$var = cache_end($ch)}echo $var;######################################################################################################################## ?>
<h2 style="clear:both;">Популярные <strong>песни</strong> в стиле <strong><?=$style?></strong></h2>
<div class="tracks">
<?
$week = $time - $t[7];$i = 0;$sql = mysql_query("SELECT music.id, music.singer, music.star, music.song, music.hits, UNIX_TIMESTAMP(music.time) as time, count(fm.track) as count
FROM `music`
INNER JOIN `music_load` as `fm` ON (fm.track=music.id)
INNER JOIN `stars` ON (stars.id=music.star)
WHERE
stars.style = '".$n_style."' AND
(UNIX_TIMESTAMP(fm.time) > '$week')
GROUP BY fm.track
ORDER BY count DESC LIMIT 50");while( $row = mysql_fetch_object($sql) ){$i++;if ((time() - $row->time) < $t[30]){$new=1}else{$new=0}?>
<div class="row<?=($new==1)?' row_new':''?>">
<div class="row_num" title="<?=data($row->time)?>"><?=($new==1)?'&nbsp;new':$i?></div>
<div class="row_singer"><a rel="s<?=$row->star?>" href="<?=$u?>/stars/<?=url($row->singer)?>"><?=$row->singer?></a></div>
<div class="row_song"><a rel="m<?=$row->id?>" href="<?=$u?>/mp3/<?=url($row->singer)?>/<?=url($row->song)?>"><?=$row->song?></a></div>
<p><?=$row->hits?></p>
<div class="clear"></div>
</div>
<?}?>
</div>
