Symfony Profiler

SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC

[
  "defaultSiteConfig"
  null
  null
]

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'defaultSiteConfig'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT * FROM website_settings WHERE id = ?

[
  1
]

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT name FROM classes WHERE id = ?

[
  "SiteConfig"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC

[
  "mainBlogPortal"
  null
  null
]

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'mainBlogPortal'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT * FROM website_settings WHERE id = ?

[
  8
]

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 8;

SELECT name FROM classes WHERE id = ?

[
  "BlogPortal"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'BlogPortal';

SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC

[
  "sourcePath" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
  "sourcePathQuery" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1580519&nearbySearchLat=47.41586&nearbySearchLong=13.6755&sorting=nearbySearchAsc&page=3&randSeed=939"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1580519&nearbySearchLat=47.41586&nearbySearchLong=13.6755&page=3&randSeed=939&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite = '6'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1580519&nearbySearchLat=47.41586&nearbySearchLong=13.6755&sorting=nearbySearchAsc&page=3&randSeed=939' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1580519&nearbySearchLat=47.41586&nearbySearchLong=13.6755&page=3&randSeed=939&sorting=nearbySearchAsc' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "reports"
  "scope" => "pimcore"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Accommodations"
  "path" => "/steiermark.com/en/Schladming-Dachstein/Vacation-planning/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';

SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC

[]

SELECT
  id
FROM
  sites
ORDER BY
  (
    SELECT
      LENGTH(path)
    FROM
      documents
    WHERE
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC ;

SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1

[]

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT name FROM classes WHERE id = ?

[
  "21"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '21';

SELECT * FROM documents_editables WHERE documentId = ?

[
  7930
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7930;

SELECT * FROM documents_editables WHERE documentId = ?

[
  7159
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7159;

SELECT name FROM classes WHERE id = ?

[
  "31"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '31';

SELECT name FROM classes WHERE id = ?

[
  "59"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '59';

select o_id,contentScore,priority,bookable  from object_8 where o_published = 1

[]

select
  o_id,
  contentScore,
  priority,
  bookable
from
  object_8
where
  o_published = 1

select o_id,contentScore,priority,bookable  from object_8 where o_published = 1;

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  11189
]

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11189 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

SELECT name FROM classes WHERE id = ?

[
  "72"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '72';

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  11408
]

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11408 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL

[]

select
  o_id as id,
  position__longitude as lon,
  position__latitude as lat
from
  object_8
WHERE
  position__longitude IS NOT NULL
  AND position__latitude IS NOT NULL

select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL;

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT * FROM translations_messages LIMIT 1;

[]

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT name FROM classes WHERE id = ?

[
  "Region"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'Region';

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT sourceId FROM documents_translations WHERE id = ?

[
  7930
]

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 7930;

SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?

[
  7159
  7930
  7930
]

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId IN(?, ?)
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId IN(7159, 7930) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;

SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?

[
  7930
  7930
]

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId = ?
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId = 7930 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;

SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?

[
  7159
  7159
]

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId = ?
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId = 7159 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Accommodations"
  "path" => "/en/Schladming-Dachstein/Vacation-planning/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Accommodations"
  "path" => "/en/Schladming-Dachstein/Vacation-planning/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Vacation-planning"
  "path" => "/en/Schladming-Dachstein/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/' AND `key` = BINARY 'Vacation-planning';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/en/Schladming-Dachstein/Vacation-planning"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Schladming-Dachstein/Vacation-planning';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Schladming-Dachstein"
  "path" => "/en/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/en/' AND `key` = BINARY 'Schladming-Dachstein';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Schladming-Dachstein"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/en/Schladming-Dachstein"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Schladming-Dachstein';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "en"
  "path" => "/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'en';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/en"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  ""
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => ""
  "path" => "/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY '';

SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT id FROM settings_store WHERE scope = ?

[
  "pimcore_staticroutes"
]

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "1"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '1' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "2"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '2' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "3"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '3' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "4"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '4' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "5"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '5' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "6"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '6' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "7"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '7' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "8"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '8' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "9"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '9' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "10"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '10' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "11"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '11' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "12"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '12' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "13"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '13' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "15"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '15' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "16"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '16' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "17"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '17' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "18"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '18' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "19"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '19' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "20"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '20' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "21"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '21' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "22"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '22' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "23"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '23' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "24"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '24' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "25"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '25' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "26"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '26' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "27"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '27' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "28"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '28' AND scope = 'pimcore_staticroutes';

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid

[
  "cid" => 1524019
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1524019;

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT name FROM classes WHERE id = ?

[
  "AlpsteinTour"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'AlpsteinTour';

SELECT name FROM classes WHERE id = ?

[
  "8"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '8';

SELECT name FROM classes WHERE id = ?

[
  "18"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '18';

SELECT name FROM classes WHERE id = ?

[
  "20"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '20';

SELECT name FROM classes WHERE id = ?

[
  "51"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '51';

SELECT name FROM classes WHERE id = ?

[
  "30"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '30';

SELECT name FROM classes WHERE id = ?

[
  "68"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '68';

SELECT * FROM documents_editables WHERE documentId = ?

[
  16088
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 16088;

SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC

[
  5882755
  "datepickerInfoTexts"
]

SELECT
  *
FROM
  object_collection_demiDatePickerInfoText_21
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;

SELECT * FROM documents_editables WHERE documentId = ?

[
  7924
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7924;

SELECT * FROM documents_editables WHERE documentId = ?

[
  6887
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 6887;

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "footer-logo"
  "scope" => "pimcore_image_thumbnails"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'footer-logo' AND scope = 'pimcore_image_thumbnails';

SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid

[
  "cid" => 3189171
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3189171;

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.o_published = 1  AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(939)

[]

SELECT
  dacco.isTop,
  dacco.bookable,
  dacco.oo_id oo_id
FROM
  `steiermark`.object_8 dacco
WHERE
  dacco.o_published = 1
  AND (
    dacco.town__id IN (
      11195, 11196, 11191, 11194, 11190, 3192509,
      11197, 11409
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(939)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.o_published = 1  AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(939) ;

SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights
              FROM    `steiermark_vacancies`.price_template pt
                   INNER JOIN
                      `steiermark_vacancies`.price_template_base_prices bp
                   ON bp.price_template_id = pt.id
             WHERE     pt.acco_id IN (219299,27808352,10655859,7599407,93789,97982,160345,213843,46237639,228314,131790,245591,90791,175232,247088,229314,121533,257470,113462,268827,211256,147915,197379,46236871,108105,149642,204745,75482,253939,252258,210751,73556,160203,218293,110254,12253627,4442181,178215,267501,193837,204204,174544,171978,213132,170725,114041,241513,131135,222898,254301,254825,82308,203308,181884,191516,266341,186259,259974,122718,180387,242703,208283,225007,100207,50388225,43581664,205724,145352,165005,227558,144028,192497,43751656,266814,183391,181441,74473,383578,241752,263121,138273,193721,28138429,74030,122838,102976,260387,98451,255957,199572,262579,180136,192804,195386,2367452,257550,104153,4791488,33664677,241967,81720,177510,212729,220755,136496,109234,77069,141562,34636746,72285,192033,22568743,259830,72528,212320,213925,77403,182482,161664,245836,138437,27808188,261158,205753,147399,382988,146288,8591193,142776,161875,108551,7186183,149216,242964,113626,22892603,89261,187883,200772,109374,249148,154608,39599857,175319,156882,261338,72244,115416,159639,151492,156556,212470,268279,111651,198498,225195,96059,44224029,117486,113160,245508,204776,88772,162891,382743,204973,51503593,119873,141037,7599993,157109,251865,150874,240646,98143,86366,144517,105369,163153,91812,80509,178500,250387,188163,383494,211155,79763,227604,139671,196032,186088,228246,84906,4791491,203901,141272,224773,202554,105154,243839,141729,181045,90162,242085,140833,105748,262167,218521,173880,9129444,115604,95383,172344,80345,13979961,139875,88601,125055,145685,218149,176007,260577,136555,145003,97682,148562,135403,121033,262617,259576,34219679,208831,85349,384128,265066,190546,147033,42105593,35700277,180717,228789,265930,244217,198994,4442214,145409,72611,80548,179201,33267404,111233,129814,185864,133247,384186,21273299,124337,21308116,192284,31514436,26970115,208932,139042,227765,116102,171964,156918,267530,220238,103317,263626,108780,162969,135685,105395,212929,131179,249413,191455,176897,6614248,163837,126658,168744,41634802,241209,122810,157283,75853,164711,221512,264308,202332,190210,23106697,104513,143537,73689,201732,162100,118332,241089,3379737,214160,210887,227134,165965,181278,124237,203577,143950,194713,191047,234239,111742,266549,125661,15659243,250696,267023,203131,4061468,94129,115223,247967,160614,81217,139070,180504,256266,1173353,143448,82805,20512295,1173158,89972,418173,197713,383118,80940,141808,226395,250829,240534,107555,150070,97583,383672,176727,27486615,7678621,217376,219645,10039806,266112,174987,1173491,268162,268951,185065,245926,164042,124869,250318,226977,98121,192391,181736,169035,208109,160168,78111,166413,75414,180007,1173124,124606,87899,150197,203394,171116,189617,47202201,108989,9282725,176975,3118747,214424,128888,257732,243765,218423,150752,158731,191210,243999,246756,252859,127946,205363,174941,98352,13723644,205800,246469,241670,127993,189226,201789,190874,75643,118392,91679,166027,101167,242072,228572,179118,103499,79701,14669428,13377190,116231,265826,135205,101969,190634,120314,128992,171662,225305,195136,51216654,20708505,186138,7941416,210612,111071,243209,98382,210768,117877,259918,268917,110779,223960,194307,188242,122139,81316,194797,44869050,79343,122780,77798,206964,149155,244956,269773,170268,180460,145614,103051,12371222,199295,48897791,144112,164627,106287,91582,89745,38723937,268989,178962,200283,226215,217510,78233,228288,176678,229645,262376,35522295,147152,3176489,27807955,110842,143596,87219,144248,223355,249733,209807,209589,141472,11367104,74427,186795,383375,114017,197746,172278,160274,136036,102266,162948,49539249,114251,14623690,129206,6771981,383139,90455,1173161,82521,95945,157428,211808,114505,85117,5957896,202690,47294199,87124,155356,254574,190401,151636,108520,124829,126983,267851,177157,22452518,186869,44404593,261005,174798,241333,125952,15050850,260943,267186,106347,128526,102558,268018,256504,135345,167765,190061,226049,209213,96544,170382,134210,83792,218867,203147,238918,101745,154821,175147,37366700,200435,142573,110677,170765,402843,170037,115353,211866,262206,207780,220948,111521,182314,202588,89073,231694,192306,150724,247473,156724,182441,244970,199934,227270,200126,251659,108881,94373,155228,182728,191937,113751,163958,32742951,221211,229470,203636,75190,154051,147531,209351,223652,206854,139824,263799,114320,383006,173474,132963,150639,39225141,168676,45539296,8388337,74880,101590,91777,134439,244042,196171,263716,221173,87409,74534,103833,101260,109827,134133,265584,175610,179171,129533,235840,31665450,144833,168470,262446,205629,183196,128612,220200,121463,111091,142256,212715,31215812,80793,153833,242919,139252,199742,218076,99548,132556,43349109,171085,176637,185045,5160340,219804,9700322,204827,146486,159735,254732,162820,128321,107672,229040,122527,13400949,162327,133887,4791485,145494,136181,198187,107594,157224,172317,187073,74091,130799,89349,266661,79494,165805,164198,226339,193693,87071,114734,4061656,222689,115902,9517217,178677,261823,111370,213537,31719532,260788,35241603,156225,198307,120627,248735,22840856,202479,102814,101229,261884,213283,111604,134714,94870,156762,87380,97332,190150,156310,161406,185888,266061,262061,155984,89565,172512,7599929,251064,158648,246836,115484,159064,91843,185795,245240,124718,122307,15668814,9395965,166529,173082,27199439,251478,265305,260291,114786,79424,183290,179813,103365,109501,204528,100623,85536,141995,212576,178072,133017,27076239,1173542,3379819,219501,267915,151257,87970,100682,155523,266691,240386,9700388,191266,74347,176244,41752708,110467,31419712,142948,384050,75600,239438,223733,246876,135125,11213840,113819,154873,141656,139146,134322,252035,169612,130324,228944,255713,80881,17594470,3379718,269473,102697,155492,268424,199975,252832,128052,76091,192120,160247,108195,23455826,31077769,84542,149059,223510,245352,224525,229397,108664,105477,183075,150701,17877742,115132,87314,218235,150268,1173892,72773,179680,83126,202800,1904411,2977929,239049,171549,189271,262837,129250,195314,163692,221136,166123,84306,96266,90325,76033,383286,225374,75898,75106,205199,384102,117802,80315,204342,195347,174680,179886,194960,89709,134094,224600,143736,147609,147869,157061,201863,151587,76900,181329,188200,186109,91299,195752,140059,197310,383021,138939,10261747,197565,101798,166611,88890,162257,115150,229144,199275,202896,5957902,251539,118621,210638,241860,164436,119097,89549,18332685,269445,130026,201425,241827,7541413,139730,90081,261585,170790,73318,108052,142897,107057,166311,180106,229095,116132,223466,181966,1173742,156120,171586,129031,200906,251348,97625,242786,147969,175902,176457,96500,209859,84693,261287,174181,157466,195558,95803,191155,383027,96112,197648,81094,189166,249659,261224,208378,7217358,244648,108003,90363,162361,6771978,37038521,212164,98441,190383,120883,83605,176111,124000,117438,26684056,142318,91149,145447,87467,210522,120959,111341,96924,129501,265878,214433,227190,1173254,212066,124113,98483,213063,187810,87340,164573,8566620,260733,171766,88291,192523,139974,5160343,179242,99678,207463,88121,143351,101403,154116,191428,144374,208674,81753,191407,103592,196249,182129,176992,47158244,164670,129897,186209,78857,244552,113085,384041,175690,260555,261090,207942,149400,222990,242815,170704,141880,221382,177333,268711,162146,7016779,193149,1173603,205493,122101,213047,142725,16306657,30148041,162656,202202,146703,128777,97423,77223,124694,111003,220483,192003,126485,209054,7967625,254246,168114,224446,148602,227732,112984,157359,127120,171431,139584,9700358,202099,101873,220348,209194,9872791,157401,130955,148975,247897,166076,255823,4061766,125397,180306,122580,101813,93903,201802,91180,8618578,263995,195225,222266,263240,173849,118447,220914,5315087,73645,98021,204855,144860,136066,135730,208516,110435,106770,113392,161033,109291,219686,38670305,92309,128141,218375,212394,209292,91383,173923,102868,146150,186921,30765443,107023,185698,104583,186176,204651,189797,96781,181569,142528,179735,174091,187911,382826,219765,142376,148376,213358,23945599,383497,143038,159538,41214843,160120,172217,18355899,247180,195022,140325,185961,161142,148079,26648317,207763,144062,242014,157541,245886,267580,135012,38050667,207573,187735,145258,73343,79610,267700,102508,191815,7715980,259743,74757,77676,91521,107333,164309,154226,221094,206198,178916,131774,253165,173602,23184951,86879,98639,170874,3411816,207109,132281,119029,220403,165025,269023,252403,209483,23106643,199700,3224895,189988,208902,135519,102372,267678,211759,132156,78602,21211748,87518,188297,185439,9290146,154758,1173653,81346,223395,75009,3224898,90830,9517247,222491,20059276,146397,78974,223285,117916,177852,37868209,194471,266243,199364,148779,269401,249871,222458,77600,14557855,269658,41024653,199850,193204,94738,91479,189598,177240,177391,144556,174338,1173693,149098,223447,196083,207430,106445,168884,119809,172618,148211,123820,195537,193028,194884,189874,107859,5315068,89456,78778,218032,156680,33072197,5957905,209445,211891,94404,27128134,211686,84734,151568,139196,146572,117646,223613,263186,17058949,261487,9700325,100061,192660,226499,88849,163235,227046,81984,228197,187408,150349,77134,20627345,219012,156053,225967,177255,174737,149455,148899,212020,18810400,265255,85437,26898515,193068,383360,6775934,132768,75680,146183,178599,4149175,190920,220693,99420,106657,135829,199831,90672,151225,268384,27808178,155681,130741,38621717,77357,176296,227481,245659,203729,1845849,99114,29311567,199099,169959,170491,22892606,95872,41680612,190819,4061616,84439,240156,162295,8870626,255905,146983,178337,92398,149700,80083,29649833,4442184,89886,154301,132606,37868894,188477,156617,263475,39558144,158481,2470567,18810410,135252,190504,96354,268304,97550,81527,206591,200595,136417,82604,138609,27808362,151031,49169351,138736,73395,250060,38008495,178544,158905,169525,36566491,213869,15243082,260687,9887645,91914,79030,104781,187460,79926,101549,253709,97116,92184,130267,155598,83429,2853495,176200,99228,221593,120483,266442,140362,198534,48897409,187530,201319,76562,132704,240120,86434,233730,130455,383826,74121,193372,146129,225114,260613,189123,194023,138331,145830,36278962,152590,140245,227572,199538,261943,222748,98180,197835,138703,383292,169666,177439,210439,195113,105761,83176,107364,21237158,114609,188894,265378,197250,219157,76116,103526,2566227,206894,240404,34037741,160845,266888,136526,189670,198380,22882595,7780777,182335,86746,185208,157521,143682,114455,175792,9700382,256037,118221,119718,265768,156464,169799,87856,194565,168651,227892,128254,204161,383256,165937,86586,95043,214015,224332,149007,242260,33072200,82419,146259,115545,171353,2655510,160801,85808,76427,188963,151300,245784,250174,130049,245060,84203,205897,179767,1173251,223333,73764,154180,198592,240971,264448,255495,88688,203882,228125,154459,23220930,81639,178433,27224568,170902,21161019,250658,225267,41796413,209921,87012,183531,228081,223044,4442187,220170,168086,210702,143260,120394,100524,105712,46904829,31789631,205836,171164,163032,106040,243956,100829,9290160,150008,174583,34719290,96619,135953,106889,218042,171224,20972969,187757,257803,173273,174035,119054,121638,8388408,110374,195918,3029831,218829,220655,109732,157149,212689,37667633,26244429,143785,4061962,73900,79212,8722785,263334,194917,17275737,128649,151676,131839,210718,173543,260508,267623,121323,115753,32979456,98309,1173121,206641,240436,200867,114925,42358761,227403,126702,147191,4580718,13818591,185598,264897,198814,186236,203485,220531,220877,220546,265965,158547,38300874,125739,246306,90285,167986,250245,203617,39355239,228856,5315084,94222,147221,208746,8722782,164234,103348,49539259,192842,131018,167903,4061779,4061851,8695139,202441,129096,256553,193518,213326,259359,193952,95652,6797421,244711,4061812,143202,134831,266360,77540,46461361,176068,265468,267314,256818,227647,187180,243243,248414,261973,74297,256865,170518,18323640,113408,84605,131085,221442,39995931,136200,256958,73135,255407,168606,139639,75959,110338,23185284,208002,38622028,147332,106094,257010,268647,125266,164128)
                  
                   AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo
                   AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id)
                   order by minPrice