MATCH (c:concept)-[r:prefLabel]-(l:label)
RETURN count(r);

MATCH (n:concept)-[*5]->(m)
WHERE n.lod_url = "http://eurovoc.europa.eu/dummy_id"
RETURN count(m);

MATCH (n:concept)-[*5]->(m)
WHERE n.lod_url = "http://eurovoc.europa.eu/5522"
RETURN count(m);

MATCH (n:concept)-[*5]->(m)
WHERE n.lod_url = "http://plwordnet.pwr.wroc.pl/wordnet/synset/295622"
RETURN count(m);

MATCH (n:concept)--(l:label {lang:"en"})
WHERE l.text CONTAINS 'car'
RETURN n, l

MATCH (l1:label {lang:"en"})--(n1:concept)-[:broader|:narrower]-(n2:concept)--(l2:label {lang:"en"})
WHERE l1.text CONTAINS l2.text
RETURN n1, l1, n2, l2

MATCH (l_pl:label {lang:"pl"})--(n:concept)--(l_en:label {lang:"en"})
WHERE l_pl.text = l_en.text
RETURN n, l_pl, l_en;

MATCH (c1:concept)-[:prefLabel|:altLabel]-(l:label)-[:prefLabel|:altLabel]-(c2:concept)
MATCH (c1)-[r*1..2]-(c2)
RETURN count(r);

MATCH (c1:concept)-[:prefLabel|:altLabel]-(l:label)-[:prefLabel|:altLabel]-(c2:concept)
WITH c1, c2 (c1)-[r*1..2]-(c2)
RETURN count(r);

MATCH (credit:concept {lod_url:"http://eurovoc.europa.eu/289"}), (bureau_of_consumers:concept {lod_url:"http://eurovoc.europa.eu/4859"})
RETURN shortestPath((credit)-[*..5]->(bureau_of_consumers));

MATCH (dog:concept {lod_url:"http://plwordnet.pwr.wroc.pl/wordnet/synset/295622"}), (bone:concept {lod_url:"http://plwordnet.pwr.wroc.pl/wordnet/synset/6476"})
RETURN shortestPath((dog)-[*..5]->(bone));

MATCH (c:concept)-[r:prefLabel]-(l:label {lang:"en"})
RETURN l.text
ORDER BY l.text
LIMIT 50;

RETURN LENGTH(prefLabel)

let startNodeId = FIRST(FOR c in concept
  FILTER c.lod_url == "http://eurovoc.europa.eu/5522"
  LIMIT 1
  RETURN c._id)

FOR v, e, p in 1..5 OUTBOUND startNodeId
  broader, related, prefLabel, altLabel, definition,
  editorialNote, inScheme, topConceptOf, scopeNote
  COLLECT WITH COUNT INTO ctx_size
  RETURN ctx_size

FOR l in label
  FILTER l.lang == "en"
  FILTER CONTAINS(l.text, "car")
  FOR v, e in INBOUND l._id
    prefLabel, altLabel
    RETURN {
        lod_url: v.lod_url,
        text: l.text
    }

FOR l1 in label
  FILTER l1.lang == "en"
  FOR l2 in label
    FILTER l2.lang == "en"
    FILTER CONTAINS(l1.text, l2.text)
  FOR v1, e1 in OUTBOUND l1._id
    prefLabel, altLabel
    FOR v2, e2 in OUTBOUND l2._id
      prefLabel, altLabel
      FOR v3, e3 in OUTBOUND v1._id
      broader
      FILTER e3._from == v1._id AND e3._to == v2._id
RETURN {
    text1: l1.text,
    lod_url1: v1.lod_url,
    lod_url2: v2.lod_url,
    text2: l2.text
}

LET en_labels = (FOR l in label
  FILTER l.lang == "en"
  RETURN l)

LET substr_labels = (
  FOR l1 IN en_labels
    FOR l2 IN en_labels
      FILTER CONTAINS(l1.text, l2.text)
      RETURN {
        "longer": l1,
        "shorter": l2
      }
)

FOR lbls in substr_labels
  FOR v1, e1 in OUTBOUND lbls.longer._id
    prefLabel, altLabel
    FOR v2, e2 in OUTBOUND lbls.shorter._id
      prefLabel, altLabel
      FOR v3, e3 in OUTBOUND v1._id
      broader
      FILTER e3._from == v1._id AND e3._to == v2._id
RETURN {
    text1: lbls.longer.text,
    lod_url1: v1.lod_url,
    lod_url2: v2.lod_url,
    text2: lbls.shorter.text
}

LET en_labels = (FOR l1 in label
  FILTER l1.lang == "en"
  RETURN l1.text)

LET pl_labels = (FOR l2 in label
  FILTER l2.lang == "pl"
  RETURN l2.text)

LET eq_labels = (INTERSECTION(pl_labels, en_labels))

FOR l in label
  FILTER POSITION(eq_labels, l.text)
  FOR v, e in 1..1 INBOUND l._id
  prefLabel, altLabel
  RETURN {
    text: l.text,
    lod_url: v.lod_url
  }

FOR l in label
  FILTER l.lang == "en"
  FOR v, e in INBOUND l._id
    prefLabel
    SORT l.text
    LIMIT 50
    RETURN {
        text: l.text
    }

let creditId = FIRST(FOR c in concept
  FILTER c.lod_url == "http://eurovoc.europa.eu/289"
  LIMIT 1
  RETURN c._id)

let bureauOfConsumersId = FIRST(FOR c in concept
  FILTER c.lod_url == "http://eurovoc.europa.eu/4859"
  LIMIT 1
  RETURN c._id)

FOR v, e
  IN OUTBOUND SHORTEST_PATH
  creditId TO bureauOfConsumersId
  broader, related, prefLabel, altLabel, definition,
  editorialNote, inScheme, topConceptOf, scopeNote
  return e