diff -r dc6c3ac62efa -r fdf808d7d374 hdalab/taginfo.php --- a/hdalab/taginfo.php Thu Feb 02 12:03:07 2012 +0100 +++ b/hdalab/taginfo.php Mon Feb 06 18:50:19 2012 +0100 @@ -20,7 +20,7 @@ pg_free_result($rq); -$sql = "SELECT COUNT(DISTINCT datasheet_id) FROM hdabo_taggedsheet WHERE tag_id IN (" . join(",", $ids) . ")"; +$sql = "SELECT COUNT(DISTINCT datasheet_id) FROM hdabo_taggedsheet V WHERE tag_id IN (" . join(",", $ids) . ") AND EXISTS (SELECT * FROM hdabo_datasheet W WHERE V.datasheet_id = W.id AND W.validated=TRUE)"; $rq = pg_query($sql); @@ -38,7 +38,7 @@ } pg_free_result($rq); - +/* if (isset($resobj["dbpedia_uri"]) and $resobj["dbpedia_uri"]) { $uri = $resobj["dbpedia_uri"]; $sql = "SELECT abstract, label, thumbnail FROM dbpedia_fields WHERE dbpedia_uri = '$uri'"; @@ -51,7 +51,7 @@ pg_free_result($rq); } - +*/ $sql = "SELECT * FROM hdaviz_simple_tag_links WHERE subject ILIKE '$label' OR object ILIKE '$label'"; $rq = pg_query($sql);