hdalab/taginfo.php
changeset 118 fdf808d7d374
parent 109 3371a40449c7
child 120 47c904f50da0
--- 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);