Symfony Profiler

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,
  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.*,
  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 = 854118;

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

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

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

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

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

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

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

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

SELECT
  *
FROM
  object_relations_30
WHERE
  src_id = ?

SELECT * FROM object_relations_30 WHERE src_id = 7764;

SELECT
  *
FROM
  object_relations_31
WHERE
  src_id = ?

SELECT * FROM object_relations_31 WHERE src_id = 5155417;

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

SELECT * FROM object_brick_store_demiEventCategoryExternalMapping_30 WHERE o_id = 7764 AND fieldname = 'demiExtension';

SELECT
  *
FROM
  object_relations_8
WHERE
  src_id = ?

SELECT * FROM object_relations_8 WHERE src_id = 2101006;

SELECT
  *
FROM
  object_store_30
WHERE
  oo_id = ?

SELECT * FROM object_store_30 WHERE oo_id = 7764;

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

SELECT * FROM object_brick_store_demiAccommodationFeatureExternalMapping_30 WHERE o_id = 7764 AND fieldname = 'demiExtension';

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

SELECT
  *
FROM
  object_store_31
WHERE
  oo_id = ?

SELECT * FROM object_store_31 WHERE oo_id = 5155417;

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

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

SELECT
  *
FROM
  object_store_8
WHERE
  oo_id = ?

SELECT * FROM object_store_8 WHERE oo_id = 2101006;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

SELECT
  documents.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 9335;

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

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

SELECT
  documents.*,
  documents_page.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 26067;

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

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

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Thermen-Vulkanland/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte-suchen-und-buchen';

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

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

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

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

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 1809;

SELECT
  id
FROM
  sites

SELECT id FROM sites;

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

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen';

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

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

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

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

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
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite = '6'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen?nearbySearchId=854118&nearbySearchLat=47.16399&nearbySearchLong=14.99405&page=8&randSeed=523&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen?nearbySearchId=854118&nearbySearchLat=47.16399&nearbySearchLong=14.99405&page=8&randSeed=523&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
  object_localized_data_AlpsteinTour
WHERE
  ooo_id = ?
  AND language IN (
    'de', 'en', 'hu', 'cs', 'pl', 'nl', 'it',
    'sk'
  )

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

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

SELECT
  *
FROM
  object_store_AlpsteinTour
WHERE
  oo_id = ?

SELECT * FROM object_store_AlpsteinTour WHERE oo_id = 854118;

SELECT
  *
FROM
  object_relations_AlpsteinTour
WHERE
  src_id = ?

SELECT * FROM object_relations_AlpsteinTour WHERE src_id = 854118;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen';

SELECT
  *
FROM
  object_relations_51
WHERE
  src_id = ?

SELECT * FROM object_relations_51 WHERE src_id = 9683;

SELECT
  *
FROM
  object_relations_39
WHERE
  src_id = ?

SELECT * FROM object_relations_39 WHERE src_id = 8588;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 209143;

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

SELECT * FROM object_brick_store_demiMerchandiseHolidaythemeRelation_39 WHERE o_id = 8588 AND fieldname = 'demiExtension';

SELECT
  *
FROM
  object_store_39
WHERE
  oo_id = ?

SELECT * FROM object_store_39 WHERE oo_id = 8588;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 9335, 590, 57, 2, 1430)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE ((cid IN (1,9335,590,57,2,1430) AND inheritable = 1) OR cid = 9337 )  AND ctype='document';

SELECT
  *
FROM
  object_store_51
WHERE
  oo_id = ?

SELECT * FROM object_store_51 WHERE oo_id = 9683;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 590, 57, 2, 1430)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE ((cid IN (1,590,57,2,1430) AND inheritable = 1) OR cid = 591 )  AND ctype='document';

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 1809;

SELECT
  *
FROM
  assets_metadata
WHERE
  cid = ?

SELECT * FROM assets_metadata WHERE cid = 461598;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT
  assets.*,
  tree_locks.locked
FROM
  assets
  LEFT JOIN tree_locks ON assets.id = tree_locks.id
  AND tree_locks.type = 'asset'
WHERE
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 461598;

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

SELECT
  documents.*,
  documents_snippet.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN documents_snippet ON documents.id = documents_snippet.id
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 591;

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
  object_collection_demiDatePickerInfoText_21
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

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

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

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

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Thermen-Vulkanland/Urlaub-planen/Unterkuenfte-suchen-und-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT
  *
FROM
  object_relations_20
WHERE
  src_id = ?

SELECT * FROM object_relations_20 WHERE src_id = 6927;

SELECT
  *
FROM
  object_store_20
WHERE
  oo_id = ?

SELECT * FROM object_store_20 WHERE oo_id = 6927;

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

SELECT * FROM object_brick_store_demiAccommodationClassExternalMapping_20 WHERE o_id = 6927 AND fieldname = 'demiExtension';

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 (
    2088417,
    2065999,
    2088936,
    2097271,
    2073525,
    2433263,
    2103756,
    2082312,
    2094141,
    16338363,
    2102395,
    2099497,
    2098691,
    2075819,
    2103431,
    2083662,
    32460992,
    2088601,
    2088227,
    48662436,
    2081934,
    5367394,
    50205454,
    2100448,
    2101221,
    51021493,
    50631523,
    2087757,
    2076379,
    2096778,
    2102784,
    2096263,
    2092835,
    2099659,
    11510964,
    2073304,
    2066719,
    2433361,
    30479894,
    2088878,
    2098097,
    8728584,
    13235747,
    2079623,
    2074228,
    2100495,
    2088021,
    44032105,
    2096844,
    2075353,
    5367459,
    2074827,
    2080986,
    2104757,
    2104085,
    2098991,
    2101292,
    2104019,
    7969044,
    2103076,
    15104158,
    2075049,
    2697535,
    2104733,
    10004877,
    2098133,
    2102419,
    2097194,
    2097383,
    17253013,
    2077909,
    16878138,
    2075589,
    9495222,
    2075753,
    2089643,
    26862862,
    2070894,
    2104304,
    2097436,
    2103832,
    2073960,
    2073379,
    2081145,
    2088142,
    48569875,
    2074334,
    2695445,
    2085600,
    2104416,
    50975869,
    30177468,
    2098329,
    2102337,
    2087497,
    2086710,
    2076325,
    2078892,
    24815862,
    7969785,
    2068749,
    3259849,
    2084424,
    5418347,
    2700465,
    2102326,
    27370998,
    2093101,
    2082700,
    2081770,
    2103560,
    4820758,
    2078155,
    2079104,
    2100087,
    2098385,
    12663360,
    16306542,
    2691122,
    11687134,
    2101243,
    7968981,
    2100659,
    2098663,
    2103027,
    9580541,
    20926250,
    2084861,
    2097213,
    2092638,
    31115865,
    39069619,
    2084188,
    37709698,
    2074707,
    30764006,
    2077788,
    2099417,
    10004874,
    2098617,
    2102365,
    2086836,
    2079581,
    2099533,
    2088558,
    2099252,
    2696471,
    9556507,
    2100549,
    2075115,
    2098711,
    2076223,
    2074900,
    2099215,
    2073801,
    21193899,
    2077625,
    2079129,
    50536907,
    2697866,
    2082293,
    2077975,
    49215024,
    2075186,
    17208002,
    2077282,
    26342176,
    2099973,
    2084957,
    43443153,
    2085525,
    2074396,
    11473248,
    4791467,
    2099837,
    4442302,
    2091472,
    17526524,
    22765980,
    7018853,
    2103465,
    2098514,
    2102926,
    2084064,
    2068685,
    2087461,
    2074772,
    4063386,
    2098830,
    2087282,
    2100329,
    2081355,
    2099002,
    2082637,
    2078594,
    2095969,
    2066945,
    25410808,
    2095560,
    2310476,
    2696852,
    2087344,
    2100175,
    2086322,
    2101108,
    2074958,
    2089778,
    2103814,
    2084894,
    5367441,
    44528295,
    4063570,
    2433378,
    17208005,
    9455321,
    2080373,
    2092540,
    5554780,
    2100307,
    2100577,
    2078142,
    2096933,
    2100144,
    2103360,
    2433398,
    2099178,
    2078081,
    2088680,
    2093030,
    2077723,
    16295655,
    16648648,
    2081732,
    2070586,
    49875366,
    2093780,
    2087883,
    2094828,
    2078764,
    2099763,
    2095526,
    2104003,
    7041608,
    33623770,
    44780416,
    51213710,
    50347967,
    2104264,
    14913875,
    2081298,
    2073619,
    2103588,
    2080902,
    2066582,
    2079301,
    49304666,
    2079240,
    2082077,
    2066578,
    2100055,
    2085249,
    2098069,
    35859506,
    2095926,
    2086783,
    2095828,
    2100932,
    13948636,
    2099474,
    2083636,
    2071163,
    2082220,
    2099561,
    2081263,
    2087201,
    2078864,
    30765378,
    2084025,
    2098488,
    2078695,
    2082358,
    2100970,
    2100270,
    2070983,
    2100103,
    2081584,
    2102509,
    2080196,
    11213989,
    2073888,
    2083559,
    2080640,
    2097352,
    2084688,
    2433243,
    2080414,
    2103875,
    2692476,
    2080795,
    4063373,
    50345014,
    2084613,
    2086547,
    2095895,
    2089077,
    2095239,
    2091589,
    2080450,
    23898867,
    2099401,
    2101162,
    2089848,
    5128432,
    2073345,
    5315124,
    5128445,
    2096996,
    2099138,
    2095446,
    2097551,
    2080323,
    2076099,
    2098724,
    2076811,
    2100430,
    2071099,
    4063525,
    2094094,
    2073500,
    2081799,
    5367405,
    48368127,
    2079352,
    2074632,
    2076985,
    2085415,
    51358271,
    2072256,
    2093462,
    2070746,
    2066831,
    33294549,
    2088994,
    26970673,
    6262634,
    2100004,
    2081964,
    2065267,
    2098561,
    2081691,
    9284087,
    2082242,
    2080497,
    2078992,
    2066351,
    2098651,
    2081071,
    2087805,
    2100256,
    2089707,
    2077429,
    2079717,
    2080600,
    48319456,
    9580537,
    2086407,
    2102674,
    2085791,
    2076905,
    32938577,
    2075240,
    50929981,
    17015951,
    6515449,
    8306877,
    2097158,
    4063327,
    29311311,
    2096960,
    49350028,
    2086648,
    2084234,
    2087656,
    2078460,
    5418389,
    6112501,
    2081916,
    2103326,
    2070247,
    2097480,
    33059182,
    2101006,
    2096916,
    2073473,
    2081507,
    2075421,
    2077377,
    2103087,
    2101765,
    2090036,
    2103381,
    2080289,
    2086854,
    2078747,
    2103495,
    12370461,
    2083376,
    2095125,
    2094928,
    2103223,
    2088269,
    2079525,
    2094594,
    9667712,
    2103968,
    2103294,
    2084127,
    2075309,
    2083801,
    2071323,
    7969551,
    34920688,
    2085493,
    2073574,
    2101927,
    9129044,
    9054218,
    2102865,
    2069310,
    2069224,
    2075683,
    2096901,
    2095022,
    12664872,
    2074117,
    2100672,
    2080698,
    2098283,
    2072287,
    2097658,
    2080254,
    2103395,
    31077072,
    2083146,
    2095070,
    2083262,
    2067310,
    36701511,
    4063461,
    2093671,
    29341932,
    2075527,
    2087379,
    34636631,
    2078829,
    13400708,
    30217324,
    2086582,
    2091555,
    2097024,
    2073691,
    6112301,
    2098851,
    2079798,
    2103859,
    7969782,
    2094540,
    14915031,
    2102038,
    2090846
  )
  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

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 (2088417,2065999,2088936,2097271,2073525,2433263,2103756,2082312,2094141,16338363,2102395,2099497,2098691,2075819,2103431,2083662,32460992,2088601,2088227,48662436,2081934,5367394,50205454,2100448,2101221,51021493,50631523,2087757,2076379,2096778,2102784,2096263,2092835,2099659,11510964,2073304,2066719,2433361,30479894,2088878,2098097,8728584,13235747,2079623,2074228,2100495,2088021,44032105,2096844,2075353,5367459,2074827,2080986,2104757,2104085,2098991,2101292,2104019,7969044,2103076,15104158,2075049,2697535,2104733,10004877,2098133,2102419,2097194,2097383,17253013,2077909,16878138,2075589,9495222,2075753,2089643,26862862,2070894,2104304,2097436,2103832,2073960,2073379,2081145,2088142,48569875,2074334,2695445,2085600,2104416,50975869,30177468,2098329,2102337,2087497,2086710,2076325,2078892,24815862,7969785,2068749,3259849,2084424,5418347,2700465,2102326,27370998,2093101,2082700,2081770,2103560,4820758,2078155,2079104,2100087,2098385,12663360,16306542,2691122,11687134,2101243,7968981,2100659,2098663,2103027,9580541,20926250,2084861,2097213,2092638,31115865,39069619,2084188,37709698,2074707,30764006,2077788,2099417,10004874,2098617,2102365,2086836,2079581,2099533,2088558,2099252,2696471,9556507,2100549,2075115,2098711,2076223,2074900,2099215,2073801,21193899,2077625,2079129,50536907,2697866,2082293,2077975,49215024,2075186,17208002,2077282,26342176,2099973,2084957,43443153,2085525,2074396,11473248,4791467,2099837,4442302,2091472,17526524,22765980,7018853,2103465,2098514,2102926,2084064,2068685,2087461,2074772,4063386,2098830,2087282,2100329,2081355,2099002,2082637,2078594,2095969,2066945,25410808,2095560,2310476,2696852,2087344,2100175,2086322,2101108,2074958,2089778,2103814,2084894,5367441,44528295,4063570,2433378,17208005,9455321,2080373,2092540,5554780,2100307,2100577,2078142,2096933,2100144,2103360,2433398,2099178,2078081,2088680,2093030,2077723,16295655,16648648,2081732,2070586,49875366,2093780,2087883,2094828,2078764,2099763,2095526,2104003,7041608,33623770,44780416,51213710,50347967,2104264,14913875,2081298,2073619,2103588,2080902,2066582,2079301,49304666,2079240,2082077,2066578,2100055,2085249,2098069,35859506,2095926,2086783,2095828,2100932,13948636,2099474,2083636,2071163,2082220,2099561,2081263,2087201,2078864,30765378,2084025,2098488,2078695,2082358,2100970,2100270,2070983,2100103,2081584,2102509,2080196,11213989,2073888,2083559,2080640,2097352,2084688,2433243,2080414,2103875,2692476,2080795,4063373,50345014,2084613,2086547,2095895,2089077,2095239,2091589,2080450,23898867,2099401,2101162,2089848,5128432,2073345,5315124,5128445,2096996,2099138,2095446,2097551,2080323,2076099,2098724,2076811,2100430,2071099,4063525,2094094,2073500,2081799,5367405,48368127,2079352,2074632,2076985,2085415,51358271,2072256,2093462,2070746,2066831,33294549,2088994,26970673,6262634,2100004,2081964,2065267,2098561,2081691,9284087,2082242,2080497,2078992,2066351,2098651,2081071,2087805,2100256,2089707,2077429,2079717,2080600,48319456,9580537,2086407,2102674,2085791,2076905,32938577,2075240,50929981,17015951,6515449,8306877,2097158,4063327,29311311,2096960,49350028,2086648,2084234,2087656,2078460,5418389,6112501,2081916,2103326,2070247,2097480,33059182,2101006,2096916,2073473,2081507,2075421,2077377,2103087,2101765,2090036,2103381,2080289,2086854,2078747,2103495,12370461,2083376,2095125,2094928,2103223,2088269,2079525,2094594,9667712,2103968,2103294,2084127,2075309,2083801,2071323,7969551,34920688,2085493,2073574,2101927,9129044,9054218,2102865,2069310,2069224,2075683,2096901,2095022,12664872,2074117,2100672,2080698,2098283,2072287,2097658,2080254,2103395,31077072,2083146,2095070,2083262,2067310,36701511,4063461,2093671,29341932,2075527,2087379,34636631,2078829,13400708,30217324,2086582,2091555,2097024,2073691,6112301,2098851,2079798,2103859,7969782,2094540,14915031,2102038,2090846)
                  
                   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
        ;