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

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

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Urlaub-planen/Pauschalen/' AND `key` = BINARY 'buchbare-Urlaubspakete';

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
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 194;

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 = '/de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete' 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
  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/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete';

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

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete';

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

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

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

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

SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 194;

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

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

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Pauschalen/buchbare-Urlaubspakete' 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
  dacco.isTop,
  dacco.bookable,
  dacco.oo_id oo_id,
  products.oo_id product_id,
  hpMasters.src_id hpMaster_id
FROM
  `steiermark`.object_8 dacco
  INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId
  INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId
  INNER JOIN `steiermark`.object_relations_44 hpMasters ON hpMasters.dest_id = products.oo_id
WHERE
  dacco.o_published = 1
  AND (
    products.o_published = 1
    AND products.productType = 'Package'
  )
  AND (
    dacco.town__id IN (
      11465,
      11466,
      11464,
      11463,
      1612603,
      11550,
      11552,
      11546,
      11938,
      11563,
      11553,
      11561,
      11562,
      11540,
      11554,
      11551,
      3896604,
      11548,
      11547,
      11545,
      11543,
      11549,
      11431,
      11422,
      11423,
      11541,
      11430,
      3192505,
      3192507,
      3192504,
      3192506,
      11426,
      3192508,
      11434,
      11848,
      11504,
      11474,
      11849,
      11470,
      11493,
      11499,
      11492,
      11841,
      11487,
      11501,
      11475,
      11495,
      11494,
      11496,
      11482,
      11846,
      11484,
      11847,
      11506,
      11479,
      11837,
      11478,
      11839,
      11505,
      11489,
      11842,
      11845,
      11836,
      11476,
      11503,
      11471,
      11483,
      11850,
      11498,
      11481,
      11497,
      11500,
      11843,
      11472,
      11490,
      11844,
      11491,
      11473,
      11838,
      11477,
      11488,
      11840,
      11485,
      11486,
      11480,
      11502,
      10003651,
      10003639,
      10003640,
      10003652,
      10003641,
      10003650,
      10003612,
      10003642,
      10003643,
      10003660,
      10003613,
      10003644,
      10003610,
      10003614,
      10003616,
      10003653,
      10003645,
      10003617,
      10003618,
      10003654,
      10003620,
      10003621,
      10003622,
      10003655,
      10003656,
      10003646,
      10003649,
      10003624,
      10003648,
      10003659,
      10003629,
      10003625,
      10003647,
      10003657,
      10003626,
      10003628,
      10003630,
      10003632,
      10003633,
      10003634,
      10003636,
      10003658,
      10003637,
      10003638,
      11534,
      11539,
      11538,
      11527,
      11522,
      11524,
      11559,
      11521,
      11567,
      11560,
      11526,
      11536,
      3896603,
      11528,
      11535,
      11537,
      11959,
      11948,
      11910,
      11909,
      11965,
      11963,
      11947,
      11922,
      11921,
      11950,
      11914,
      11920,
      11946,
      11937,
      11956,
      11929,
      11935,
      11923,
      11936,
      11926,
      11927,
      11918,
      11966,
      11971,
      11972,
      11931,
      11928,
      11953,
      11930,
      11924,
      11954,
      11955,
      11942,
      11932,
      3239518,
      12146,
      12115,
      12122,
      12133,
      12531,
      12143,
      12116,
      12129,
      12138,
      12136,
      12118,
      12163,
      12164,
      12155,
      12152,
      12525,
      3552351,
      12162,
      12154,
      5099244,
      3552346,
      3190431,
      12157,
      3552350,
      3238735,
      12110,
      3552345,
      3552348,
      3552347,
      12120,
      12123,
      12135,
      12137,
      12140,
      12099,
      12098,
      12117,
      12108,
      12151,
      12134,
      12109,
      12156,
      12106,
      12126,
      12132,
      3190432,
      12158,
      12103,
      12139,
      3552349,
      12114,
      12111,
      12160,
      12112,
      11409,
      11195,
      11196,
      11191,
      11194,
      11190,
      3192509,
      11197,
      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,
      12478,
      12548,
      12464,
      12539,
      12535,
      12532,
      12555,
      12472,
      12489,
      12505,
      12503,
      12508,
      12526,
      12544,
      12530,
      12537,
      12463,
      12491,
      12547,
      12519,
      12480,
      12542,
      12551,
      12477,
      12469,
      3239510,
      12528,
      12507,
      3239509,
      12510,
      3239507,
      3239508,
      12522,
      12543,
      12502,
      12546,
      12552,
      12538,
      12465,
      29785444,
      29785442
    )
  )
  AND (
    products.oo_id IN (
      SELECT
        DISTINCT o_id
      FROM
        `steiermark`.object_collection_demiDate_6
      WHERE
        `to` > 1732651037
    )
    OR validDatesType = 'Always'
  )
  AND hpMasters.src_id in (
    select
      o_id
    from
      `steiermark`.object_44
    where
      o_published = 1
      and active = 1
  )
GROUP BY
  product_id
ORDER BY
  RAND(285)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id, products.oo_id product_id, hpMasters.src_id hpMaster_id  FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_7 services ON dacco.oo_id = services.o_parentId  INNER JOIN `steiermark`.object_6 products ON services.oo_id = products.o_parentId  INNER JOIN `steiermark`.object_relations_44 hpMasters ON hpMasters.dest_id = products.oo_id  WHERE  dacco.o_published = 1  AND (products.o_published = 1  AND products.productType = 'Package') AND (dacco.town__id IN (11465, 11466, 11464, 11463, 1612603, 11550, 11552, 11546, 11938, 11563, 11553, 11561, 11562, 11540, 11554, 11551, 3896604, 11548, 11547, 11545, 11543, 11549, 11431, 11422, 11423, 11541, 11430, 3192505, 3192507, 3192504, 3192506, 11426, 3192508, 11434, 11848, 11504, 11474, 11849, 11470, 11493, 11499, 11492, 11841, 11487, 11501, 11475, 11495, 11494, 11496, 11482, 11846, 11484, 11847, 11506, 11479, 11837, 11478, 11839, 11505, 11489, 11842, 11845, 11836, 11476, 11503, 11471, 11483, 11850, 11498, 11481, 11497, 11500, 11843, 11472, 11490, 11844, 11491, 11473, 11838, 11477, 11488, 11840, 11485, 11486, 11480, 11502, 10003651, 10003639, 10003640, 10003652, 10003641, 10003650, 10003612, 10003642, 10003643, 10003660, 10003613, 10003644, 10003610, 10003614, 10003616, 10003653, 10003645, 10003617, 10003618, 10003654, 10003620, 10003621, 10003622, 10003655, 10003656, 10003646, 10003649, 10003624, 10003648, 10003659, 10003629, 10003625, 10003647, 10003657, 10003626, 10003628, 10003630, 10003632, 10003633, 10003634, 10003636, 10003658, 10003637, 10003638, 11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537, 11959, 11948, 11910, 11909, 11965, 11963, 11947, 11922, 11921, 11950, 11914, 11920, 11946, 11937, 11956, 11929, 11935, 11923, 11936, 11926, 11927, 11918, 11966, 11971, 11972, 11931, 11928, 11953, 11930, 11924, 11954, 11955, 11942, 11932, 3239518, 12146, 12115, 12122, 12133, 12531, 12143, 12116, 12129, 12138, 12136, 12118, 12163, 12164, 12155, 12152, 12525, 3552351, 12162, 12154, 5099244, 3552346, 3190431, 12157, 3552350, 3238735, 12110, 3552345, 3552348, 3552347, 12120, 12123, 12135, 12137, 12140, 12099, 12098, 12117, 12108, 12151, 12134, 12109, 12156, 12106, 12126, 12132, 3190432, 12158, 12103, 12139, 3552349, 12114, 12111, 12160, 12112, 11409, 11195, 11196, 11191, 11194, 11190, 3192509, 11197, 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, 12478, 12548, 12464, 12539, 12535, 12532, 12555, 12472, 12489, 12505, 12503, 12508, 12526, 12544, 12530, 12537, 12463, 12491, 12547, 12519, 12480, 12542, 12551, 12477, 12469, 3239510, 12528, 12507, 3239509, 12510, 3239507, 3239508, 12522, 12543, 12502, 12546, 12552, 12538, 12465, 29785444, 29785442)) AND (
                products.oo_id  IN (SELECT DISTINCT o_id FROM `steiermark`.object_collection_demiDate_6
                WHERE  `to` > 1732651037) OR validDatesType = 'Always'
            )  AND hpMasters.src_id in (select o_id from `steiermark`.object_44 where o_published = 1 and active=1) GROUP BY product_id  ORDER BY  RAND(285) ;

SELECT
  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.product_id IN (
    27947471,
    27947490,
    27947465,
    27947484,
    27947459,
    27947496,
    27947478,
    1614101,
    36095702,
    1614137,
    36095866,
    1614485,
    51733776,
    1614461,
    1614413,
    36096005,
    1613676,
    1613795,
    36778784,
    36778854,
    1613983,
    36778918,
    36095770,
    51733863,
    1613640,
    1614324,
    36779157,
    1614312,
    1614155,
    36096071,
    36091742,
    36095606,
    1614167,
    1614258,
    1613688,
    1614019,
    1613867,
    36095942,
    36091878,
    1613843,
    1614449,
    1614294,
    39951870,
    1614013,
    36095791,
    36779079,
    32381308,
    1613849,
    1613995,
    1614001,
    1613682,
    36096025,
    1613947,
    29570869,
    1614149,
    1614300,
    29571194,
    1613837,
    37242249,
    51733902,
    29571134,
    1613989,
    51733547,
    36091776,
    51733715,
    1614467,
    36095468,
    1613670,
    1614330,
    29570875,
    36779034,
    36095917,
    36778983,
    36091640,
    36095677,
    1613861,
    29571286,
    36095588,
    1614306,
    51733945,
    1614455,
    36091693,
    51733629,
    1614173,
    1613700,
    36091913,
    1614479,
    32381314,
    39951878,
    36096097,
    36091943,
    36095501,
    1613831,
    39951817,
    1613706,
    29571128,
    32381359,
    51733821,
    36779118,
    36095848,
    36091844,
    32381365,
    1614143,
    43184465,
    32149472,
    20889110,
    20889104,
    20890062,
    15972952,
    15972980,
    15973152,
    15973100,
    15973246,
    15973016,
    15972870,
    15973282,
    15973128,
    15972984,
    33542283,
    15973148,
    15973230,
    15973242,
    15627944,
    15973209,
    15972847,
    15973000,
    33582485,
    15627674,
    15972839,
    15973116,
    15972874,
    15972793,
    15973104,
    15973222,
    15972815,
    33541970,
    15973040,
    15973032,
    15972909,
    15973218,
    33582557,
    15972956,
    33541912,
    15973213,
    15973012,
    33582545,
    15627736,
    15973172,
    15973108,
    15973250,
    33582575,
    33582539,
    33582587,
    15973238,
    15973201,
    15973132,
    15973112,
    15972996,
    15973064,
    15973226,
    15973294,
    15973020,
    15972819,
    15627948,
    33542379,
    15972811,
    15627732,
    15972905,
    15972972,
    33542347,
    15973028,
    15972992,
    15972789,
    15972944,
    33541883,
    15973180,
    15973234,
    33541853,
    15972843,
    15972781,
    15972882,
    15627582,
    15973044,
    15973274,
    15972940,
    15627662,
    33582599,
    15627666,
    15973188,
    15584049,
    15973080,
    15973084,
    15972851,
    33582521,
    33582515,
    15973060,
    15972988,
    15870553,
    15973024,
    15972823,
    33582509,
    15972785,
    15973184,
    15973254,
    15973193,
    15972878,
    15973197,
    15973068,
    15973072,
    33582497,
    15972901,
    33542251,
    15973076,
    15973176,
    15972976,
    15973036,
    15973056,
    15972968,
    33582605,
    15627960,
    33541941,
    33582527,
    15627964,
    15870557,
    15973266,
    15627940,
    15972948,
    33582503,
    15627823,
    15973088,
    15973278,
    15973120,
    15627952,
    15973205,
    15627956,
    15973168,
    33582491,
    15973262,
    15973290,
    33582593,
    15627670,
    33582569,
    33582563,
    15973258,
    15973144,
    33582479,
    15973286,
    33582551,
    33542315,
    33582581,
    15973270,
    15973124,
    16273839,
    17811238,
    24820573,
    17844819,
    24820876,
    16273822,
    16273830,
    16273836,
    17811235,
    17811223,
    24820579,
    24820900,
    17844835,
    24820888,
    17811226,
    17844823,
    17844827,
    17844815,
    17844831,
    16273833,
    24820912,
    29263566,
    16273826,
    17811232,
    17811229,
    1963994,
    20203434,
    1963974,
    20058827,
    1963940,
    20203444,
    1963725,
    20204874,
    1963960,
    20058822,
    20058797,
    1963665,
    20204820,
    1963768,
    20202991,
    20058849,
    1963822,
    20203386,
    20203418,
    1963899,
    1963944,
    1963705,
    1964081,
    1963802,
    1963691,
    20203423,
    20203713,
    1964054,
    1963772,
    20058832,
    20203381,
    20203413,
    1963810,
    1963762,
    1963859,
    20058787,
    1963713,
    1963875,
    20204892,
    1964046,
    20203376,
    1964032,
    1963934,
    1963986,
    1964089,
    1963887,
    20204849,
    1963675,
    1963895,
    1963814,
    20204804,
    20202951,
    1964040,
    20058802,
    20203449,
    1963788,
    1963863,
    1963855,
    1963982,
    1964071,
    1963671,
    1963907,
    20202980,
    20202956,
    20204922,
    1964036,
    18048198,
    20058844,
    1963717,
    20203439,
    11400867,
    2069509,
    11400881,
    11367201,
    11400852,
    2069759,
    11367186,
    41069905,
    41069937,
    41069791,
    41069802,
    41069824,
    41069897,
    41069862,
    41069777,
    41069929,
    41069835,
    41069921,
    41069854,
    41069881,
    41069744,
    41069945,
    41069846,
    41069913,
    41069873,
    41069755,
    41069889,
    41069813,
    41069766,
    15104111,
    9653784,
    2089282,
    15104117,
    26277,
    48986512,
    48986542,
    48986559,
    41709730,
    41709776,
    49259450,
    49306568,
    49259442,
    7082575,
    4434066,
    4434011,
    1600254,
    4434039,
    49970564,
    49970619,
    49970613,
    49970590,
    49970600,
    7082538,
    4434029,
    7082515,
    49970570,
    7082557,
    41794972,
    49169082,
    17909896,
    49169099,
    49169093,
    17909904,
    41795738,
    49169118,
    41795732,
    49169125,
    42060102,
    17909900,
    17909889,
    17909892,
    49169071,
    44735045,
    41794965,
    49169135,
    50535771,
    2088491,
    47673787,
    47673715,
    47673794,
    46237675,
    47673606,
    38974445,
    47673647,
    47673598,
    47673630,
    47673722,
    47673679,
    47673685,
    47673701,
    47673731,
    47673809,
    47673766,
    47673639,
    47673756,
    46237691,
    47673802,
    47673692,
    38974429,
    46237660,
    46237683,
    16791740,
    16791755,
    17679345,
    16791764,
    17679497,
    17679480,
    17679448,
    17679354,
    17679464,
    17679336,
    16791746,
    17679327,
    36662481,
    36662446,
    36662498,
    36662427,
    36662465,
    19945029,
    21946499,
    21946296,
    19984826,
    42015756,
    42016123,
    42015771,
    42015750,
    42016147,
    42015765,
    47604024,
    47561688,
    2069001,
    47603968,
    47561683,
    47561537,
    47561084,
    47561112,
    2068919,
    47604037,
    2069005,
    47561383,
    47603984,
    2068914,
    47603545,
    47561506,
    47603976,
    47603495,
    47603108,
    47603537,
    47604016,
    47561499,
    47603529,
    47604044,
    47561129,
    47561388,
    47561530,
    2069124,
    47604030,
    47603487,
    47603503,
    18668447,
    1991849,
    2058059,
    1995312,
    2058046,
    2057964,
    2058037,
    2057933,
    2057981,
    2057972,
    2057943,
    2086926,
    2086916,
    2086954,
    2086906,
    7780108,
    2086945,
    1967777,
    1967730,
    12587887,
    1967781,
    1967742,
    1967734,
    1967789,
    1967746,
    2084277,
    2084297,
    2084340,
    2084273,
    2084328,
    2084324,
    2084285,
    1986307,
    1986350,
    1986356,
    1986313,
    43443700,
    35199151,
    41458329,
    41458341,
    41458335,
    1971702,
    1971531,
    10822056,
    1971523,
    1971499,
    34219930,
    34301126,
    18777112,
    18777128,
    18777132,
    18777116,
    35323456,
    35323471,
    35323641,
    35323624,
    1959266,
    45641407,
    36320640,
    11652650,
    12593546,
    11652636,
    12593561,
    50535792,
    367100,
    44136448,
    33746033,
    33745982,
    33746047,
    34502149,
    33746040,
    25337164,
    25337158,
    44136203,
    44136184,
    36704531,
    45130523,
    50536062,
    16573610,
    2087734,
    38724463,
    38724453,
    33745716,
    49681471,
    41236790,
    18777218,
    28091771,
    50252565
  )
  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.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.product_id IN (27947471,27947490,27947465,27947484,27947459,27947496,27947478,1614101,36095702,1614137,36095866,1614485,51733776,1614461,1614413,36096005,1613676,1613795,36778784,36778854,1613983,36778918,36095770,51733863,1613640,1614324,36779157,1614312,1614155,36096071,36091742,36095606,1614167,1614258,1613688,1614019,1613867,36095942,36091878,1613843,1614449,1614294,39951870,1614013,36095791,36779079,32381308,1613849,1613995,1614001,1613682,36096025,1613947,29570869,1614149,1614300,29571194,1613837,37242249,51733902,29571134,1613989,51733547,36091776,51733715,1614467,36095468,1613670,1614330,29570875,36779034,36095917,36778983,36091640,36095677,1613861,29571286,36095588,1614306,51733945,1614455,36091693,51733629,1614173,1613700,36091913,1614479,32381314,39951878,36096097,36091943,36095501,1613831,39951817,1613706,29571128,32381359,51733821,36779118,36095848,36091844,32381365,1614143,43184465,32149472,20889110,20889104,20890062,15972952,15972980,15973152,15973100,15973246,15973016,15972870,15973282,15973128,15972984,33542283,15973148,15973230,15973242,15627944,15973209,15972847,15973000,33582485,15627674,15972839,15973116,15972874,15972793,15973104,15973222,15972815,33541970,15973040,15973032,15972909,15973218,33582557,15972956,33541912,15973213,15973012,33582545,15627736,15973172,15973108,15973250,33582575,33582539,33582587,15973238,15973201,15973132,15973112,15972996,15973064,15973226,15973294,15973020,15972819,15627948,33542379,15972811,15627732,15972905,15972972,33542347,15973028,15972992,15972789,15972944,33541883,15973180,15973234,33541853,15972843,15972781,15972882,15627582,15973044,15973274,15972940,15627662,33582599,15627666,15973188,15584049,15973080,15973084,15972851,33582521,33582515,15973060,15972988,15870553,15973024,15972823,33582509,15972785,15973184,15973254,15973193,15972878,15973197,15973068,15973072,33582497,15972901,33542251,15973076,15973176,15972976,15973036,15973056,15972968,33582605,15627960,33541941,33582527,15627964,15870557,15973266,15627940,15972948,33582503,15627823,15973088,15973278,15973120,15627952,15973205,15627956,15973168,33582491,15973262,15973290,33582593,15627670,33582569,33582563,15973258,15973144,33582479,15973286,33582551,33542315,33582581,15973270,15973124,16273839,17811238,24820573,17844819,24820876,16273822,16273830,16273836,17811235,17811223,24820579,24820900,17844835,24820888,17811226,17844823,17844827,17844815,17844831,16273833,24820912,29263566,16273826,17811232,17811229,1963994,20203434,1963974,20058827,1963940,20203444,1963725,20204874,1963960,20058822,20058797,1963665,20204820,1963768,20202991,20058849,1963822,20203386,20203418,1963899,1963944,1963705,1964081,1963802,1963691,20203423,20203713,1964054,1963772,20058832,20203381,20203413,1963810,1963762,1963859,20058787,1963713,1963875,20204892,1964046,20203376,1964032,1963934,1963986,1964089,1963887,20204849,1963675,1963895,1963814,20204804,20202951,1964040,20058802,20203449,1963788,1963863,1963855,1963982,1964071,1963671,1963907,20202980,20202956,20204922,1964036,18048198,20058844,1963717,20203439,11400867,2069509,11400881,11367201,11400852,2069759,11367186,41069905,41069937,41069791,41069802,41069824,41069897,41069862,41069777,41069929,41069835,41069921,41069854,41069881,41069744,41069945,41069846,41069913,41069873,41069755,41069889,41069813,41069766,15104111,9653784,2089282,15104117,26277,48986512,48986542,48986559,41709730,41709776,49259450,49306568,49259442,7082575,4434066,4434011,1600254,4434039,49970564,49970619,49970613,49970590,49970600,7082538,4434029,7082515,49970570,7082557,41794972,49169082,17909896,49169099,49169093,17909904,41795738,49169118,41795732,49169125,42060102,17909900,17909889,17909892,49169071,44735045,41794965,49169135,50535771,2088491,47673787,47673715,47673794,46237675,47673606,38974445,47673647,47673598,47673630,47673722,47673679,47673685,47673701,47673731,47673809,47673766,47673639,47673756,46237691,47673802,47673692,38974429,46237660,46237683,16791740,16791755,17679345,16791764,17679497,17679480,17679448,17679354,17679464,17679336,16791746,17679327,36662481,36662446,36662498,36662427,36662465,19945029,21946499,21946296,19984826,42015756,42016123,42015771,42015750,42016147,42015765,47604024,47561688,2069001,47603968,47561683,47561537,47561084,47561112,2068919,47604037,2069005,47561383,47603984,2068914,47603545,47561506,47603976,47603495,47603108,47603537,47604016,47561499,47603529,47604044,47561129,47561388,47561530,2069124,47604030,47603487,47603503,18668447,1991849,2058059,1995312,2058046,2057964,2058037,2057933,2057981,2057972,2057943,2086926,2086916,2086954,2086906,7780108,2086945,1967777,1967730,12587887,1967781,1967742,1967734,1967789,1967746,2084277,2084297,2084340,2084273,2084328,2084324,2084285,1986307,1986350,1986356,1986313,43443700,35199151,41458329,41458341,41458335,1971702,1971531,10822056,1971523,1971499,34219930,34301126,18777112,18777128,18777132,18777116,35323456,35323471,35323641,35323624,1959266,45641407,36320640,11652650,12593546,11652636,12593561,50535792,367100,44136448,33746033,33745982,33746047,34502149,33746040,25337164,25337158,44136203,44136184,36704531,45130523,50536062,16573610,2087734,38724463,38724453,33745716,49681471,41236790,18777218,28091771,50252565)
                       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
            ;