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/Oststeiermark/Plan-your-holiday/Events"
  "sourcePathQuery" => "/en/Oststeiermark/Plan-your-holiday/Events"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Oststeiermark/Plan-your-holiday/Events"
  "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/Oststeiermark/Plan-your-holiday/Events' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Oststeiermark/Plan-your-holiday/Events' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Oststeiermark/Plan-your-holiday/Events' 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" => "Events"
  "path" => "/steiermark.com/en/Oststeiermark/Plan-your-holiday/"
]

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Oststeiermark/Plan-your-holiday/' AND `key` = BINARY 'Events';

SELECT * FROM object_url_slugs WHERE slug = '/en/Oststeiermark/Plan-your-holiday/Events' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Oststeiermark/Plan-your-holiday/Events'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Oststeiermark/Plan-your-holiday/Events' 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 * 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 * FROM documents_editables WHERE documentId = ?

[
  18618
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 18618;

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT sourceId FROM documents_translations WHERE id = ?

[
  18618
]

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 18618;

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

[
  6743
  18618
  18618
]

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

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

[
  18618
  18618
]

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

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

[
  6743
  6743
]

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

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

[
  "key" => "Events"
  "path" => "/en/Oststeiermark/Plan-your-holiday/"
]

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

SELECT id FROM documents WHERE path = BINARY '/en/Oststeiermark/Plan-your-holiday/' AND `key` = BINARY 'Events';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Oststeiermark/Plan-your-holiday/Events"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Oststeiermark/Plan-your-holiday/Events';

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

[
  "key" => "Events"
  "path" => "/en/Oststeiermark/Plan-your-holiday/"
]

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

SELECT id FROM documents WHERE path = BINARY '/en/Oststeiermark/Plan-your-holiday/' AND `key` = BINARY 'Events';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Oststeiermark/Plan-your-holiday/Events"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Oststeiermark/Plan-your-holiday/Events';

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/Oststeiermark/Plan-your-holiday/Events"
]

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/Oststeiermark/Plan-your-holiday/Events';

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

[
  "key" => "Plan-your-holiday"
  "path" => "/en/Oststeiermark/"
]

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

SELECT id FROM documents WHERE path = BINARY '/en/Oststeiermark/' AND `key` = BINARY 'Plan-your-holiday';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Oststeiermark/Plan-your-holiday"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Oststeiermark/Plan-your-holiday';

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/Oststeiermark/Plan-your-holiday"
]

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/Oststeiermark/Plan-your-holiday';

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

[
  "key" => "Oststeiermark"
  "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 'Oststeiermark';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Oststeiermark"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

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

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/Oststeiermark"
]

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/Oststeiermark';

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/Oststeiermark/Plan-your-holiday/Events' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Oststeiermark/Plan-your-holiday/Events'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Oststeiermark/Plan-your-holiday/Events' 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" => 1327906
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1327906;

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT name FROM classes WHERE id = ?

[
  "21"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '21';

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT name FROM classes WHERE id = ?

[
  "MediaCopyright"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'MediaCopyright';

SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid

[
  "cid" => 5765380
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5765380;

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

[
  "id" => "img-text-slide"
  "scope" => "pimcore_image_thumbnails"
]

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

SELECT * FROM settings_store WHERE id = 'img-text-slide' AND scope = 'pimcore_image_thumbnails';

SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid

[
  "cid" => 5742858
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5742858;

SELECT name FROM classes WHERE id = ?

[
  "72"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '72';

SELECT name FROM classes WHERE id = ?

[
  "29"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '29';

SELECT name FROM classes WHERE id = ?

[
  "39"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '39';

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

[
  5772
]

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 = 5772 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

SELECT name FROM classes WHERE id = ?

[
  "30"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '30';

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

[
  5773
]

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 = 5773 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5768
]

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 = 5768 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5758
]

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 = 5758 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5781
]

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 = 5781 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5760
]

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 = 5760 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5757
]

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 = 5757 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5727
]

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 = 5727 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5762
]

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 = 5762 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5769
]

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 = 5769 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5771
]

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 = 5771 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5779
]

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 = 5779 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5764
]

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 = 5764 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 = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  5796
]

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 = 5796 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

SELECT object_localized_28_en.o_id as o_id, object_localized_28_en.o_type as o_type FROM object_localized_28_en LEFT JOIN object_collection_demiRecurringDate_28 eventDate ON eventDate.o_id = object_localized_28_en.oo_id WHERE ((visibility is not null and visibility != "")  AND ((FIND_IN_SET(12146, `towns`) > 0 OR FIND_IN_SET(12115, `towns`) > 0 OR FIND_IN_SET(12122, `towns`) > 0 OR FIND_IN_SET(12133, `towns`) > 0 OR FIND_IN_SET(12531, `towns`) > 0 OR FIND_IN_SET(12143, `towns`) > 0 OR FIND_IN_SET(12116, `towns`) > 0 OR FIND_IN_SET(12129, `towns`) > 0 OR FIND_IN_SET(12138, `towns`) > 0 OR FIND_IN_SET(12136, `towns`) > 0 OR FIND_IN_SET(12118, `towns`) > 0 OR FIND_IN_SET(12164, `towns`) > 0 OR FIND_IN_SET(12155, `towns`) > 0 OR FIND_IN_SET(12152, `towns`) > 0 OR FIND_IN_SET(12162, `towns`) > 0 OR FIND_IN_SET(12154, `towns`) > 0 OR FIND_IN_SET(5099244, `towns`) > 0 OR FIND_IN_SET(12157, `towns`) > 0 OR FIND_IN_SET(3238735, `towns`) > 0 OR FIND_IN_SET(12110, `towns`) > 0 OR FIND_IN_SET(12120, `towns`) > 0 OR FIND_IN_SET(12123, `towns`) > 0 OR FIND_IN_SET(12135, `towns`) > 0 OR FIND_IN_SET(12098, `towns`) > 0 OR FIND_IN_SET(12099, `towns`) > 0 OR FIND_IN_SET(12140, `towns`) > 0 OR FIND_IN_SET(12117, `towns`) > 0 OR FIND_IN_SET(12108, `towns`) > 0 OR FIND_IN_SET(12109, `towns`) > 0 OR FIND_IN_SET(12156, `towns`) > 0 OR FIND_IN_SET(12106, `towns`) > 0 OR FIND_IN_SET(12126, `towns`) > 0 OR FIND_IN_SET(12132, `towns`) > 0 OR FIND_IN_SET(12158, `towns`) > 0 OR FIND_IN_SET(12103, `towns`) > 0 OR FIND_IN_SET(12139, `towns`) > 0 OR FIND_IN_SET(3552349, `towns`) > 0 OR FIND_IN_SET(12114, `towns`) > 0 OR FIND_IN_SET(12111, `towns`) > 0 OR FIND_IN_SET(12160, `towns`) > 0 OR FIND_IN_SET(12112, `towns`) > 0 OR FIND_IN_SET(12134, `towns`) > 0 OR FIND_IN_SET(3552346, `towns`) > 0))  AND ((FIND_IN_SET(7863, `facilities`) > 0 OR FIND_IN_SET(7864, `facilities`) > 0 OR FIND_IN_SET(7862, `facilities`) > 0 OR FIND_IN_SET(323728, `facilities`) > 0 OR FIND_IN_SET(8157, `facilities`) > 0 OR FIND_IN_SET(8155, `facilities`) > 0 OR FIND_IN_SET(8143, `facilities`) > 0 OR FIND_IN_SET(8148, `facilities`) > 0 OR FIND_IN_SET(8151, `facilities`) > 0 OR FIND_IN_SET(8145, `facilities`) > 0 OR FIND_IN_SET(8142, `facilities`) > 0 OR FIND_IN_SET(8150, `facilities`) > 0 OR FIND_IN_SET(8153, `facilities`) > 0 OR FIND_IN_SET(8156, `facilities`) > 0 OR FIND_IN_SET(8154, `facilities`) > 0 OR FIND_IN_SET(8149, `facilities`) > 0 OR FIND_IN_SET(8152, `facilities`) > 0 OR FIND_IN_SET(8146, `facilities`) > 0 OR FIND_IN_SET(8147, `facilities`) > 0 OR FIND_IN_SET(8144, `facilities`) > 0 OR FIND_IN_SET(7573, `facilities`) > 0 OR FIND_IN_SET(7577, `facilities`) > 0 OR FIND_IN_SET(7572, `facilities`) > 0 OR FIND_IN_SET(7576, `facilities`) > 0 OR FIND_IN_SET(7574, `facilities`) > 0 OR FIND_IN_SET(7575, `facilities`) > 0 OR FIND_IN_SET(7036, `facilities`) > 0 OR FIND_IN_SET(7032, `facilities`) > 0 OR FIND_IN_SET(12882, `facilities`) > 0 OR FIND_IN_SET(7035, `facilities`) > 0 OR FIND_IN_SET(7030, `facilities`) > 0 OR FIND_IN_SET(29785456, `facilities`) > 0 OR FIND_IN_SET(7038, `facilities`) > 0 OR FIND_IN_SET(7047, `facilities`) > 0 OR FIND_IN_SET(7037, `facilities`) > 0 OR FIND_IN_SET(7031, `facilities`) > 0 OR FIND_IN_SET(7033, `facilities`) > 0 OR FIND_IN_SET(7041, `facilities`) > 0 OR FIND_IN_SET(1915693, `facilities`) > 0 OR FIND_IN_SET(7039, `facilities`) > 0 OR FIND_IN_SET(7044, `facilities`) > 0 OR FIND_IN_SET(7045, `facilities`) > 0 OR FIND_IN_SET(1915690, `facilities`) > 0 OR FIND_IN_SET(7042, `facilities`) > 0 OR FIND_IN_SET(7046, `facilities`) > 0 OR FIND_IN_SET(7040, `facilities`) > 0 OR FIND_IN_SET(7043, `facilities`) > 0 OR FIND_IN_SET(7034, `facilities`) > 0 OR FIND_IN_SET(7815, `facilities`) > 0 OR FIND_IN_SET(7805, `facilities`) > 0 OR FIND_IN_SET(7803, `facilities`) > 0 OR FIND_IN_SET(6121793, `facilities`) > 0 OR FIND_IN_SET(7798, `facilities`) > 0 OR FIND_IN_SET(7810, `facilities`) > 0 OR FIND_IN_SET(7809, `facilities`) > 0 OR FIND_IN_SET(7814, `facilities`) > 0 OR FIND_IN_SET(7812, `facilities`) > 0 OR FIND_IN_SET(7801, `facilities`) > 0 OR FIND_IN_SET(7806, `facilities`) > 0 OR FIND_IN_SET(7802, `facilities`) > 0 OR FIND_IN_SET(7813, `facilities`) > 0 OR FIND_IN_SET(7808, `facilities`) > 0 OR FIND_IN_SET(7807, `facilities`) > 0 OR FIND_IN_SET(7800, `facilities`) > 0 OR FIND_IN_SET(7799, `facilities`) > 0 OR FIND_IN_SET(7804, `facilities`) > 0 OR FIND_IN_SET(7811, `facilities`) > 0 OR FIND_IN_SET(7381, `facilities`) > 0 OR FIND_IN_SET(7379, `facilities`) > 0 OR FIND_IN_SET(7383, `facilities`) > 0 OR FIND_IN_SET(7380, `facilities`) > 0 OR FIND_IN_SET(7382, `facilities`) > 0 OR FIND_IN_SET(7092, `facilities`) > 0 OR FIND_IN_SET(7089, `facilities`) > 0 OR FIND_IN_SET(7096, `facilities`) > 0 OR FIND_IN_SET(7088, `facilities`) > 0 OR FIND_IN_SET(7091, `facilities`) > 0 OR FIND_IN_SET(7090, `facilities`) > 0 OR FIND_IN_SET(7093, `facilities`) > 0 OR FIND_IN_SET(7094, `facilities`) > 0 OR FIND_IN_SET(7095, `facilities`) > 0 OR FIND_IN_SET(7442, `facilities`) > 0 OR FIND_IN_SET(7415, `facilities`) > 0 OR FIND_IN_SET(7478, `facilities`) > 0 OR FIND_IN_SET(29785462, `facilities`) > 0 OR FIND_IN_SET(7430, `facilities`) > 0 OR FIND_IN_SET(7518, `facilities`) > 0 OR FIND_IN_SET(7446, `facilities`) > 0 OR FIND_IN_SET(7485, `facilities`) > 0 OR FIND_IN_SET(7488, `facilities`) > 0 OR FIND_IN_SET(7505, `facilities`) > 0 OR FIND_IN_SET(7421, `facilities`) > 0 OR FIND_IN_SET(7452, `facilities`) > 0 OR FIND_IN_SET(7487, `facilities`) > 0 OR FIND_IN_SET(7486, `facilities`) > 0 OR FIND_IN_SET(7498, `facilities`) > 0 OR FIND_IN_SET(7474, `facilities`) > 0 OR FIND_IN_SET(7496, `facilities`) > 0 OR FIND_IN_SET(12896, `facilities`) > 0 OR FIND_IN_SET(7449, `facilities`) > 0 OR FIND_IN_SET(7477, `facilities`) > 0 OR FIND_IN_SET(7454, `facilities`) > 0 OR FIND_IN_SET(12898, `facilities`) > 0 OR FIND_IN_SET(7501, `facilities`) > 0 OR FIND_IN_SET(12895, `facilities`) > 0 OR FIND_IN_SET(7413, `facilities`) > 0 OR FIND_IN_SET(7423, `facilities`) > 0 OR FIND_IN_SET(7411, `facilities`) > 0 OR FIND_IN_SET(7507, `facilities`) > 0 OR FIND_IN_SET(7466, `facilities`) > 0 OR FIND_IN_SET(7444, `facilities`) > 0 OR FIND_IN_SET(48173632, `facilities`) > 0 OR FIND_IN_SET(29785463, `facilities`) > 0 OR FIND_IN_SET(12900, `facilities`) > 0 OR FIND_IN_SET(7412, `facilities`) > 0 OR FIND_IN_SET(7438, `facilities`) > 0 OR FIND_IN_SET(7459, `facilities`) > 0 OR FIND_IN_SET(7453, `facilities`) > 0 OR FIND_IN_SET(7440, `facilities`) > 0 OR FIND_IN_SET(29785464, `facilities`) > 0 OR FIND_IN_SET(7441, `facilities`) > 0 OR FIND_IN_SET(7469, `facilities`) > 0 OR FIND_IN_SET(7416, `facilities`) > 0 OR FIND_IN_SET(7504, `facilities`) > 0 OR FIND_IN_SET(7472, `facilities`) > 0 OR FIND_IN_SET(7506, `facilities`) > 0 OR FIND_IN_SET(7426, `facilities`) > 0 OR FIND_IN_SET(323718, `facilities`) > 0 OR FIND_IN_SET(7428, `facilities`) > 0 OR FIND_IN_SET(7424, `facilities`) > 0 OR FIND_IN_SET(7409, `facilities`) > 0 OR FIND_IN_SET(7475, `facilities`) > 0 OR FIND_IN_SET(7494, `facilities`) > 0 OR FIND_IN_SET(7517, `facilities`) > 0 OR FIND_IN_SET(32381418, `facilities`) > 0 OR FIND_IN_SET(7410, `facilities`) > 0 OR FIND_IN_SET(7422, `facilities`) > 0 OR FIND_IN_SET(7420, `facilities`) > 0 OR FIND_IN_SET(7510, `facilities`) > 0 OR FIND_IN_SET(7503, `facilities`) > 0 OR FIND_IN_SET(7435, `facilities`) > 0 OR FIND_IN_SET(7463, `facilities`) > 0 OR FIND_IN_SET(12897, `facilities`) > 0 OR FIND_IN_SET(7490, `facilities`) > 0 OR FIND_IN_SET(7495, `facilities`) > 0 OR FIND_IN_SET(7408, `facilities`) > 0 OR FIND_IN_SET(7460, `facilities`) > 0 OR FIND_IN_SET(7417, `facilities`) > 0 OR FIND_IN_SET(29785465, `facilities`) > 0 OR FIND_IN_SET(323717, `facilities`) > 0 OR FIND_IN_SET(7433, `facilities`) > 0 OR FIND_IN_SET(7436, `facilities`) > 0 OR FIND_IN_SET(7468, `facilities`) > 0 OR FIND_IN_SET(7443, `facilities`) > 0 OR FIND_IN_SET(7462, `facilities`) > 0 OR FIND_IN_SET(7471, `facilities`) > 0 OR FIND_IN_SET(7493, `facilities`) > 0 OR FIND_IN_SET(7514, `facilities`) > 0 OR FIND_IN_SET(7419, `facilities`) > 0 OR FIND_IN_SET(7431, `facilities`) > 0 OR FIND_IN_SET(7456, `facilities`) > 0 OR FIND_IN_SET(7445, `facilities`) > 0 OR FIND_IN_SET(7465, `facilities`) > 0 OR FIND_IN_SET(7512, `facilities`) > 0 OR FIND_IN_SET(7425, `facilities`) > 0 OR FIND_IN_SET(7515, `facilities`) > 0 OR FIND_IN_SET(7509, `facilities`) > 0 OR FIND_IN_SET(7502, `facilities`) > 0 OR FIND_IN_SET(7457, `facilities`) > 0 OR FIND_IN_SET(7450, `facilities`) > 0 OR FIND_IN_SET(7451, `facilities`) > 0 OR FIND_IN_SET(7508, `facilities`) > 0 OR FIND_IN_SET(7467, `facilities`) > 0 OR FIND_IN_SET(7448, `facilities`) > 0 OR FIND_IN_SET(7482, `facilities`) > 0 OR FIND_IN_SET(7458, `facilities`) > 0 OR FIND_IN_SET(7513, `facilities`) > 0 OR FIND_IN_SET(7427, `facilities`) > 0 OR FIND_IN_SET(7497, `facilities`) > 0 OR FIND_IN_SET(7492, `facilities`) > 0 OR FIND_IN_SET(7464, `facilities`) > 0 OR FIND_IN_SET(7434, `facilities`) > 0 OR FIND_IN_SET(7483, `facilities`) > 0 OR FIND_IN_SET(7414, `facilities`) > 0 OR FIND_IN_SET(7437, `facilities`) > 0 OR FIND_IN_SET(7500, `facilities`) > 0 OR FIND_IN_SET(7511, `facilities`) > 0 OR FIND_IN_SET(7432, `facilities`) > 0 OR FIND_IN_SET(7461, `facilities`) > 0 OR FIND_IN_SET(7470, `facilities`) > 0 OR FIND_IN_SET(7476, `facilities`) > 0 OR FIND_IN_SET(7418, `facilities`) > 0 OR FIND_IN_SET(7447, `facilities`) > 0 OR FIND_IN_SET(7489, `facilities`) > 0 OR FIND_IN_SET(7491, `facilities`) > 0 OR FIND_IN_SET(12899, `facilities`) > 0 OR FIND_IN_SET(7455, `facilities`) > 0 OR FIND_IN_SET(7439, `facilities`) > 0 OR FIND_IN_SET(7479, `facilities`) > 0 OR FIND_IN_SET(6121789, `facilities`) > 0 OR FIND_IN_SET(7516, `facilities`) > 0 OR FIND_IN_SET(7473, `facilities`) > 0 OR FIND_IN_SET(7499, `facilities`) > 0 OR FIND_IN_SET(7484, `facilities`) > 0 OR FIND_IN_SET(7429, `facilities`) > 0 OR FIND_IN_SET(7481, `facilities`) > 0 OR FIND_IN_SET(7480, `facilities`) > 0 OR FIND_IN_SET(7530, `facilities`) > 0 OR FIND_IN_SET(7529, `facilities`) > 0 OR FIND_IN_SET(7524, `facilities`) > 0 OR FIND_IN_SET(7525, `facilities`) > 0 OR FIND_IN_SET(7528, `facilities`) > 0 OR FIND_IN_SET(7520, `facilities`) > 0 OR FIND_IN_SET(7519, `facilities`) > 0 OR FIND_IN_SET(7527, `facilities`) > 0 OR FIND_IN_SET(7526, `facilities`) > 0 OR FIND_IN_SET(1915772, `facilities`) > 0 OR FIND_IN_SET(7522, `facilities`) > 0 OR FIND_IN_SET(6121790, `facilities`) > 0 OR FIND_IN_SET(7523, `facilities`) > 0 OR FIND_IN_SET(7521, `facilities`) > 0 OR FIND_IN_SET(1915931, `facilities`) > 0 OR FIND_IN_SET(8224, `facilities`) > 0 OR FIND_IN_SET(8227, `facilities`) > 0 OR FIND_IN_SET(12921, `facilities`) > 0 OR FIND_IN_SET(8229, `facilities`) > 0 OR FIND_IN_SET(8228, `facilities`) > 0 OR FIND_IN_SET(8231, `facilities`) > 0 OR FIND_IN_SET(8221, `facilities`) > 0 OR FIND_IN_SET(8222, `facilities`) > 0 OR FIND_IN_SET(8226, `facilities`) > 0 OR FIND_IN_SET(8230, `facilities`) > 0 OR FIND_IN_SET(8225, `facilities`) > 0 OR FIND_IN_SET(8223, `facilities`) > 0 OR FIND_IN_SET(7851, `facilities`) > 0 OR FIND_IN_SET(7850, `facilities`) > 0 OR FIND_IN_SET(7849, `facilities`) > 0 OR FIND_IN_SET(7852, `facilities`) > 0 OR FIND_IN_SET(16805605, `facilities`) > 0 OR FIND_IN_SET(12908, `facilities`) > 0 OR FIND_IN_SET(16878442, `facilities`) > 0 OR FIND_IN_SET(16805604, `facilities`) > 0 OR FIND_IN_SET(12907, `facilities`) > 0 OR FIND_IN_SET(323727, `facilities`) > 0 OR FIND_IN_SET(29785472, `facilities`) > 0 OR FIND_IN_SET(7844, `facilities`) > 0 OR FIND_IN_SET(7840, `facilities`) > 0 OR FIND_IN_SET(7842, `facilities`) > 0 OR FIND_IN_SET(7846, `facilities`) > 0 OR FIND_IN_SET(29785471, `facilities`) > 0 OR FIND_IN_SET(7847, `facilities`) > 0 OR FIND_IN_SET(7845, `facilities`) > 0 OR FIND_IN_SET(7843, `facilities`) > 0 OR FIND_IN_SET(7839, `facilities`) > 0 OR FIND_IN_SET(7841, `facilities`) > 0 OR FIND_IN_SET(7838, `facilities`) > 0 OR FIND_IN_SET(7579, `facilities`) > 0 OR FIND_IN_SET(7581, `facilities`) > 0 OR FIND_IN_SET(7580, `facilities`) > 0 OR FIND_IN_SET(7578, `facilities`) > 0 OR FIND_IN_SET(1915829, `facilities`) > 0 OR FIND_IN_SET(7950, `facilities`) > 0 OR FIND_IN_SET(7952, `facilities`) > 0 OR FIND_IN_SET(7953, `facilities`) > 0 OR FIND_IN_SET(7951, `facilities`) > 0 OR FIND_IN_SET(7954, `facilities`) > 0))  AND ((FIND_IN_SET(11895589, `holidayThemes`) > 0))  AND (contentScore > 10)  AND ((object_localized_28_en.active = 1 ))  AND (eventDate.dateTo >= 1732575600)  AND (eventDate.dateFrom <= 1798671599)  AND ((eventDate.Sun = 1 OR eventDate.Mon = 1 OR eventDate.Tue = 1 OR eventDate.Wed = 1 OR eventDate.Thu = 1 OR eventDate.Fri = 1 OR eventDate.Sat = 1))  AND  object_localized_28_en.o_type IN ('object')) AND object_localized_28_en.o_published = 1 ORDER BY topEvent DESC, eventDate.dateTo ASC, eventDate.dateFrom ASC, eventDate.time ASC, name ASC