Symfony Profiler

SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC

[
  "defaultSiteConfig"
  null
  null
]

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'defaultSiteConfig'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT * FROM website_settings WHERE id = ?

[
  1
]

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT name FROM classes WHERE id = ?

[
  "SiteConfig"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC

[
  "mainBlogPortal"
  null
  null
]

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'mainBlogPortal'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT * FROM website_settings WHERE id = ?

[
  8
]

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 8;

SELECT name FROM classes WHERE id = ?

[
  "BlogPortal"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'BlogPortal';

SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC

[
  "sourcePath" => "/en/Plan-your-holiday/Search-book-accommodation/map-poi-json"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation/map-poi-json?nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&sorting=nearbySearchAsc&page=2&randSeed=732&_locale=en&&_=1731473564023"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation/map-poi-json?_=1731473564023&_locale=en&nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&page=2&randSeed=732&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite = '6'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/en/Plan-your-holiday/Search-book-accommodation/map-poi-json' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Plan-your-holiday/Search-book-accommodation/map-poi-json?nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&sorting=nearbySearchAsc&page=2&randSeed=732&_locale=en&&_=1731473564023' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation/map-poi-json?_=1731473564023&_locale=en&nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&page=2&randSeed=732&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 settings_store WHERE id = :id AND scope = :scope

[
  "id" => "reports"
  "scope" => "pimcore"
]

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

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

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

[
  "key" => "map-poi-json"
  "path" => "/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/"
]

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/' AND `key` = BINARY 'map-poi-json';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/map-poi-json"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/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 = ?

[
  "/steiermark.com/%"
  "/en/Plan-your-holiday/Search-book-accommodation/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/Plan-your-holiday/Search-book-accommodation/map-poi-json';

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

[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]

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

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

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1

[]

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

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

SELECT name FROM classes WHERE id = ?

[
  "21"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '21';

SELECT * FROM documents_editables WHERE documentId = ?

[
  4084
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 4084;

SELECT * FROM documents_editables WHERE documentId = ?

[
  115
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 115;

SELECT name FROM classes WHERE id = ?

[
  "31"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '31';

SELECT name FROM classes WHERE id = ?

[
  "59"
]

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

[
  11462
]

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 name FROM classes WHERE id = ?

[
  "72"
]

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

[
  11512
]

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

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

[
  11420
]

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

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

[
  11467
]

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

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

[
  1683716
]

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

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

[
  11507
]

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

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

[
  11893
]

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

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

[
  11886
]

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

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

[
  12089
]

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

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

[
  11408
]

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

[
  11189
]

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

[
  6938
]

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

[
  12452
]

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

[
  29785441
]

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 = 29785441 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 (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))  GROUP BY dacco.oo_id  ORDER BY  RAND(732)

[]

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 (
      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
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(732)

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 (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))  GROUP BY dacco.oo_id  ORDER BY  RAND(732) ;

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,1750679,24580,1970512,24815862,26739995,2457450,42769461,6515449,162891,47606,1990469,30838280,1988731,1979636,1713652,188200,213843,15115425,2079581,26739966,2098991,2457804,159538,30764006,1627999,2097158,7452995,4149175,31116045,1630154,2066578,2074632,3224895,132281,45886154,1989698,266112,1601456,107672,1936897,227604,1964588,7452925,1965688,135252,1173542,2104698,9394208,2086582,47247472,1605324,30479894,26740045,1827525,170725,26739827,45503,100829,139042,45143324,182335,2486062,81720,9629647,241752,122307,1990403,1966219,4061962,181045,38300874,1905995,1936326,26739976,6614248,43125,154301,40661069,136526,1966896,156617,19812,1618898,127946,59655,1950811,2697535,45430771,1964833,2097658,23720,26740121,74757,30980,5128432,1930130,209807,262167,158481,18743458,8566620,7512292,26740233,1974719,26740055,1953156,44404593,2075186,1749742,192284,174035,53239,79494,1954940,1990285,1948401,80881,1744741,2457187,266061,1968807,1713989,2661674,99678,22680307,15419107,122527,2104688,2093030,1968789,41793,39669088,15103887,1712581,208283,1627038,2433263,227270,52727,1625639,1955319,26739881,41879,244711,1976710,119029,221211,119718,7041608,45233699,5418389,47978187,2458315,1616336,129250,110435,31843325,1620033,2078764,42785,2080289,2100103,191815,247088,46529,205897,1828794,1972586,257550,2093101,1947355,2098488,34013,156053,10374087,74091,1624427,1968001,1968641,1937469,138736,11245625,2089077,1645934,120883,1750798,35617129,2077975,31719532,19587,1746070,2094828,1567825,1568208,217510,162948,35757609,2655510,1906112,1954995,1906766,2194020,127993,242014,18777989,82521,32356610,3032193,173543,1623749,222689,20627345,2069224,384041,120483,1947283,1729389,1953959,205363,39599857,1738785,150349,43641,1984347,23055,2079525,1616249,2404244,94738,1616081,150268,91479,2074827,39312810,26147003,1632008,1959845,2085600,1986716,10680223,30765443,26739942,1567017,2081964,117916,1906028,260291,2587910,1968884,174737,1948710,75414,34961275,146288,4791432,2103087,1947373,77223,26890,26739932,2457383,21211748,2454764,1845849,162146,7452890,2368235,74534,91149,1627570,20926250,1988207,1968595,46968,96112,24793,1616614,2100448,48804066,1729848,10039806,103526,12578480,1948486,41649,44780416,1824754,263475,2096844,1906189,105748,1957246,1965841,34716,179680,1615674,1746966,100682,80548,1825302,204745,1733895,229397,1950095,1747740,1743288,9576144,213869,162361,2074707,45479665,228572,18165472,1955936,26740015,2456499,1950128,202202,18746,1646511,1951675,212470,36327,247897,1969164,39998,7453002,2058512,45167318,227558,1643222,74297,39908198,114455,26740005,17676,18778011,2100087,1829479,4062700,4061122,21284,1980881,1733491,33321359,31406340,2083559,2664864,43065,32460992,2404275,4062806,1567028,11928644,190401,1823171,41643929,95872,1907004,27807120,245240,6771981,149216,149098,29614,190383,2100256,40473,192306,1742316,22968535,90455,8745860,49585241,1945611,19115,1630109,3022806,111233,1968545,22568743,15136578,1626974,143785,4820748,218293,134210,4061812,12212021,96619,1821635,135345,1994545,172512,25410808,36640511,18743300,242085,34024549,1739422,362789,1824146,18777967,77069,49874948,1952542,74473,35322667,2455688,22452518,109732,1739032,31077072,26739952,257470,249659,1974380,150639,1731831,256818,8728584,48804069,1624458,201319,10680394,1713553,4062328,16648129,1714950,195113,48557901,4704521,7970607,5418347,180504,1728976,11825924,35313684,128777,1634962,195386,23455826,147152,1994480,42769482,1951695,1957466,1645676,4062502,1948065,35566,192497,2659058,187460,1955197,7969044,9700322,122580,182441,2078992,31967,205493,2530025,130049,124337,27199439,3402151,2076985,129206,86879,168676,2093462,46578,214015,5315068,36935,235840,2673648,17120,1627365,38423,227765,2081071,1935804,1972047,45797,1946839,196032,1716696,1630519,26740200,3402215,4061616,225007,41108210,2097271,2458698,11993589,2094540,1962257,24448,141656,210751,9159056,1742817,1906035,1974414,218076,42724880,186209,146983,1734194,2086854,9919871,11687134,6797421,124606,1993878,1952101,42682901,1702924,1970440,1969409,250658,1952424,145685,132768,1968497,43581664,9290146,1746508,49497910,1599922,1613120,217376,383672,1635550,190061,1730951,1633707,32806,1981594,227134,1621941,2092540,2097480,21577455,14012385,1984126,1621181,1742553,1824536,30354,164670,39297,47921,267915,1622382,1615308,18175240,214424,18230,3089986,1991966,18776204,383256,39377,33905,2078747,250318,1960995,1828716,8722785,26848408,1969267,1750886,2673541,14659516,1980584,211256,2098069,8746207,1986795,141729,26739408,1953843,43443153,35259362,1626927,1646975,1635377,1616296,26306220,263995,2099401,252859,1621086,26739900,1624562,1989734,220238,1733314,1635442,1930168,1614713,1629739,2457692,2458275,1627273,1906747,124237,2457105,27066899,2059447,2674021,1712323,3379737,1942388,26739832,1953332,1616225,113408,4063709,96354,1620087,179813,3379852,4580718,38670305,2676863,367300,247967,1825448,145003,2453987,1740354,1905954,142573,1625875,166529,29658091,151568,163153,1621683,1970683,2454928,2102674,26740117,1601425,1821748,1615190,190504,1965803,32298578,139196,5367477,2308760,1739549,39811619,22621551,46201539,1604133,81346,1627739,1603697,118392,1631995,28867350,2080373,185888,205753,1976408,1975374,1735769,1601128,1749431,16975,32979366,1823539,1620892,1950174,2083636,114734,7453016,2096916,28278,41643953,34043087,146397,1969702,2100329,154608,363284,1750182,81984,1713496,4062640,1945387,1947387,267580,1619289,15136325,1736761,29195233,26342382,1641782,2084688,35330412,17015951,1961516,4062128,12665315,192033,202800,81527,1989882,154821,6497553,173273,1620528,89549,47158211,186138,33321369,367148,228314,33623528,252035,96059,151257,1966954,92184,26898515,45319,1627793,1743486,1733811,26739413,1625445,1988937,42724838,51503593,73645,6553921,39231,76033,195558,89565,198592,91299,191407,4061338,1992394,128052,21327,1739120,1950753,145258,1602438,383286,1933865,1942414,1968484,1632608,210612,173602,1824813,1568610,1626162,2065496,1623678,1994889,1625909,1907413,1827779,8306877,1743089,20847844,7541413,1729325,1980873,91914,140833,144860,26740205,44172,17208005,1625429,4061376,1743705,170037,73395,43433,259918,1713325,76562,91521,159639,12894885,26477859,86434,4062000,26739841,95383,2696852,1633887,48663405,1968982,34372366,8722782,12771836,1618763,13235747,2084861,143448,27820,1613183,29585,1714377,41752708,150008,2073691,138273,1735663,195314,1744492,118621,2097194,1748280,42811899,1907399,1604964,48897445,149642,14049003,272389,26740170,53159,51021493,1734343,1906546,5367350,1736996,2082077,121463,1632225,2662461,202479,82419,224600,1979772,2104304,1735385,26740040,81316,49189,109501,1970366,13400708,17626,2082312,153833,272624,1604752,1716637,1994096,1614871,2103381,193149,31896277,123820,1943586,171586,1906209,204342,1828510,180387,55167,29788089,1615601,5612646,27807955,1948646,1953112,2457960,36160,273143,1990181,4063160,42724847,2530034,265768,1954551,1730694,36617,2673915,11367104,1633774,48563836,16889,256504,2104833,28828,2077788,196083,1906171,47601194,6553923,271621,1641970,223044,25723022,1948900,1833139,2075309,7452932,170902,103317,42724832,194023,2674165,11367489,1977743,25089373,265255,1989922,1748682,199295,188894,2077723,180106,1750841,6342567,49229,5367459,132556,1826683,50929972,50929981,15176332,208902,29788817,162969,1637479,8925508,2099497,51238225,37868894,2453569,240386,1612786,2099002,1995257,4149203,36619529,26740135,4063373,2059839,1615522,26739383,144062,1616440,9700325,2086836,1634247,193721,1646822,44224029,2075753,1738996,198814,117802,1621213,28018930,2454859,73900,2076811,1823090,33002559,2458107,362224,1829717,11892410,40695402,1986433,29699643,208674,21862384,2065944,165937,76116,29311463,164128,46409424,44032105,36598477,1567581,1713460,1741019,1827876,1603081,1620737,43822465,1567091,1730678,2078864,259743,3406278,4062912,1739660,101745,20512295,11436541,2418919,1632429,363436,1974937,21659,106040,2457590,107555,40739599,1961622,108105,172317,11758096,263240,7757553,1629078,1940948,21285943,202332,75853,26740112,2095239,2091589,167765,242919,47710,2059260,176296,2103968,10990613,202588,17877742,42581,73764,1745241,4791435,94222,1824494,131018,124829,2058868,1601381,1634534,103365,1739806,2087497,1612895,1824068,41198724,1743364,1612661,1746456,1823821,2194164,1976860,2080795,50330126,91843,1612655,1971885,1947826,1634918,1625388,4062664,46236871,241333,1943137,48368127,1638661,1630256,49723102,1639729,48313377,2087883,1982334,162257,50330129,265826,4608272,84906,2098329,233730,1749936,90791,18721781,38928823,22149472,179242,30465588,213326,2587898,189271,1964566,31077769,144833,4061075,48320437,26739910,15465861,172278,1828920,1173742,1830380,52476,1821740,77403,178072,49158,36492,119873,382743,1646563,2103431,44587191,205724,139070,12963484,185864,1964801,1638406,209921,269658,1980389,7453037,1648586,2101292,39454,269023,4580781,242964,1829934,362476,31259,9290160,115902,1631781,1624054,2075683,41680612,17904,1634862,42682885,176727,17462725,1612780,36655,164711,26740330,2458372,1620627,1951414,47247,1981017,1906795,2455620,49681004,1949966,1615272,1747963,26739971,1955727,27998615,7452974,124694,2078142,51216654,46852469,80940,148211,1616313,1987314,221094,1932470,2662512,1741277,1980811,261585,1625225,1828318,229095,160614,1748874,81217,3359223,1743804,7453128,51333826,4553064,246469,206894,2457195,3429558,6497598,1635495,121638,1745175,3259747,148779,2309544,177255,7186183,2459254,1619113,1626378,2095895,228197,2456775,1824908,1628839,256037,207942,1615985,29649833,1740806,201425,11106490,1944200,196249,175147,266549,15104158,1976273,1979290,1943475,1982263,2458797,2060738,26739986,223466,52801,140325,2077625,7941416,30205115,2068685,1568474,1648428,1936218,1731048,1944279,1951749,41842,35658710,48891238,108780,2087344,2459044,1987585,1962451,150874,26739846,49548934,2458220,2080902,1625179,18776639,238918,1618672,92309,2095526,164234,42478172,43472,191516,185439,20023418,189226,1633994,1639599,47257351,1983752,118332,1625496,1628215,24971,15692025,1974528,262837,157401,25724,1732456,109374,1173653,147609,1612792,2470567,5367405,179767,2310347,1939308,249733,125739,108989,267501,1627958,29829,2103859,103833,42724874,195752,125266,1748970,2455321,2456226,34270,2063196,1965726,2096933,1727824,4061779,41188273,2459142,48417638,1616064,26739957,2063091,1742891,74121,4062830,154051,2529886,210439,1930161,1635895,363214,10684637,81753,130799,173923,4525596,188163,1988347,29903,2454629,55242,1605293,3283083,229314,1955738,27419533,268989,2102784,224332,1951232,2104085,362951,242072,155356,267678,1619082,209483,22775,251539,175792,84439,136555,1643921,28035682,9490401,31789631,141808,29671,45198113,1981655,2074772,97423,1173892,26740175,418173,40066879,150752,1993242,2669577,1959004,1730657,3045210,271832,97982,220877,150701,44782,32108,1643509,1907420,10680500,1972784,2085249,1976549,1906916,1946548,1941268,1939108,45756976,26740035,17184421,1615619,4442305,1986758,1631240,1743226,259359,1742539,48663392,34887538,1906066,40425,145447,1959380,145409,50086,1938936,22892603,1980321,2078155,48675,4062150,1612643,213925,143351,20926241,41305644,31291,53347,177391,157466,2084957,2100932,1740164,77134,1951116,1737844,1645091,46316,2669983,2075819,6142093,31625,209859,18891,1146711,31203,1988139,193518,2691122,1972880,52545,8844791,1974078,27066902,1830603,1644507,194565,2095560,36095,220755,1645885,2086783,192391,19054,45756981,240534,1742903,22916,201863,17594470,2700465,26740070,134831,134439,7018201,268162,151225,79926,2074117,1568590,204651,53418,1730704,125397,7453009,262376,38008495,1746888,48319918,2458412,1976587,1713138,267314,18777666,178500,52769,146183,7938552,130741,24242,2078081,25942,266360,227190,26740304,1952359,25025,2062596,197746,26740060,1729176,26740102,1624490,10141050,225305,1625303,9872791,225195,1948166,1955705,89709,45911208,2066582,1715444,43184382,3259752,204827,20969330,2096996,1957306,87856,2458294,147033,2075353,2074958,245926,1978760,26739388,32570986,11329889,1906561,83605,46703369,208932,1953564,200283,36427,1968072,1906009,2454613,50630461,1824363,40480657,18776659,44760927,139671,28256420,1628483,2530373,7453190,1965642,42114,1616477,9108294,1826269,115223,1931733,261884,1976977,1601222,2673544,362238,31514436,260733,90285,81639,40818577,2079240,2655626,1612675,1624776,1823239,1746105,1745277,41494,1738782,1961566,136496,83176,43484376,49619462,25984203,12253627,210718,19558,27858940,265305,2095926,4580806,15243082,4062930,33100,18777677,1737987,1728707,32802,1958743,18813,1633182,228856,223285,206641,1942882,1993788,1960869,2655655,1613127,1993946,160203,1821686,1730858,1940778,189598,1930118,1934672,9520223,116231,1743467,155228,176457,75482,121033,1624685,269401,205629,263626,268424,19244,36640534,1743173,1633762,36278962,185795,190920,1621646,51213710,110254,26739438,33664677,2456405,166027,2458151,1746188,223960,1993209,77600,48050342,1944838,31050826,1612687,16854,243999,222748,1739830,1984760,132156,35238,54374,176897,1745085,197648,1613038,1739372,21824738,263716,2829775,1627654,1943997,1969581,1975952,37827,2457241,4063277,6497550,1990830,1616142,27961045,111742,169035,261090,41003922,1942177,2674068,1982404,1619453,26739635,1622267,247180,1823444,107057,175690,1975571,154758,11993553,222491,1822022,175902,11993564,46284,48716,1616507,106094,2084025,129897,47196812,129814,1821730,1932702,1742867,171164,194713,18290,1984665,4061468,240646,1906852,245352,195347,18743480,169666,2077909,1980623,363511,4062676,27187816,1954353,135403,1622191,48625748,224446,19359405,3176489,264448,18332685,148376,4061187,168470,32689,105477,1906073,45916289,54464,1906356,41239,224773,193068,26337,1978070,75600,89073,88688,9455693,2062975,4062032,151636,9495222,1619615,2066719,177157,1987680,1905902,2097383,114041,189166,12253807,139730,268018,1942484,1963035,74030,211759,2457137,42766841,1967131,42396774,27298,2671474,8776246,7951197,18777699,52980,2089643,148899,17418,1949086,213358,1969455,2097352,1702984,17208002,13026962,6771978,1954000,107859,1734285,192003,135519,1633506,30192336,39226898,2453896,36619704,1823052,29789564,13377190,20108,2082220,30448600,1930310,1947728,35206879,1602987,2670780,1955017,1734240,1750647,1964399,8618578,1906044,9624503,1627590,2093671,40935234,35677466,155492,1946429,199572,128254,263334,1976486,26739822,1906052,1748613,35736,29658071,40818571,1731437,32341429,145830,46636,1972735,2076905,9667712,1906454,188242,146129,245508,29827678,2088601,17275737,45756971,1964721,172344,1823654,1627169,19763617,245836,2457950,2078892,122718,114017,1983915,4062249,50135,2080600,18250396,35989,1744299,37308,23827352,8870626,25500,2104791,268951,2098724,199934,2457118,7452988,80315,18323640,1621280,1630452,22475,109291,177852,1626047,4061087,1978232,1634940,49758724,2074396,182314,145352,1946296,135205,1948260,50975869,18743289,179171,2104901,24629767,39338675,36531205,22441,19612,116132,1945246,18680,212715,7599407,2059361,1975076,88601,4062325,1736494,1615997,2458056,35666828,76427,1933727,1993438,48569875,11432158,139974,1634078,1985522,79343,2458323,2458566,2078594,42358761,1973855,103348,1736723,1944638,111370,6497577,39225141,1989189,25806,26740160,2084894,26739418,202690,1981054,2103495,1963049,45112981,125952,39069619,44831,1952660,1939951,1954644,38973570,2455657,104583,1619716,1644484,1648697,2093780,84542,2669356,10261747,88890,26739447,227403,2455815,1602100,1640532,1940590,1736356,42682891,1974755,1604437,190150,1955476,1750906,27866430,204204,1942441,43751656,1955415,212320,1971852,222898,1827242,1744268,261973,3263475,39922,1632798,162100,31613769,2100004,269473,1735975,49580925,156680,1625983,2073379,1620355,26739531,3379718,1612889,49539249,1628028,2073619,25101,2103814,135730,2663247,46733,181966,2454738,268279,1712819,17770044,4061211,2099417,1747672,42724868,2088936,181441,1612635,84734,7738339,264897,23455755,169525,2433398,2081934,94870,33992180,1615547,1628609,1738871,1619257,206198,220483,8924349,218042,17811174,18743311,151676,1604586,28875683,1605354,2059767,267186,1613013,42811912,9529160,1987095,2089778,4062757,54660,117486,1947886,30359,12663360,46450,1647500,2098691,26740030,9019876,1934349,1955577,1994693,9484915,1934723,1743243,130455,182482,48416900,166076,1906859,12910566,1646258,53948,198187,4061766,49875366,1952871,7780777,267530,32658,367391,186236,18777721,383292,48662436,29789097,1960354,165965,1624206,2073473,1971191,2092835,363263,5315087,49387,1628266,2194032,202099,46992771,6775712,2102419,39995931,146259,17275786,26739452,48319456,48208705,1602028,147399,143260,19763638,54166,142725,1830434,156762,1612667,1741776,4063767,2069310,363505,17058949,35740,1631899,53913,1824745,50660470,205199,178337,122838,2084064,172618,1616053,161664,3213244,30522747,24173653,2100307,1944935,28876,176992,49276,222266,2456739,4062381,1906021,1736122,1630912,1745878,15116614,1948847,220655,229144,143596,1639682,6612349,2104811,13948636,2459391,122780,113462,168884,248414,272273,22680295,2458981,2667097,1829134,21859,40739591,10672408,249413,130955,75959,1742525,189988,1627892,48610530,42769488,1627443,30565,170874,4791485,1625285,203308,1952996,1612971,26740097,1934252,2455032,30177468,1969741,1730586,16192461,1969382,32550,1742732,35859506,1906838,1948687,173880,1433530,17354,28920,15201310,1948414,50345014,38290359,252403,218149,1951313,2670885,200906,2098651,1568525,259576,190546,1736412,7452869,2529880,2455960,1733775,1829206,20188,87071,18810400,2104757,1713102,1906901,144028,1745374,151031,139584,1986581,1602757,2103465,31117139,1713950,45252,1947198,2060384,2453808,1605263,150197,1614778,1932966,7452946,42060036,48753192,37365,131135,47650472,1614803,1745650,163235,383118,28470795,31422,1600537,1825519,219012,185065,1993811,247473,1981033,46409417,170765,2084234,1950988,1619430,50341773,160845,1828934,146703,21273299,267851,1955200,2530046,2458026,79701,23898669,40768,1823609,36640514,9455321,9629644,4525581,1635028,142528,1613053,7453051,31116306,41634802,2368223,1623492,189670,96924,42724854,31116650,199742,1986946,1616532,2079352,19857,24874128,9665940,26739398,129533,1971387,32356605,1735857,1988874,2457048,52190,1989224,37667633,1740988,2089848,2104019,18943,1616374,1978012,174091,37260090,1616557,1821823,7453107,121323,44528295,1984508,1750909,1646091,1567553,15468314,218375,1616103,2098617,35522295,1938100,227046,1939806,223395,223733,1632826,1931829,1987293,2087282,219686,32996115,50325,1985114,11213989,221382,231694,2673150,50194,1616423,363560,1727813,142897,1964207,1989517,1962754,1940920,1950645,2458180,114505,120314,128612,9684290,1827458,1744618,10106915,1628231,41655076,1638201,141037,262061,367184,261338,6553925,2457745,174987,2098283,30525605,7969782,1936689,228125,36258298,100061,1966779,156225,1964932,4063386,1938835,2081507,21236516,2083662,1906305,206854,100623,28867353,31665450,1741842,19763596,160345,1962474,175610,383360,273030,16993556,1630285,49790,190210,1621992,191428,2103223,97116,1955046,17541,254825,2100055,47693113,44781292,29311567,31116608,43758,2458008,208002,30751,45344641,1950667,180306,1733525,254732,98121,1735710,15419098,42829790,2104851,143038,189797,1950224,2070746,1938666,1637797,2661087,27066893,1986219,1985415,1603030,6995557,1740105,2456727,1634280,1933801,164627,37868363,119097,36227,23435,42105593,39621948,177240,2101765,2086322,1906802,50536907,1635138,2103756,31215812,98021,1821899,197835,1737589,40818583,1823715,31820476,2079104,17469346,1945097,1986509,1949915,111071,1906328,255905,1945680,23106643,30192347,26740210,1991413,2458779,42682912,154459,21984508,1612964,31406343,261943,113819,194960,219765,1742632,31569228,30629016,227572,15498026,43384,1990037,2082293,210702,1948700,25414206,1736068,1736352,50631523,1969057,2457632,260555,1737009,1955273,2692476,75680,227892,32751,1702930,1989012,219299,6112501,4918601,1615743,1943381,2102038,1994800,26739443,2102509,12149352,1630724,2457782,2695445,6497583,33768,155598,13979961,117438,14055216,1967445,17526524,2099474,1621542,1637831,1946779,1744680,1623305,1632452,1737173,1931758,1946746,220914,38480,1630848,1612819,117646,2082358,1622610,207109,88291,1944896,48897791,2064513,1626682,30576713,1627633,2077282,149155,17068,243209,9238291,6342564,2098097,14557855,47247486,1972698,42339673,1738191,383139,120394,26739981,1944324,261287,2063414,163958,2096901,1959616,1976775,167986,147332,26740229,87899,19475,27631,2103832,1821629,1972169,2309712,5957905,1955377,33363840,2104824,1635256,208109,2073345,1906696,2089707,47698731,26739403,1625728,1944590,2094594,7449751,30841045,198380,129096,128649,1624928,13768757,2099763,46152494,197250,97625,135012,1744231,1748326,146486,254301,126983,2074228,86586,1989465,31340,1964309,4442187,122101,2065999,1739520,15843263,1933417,1967421,2085415,1948522,2194150,2076325,7364155,174583,4442181,147531,77357,13723644,2458404,1712193,110779,26740150,1972326,91679,1970969,1985351,87970,40066871,1630992,5612896,1612807,200126,1966648,2101221,198994,1905966,49304666,9054218,36985954,2104798,41278917,1827922,1940444,6356118,17071511,1623990,1964612,1732510,115545,1646646,1953708,1617658,1937824,42444600,4062628,41935,226049,195537,1947435,25114536,1643072,47644595,195225,111091,2081355,15187823,262617,1955042,1616483,1952711,1988269,1969075,103592,220170,209194,1987973,2456108,98639,90672,2102926,46206,21363,214433,2074900,79030,1173161,78974,33451,1987442,1952246,1949501,45375,170518,12141191,1715485,5949155,44781642,1625771,1626894,2455852,27808188,265878,226215,95803,1616367,20962005,2100430,31077191,171978,191937,39083,30482936,1981704,1967866,1943815,1713829,29907,1729604,131839,29789987,1713862,222458,31116285,1732017,204776,185598,1954907,1968062,7217358,2088227,2457931,15221891,41406325,3379819,73135,41453473,2090846,83792,29789889,33898,106445,46904062,223447,2309376,1989832,1742359,26740079,1733826,1603255,11364731,43384756,1623716,1953810,226499,241670,157521,43414,30400,87314,226395,103051,1600091,2530049,145494,198534,1829797,171662,362915,384128,22868106,2099659,26739837,212066,259974,26851,171964,1964869,1645256,1743691,1747228,223613,26739782,9576135,47614112,383027,1946528,1744087,2310556,1633380,1949730,1954921,5554733,1729762,1906719,1601806,1985962,1824952,1973431,1737642,1629269,42811918,7678621,132704,209351,1970810,1634574,362272,19472755,162327,1934294,2099215,1985660,2099533,1941538,32582,31960,253709,157224,1712283,1731019,1616117,1741295,142776,6648868,156120,2081799,17670,2080254,1632749,97550,1957805,1633581,1628901,225114,186869,1616087,1981153,220200,1633155,7016779,221136,27700476,1959487,2075527,180460,42724862,1971834,363337,198307,1714772,23077,1944971,1949477,2085791,2457275,220948,1821692,9566387,207763,117877,22003,26717,2062684,1943182,1749206,156464,31772,76091,2070983,203617,34636746,26740025,2076379,138703,1737274,2102337,101229,39198,2083146,1603557,1630358,260943,2065098,244042,47650481,42655,1983110,1617964,42753173,4063525,31115865,1630959,1612882,26956680,31341041,204161,42085312,4063051,30806616,11366305,27167031,208831,3121111,187180,2087757,27972191,1729443,96781,2070586,16605339,267623,1631106,32147,2079717,1714881,39952681,89261,1749371,1980474,31116495,161142,2101243,2103560,2063745,219157,8388337,5367394,26684353,2103326,1616740,18152,1981496,22680304,1642524,4061656,1824854,1969595,90830,41024653,1942503,39355239,168744,1933088,20059276,26739378,2529898,228288,181278,202554,98441,260508,2059088,2458552,50388225,383497,12910729,30148041,187408,85808,143202,1622536,2100970,2670053,1822005,30773134,362207,25413382,31159141,1735985,191210,221512,1973018,142948,4704486,1624824,11185192,22680298,1937692,17227,1750628,31116629,1146742,7452883,2103395,174338,35456,121533,2073574,41305633,1635097,1603635,50692778,51735516,8695297,1906816,4791491,50593655,243839,4791488,47240616,2194254,2059571,41615,15659243,1603799,2309430,383578,29787925,54798,1982005,11644081,2066268,47158244,1742341,51974,53474,7452876,24781077,32076506,26647560,29754,1732231,367388,45794146,31747387,245659,250245,13418149,36664,196171,1568077,1970018,161033,9887645,1950333,21427,6945367,12879304,17593634,1932776,1715597,108003,1986914,176244,87219,18541017,1972098,128141,11366349,186259,47698722,135125,1568396,2074334,88772,1739695,34969921,19725,1616498,32938577,166311,1979472,1930304,248735,171431,2101927,1628124,45923,1736174,1823597,1743927,113626,34358,17517682,108520,174798,213283,31474,1635202,207780,156310,1735817,22680310,9700382,25522,2080986,182728,4063461,18355899,1967010,268827,1648548,1977210,1945937,1619305,48265993,37911918,1955919,42433218,1600895,1627828,51151,1965236,51358271,192842,4063201,50878032,155984,2458065,25851748,1732419,1616205,1970266,176111,1976072,229470,13818591,1984904,1823188,7968981,1931105,211891,18776174,44869050,2310457,140059,12948653,1627127,90325,34920688,1947551,133017,173849,1568248,1828360,2070894,34719290,33072197,19158,14383937,1747013,1973899,21585,30765378,1822030,1959914,23107117,82805,8694081,1600028,1716290,1941684,1716944,114925,18743357,1736862,1633481,1976678,22953,50062229,2455138,31261223,2458128,1618699,37859,253165,254574,111003,10655859,136200,16552093,1703035,1961503,2085525,1821772,1954411,1615228,27082,5160398,1930481,1640108,1904712,169959,50584316,115150,1605052,46904829,170382,1737665,1746933,1616381,40707377,210522,7599929,1747444,1970788,1976935,1977942,16295655,2102326,20810,29341932,2457980,1621239,7452967,261005,131179,30843,138437,9282725,6553969,5367441,78778,1982912,242815,1568439,26342359,53131,49299937,1622327,47463,2670355,1985174,14623690,1625755,1969008,4442184,2081916,1628181,1967144,147191,176678,4062673,1946098,2082700,2457153,203577,40556,17574337,240120,1173693,190634,77540,1935741,1907049,26342176,168606,246836,38622028,33519,2063458,5732976,115416,155681,7453058,1616259,91582,223652,114251,38583,1628457,25076569,5160343,102697,1965052,22204981,1631532,1971299,1620709,31543,39249742,1742970,1632667,209292,2458331,2456747,1994732,148602,2668273,19739002,254246,12435028,26626,4442120,29502930,75898,1907248,4062202,2066133,1974684,42105627,14600421,157428,2098830,181329,8382758,18861848,2673689,47131,5612752,1966986,2657360,110467,44433919,39558266,1947036,74347,245784,35341,35070,26740247,186088,1987149,1823225,27808178,35206874,2104003,1730031,188297,46237639,1986476,26740294,1978670,83126,2099178,2679537,2060465,2085493,1744374,178599,2081263,19208,175319,12785402,1829510,1628284,1612986,1975478,1626078,1614616,1741980,78111,49917837,1624179,384050,13415036,1995175,73343,2095828,272587,1602156,2663172,1643418,1615991,32662482,1612950,130026,1715510,2453840,1992182,263799,1731339,11993576,2454119,2853499,1991492,3238663,2096778,91812,1951179,35700277,1732163,72244,27189478,2103588,1733355,210768,91777,1739062,241827,1983839,1622416,125661,4442214,205836,1995103,25423486,1905888,27294,42841,1717100,1823467,52068,2454032,158905,21193899,12370461,249148,1601300,1944389,204973,163692,1603143,47981,6110063,1961578,2091555,149455,2193918,44526349,1736055,2097436,96544,9491906,134714,41214843,2684053,2073960,1987270,2101162,1715325,1750146,34831,1954287,272451,1954524,7452953,1612621,2530028,1629150,207463,1712145,4442302,1736773,1740843,197565,1615202,75106,73318,15176277,28929422,44080159,23500,174941,1945464,157149,2086407,1746266,26740050,1737654,18776567,27224568,18776428,9700358,2091472,44050,102266,10664738,200867,260577,1973390,20643,2080497,229645,1965864,1627206,227481,257803,16942941,1955952,1825612,2087656,3213231,84203,1612739,1620205,1975511,2082137,2078460,113751,1736268,1946351,47930787,6553977,84306,14660255,2088994,202896,1634372,130267,1715372,1734330,108195,1823959,1821737,42830442,1944069,1619797,80083,149059,183290,1714423,1954958,1613214,160274,267700,1343842,11328801,1616414,3413534,46896212,83429,4090781,1733471,1743212,138939,36640524,1980402,1600619,33031,181884,2088558,1983086,1949028,1748634,1615509,44660,43604597,45582,225967,7542353,1948234,1739920,1967244,1821723,199364,34219679,251865,44387,10223870,1823376,186795,44079175,1945182,1957403,125055,197713,266814,1986627,1945531,1616447,7452918,192523,1603350,11365151,1612798,1947083,223510,22786995,256865,1740503,85536,39007,1991623,1745913,2659288,1953506,3411816,239438,38050667,29104,27808352,18777688,39558144,2100577,1616459,2611644,49345129,2082202,2064720,242260,141272,18778000,1747203,1953230,41710,37746,1635281,1974607,147221,1628590,1823886,80793,99114,15050850,1826136,179201,1641179,1627511,1743861,50011,124869,47398,187757,1985246,1930954,201802,6775934,1975755,29263800,219501,1750076,1992261,78857,26740325,1620658,1633342,2104858,1821680,1961040,2566254,1733241,4062431,12664872,95043,199538,2310269,1620047,1615125,1974902,2673903,1906059,186921,2081584,1620998,2080323,42144620,1614910,246756,31336,201789,1567898,218235,2077429,4061851,1931440,33002564,50010802,22612,1973664,1621367,33905433,26244429,12076227,146150,26970115,199850,2455301,87380,1612861,1738986,25681111,1931251,3029831,2079301,2081770,1989566,41365379,1941470,173082,1952166,2310359,5315124,101403,106770,244970,35562327,2084188,243243,98309,2081298,14957863,252832,20708505,31439157,1966865,1972255,6112301,203729,2669496,1821955,7453225,16943153,12406905,2080414,268711,1958966,1619633,1602560,3283074,91180,24523,1944467,20782,1631825,164436,124000,4062004,54523,21161019,42769497,171353,192804,18328480,1622643,1737328,1619043,22149479,1965083,2094141,135685,162820,383006,18777710,101873,1994502,227732,2458381,1982812,1738037,28138429,2097551,16349108,2697866,197310,26740313,1975247,47840451,53293,1629285,1970644,107364,1631489,35666833,136036,1906002,39225314,19286,18520,31823031,1977652,2455156,5957896,1631887,1955094,2566227,1616360,1567618,207573,36299,367295,26740087,251659,220403,34636631,2457291,179118,1647275,206591,39126410,1952501,171085,101590,8484467,214160,118221,260788,1638938,28492,199700,1960208,157283,26739866,178962,2073801,18777655,100524,94129,1742419,26970673,136181,75643,1732645,48905589,19326229,1958857,1615773,1714453,178544,1821791,32043296,220693,8591193,1960316,6262634,1741041,28091523,1977077,1955508,179735,1956154,48563833,266661,1730598,2065267,183075,1735734,2082242,22680313,4761786,1993711,1568301,2088269,51034,1736830,120959,1637581,149007,1951986,1642184,164573,192120,1615208,89349,1636022,2104885,2669164,159735,2098711,1604712,1627301,1972350,2673848,1941039,1733120,2454097,115353,1603434,127120,34613539,122139,156724,11365272,32570989,26740130,20885,158731,1625784,50850,49046532,40646,173474,50200137,131774,183531,1948977,15399861,47929048,1733379,48265977,1991534,1640939,1932213,1826626,1992224,2668546,41655080,91383,139639,1621908,27858937,1957311,208516,19029556,2457442,26739851,3263472,1828133,261487,185045,1981834,1950873,40704,187073,1749921,2104878,1942686,199975,2458389,54118,2458494,102508,2456895,1949421,1971267,25577919,2660121,1906249,25366,55010,1615279,33072200,2060888,9517247,79610,75009,1906202,1907111,51833,1994822,35324,1945485,1905939,2454264,1826473,1990091,7453211,1979347,186176,1825713,2072256,1627758,1632497,383021,15419089,1935963,1954391,7576136,1821698,191455,2853495,6285088,144112,1714298,12216039,1733212,39575,2088021,251064,262446,33059182,76900,157541,154116,8195213,3259849,1990242,16306542,18777644,2853535,98451,2086710,2661069,383494,1993645,43526,7453065,26739905,2457556,245591,2457844,26739792,2098663,1567186,2058626,49502,119054,1829164,102814,265965,2458035,255957,1955972,203147,166611,139875,12736708,48313371,363102,2104416,25052280,1973794,46461361,78233,2457665,2097213,36260848,23185284,30763608,1601631,1641827,20577,17823,1622470,55324,131790,12279128,89972,244217,1955685,43686,164042,2083801,263121,26648317,241209,1983483,30101,25273,1730342,1614785,2454461,1734130,22166841,2666152,107333,203131,1645656,21489,2194142,2088878,2433243,7453121,145614,262579,7571608,1978568,2456271,26740269,1568361,1825179,1968121,1637071,1623962,27808362,1619845,54339,27795127,104153,1968049,15028571,2067310,1628086,6645739,101969,1750860,21239,28867356,1624588,187911,113392,1622865,2099252,265468,33294549,1604920,2098385,37366700,163032,1948505,1985474,1977491,165005,1728448,2457536,264308,9313566,5315084,101549,9517217,1955268,1907329,190819,1626287,18129824,38723937,2083376,2070247,93903,48017,77676,26739927,2454904,1937544,87012,1619783,51301,139824,1824347,1977269,1729120,1973715,1938339,6497634,21308116,133887,1633679,1979549,151587,4820758,5554780,27436656,11993543,199275,26740242,1622502,220546,102558,7969551,19754,45930227,7453030,1954471,9580541,183196,1616323,1964182,260387,92398,1737555,46121793,1732918,48981906,1975205,234239,1821814,26739991,6645761,266691,41064007,1906621,210887,20847987,1648391,1946582,10490264,1907143,22765980,32305843,1951622,1714209,14669428,154873,1980553,1173491,1970550,82604,49215024,259830,1612615,1744654,141995,1950062,2094094,50347967,2457774,72611,2088680,26740020,147869,1988015,1992841,78602,1821623,31159117,1612870,240971,1962811,2076099,227647,4063718,1969608,33331,26021709,202441,115753,195136,87124,129031,112984,27056,362821,1946470,194797,187810,24118,1904411,18743447,1614767,1622139,1952340,1730546,1737436,203882,1625531,1988385,35697,1821596,2667581,43399592,7453079,1728765,4063124,18375,6497563,1905920,1946502,1635060,191266,29836686,1745839,2066831,1825793,2674018,204528,1603875,2103360,110338,37217,86366,128992,1742580,1933433,1632926,139252,1612876,244956,26431,51194931,1635520,46250,48863,1729870,209445,2086648,7453218,26740126,17253013,99228,1963111,1614918,18810410,203901,2663977,144374,1745037,1604675,185698,228944,1632999,43837572,260613,1567856,164198,105369,2087805,1749855,26740224,1821807,27384,1615159,2458255,2075115,29850681,26740257,252258,208378,1826556,1737106,111604,1976365,1620303,1615695,49345132,77798,195918,1748239,9284087,1966052,29109,1955624,12894895,1638503,1974283,193372,17126,1989124,42753168,87409,1615663,22882595,220531,2454304,171549,42811906,140362,1930330,45082,7018853,42977,1623157,48897409,36640521,108052,2100659,124718,1943508,26740195,22213550,48564332,2458159,1950256,37038521,3118747,102976,162656,54243,1937978,2095969,1629064,23899160,1735575,194917,1948291,1626802,212729,2458533,1736889,5128445,15668814,2458073,74427,1616284,52516,191047,47294199,2458503,2099973,261158,1826686,1906196,1599977,1946951,135829,1744565,1636646,7453072,1743384,1986865,2062885,2081145,2087461,2086547,1906418,2073525,23620,80345,1632762,8925967,13734739,1600513,2073500,40739609,26739856,44735018,23920,41198698,22047,2064808,2103875,1730377,189123,106889,2457544,176007,2058557,7452939,102868,1960793,257010,198498,108664,2080640,1567369,1743604,25667,17770,5160340,1976233,12143455,20989,16110362,1648172,140245,1744760,2453674,9580537,177333,14383638,36531210,108881,1750211,2059991,1714248,141562,1615234,25086439,4761749,1823552,1972521,95652,1953774,26739876,147969,1745754,6497526,11993491,38954139,211808,33252193,36090619,1956007,1631738,36100,2679052,14659907,2082637,8142109,7351637,7453114,1952143,1622914,241089,1905927,2458357,203394,1631084,2456436,1952040,1702996,1973992,98352,39976679,1638980,4791467,203485,1617940,46874,1739074,1965631,116102,1960488,1824253,17030,16306657,31788832,45582974,131085,187883,2100495,1980341,26739885,1957212,28923,2457393,1615196,2066945,142318,1729000,1829617,4062067,156882,1906079,207430,2096960,1967609,221593,2456765,1962766,110842,29658086,2094928,50205454,47196,1970828,49539259,193028,5367353,4062685,1643752,105712,1988766,136417,1989306,2102395,135953,88849,49289508,26740140,30217324,97583,16421480,1733965,154180,1959573,35908675,35655,2066111,244648,2457621,268917,13205136,2064618,2530031,1978956,194884,1947615,9798794,1713696,1954696,7453044,26739861,2977929,1622066,2060516,132606,1942274,1620967,37175,40480654,42551,49253798,2100549,1615749,32478,28980,2100175,1823037,167903,266442,1615738,1635360,32449058,1932817,209213,2061355,26570,1733016,109234,48981909,25763,1907427,1930243,27568,45532997,1966404,48905586,2457650,41969421,160801,46837228,246306,143736,1625836,79424,1636769,1906119,1715186,1956116,1621080,1715129,9566396,16648648,26721,8537205,1643484,1614830,1712652,1731471,16878138,218867,28657,2457968,2456969,1741720,4608269,26740299,1567748,1620510,13873463,1634459,31953,7453183,50718,1943105,26506,208746,1634217,363139,1978718,18432,17197373,10368361,113085,13400949,1829408,38702048,1624901,2457353,187530,35241603,4063327,1729658,241513,26739467,1644056,1977863,14913865,2457417,1953052,1730727,1955322,48365,1646625,23991,174544,1615005,224525,1937367,225267,26740000,1648359,2072287,54695,90081,1984093,177510,134133,187735,162295,124113,27370998,1972617,218423,1615080,1821836,1989075,2064168,18776417,2059036,1979378,1744810,212394,206964,40707373,7453023,98143,253939,29311311,1733028,4149206,49029361,26739373,18462,1629466,2099138,1734086,1984997,255823,1828062,2078695,1614903,98180,34595469,1987339,2453876,45468398,1740630,250696,50760,106657,1643032,27471,1906508,1616585,18776406,1826193,87340,1930178,1615721,2084613,1967514,1615966,43139185,34012809,42442514,255407,212576,1626620,1639755,36066,1742389,1612993,199099,55395,6553917,2080196,1744000,1971344,17001,43594,25766748,1749288,53817,15730622,265930,99420,30724471,1828221,2310272,1947958,120627,31820473,113160,26740165,115604,2104401,1949676,1612855,2099837,33077,18777956,212020,1821893,36640531,9923960,11861138,1979726,2310476,250829,89456,1953538,2065425,228246,36022010,15862624,1615295,1827613,1612831,170491,1612628,21032,165805,44339,1613197,1615164,212929,1619864,48890,266341,16338363,4061295,2102865,26739787,144517,222990,1994761,39685585,203636,18042,267023,101260,37709698,1948441,30731557,18411811,33267404,251478,7599993,16329832,41366,115484,176200,1173158,1990539,1825011,1983681,1948303,16605043,26739393,269445,8695139,130324,1615580,1630213,11753981,152590,1945227,160168,193204,43702020,14915031,265066,2661877,138609,2075240,1745311,1960586,1964231,1631921,223355,21179,26740010,268384,55108,110677,1946065,1732394,2670240,22870909,87467,8388408,7738640,1741179,245886,157359,180717,1612937,1633626,33294335,15118655,175232,1736675,18777978,115132,213132,96266,176975,46648161,44222,189617,156918,157109,13468660,26059963,1729645,1648515,1173603,1613190,49522274,188963,110374,163837,15432854,1969193,2078829,179886,1632111,27520,2101108,1628719,2083262,1615731,384102,84693,4062019,18094541,48625751,14913875,1990954,43826963,119809,1968180,1973199,6493635,45539296,23945599,1941076,1953633,1828871,209054,43349109,201732,2095022,1616514,35382,211155,101813,26739817,1711987,7162763,1750061,128526,239049,17364709,48313374,4062278,17804792,1728960,26739890,2664006,26739919,41796413,263186,7969785,36716325,171116,1960667,11618312,25766745,95945,9490392,1931242,27685,1906788,1974566,262206,2075421,2433378,1907362,250174,219645,27947163,265584,383826,151300,1949573,34037741,2104733,18560,19928947,164309,34180,8924340,218521,4062193,105761,1717056,362255,2670783,382988,1173251,1983002,43384764,1614837,2102365,32750792,9886762,1951927,26739546,27825,1951458,114609,43384770,1602702,2674009,168086,106347,1625106,1735424,22840856,1942813,6494431,2674013,1821849,25135852,49350028,1628384,169612,18743469,45548175,1616235,32353,80509,27142048,2103027,1821779,1749264,12141175,255495,44526346,50062232,1616047,178433,85437,1987221,41546,1748053,1635930,182129,1980918,50189,1748466,195022,1930778,2063926,23184951,2529883,1906297,26740092,26739772,126702,42448818,20840,250387,41909293,2079798,2098561,185208,1642980,1965827,12176479,7452960,101798,1741314,1950703,1628949,1742445,155523,133247,1734569,154226,1959784,1629040,1612928,1600797,218829,1716219,1987706,157061,27961048,204855,46933,213047,29547,34983,48496,2458228,1972286,1957280,225374,108551,1946806,1951065,48891241,1952204,49924348,26862862,1949614,1173353,9395965,29619,1567972,1953997,2071323,2670158,1616197,35829,47202201,1750052,2087379,17115,39687,1821979,1712994,176637,79763,1967229,2456321,48625745,2101006,1976167,174680,10004874,9651389,255713,24375268,18015,242786,1973113,1741616,19852,228789,1952062,1633539,38904,32526079,1729347,2071099,26740309,1728547,170704,141880,382826,5957902,11473248,229040,134322,161875,20972969,218032,384186,1637716,2978039,1732250,190874,12371222,18755389,42682918,1906873,9283115,6208703,41198692,2458424,24767422,23220930,1626434,200772,1735505,2696471,169799,86746,194307,1643109,178916,1822910,362302,160247,1961476,43155,1736444,1984959,193837,243765,32010,41160,85117,1962416,129501,1173254,1829458,104513,7967625,1633276,2542786,10114007,118447,2853529,122810,240404,97332,33611480,213063,148562,31775662,1568651,94373,1739846,20707,1948108,1948827,109827,1173121,3190492,1735488,53010,31341209,47781,26447592,2454173,82308,36566491,2080698,99548,1648477,1974122,1616601,31755375,1981953,2458788,1826326,268647,1984371,1971898,1631662,1821861,4580754,1958820,1981615,260687,102372,4062709,111341,89886,2458339,7453204,9735393,2100672,1728417,1968105,1994374,2079623,15399851,53593,1746869,1625681,1825677,1173124,192660,1906601,183391,73556,1821868,1717034,2081732,1955956,256553,1948321,170790,13440568,1954031,221173,1982666,107594,148079,156556,101167,105395,171224,111651,2071163,9700388,1642449,2095070,1715692,2100270,32043299,2075049,72528,265378,177439,42911,50330123,7453135,85349,1646152,1930577,73689,2080450,2079129,98483,1906157,1619833,9556507,2088142,30764208,1823127,27868,5418662,149700,1639192,2660012,1614843,1646659,143950,1739008,33178,1953092,2456579,16922,18272,2674170,1713366,197379,1965992,11508819,12879307,49548929,1946327,103499,1906343,2104865,7453176,1978863,249871,181736,1620331,211686,1633857,2066351,148975,53783,107023,38621717,2073888,3224898,1615178,45830452,166123,11510964,1621340,1727855,1601151,21237158,1906432,97682,250060,1627052,1702966,172217,21942,31729351,37942,1946671,1633946,6173328,1640841,1733744,26684056,1620881,53743,189874,13468069,1935486,2092638,1961528,1906635,32742951,1967192,2088417,2529904,363159,4063570,1987463,13447471,1824605,7453169,2103076,136066,45122,9886077,256958,2062410,11862006,33623770,178677,47888734,1829900,38616,2087201,1949004,2076223,158648,141472,1969318,25215728,30564071,1967217,1728156,1938764,26739895,1742670,42428,1715720,2090036,39952619,2457171,1622686,2454161,72773,21543,2458171,27486615,2068749,38807,33401,223333,26739961,1748796,1993620,1743121,1634602,1731875,139146,89745,48928,144556,151492,1930324,72285,11753999,257732,1821716,10004877,4062044,34613565,27076239,47487,90162,11281445,271807,266888,2075589,32203081,105154,50963,30852,180007,36701511,2457463,1567525,27740,13169002,7453197,1826175,209589,228081,90363,1623363,26740155,44781629,174181,1733186,1943973,94404,1716000,27128134,1990911,20668,1637922,74880,166413,41704397,1732862,48933696,221442,29658076,1600709,269773,15375608,1616351,20203610,25156,200595,261224,111521,32979456,246876,2084127,22817521,1715779,6645142,31341359,1970986,2098851,2098133,142376,27982954,106287,2095446,200435,79212,1712703,45054,29819550,2103294,1630801,38060,27090024,1972504,219804,1971221,146572,26739502,1988816,39270097,52662,241860,49169351,48224470,1634109,42237,1602235,242703,1737602,28587,114320,1735334,149400,1616174,26739871,37484,2663894,1971966,143537,1954488,12578470,35994,256266,47830,1714011,22892606,48663426,12076233,212689,1954604,15154165,87518,2097024,1622354,42350,168651,159064,3190322,1567956,1716720,128321,4062921,150070,1956234,212164,9129044,2456978,1982238,191155,2308773,30756,1625132,2081691,81094,199831,1713909,132963,40649956,144248,1741900,2064954,210638,2457179,1821641,29764,1930447,15498539,1821963,1616159,1989419,1736624,7715980,1615872,1990504,1945724,88121,1620371,41458409,1625798,193952,21622,1737234,7364158,42449618,2104264,23106697,20291,27178461,1740280,1615533,266243,4062035,28124,126658,1975018,84605,43804,4062845,226977,51357,272908,75190,1713759,50613474,176068,17593669,1954889,1567284,24767419,1603751,1966440,2367452,1822011,160120,98382,362414,13104309,49910,240156,2100144,1955349,2096263,186109,1828194,243956,2459068,24896602,268304,2073304,1972642,2104726,48570,26899206,12879310,1821762,1614854,211866,261823,1977360,100207,241967,49534198,1615680,4525614,32396816,17804775,180136,21821,168114,114786,1626131,1986015,244552,1620732,1947843,402843,93789,2095125,1615503,1949818,1703009,51533229,1744456,9258388,38549,143682,193693,1932526,1986681,96500,2457214,226339,251348,1640812,188477,161406,185961,13770777,194471,2433361,24985,24109335,37868209,23898867,213537,383375,1737668,1748469,1744099,16463906,1906263,205800,1821580,240436,38373,31419712,1730919,1750660,178215,47644592,29072957,21905908,26578533,1634090,104781,10684008,1632860,46597852,26739802,1967087,171766,150724,1983516,1981922,28508,15176970,128888,1947469,21368,26740265,2098514,1647231,54763,181569,1943201,220348,170268,9129444,34168343,126485,1939045,147915,1627158,2077377,2099561,158547,142256,2084424,35666823,1979421,11213840,1989268,1972399,134094,1964283,138331,165025,1640572,1602287)
                  
                   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