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" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
  "sourcePathQuery" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=14979015&nearbySearchLat=47.45579&nearbySearchLong=13.81252&page=3&randSeed=251&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=14979015&nearbySearchLat=47.45579&nearbySearchLong=13.81252&page=3&randSeed=251&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 = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=14979015&nearbySearchLat=47.45579&nearbySearchLong=13.81252&page=3&randSeed=251&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=14979015&nearbySearchLat=47.45579&nearbySearchLong=13.81252&page=3&randSeed=251&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" => "Unterkuenfte"
  "path" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/"
]

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';

SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' 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 = ?

[
  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//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' 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 = ?

[
  7159
]

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 7159;

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

[
  7159
  7159
  7159
]

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, 7159) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;

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 FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Unterkuenfte"
  "path" => "/de/Schladming-Dachstein/Urlaub-planen/"
]

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

SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';

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

[
  "key" => "Unterkuenfte"
  "path" => "/de/Schladming-Dachstein/Urlaub-planen/"
]

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

SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';

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/%"
  "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]

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 = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';

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

[
  "key" => "Urlaub-planen"
  "path" => "/de/Schladming-Dachstein/"
]

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

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

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen';

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/%"
  "/de/Schladming-Dachstein/Urlaub-planen"
]

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 = '/de/Schladming-Dachstein/Urlaub-planen';

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

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

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

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

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/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/%"
  "/de/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 = '/de/Schladming-Dachstein';

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

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

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

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

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

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

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/%"
  "/de"
]

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 = '/de';

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 = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' 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 o_type,o_className,o_classId FROM objects WHERE o_id = ?

[
  154051
]

SELECT
  o_type,
  o_className,
  o_classId
FROM
  objects
WHERE
  o_id = ?

SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 154051;

SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?

[
  154051
]

SELECT
  objects.*,
  tree_locks.locked as o_locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.o_id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  o_id = ?

SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = 154051;

SELECT name FROM classes WHERE id = ?

[
  "8"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '8';

SELECT * FROM object_store_8 WHERE oo_id = ?

[
  154051
]

SELECT
  *
FROM
  object_store_8
WHERE
  oo_id = ?

SELECT * FROM object_store_8 WHERE oo_id = 154051;

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

[
  154051
  "facilities"
]

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

SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = 154051 AND fieldname = 'facilities' ORDER BY `index` ASC;

SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?

[
  154051
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiAccessibilityCategories_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = 154051 AND fieldname = 'demiExtension';

SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?

[
  154051
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiEnrichAcco_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = 154051 AND fieldname = 'demiExtension';

SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?

[
  154051
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiCanonicalRegion_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = 154051 AND fieldname = 'demiExtension';

SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?

[
  154051
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiYoungStyria_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = 154051 AND fieldname = 'demiExtension';

SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')

[
  154051
]

SELECT
  *
FROM
  object_localized_data_8
WHERE
  ooo_id = ?
  AND language IN (
    'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it',
    'sk'
  )

SELECT * FROM object_localized_data_8 WHERE ooo_id = 154051 AND language IN ('de','en','hu','cs','pl','nl','it','sk');

SELECT * FROM object_relations_8 WHERE src_id = ?

[
  154051
]

SELECT
  *
FROM
  object_relations_8
WHERE
  src_id = ?

SELECT * FROM object_relations_8 WHERE src_id = 154051;

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 o_type,o_className,o_classId FROM objects WHERE o_id = ?

[
  147915
]

SELECT
  o_type,
  o_className,
  o_classId
FROM
  objects
WHERE
  o_id = ?

SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 147915;

SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?

[
  147915
]

SELECT
  objects.*,
  tree_locks.locked as o_locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.o_id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  o_id = ?

SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = 147915;

SELECT * FROM object_store_8 WHERE oo_id = ?

[
  147915
]

SELECT
  *
FROM
  object_store_8
WHERE
  oo_id = ?

SELECT * FROM object_store_8 WHERE oo_id = 147915;

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

[
  147915
  "facilities"
]

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

SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = 147915 AND fieldname = 'facilities' ORDER BY `index` ASC;

SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?

[
  147915
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiAccessibilityCategories_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = 147915 AND fieldname = 'demiExtension';

SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?

[
  147915
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiEnrichAcco_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = 147915 AND fieldname = 'demiExtension';

SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?

[
  147915
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiCanonicalRegion_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = 147915 AND fieldname = 'demiExtension';

SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?

[
  147915
  "demiExtension"
]

SELECT
  *
FROM
  object_brick_store_demiYoungStyria_8
WHERE
  o_id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = 147915 AND fieldname = 'demiExtension';

SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')

[
  147915
]

SELECT
  *
FROM
  object_localized_data_8
WHERE
  ooo_id = ?
  AND language IN (
    'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it',
    'sk'
  )

SELECT * FROM object_localized_data_8 WHERE ooo_id = 147915 AND language IN ('de','en','hu','cs','pl','nl','it','sk');

SELECT * FROM object_relations_8 WHERE src_id = ?

[
  147915
]

SELECT
  *
FROM
  object_relations_8
WHERE
  src_id = ?

SELECT * FROM object_relations_8 WHERE src_id = 147915;

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 = ?

[
  8152
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 8152;

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 = ?

[
  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(251)

[]

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(251)

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(251) ;

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