Symfony Profiler

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/vinskiklub/routes/hr/interaktivna-karta'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/routes/hr/interaktivna-karta') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND identifier IN (?)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('cf57bd95-08b7-4a0a-b2b9-6db7e619a715');

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/vinskiklub/contents'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/hrvatska-istra-i-kvarner' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/dalmacija') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/hrvatska-istra-i-kvarner', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/dalmacija') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/trs' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/ilocki-podrumi') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/trs', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/ilocki-podrumi') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/trs/riesling-2021' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/trs/blaufrankisch-2020') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/trs/riesling-2021', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/trs/blaufrankisch-2020') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/ilocki-podrumi/traminac-izborna-berba-bobica-2018') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-srijem/ilocki-podrumi/traminac-izborna-berba-bobica-2018') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/k55') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/k55') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/j-rose-pinot-noir-grand-selection' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/grasevina-tradition-grand-selection-2021' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/chardonnay-sur-lie-grand-selection-2017' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/cab-franc-grand-selection-2020') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/j-rose-pinot-noir-grand-selection', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/grasevina-tradition-grand-selection-2021', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/chardonnay-sur-lie-grand-selection-2017', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/antunovic/cab-franc-grand-selection-2020') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/k55/grasevina-antique-premium-2023') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-erdut/k55/grasevina-antique-premium-2023') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/zlatno-brdo' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/belje') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/zlatno-brdo', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/belje') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/zlatno-brdo/cabernet-sauvignon-prestige-2017') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/zlatno-brdo/cabernet-sauvignon-prestige-2017') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/belje/grasevina-goldberg-2023') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/hrvatsko-podunavlje/vinogorje-baranja/belje/grasevina-goldberg-2023') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-dakovo' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-slavonski-brod' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-nova-gradiska' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-pozega-pleternica' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-daruvar' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-pakrac' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-fericanci' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-orahovica-slatina' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-virovitica') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-dakovo', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-slavonski-brod', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-nova-gradiska', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-pozega-pleternica', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-daruvar', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-pakrac', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-fericanci', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-orahovica-slatina', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-virovitica') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-slavonski-brod/jakob') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-slavonski-brod/jakob') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-slavonski-brod/jakob/cuvee-red-2019') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-slavonski-brod/jakob/cuvee-red-2019') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/enjingi' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/sontacchi') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/enjingi', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/sontacchi') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic/code-black-639-brut-nature' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic/code-white-396' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic/rose-2024') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic/code-black-639-brut-nature', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic/code-white-396', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/galic/rose-2024') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo/rose-premium-2024' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo/grasevina-vinkomir-2024' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo/grasevina-ledena-berba-2018') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo/rose-premium-2024', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo/grasevina-vinkomir-2024', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/kutjevo/grasevina-ledena-berba-2018') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/enjingi/venje-bijelo-2015') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/enjingi/venje-bijelo-2015') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/grasevina-mitrovac-2024' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/merlot-selekcija-2019' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/nebbiolo-2020' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/grasevina-izborna-berba-prosusenih-bobica-2019' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/zelenac-izborna-berba-prosusenih-bobica-2018') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/grasevina-mitrovac-2024', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/merlot-selekcija-2019', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/nebbiolo-2020', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/grasevina-izborna-berba-prosusenih-bobica-2019', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/krauthaker/zelenac-izborna-berba-prosusenih-bobica-2018') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/sontacchi/grasevina-superslav-2022' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/sontacchi/cabernet-franc-2022') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/sontacchi/grasevina-superslav-2022', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/slavonija-i-hrvatsko-podunavlje/slavonija/vinogorje-kutjevo/sontacchi/cabernet-franc-2022') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/prigorje-bilogora' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/zagorje-medimurje' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/plesivica' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/pokuplje') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/prigorje-bilogora', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/zagorje-medimurje', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/plesivica', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/pokuplje') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-cazma') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-cazma') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/kosutic' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/klet-romic' OR path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/glavica') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/kosutic', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/klet-romic', '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/glavica') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/kosutic/skrlet-2024') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/kosutic/skrlet-2024') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/vinskiklub/contents/interaktivna-karta/hrvatska/sredisnja-bregovita-hrvatska/moslavina/vinogorje-voloder-ivanic-grad/klet-romic/dragonada-2023') ORDER BY sort_order ASC;