--- 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);