Symfony Profiler

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
  *
FROM
  object_relations_8
WHERE
  src_id = ?

SELECT * FROM object_relations_8 WHERE src_id = 2062596;

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

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

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

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

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

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

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

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

SELECT
  *
FROM
  object_store_8
WHERE
  oo_id = ?

SELECT * FROM object_store_8 WHERE oo_id = 2062596;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 19895;

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

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

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/' AND `key` = BINARY 'book-camping';

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

SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = 2062596 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
  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/Suedsteiermark/Holiday/book-accommodation/book-camping';

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

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

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

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

SELECT
  id
FROM
  sites

SELECT id FROM sites;

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/Suedsteiermark/Holiday/book-accommodation/book-camping' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Suedsteiermark/Holiday/book-accommodation/book-camping?page=24&randSeed=833' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/book-camping?page=24&randSeed=833' 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
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation/book-camping';

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

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

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

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Suedsteiermark/Holiday/book-accommodation/book-camping'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Suedsteiermark/Holiday/book-accommodation/book-camping' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//en/Suedsteiermark/Holiday/book-accommodation/book-camping'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Suedsteiermark/Holiday/book-accommodation/book-camping' AND siteId = 0 ORDER BY siteId DESC 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(19597, 19895) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 19895;

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

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
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1223526;

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

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

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 19895;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Suedsteiermark/Holiday/book-accommodation/book-camping'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Suedsteiermark/Holiday/book-accommodation/book-camping' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  object_relations_20
WHERE
  src_id = ?

SELECT * FROM object_relations_20 WHERE src_id = 6894;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  object_store_20
WHERE
  oo_id = ?

SELECT * FROM object_store_20 WHERE oo_id = 6894;

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

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

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

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 (
    21032,
    24118,
    1988816,
    1994761,
    25763,
    19754,
    52662,
    25025,
    48663392,
    51833,
    36664,
    53783,
    47606,
    8537205,
    36160,
    29619,
    2062596,
    1987270,
    1987585,
    6945367,
    39998,
    48050342,
    2066133,
    36299,
    32802,
    20810,
    43526,
    35736,
    40704,
    21327,
    2063745,
    35989,
    31336,
    53239,
    17811174,
    1990911,
    14659516,
    29671,
    44781642,
    4791432,
    43804,
    1990469,
    49497910,
    1989465,
    55108,
    54339,
    27082,
    1986865,
    29109,
    30448600,
    1985174,
    4149206,
    48017,
    45797,
    25273,
    1989224,
    28657,
    1991492,
    1993438,
    1993811,
    1987680,
    23920,
    17904,
    45756976,
    35994,
    43702020,
    45319,
    18943,
    32658,
    51034,
    28920,
    1994096,
    45503,
    22003,
    55167,
    1994889,
    34887538,
    22916,
    1987442,
    43065,
    15375608,
    48570,
    32689,
    21942,
    2059088,
    39007,
    46250,
    47257351,
    21659,
    4525614,
    20023418,
    7351637,
    5367477,
    32010,
    36716325,
    1990091,
    2062684,
    1986914,
    2684053,
    28091523,
    1994480,
    35666823,
    41160,
    24375268,
    26851,
    22213550,
    2065098,
    29547,
    51974,
    23435,
    2063458,
    9313566,
    52190,
    18042,
    39687,
    25724,
    10114007,
    52545,
    35740,
    1988874,
    31625,
    22047,
    19852,
    28470795,
    20108,
    54660,
    9529160,
    17593634,
    45122,
    2066268,
    46284,
    33401,
    38583,
    27825,
    1985415,
    38373,
    28980,
    33077,
    21363,
    48496,
    33519,
    17418,
    25500,
    1993620,
    24985,
    44587191,
    1986581,
    19558,
    38807,
    2065496,
    47131,
    1994732,
    18328480,
    42753168,
    53474,
    31960,
    18230,
    47830,
    19286,
    54166,
    41842,
    16854,
    43472,
    34969921,
    18272,
    2063091,
    50718,
    2064618,
    46450,
    27471,
    21239,
    30773134,
    17115,
    18462,
    55010,
    4063277,
    1989075,
    29907,
    31953,
    18891,
    29829,
    2064513,
    20707,
    1984959,
    48716,
    33992180,
    5367353,
    45548175,
    48905586,
    47247,
    2063196,
    36531205,
    47981,
    51151,
    22475,
    21179,
    36617,
    1985474,
    40646,
    27294,
    41793,
    23991,
    20188,
    4061087,
    15498539,
    42977,
    24242,
    2058626,
    34983,
    1990181,
    31291,
    17670,
    55395,
    13440568,
    35330412,
    2059447,
    32550,
    41879,
    32751,
    27056,
    49790,
    42237,
    17541,
    10664738,
    48625745,
    2059260,
    29658091,
    18015,
    34831,
    42655,
    23620,
    50593655,
    37365,
    1995257,
    25156,
    27820,
    19587,
    2058512,
    7738339,
    1987973,
    24448,
    36227,
    36095,
    2059361,
    1992841,
    54464,
    45756981,
    32076506,
    1991534,
    38060,
    36066,
    50850,
    41366,
    48890,
    1985114,
    1343842,
    1994822,
    4063051,
    28876,
    2066111,
    1986015,
    1991966,
    1987149,
    1987314,
    6645142,
    30764208,
    25766745,
    21284,
    29614,
    18813,
    44831,
    18560,
    35697,
    1986716,
    31967,
    33451,
    35206874,
    41239,
    23500,
    38616,
    53131,
    32806,
    4061122,
    24793,
    27419533,
    1987706,
    1991413,
    7951197,
    31117139,
    53743,
    12948653,
    38480,
    33178,
    39198,
    18432,
    4761749,
    2059767,
    59655,
    35566,
    53293,
    45756971,
    1989734,
    44222,
    1995175,
    17823,
    367300,
    48928,
    1989698,
    50760,
    30731557,
    23720,
    44339,
    1986795,
    367295,
    12910729,
    42911,
    40425,
    1990539,
    4061075,
    50189,
    48863,
    40556,
    23077,
    28867356,
    2065425,
    39558266,
    2061355,
    30843,
    50963,
    44781629,
    46529,
    46578,
    34013,
    17227,
    46201539,
    26721,
    54523,
    367388,
    2058868,
    31340,
    53948,
    1988269,
    1994800,
    3263472,
    11364731,
    31259,
    1985962,
    18290,
    36655,
    46597852,
    2059571,
    19812,
    29104,
    28124,
    16421480,
    29903,
    1990830,
    43155,
    45082,
    40768,
    1990037,
    367391,
    32298578,
    1986509,
    25101,
    27868,
    46206,
    50135,
    20643,
    1986946,
    30756,
    30359,
    53418,
    35382,
    36427,
    26506,
    36327,
    48625748,
    30482936,
    27384,
    35666833,
    47614112,
    2059991,
    25366,
    41198698,
    21859,
    21427,
    35206879,
    42785,
    39377,
    12879307,
    18746,
    47781,
    12879304,
    18165472,
    28923,
    37308,
    54118,
    12279128,
    27568,
    25522,
    1992261,
    4580754,
    28828,
    1990504,
    1989882,
    35324,
    2059839,
    27807120,
    1989124,
    1989566,
    1992224,
    2060738,
    4061187,
    45252,
    21543,
    20668,
    1989012,
    16975,
    12910566,
    18776204,
    1993209,
    2853535,
    19725,
    18375,
    41494,
    42428,
    54243,
    19857,
    1995103,
    20782,
    47921,
    48625751,
    49910,
    25806,
    47888734,
    37859,
    52727,
    46316,
    50325,
    20840,
    22441,
    1985351,
    29585,
    47463,
    41198692,
    43594,
    35456,
    19475,
    30354,
    54763,
    22612,
    27685,
    42841,
    9283115,
    2063414,
    2853499,
    1433530,
    1986627,
    36100,
    49276,
    1986476,
    39231,
    1989268,
    34180,
    31755375,
    20989,
    4063160,
    50194,
    2064168,
    53593,
    43414,
    42753173,
    2062885,
    44050,
    1984997,
    2062975,
    1993946,
    52516,
    21622,
    2060516,
    17770,
    29658086,
    9484915,
    27631,
    52476,
    16110362,
    54695,
    47398,
    1987339,
    53159,
    367148,
    43184382,
    1994502,
    30852,
    31203,
    32147,
    55242,
    48663405,
    27520,
    1986681,
    31772,
    2058557,
    21585,
    30724471,
    49387,
    2062410,
    29754,
    33031,
    42581,
    20885,
    42551,
    24971,
    37827,
    17030,
    1984665,
    1994693,
    30400,
    1987463,
    2065944,
    11365272,
    1991623,
    42350,
    19115,
    32353,
    1987293,
    54374,
    26570,
    41710,
    1994374,
    1985522,
    15843263,
    45054,
    11436541,
    43641,
    1992182,
    18680,
    24580,
    48365,
    34270,
    1985660,
    35829,
    1994545,
    367184,
    53010,
    16889,
    25942,
    4061211,
    1993645,
    41546,
    37175,
    1989832,
    53347,
    34716,
    45198113,
    41649,
    52068,
    1989306,
    25423486,
    24523,
    52769,
    17126,
    2064808,
    37217,
    52980,
    41198724,
    1993242,
    45923,
    1989517,
    20291,
    28492,
    27298,
    1988015,
    17068,
    39083,
    49189,
    2063926,
    41935,
    20203610,
    46152494,
    1986219,
    43125,
    14913865,
    4608272,
    1146711,
    32305843,
    49229,
    1988207,
    21821,
    1986433,
    34358,
    26890,
    23055,
    50692778,
    1990403,
    35666828,
    32582,
    9455693,
    46968,
    19054,
    37942,
    2060888,
    43686,
    1988139,
    45143324,
    1987221,
    4061295,
    22775,
    25766748,
    1988937,
    28867350,
    1984904,
    21368,
    1993788,
    44387,
    28278,
    47710,
    31843325,
    22953,
    19244,
    1984508,
    17626,
    46636,
    33905,
    1146742,
    36531210,
    49548929,
    55324,
    1988347,
    25723022,
    26578533,
    2060465,
    32108,
    26717,
    44172,
    43837572,
    1984760,
    47196,
    1989419,
    50086,
    17001,
    39297,
    38549,
    33331,
    2060384,
    4061338,
    24173653,
    32478,
    35238,
    2064954,
    3263475,
    46992771,
    45375,
    46733,
    53913,
    45582,
    24781077,
    17676,
    19612,
    1988385,
    49046532,
    17120,
    39454,
    17354,
    44660,
    48663426,
    43758,
    35655,
    33768,
    50011,
    39922,
    33898,
    30980,
    28508,
    46933,
    1990954,
    42114,
    37746,
    46874,
    14049003,
    11367489,
    29836686,
    8142109,
    48905589,
    48675,
    26337,
    29764,
    30565,
    29658071,
    40473,
    1989922,
    19029556,
    50584316,
    1988731,
    1990285,
    1989189,
    1985246,
    16922,
    35070,
    25667,
    49548934,
    36492,
    18152,
    20577,
    47487,
    5949155,
    51301,
    30101,
    38904,
    49502,
    1990242,
    31474,
    1987095,
    2193918,
    36935,
    7738640,
    37484,
    1988766,
    28587,
    1986758,
    54798,
    19208,
    39575,
    1992394,
    1833139,
    12879310,
    51357,
    11185192,
    1993878,
    32750792,
    2064720,
    41615,
    26626,
    30751,
    49158,
    26431,
    31422,
    29658076,
    53817,
    35341,
    52801,
    38423,
    33100,
    43384,
    1993711,
    28867353,
    25414206,
    21489,
    19158,
    43433,
    18520,
    27740,
    31543,
    44782
  )
  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 (21032,24118,1988816,1994761,25763,19754,52662,25025,48663392,51833,36664,53783,47606,8537205,36160,29619,2062596,1987270,1987585,6945367,39998,48050342,2066133,36299,32802,20810,43526,35736,40704,21327,2063745,35989,31336,53239,17811174,1990911,14659516,29671,44781642,4791432,43804,1990469,49497910,1989465,55108,54339,27082,1986865,29109,30448600,1985174,4149206,48017,45797,25273,1989224,28657,1991492,1993438,1993811,1987680,23920,17904,45756976,35994,43702020,45319,18943,32658,51034,28920,1994096,45503,22003,55167,1994889,34887538,22916,1987442,43065,15375608,48570,32689,21942,2059088,39007,46250,47257351,21659,4525614,20023418,7351637,5367477,32010,36716325,1990091,2062684,1986914,2684053,28091523,1994480,35666823,41160,24375268,26851,22213550,2065098,29547,51974,23435,2063458,9313566,52190,18042,39687,25724,10114007,52545,35740,1988874,31625,22047,19852,28470795,20108,54660,9529160,17593634,45122,2066268,46284,33401,38583,27825,1985415,38373,28980,33077,21363,48496,33519,17418,25500,1993620,24985,44587191,1986581,19558,38807,2065496,47131,1994732,18328480,42753168,53474,31960,18230,47830,19286,54166,41842,16854,43472,34969921,18272,2063091,50718,2064618,46450,27471,21239,30773134,17115,18462,55010,4063277,1989075,29907,31953,18891,29829,2064513,20707,1984959,48716,33992180,5367353,45548175,48905586,47247,2063196,36531205,47981,51151,22475,21179,36617,1985474,40646,27294,41793,23991,20188,4061087,15498539,42977,24242,2058626,34983,1990181,31291,17670,55395,13440568,35330412,2059447,32550,41879,32751,27056,49790,42237,17541,10664738,48625745,2059260,29658091,18015,34831,42655,23620,50593655,37365,1995257,25156,27820,19587,2058512,7738339,1987973,24448,36227,36095,2059361,1992841,54464,45756981,32076506,1991534,38060,36066,50850,41366,48890,1985114,1343842,1994822,4063051,28876,2066111,1986015,1991966,1987149,1987314,6645142,30764208,25766745,21284,29614,18813,44831,18560,35697,1986716,31967,33451,35206874,41239,23500,38616,53131,32806,4061122,24793,27419533,1987706,1991413,7951197,31117139,53743,12948653,38480,33178,39198,18432,4761749,2059767,59655,35566,53293,45756971,1989734,44222,1995175,17823,367300,48928,1989698,50760,30731557,23720,44339,1986795,367295,12910729,42911,40425,1990539,4061075,50189,48863,40556,23077,28867356,2065425,39558266,2061355,30843,50963,44781629,46529,46578,34013,17227,46201539,26721,54523,367388,2058868,31340,53948,1988269,1994800,3263472,11364731,31259,1985962,18290,36655,46597852,2059571,19812,29104,28124,16421480,29903,1990830,43155,45082,40768,1990037,367391,32298578,1986509,25101,27868,46206,50135,20643,1986946,30756,30359,53418,35382,36427,26506,36327,48625748,30482936,27384,35666833,47614112,2059991,25366,41198698,21859,21427,35206879,42785,39377,12879307,18746,47781,12879304,18165472,28923,37308,54118,12279128,27568,25522,1992261,4580754,28828,1990504,1989882,35324,2059839,27807120,1989124,1989566,1992224,2060738,4061187,45252,21543,20668,1989012,16975,12910566,18776204,1993209,2853535,19725,18375,41494,42428,54243,19857,1995103,20782,47921,48625751,49910,25806,47888734,37859,52727,46316,50325,20840,22441,1985351,29585,47463,41198692,43594,35456,19475,30354,54763,22612,27685,42841,9283115,2063414,2853499,1433530,1986627,36100,49276,1986476,39231,1989268,34180,31755375,20989,4063160,50194,2064168,53593,43414,42753173,2062885,44050,1984997,2062975,1993946,52516,21622,2060516,17770,29658086,9484915,27631,52476,16110362,54695,47398,1987339,53159,367148,43184382,1994502,30852,31203,32147,55242,48663405,27520,1986681,31772,2058557,21585,30724471,49387,2062410,29754,33031,42581,20885,42551,24971,37827,17030,1984665,1994693,30400,1987463,2065944,11365272,1991623,42350,19115,32353,1987293,54374,26570,41710,1994374,1985522,15843263,45054,11436541,43641,1992182,18680,24580,48365,34270,1985660,35829,1994545,367184,53010,16889,25942,4061211,1993645,41546,37175,1989832,53347,34716,45198113,41649,52068,1989306,25423486,24523,52769,17126,2064808,37217,52980,41198724,1993242,45923,1989517,20291,28492,27298,1988015,17068,39083,49189,2063926,41935,20203610,46152494,1986219,43125,14913865,4608272,1146711,32305843,49229,1988207,21821,1986433,34358,26890,23055,50692778,1990403,35666828,32582,9455693,46968,19054,37942,2060888,43686,1988139,45143324,1987221,4061295,22775,25766748,1988937,28867350,1984904,21368,1993788,44387,28278,47710,31843325,22953,19244,1984508,17626,46636,33905,1146742,36531210,49548929,55324,1988347,25723022,26578533,2060465,32108,26717,44172,43837572,1984760,47196,1989419,50086,17001,39297,38549,33331,2060384,4061338,24173653,32478,35238,2064954,3263475,46992771,45375,46733,53913,45582,24781077,17676,19612,1988385,49046532,17120,39454,17354,44660,48663426,43758,35655,33768,50011,39922,33898,30980,28508,46933,1990954,42114,37746,46874,14049003,11367489,29836686,8142109,48905589,48675,26337,29764,30565,29658071,40473,1989922,19029556,50584316,1988731,1990285,1989189,1985246,16922,35070,25667,49548934,36492,18152,20577,47487,5949155,51301,30101,38904,49502,1990242,31474,1987095,2193918,36935,7738640,37484,1988766,28587,1986758,54798,19208,39575,1992394,1833139,12879310,51357,11185192,1993878,32750792,2064720,41615,26626,30751,49158,26431,31422,29658076,53817,35341,52801,38423,33100,43384,1993711,28867353,25414206,21489,19158,43433,18520,27740,31543,44782)
                  
                   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
  dacco.isTop,
  dacco.bookable,
  dacco.oo_id oo_id
FROM
  `steiermark`.object_8 dacco
WHERE
  dacco.o_published = 1
  AND (
    dacco.town__id IN (
      6944, 6971, 12312, 12321, 6973, 12320,
      6953, 12309, 6955, 6957, 6963, 6948,
      12304, 6969, 6945, 6966, 6951, 6968,
      6949, 12305, 6958, 6959, 6970, 6974,
      12324, 12342, 6946, 6956, 6964, 6954,
      6967, 12319, 12333, 6965, 12323, 12316,
      6961, 12318, 6972, 6962, 6960, 12329,
      12311, 6947
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(833)