<?php
require_once('../user.php');
require_once('../common.php');

header("Content-type: text/html");

mysql_select_db('imagenet') or die('Could not select database');
# $query = sprintf("select distinct synsetoffset, words from bbox_internal_release b join view_synset using(synsetid)");
$query = sprintf("select distinct targetsynsetid, synsetoffset, words from (select targetsynsetid, count(*) as nready, synsetoffset, words from bbox_internal_release b join view_synset using(synsetid) group by targetsynsetid) as a where a.nready>25;");
$result = mysql_query($query) or die();
while($row= mysql_fetch_assoc($result)) {
    $synsetoffset = $row['synsetoffset'];
    $words = $row['words'];
    echo "<a href=\"../../api/download/imagenet.bbox.synset?wnid=n$synsetoffset\">$words</a><br/>\n";
}
?>
