From d056a2f44cfe0ba1c517221fa87e965583188c6c Mon Sep 17 00:00:00 2001 From: Stefano Zacchiroli Date: Tue, 9 Nov 2004 08:14:20 +0000 Subject: [PATCH] formatted --- helm/metadata/sql/fill_inconcl_aux.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/helm/metadata/sql/fill_inconcl_aux.sql b/helm/metadata/sql/fill_inconcl_aux.sql index 55c388462..2e7140e18 100644 --- a/helm/metadata/sql/fill_inconcl_aux.sql +++ b/helm/metadata/sql/fill_inconcl_aux.sql @@ -1,3 +1,9 @@ +INSERT INTO no_inconcl_aux +SELECT source, COUNT(h_occurrence) +FROM refObj +WHERE + h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#InConclusion' + OR h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#MainConclusion' +GROUP BY source; - insert into no_inconcl_aux select source,count(h_occurrence) from refObj where h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#InConclusion' or h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#MainConclusion' group by source; -- 2.39.2