![](/pics/flags/".$countrycode.".png "\".$country.\"") | ";
print "".round($count/$total*100,2)."% | ";
$subcommand="SELECT AV.ACTOR AS ID, A.FIRST_NAME AS FIRST_NAME, A.LAST_NAME AS LAST_NAME, A.SUFFIX AS SUFFIX, AVG(SCALE) AS A, COUNT(*) AS C FROM `ACTORS_VOGUE` AV, ACTORS AA, ACTORS A, COUNTRIES C WHERE A.ID=AA.ID AND C.NAME=AV.COUNTRY AND C.CODE='".$countrycode."' AND AV.ACTOR=AA.ID AND YEAR(AV.DATE)=".$year." GROUP BY AV.ACTOR ORDER BY C DESC, A DESC LIMIT 1";
$subquery=mysqli_query($link,$subcommand);
while ($subrow = $subquery->fetch_assoc()) {
$id=$subrow['ID'];
$name=trim($subrow['FIRST_NAME']." ".$subrow['LAST_NAME']." ".$subrow['SUFFIX']);
print "".$name." | ";
}
$subcommand="SELECT COUNT(*) AS C, V.CITY AS CITY, V.STATE AS STATE FROM ACTORS_VOGUE V, COUNTRIES C WHERE C.NAME=V.COUNTRY AND C.CODE='".$countrycode."' AND YEAR(V.DATE)=".$year." GROUP BY V.CITY, V.STATE ORDER BY C DESC LIMIT ".$limit;
$subquery=mysqli_query($link,$subcommand);
print "";
$subcount=0;
while ($subrow = $subquery->fetch_assoc()) {
$subcount=$subrow['C'];
$city=$subrow['CITY'];
$state=$subrow['STATE'];
$location="";
if ($city!="") $location=$city.", ";
if ($state!="") $location.=$state; else $location.="Unknown";
print "- ".$location.": ".round($subcount/$count*100,0)."%
";
}
print " | ";
print "
";
}
print "