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

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

SELECT * FROM website_settings WHERE id = 1;

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

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

SELECT * FROM website_settings WHERE id = 8;

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

SELECT * FROM redirects WHERE
            (
                (source = '/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json?nearbySearchId=853967&nearbySearchLat=47.45097&nearbySearchLong=13.61803&sorting=nearbySearchAsc&_locale=en&' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json?amp;_locale=en&nearbySearchLat=47.45097&nearbySearchLong=13.61803&sorting=nearbySearchAsc&nearbySearchId=853967' 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

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

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations/' AND `key` = BINARY 'map-poi-json';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json';

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

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json';

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '21';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7930;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7159;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '31';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '59';

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11189 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '72';

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11408 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

SELECT
  dacco.isTop,
  dacco.bookable,
  dacco.oo_id oo_id,
  dacco.position__longitude as lng,
  dacco.position__latitude as lat,
  stars.starsNumbers as starNr,
  stars.isSuperior as starSup,
  addressColl.addressLine1,
  addressColl.addressLine2,
  addressColl.zipCode,
  addressColl.town,
  addressColl.city,
  addressColl.country,
  dacco.ratingAverageDirect as ratingAverage,
  dacco.ratingCountDirect as ratingCount,
  dacco.name as accoName
FROM
  `steiermark`.object_8 dacco
  INNER JOIN `steiermark`.object_relations_8 facrel ON facrel.src_id = dacco.oo_id
  LEFT JOIN `steiermark`.object_collection_demiAddress_8 addressColl ON addressColl.o_id = dacco.oo_id
  AND addressColl.fieldname = 'addresses'
  AND addressColl.addressType = 'Object'
  LEFT JOIN `steiermark`.object_68 stars ON dacco.stars__id = stars.oo_id
WHERE
  dacco.o_published = 1
  AND (
    dacco.town__id IN (
      11195, 11196, 11191, 11194, 11190, 3192509,
      11197, 11409
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(311)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id, dacco.position__longitude as lng, dacco.position__latitude as lat, stars.starsNumbers as starNr, stars.isSuperior as starSup, addressColl.addressLine1, addressColl.addressLine2, addressColl.zipCode, addressColl.town, addressColl.city, addressColl.country, dacco.ratingAverageDirect as ratingAverage, dacco.ratingCountDirect as ratingCount, dacco.name as accoName  FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_relations_8 facrel ON facrel.src_id = dacco.oo_id  LEFT JOIN `steiermark`.object_collection_demiAddress_8 addressColl ON addressColl.o_id = dacco.oo_id AND addressColl.fieldname = 'addresses' AND addressColl.addressType = 'Object'  LEFT JOIN `steiermark`.object_68 stars ON dacco.stars__id = stars.oo_id WHERE  dacco.o_published = 1  AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(311) ;

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