@de17 /opt/spocq/query-statistics # fgrep -i select query-statistics.csv | sed -e 's/^\([^,]*\),.*/\1/' | while read dir; do fgrep $dir query-statistics.csv; echo; ls */$dir/*.rq | while read rq; do echo $rq; cat $rq; echo; done; echo;  done
2a79f0e99855742de86b5d17b167964455bef2b3,4,3,"bgp select triple","EXISTS { SELECT ?var1 WHERE { ?var1 <http://example.org/anon/iri1> ?var2 } }"

2a/2a79f0e99855742de86b5d17b167964455bef2b3/06fee1a1f80b81e2016277ce83dbeb99a54ec347.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q6256> .
  ?var1  <http://www.w3.org/2000/01/rdf-schema#label>  ?var1Label .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "germ" )  ) 
) .
 FILTER (  ( (  LANG (  ?var1Label  )  =  "en" ) ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P27>  ?var1 .
  }
 }
 ) 
) .
}
LIMIT 10

2a/2a79f0e99855742de86b5d17b167964455bef2b3/4a33a98f4f9b55c7a7422307946866f5174b99d4.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.w3.org/2000/01/rdf-schema#label>  ?var1Label .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "president" )  ) 
) .
 FILTER (  ( (  LANG (  ?var1Label  )  =  "en" ) ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P106>  ?var1 .
  }
 }
 ) 
) .
}
LIMIT 10

2a/2a79f0e99855742de86b5d17b167964455bef2b3/77c0193053c8a3c1e58fc9be4c7f5eb18b969245.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
  ?var1  <http://www.w3.org/2000/01/rdf-schema#label>  ?var1Label .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "bill g" )  ) 
) .
 FILTER (  ( (  LANG (  ?var1Label  )  =  "en" ) ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P26>  ?var1 .
  }
 }
 ) 
) .
}
LIMIT 10

2a/2a79f0e99855742de86b5d17b167964455bef2b3/f181549463944fa84794da0699a9ea2546377fbf.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.w3.org/2000/01/rdf-schema#label>  ?var1Label .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "germ" )  ) 
) .
 FILTER (  ( (  LANG (  ?var1Label  )  =  "en" ) ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P27>  ?var1 .
  }
 }
 ) 
) .
}
LIMIT 10


3a4b5a243b52f603484db3616234ceed9d6bb349,2,8,"bgp join select service triple","EXISTS { SELECT ?var1\n          WHERE { SERVICE <http://example.org/anon/iri1>\n                           { ?var1 <http://example.org/anon/iri2> ?var2 .\n                             <http://example.org/anon/iri3> <http://example.org/anon/iri4> 'LITERAL1' .\n                             <http://example.org/anon/iri3> <http://example.org/anon/iri5> 'LITERAL2' }} }"

3a/3a4b5a243b52f603484db3616234ceed9d6bb349/60ab841fb27f5d5c0c19d5abdd4e52a28ea3c3b6.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q23442> .
 FILTER (  (  NOT EXISTS  {
  {
   SELECT ?var1 
   WHERE    {
    SERVICE  <http://wikiba.se/ontology#box>      {
       ?var1  <http://www.wikidata.org/prop/direct/P625>  ?var2 .
       <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#cornerWest>  "string1"^^<http://www.opengis.net/ont/geosparql#wktLiteral> .
       <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#cornerEast>  "string2"^^<http://www.opengis.net/ont/geosparql#wktLiteral> .
     }
   }
  }
 }
 ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "id".
  }
}

3a/3a4b5a243b52f603484db3616234ceed9d6bb349/ffe258d0fddf8da1a300b7a357ffdeba91da3d16.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q23442> .
  ?var1  <http://www.wikidata.org/prop/direct/P17>  <http://www.wikidata.org/entity/Q252> .
 FILTER (  (  NOT EXISTS  {
  {
   SELECT ?var1 
   WHERE    {
    SERVICE  <http://wikiba.se/ontology#box>      {
       ?var1  <http://www.wikidata.org/prop/direct/P625>  ?var2 .
       <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#cornerWest>  "string1"^^<http://www.opengis.net/ont/geosparql#wktLiteral> .
       <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#cornerEast>  "string2"^^<http://www.opengis.net/ont/geosparql#wktLiteral> .
     }
   }
  }
 }
 ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "id".
  }
}


7d0e5294d5318bd319db196c60649bfe0e4b24c2,1,13,"bgp join select service triple","EXISTS { SELECT ?var1\n          WHERE { { SERVICE <http://example.org/anon/iri1>\n                             { ?var1 <http://example.org/anon/iri2> ?var2 .\n                               <http://example.org/anon/iri3> <http://example.org/anon/iri4> 'LITERAL1' .\n                               <http://example.org/anon/iri3> <http://example.org/anon/iri5> 'LITERAL2' }\n                    { ?var1 <http://example.org/anon/iri7> <http://example.org/anon/iri8> .\n                      ?var1 <http://example.org/anon/iri9> <http://example.org/anon/iri10> } }} }"

7d/7d0e5294d5318bd319db196c60649bfe0e4b24c2/766ec0ec2ea9214ce1af51bce7695dbff3d7eff7.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q23442> .
  ?var1  <http://www.wikidata.org/prop/direct/P17>  <http://www.wikidata.org/entity/Q252> .
 FILTER (  (  NOT EXISTS  {
  {
   SELECT ?var1 
   WHERE    {
     ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q23442> .
     ?var1  <http://www.wikidata.org/prop/direct/P17>  <http://www.wikidata.org/entity/Q252> .
    SERVICE  <http://wikiba.se/ontology#box>      {
       ?var1  <http://www.wikidata.org/prop/direct/P625>  ?var2 .
       <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#cornerWest>  "string1"^^<http://www.opengis.net/ont/geosparql#wktLiteral> .
       <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#cornerEast>  "string2"^^<http://www.opengis.net/ont/geosparql#wktLiteral> .
     }
   }
  }
 }
 ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "id".
  }
}


b4cddc441a8c96875f16fdaf7d883e56148e27ed,11,5,"bgp join select triple","EXISTS { SELECT ?var1\n          WHERE { ?var1 <http://example.org/anon/iri1> <http://example.org/anon/iri2> .\n                  ?var1 <http://example.org/anon/iri3> ?var2 } }"

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/02e8be13bf06e26faa030562f419561e90678d1d.rq
SELECT ?var1  ?var1Label 
WHERE {
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/0f333919eb2da4c706c45b8b5a457d9c5a52d184.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
  ?var1  <http://www.w3.org/2000/01/rdf-schema#label>  ?var1Label .
 FILTER (  (  STRSTARTS (  ?var1Label , "Master" )  ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/13a13a8713ac2983734700b538a172f381ad5f66.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "Master" )  ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/13fadd2ea33002c922abaaa8cbac362f288ede72.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/17729d2315032c3c1d1cfc84f32f1c4e4b2b15e4.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "master" )  ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/2fe3e00889b9ea736daa5da8a251ea154bf4f52c.rq
SELECT ?var1  ?var1Label 
WHERE {
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en,en".
  }
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/51bd8f0acb3e5d55b3bfcdfcaa427b1a78a7330c.rq
SELECT ?var1  ?var1Label 
WHERE {
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "master" )  ) 
) .
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/927c2c42bfe6116e2130f7b240af7cd669e39725.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
  ?var1  <http://www.w3.org/2000/01/rdf-schema#label>  ?var1Label .
 FILTER (  (  STRSTARTS (  ?var1Label , "Master" )  ) 
) .
 FILTER (  ( (  LANG (  ?var1Label  )  =  "en" ) ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/99cb39fd79181de16f5e72a197d9067797861175.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 FILTER (  (  STRSTARTS (  ?var1Label , "Master" )  ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/a24ed00072b480ae0088fae1d8073d179bfee8dd.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
  ?var1  <http://www.w3.org/2000/01/rdf-schema#label>  ?var1Label .
 FILTER (  (  STRSTARTS (  ?var1Label , "Master" )  ) 
) .
 FILTER (  ( (  LANG (  ?var2Label  )  =  "en" ) ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
}
ORDER BY ASC( ?var1 )

b4/b4cddc441a8c96875f16fdaf7d883e56148e27ed/f8ec14370e12a0a6d2bfcf78c00561d290dcb0b4.rq
SELECT ?var1  ?var1Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q189533> .
 FILTER (  (  STRSTARTS (  LCASE (  ?var1Label  ) , "master" )  ) 
) .
 FILTER (  (  EXISTS  {
  SELECT ?var2 
  WHERE   {
    ?var2  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
    ?var2  <http://www.wikidata.org/prop/direct/P512>  ?var1 .
  }
 }
 ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
ORDER BY ASC( ?var1 )


cf00610ed40c4bf48e0e0d9d7aedb6cd354926e3,1,9,"bgp join select triple","EXISTS { SELECT ?var2\n          WHERE { <http://example.org/anon/iri1> <http://example.org/anon/iri2> ?var1 .\n                  ?var1 <http://example.org/anon/iri3> ?var2 .\n                  ?var1 <http://example.org/anon/iri4> <http://example.org/anon/iri5> .\n                  ?var1 <http://example.org/anon/iri6> <http://example.org/anon/iri7> } }"

cf/cf00610ed40c4bf48e0e0d9d7aedb6cd354926e3/38107f462d952707916d7cc5f8da46bb896264b2.rq
SELECT ?var1  ?var1Label  ?var2  ?var3  ?var3Label 
WHERE {
  ?var1  <http://www.wikidata.org/prop/direct/P650>  ?var3 .
 FILTER (  (  NOT EXISTS  {
   ?var1  <http://www.wikidata.org/prop/direct/P21>  [] .
 }
 ) 
) .
 FILTER (  (  NOT EXISTS  {
   ?var1  <http://www.wikidata.org/prop/direct/P31>  <http://www.wikidata.org/entity/Q5> .
 }
 ) 
) .
 FILTER (  (  NOT EXISTS  {
  SELECT ?var1 
  WHERE   {
    <http://www.wikidata.org/entity/P650>  <http://www.wikidata.org/prop/P2302>  ?var4 .
    ?var4  <http://www.wikidata.org/prop/statement/P2302>  <http://www.wikidata.org/entity/Q21503247> .
    ?var4  <http://www.wikidata.org/prop/qualifier/P2306>  <http://www.wikidata.org/entity/P21> .
    ?var4  <http://www.wikidata.org/prop/qualifier/P2303>  ?var1 .
  }
 }
 ) 
) .
 SERVICE  <http://wikiba.se/ontology#label>   {
    <http://www.bigdata.com/rdf#serviceParam>  <http://wikiba.se/ontology#language>  "en".
  }
}
LIMIT 1000


root@de17 /opt/spocq/query-statistics #