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=853837&nearbySearchLat=47.11285&nearbySearchLong=14.17788&sorting=nearbySearchAsc&page=7&randSeed=433"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=853837&nearbySearchLat=47.11285&nearbySearchLong=14.17788&page=7&randSeed=433&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=853837&nearbySearchLat=47.11285&nearbySearchLong=14.17788&sorting=nearbySearchAsc&page=7&randSeed=433' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=853837&nearbySearchLat=47.11285&nearbySearchLong=14.17788&page=7&randSeed=433&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 * 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 * 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 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 = ?

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

[
  "30"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '30';

SELECT name FROM classes WHERE id = ?

[
  "20"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '20';

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

[
  22882595
]

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

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

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

[
  22882595
]

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 = 22882595;

SELECT * FROM object_store_8 WHERE oo_id = ?

[
  22882595
]

SELECT
  *
FROM
  object_store_8
WHERE
  oo_id = ?

SELECT * FROM object_store_8 WHERE oo_id = 22882595;

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

[
  22882595
  "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 = 22882595 AND fieldname = 'facilities' ORDER BY `index` ASC;

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

[
  22882595
  "demiExtension"
]

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

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

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

[
  22882595
  "demiExtension"
]

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

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

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

[
  22882595
  "demiExtension"
]

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

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

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

[
  22882595
  "demiExtension"
]

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

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

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

[
  22882595
]

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 = 22882595 AND language IN ('de','en','hu','cs','pl','nl','it','sk');

SELECT * FROM object_relations_8 WHERE src_id = ?

[
  22882595
]

SELECT
  *
FROM
  object_relations_8
WHERE
  src_id = ?

SELECT * FROM object_relations_8 WHERE src_id = 22882595;

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

[
  8566620
]

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

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

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

[
  8566620
]

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 = 8566620;

SELECT * FROM object_store_8 WHERE oo_id = ?

[
  8566620
]

SELECT
  *
FROM
  object_store_8
WHERE
  oo_id = ?

SELECT * FROM object_store_8 WHERE oo_id = 8566620;

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

[
  8566620
  "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 = 8566620 AND fieldname = 'facilities' ORDER BY `index` ASC;

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

[
  8566620
  "demiExtension"
]

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

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

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

[
  8566620
  "demiExtension"
]

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

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

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

[
  8566620
  "demiExtension"
]

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

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

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

[
  8566620
  "demiExtension"
]

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

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

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

[
  8566620
]

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 = 8566620 AND language IN ('de','en','hu','cs','pl','nl','it','sk');

SELECT * FROM object_relations_8 WHERE src_id = ?

[
  8566620
]

SELECT
  *
FROM
  object_relations_8
WHERE
  src_id = ?

SELECT * FROM object_relations_8 WHERE src_id = 8566620;

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

[
  "68"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '68';

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

[]

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

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

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