$q = "Select scenario.id id,count(player_was) a,publisher_name, scenario.title from playings,scenario,pubs,publishers where pubs.id=scenario.pub_id and playings.sc_id=scenario.id and pubs.publish_id=publishers.publisher_id and duplicate=0 group by scenario.id order by a desc limit 50";
$result=mysql_query($q,$conn) or die("Failed Query");
echo('

");
$q = "Select distinct scenario.id id,publisher_name, scenario.title,total_playings a from roardata,scenario,pubs,publishers where archive_sc_id=scenario.id and pubs.id=scenario.pub_id and pubs.publish_id=publishers.publisher_id group by scenario.title order by a desc limit 50";
$result=mysql_query($q,$conn) or die("Failed Query");
/* echo('