Учебные видеоматериалы по металлургии
$sql = "SELECT term_data.name,term_data.tid,COUNT(term_data.tid) AS total FROM term_node JOIN term_data ON term_node.tid=term_data.tid JOIN node ON node.nid=term_node.nid WHERE node.type='video' AND term_data.vid='2' GROUP BY term_data.tid";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
echo "";
}