Symfony Profiler

select
  o_id,
  contentScore,
  priority,
  bookable
from
  object_8
where
  o_published = 1

select o_id,contentScore,priority,bookable  from object_8 where o_published = 1;

select
  o_id as id,
  position__longitude as lon,
  position__latitude as lat
from
  object_8
WHERE
  position__longitude IS NOT NULL
  AND position__latitude IS NOT NULL

select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL;

SELECT
  objects.*,
  tree_locks.locked as o_locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.o_id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  o_id = ?

SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = 1592229;

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

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

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

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

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

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

SELECT
  *
FROM
  object_relations_8
WHERE
  src_id = ?

SELECT * FROM object_relations_8 WHERE src_id = 1733379;

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

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

SELECT
  *
FROM
  object_relations_31
WHERE
  src_id = ?

SELECT * FROM object_relations_31 WHERE src_id = 5155184;

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

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

SELECT
  *
FROM
  object_store_31
WHERE
  oo_id = ?

SELECT * FROM object_store_31 WHERE oo_id = 5155184;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 9789;

SELECT
  *
FROM
  object_store_8
WHERE
  oo_id = ?

SELECT * FROM object_store_8 WHERE oo_id = 1733379;

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Murau/Plan-your-holidays/' AND `key` = BINARY 'Find-and-book-accommodation';

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/Murau/Plan-your-holidays/Find-and-book-accommodation';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/Murau/Plan-your-holidays/Find-and-book-accommodation' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Murau/Plan-your-holidays/Find-and-book-accommodation?nearbySearchId=1592229&nearbySearchLat=47.22739&nearbySearchLong=14.76125&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Murau/Plan-your-holidays/Find-and-book-accommodation?nearbySearchId=1592229&nearbySearchLat=47.22739&nearbySearchLong=14.76125&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
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Murau/Plan-your-holidays/Find-and-book-accommodation';

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

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

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1039116;

SELECT
  *
FROM
  object_store_AlpsteinTour
WHERE
  oo_id = ?

SELECT * FROM object_store_AlpsteinTour WHERE oo_id = 1592229;

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId = ?
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId = 9789 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 9789;

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId IN(?, ?)
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId IN(6681, 9789) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 9789;

SELECT
  *
FROM
  object_relations_30
WHERE
  src_id = ?

SELECT * FROM object_relations_30 WHERE src_id = 7910;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

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

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

SELECT
  *
FROM
  assets_metadata
WHERE
  cid = ?

SELECT * FROM assets_metadata WHERE cid = 1840468;

SELECT
  *
FROM
  object_store_30
WHERE
  oo_id = ?

SELECT * FROM object_store_30 WHERE oo_id = 7910;

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

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

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Murau/Plan-your-holidays/Find-and-book-accommodation'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Murau/Plan-your-holidays/Find-and-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

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

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

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//en/Murau/Plan-your-holidays/Find-and-book-accommodation'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Murau/Plan-your-holidays/Find-and-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

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

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

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

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

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

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

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

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

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 9789;

SELECT
  *
FROM
  object_relations_AlpsteinTour
WHERE
  src_id = ?

SELECT * FROM object_relations_AlpsteinTour WHERE src_id = 1592229;

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

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

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Murau/Plan-your-holidays/Find-and-book-accommodation'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Murau/Plan-your-holidays/Find-and-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  object_relations_51
WHERE
  src_id = ?

SELECT * FROM object_relations_51 WHERE src_id = 23413274;

SELECT
  *
FROM
  object_store_51
WHERE
  oo_id = ?

SELECT * FROM object_store_51 WHERE oo_id = 23413274;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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 (
    2669356,
    1728707,
    29789987,
    1824754,
    1955952,
    2674021,
    1948646,
    9576144,
    1734130,
    1827876,
    1952143,
    1947843,
    1936326,
    1727813,
    1828360,
    1933433,
    11928644,
    1735985,
    1828920,
    1951458,
    3089986,
    1823609,
    1953997,
    41064007,
    1950174,
    1942274,
    1738871,
    1954644,
    1730951,
    2669983,
    1736624,
    1826175,
    1936218,
    1950811,
    1952062,
    1953112,
    1824347,
    1946746,
    1733895,
    2670783,
    44433919,
    1931440,
    1955268,
    1733379,
    1948260,
    1941076,
    1946470,
    1947355,
    1930954,
    1934349,
    1730657,
    27066902,
    8844791,
    1932470,
    1750886,
    1827613,
    1946528,
    1937544,
    1930447,
    1932776,
    1948505,
    8382758,
    1949086,
    1949004,
    1947551,
    1940590,
    1951986,
    1948291,
    1952996,
    50929972,
    22870909,
    1735505,
    1952359,
    1830434,
    1750628,
    1737668,
    1736862,
    1950988,
    33294335,
    1735663,
    1733965,
    23899160,
    1950667,
    1829479,
    1732918,
    1732862,
    1933865,
    1941039,
    10374087,
    1828871,
    5554733,
    1736055,
    1734240,
    1823376,
    30525605,
    1737436,
    1949676,
    2673648,
    2670885,
    2673915,
    1939108,
    1750860,
    1942388,
    1728765,
    1737987,
    1955919,
    1948321,
    1946671,
    1826683,
    2673544,
    1732645,
    2670158,
    50010802,
    1730342,
    2664006,
    1731831,
    1957280,
    37868363,
    1952246,
    48564332,
    1955624,
    1731875,
    22680307,
    1729120,
    2674009,
    1954940,
    1955705,
    1955577,
    2674170,
    1951065,
    1954391,
    1951675,
    9629644,
    1736675,
    1952501,
    1734343,
    1940948,
    1948486,
    1943508,
    1935804,
    1828716,
    2663977,
    1730586,
    1937469,
    1828133,
    1823552,
    1730377,
    1957306,
    1951695,
    1737642,
    2669496,
    1823090,
    1957246,
    1952101,
    1953092,
    2673689,
    1954551,
    1750841,
    4062830,
    1731471,
    1733016,
    11862006,
    1825612,
    4442305,
    1731048,
    1949573,
    1934294,
    40707377,
    1951622,
    4062676,
    1946839,
    27066893,
    1824363,
    1736773,
    1954488,
    4062912,
    1750909,
    2670355,
    1824605,
    1730858,
    1733811,
    1830380,
    1941470,
    1728547,
    1938835,
    43826963,
    21577455,
    1732394,
    1826686,
    1948303,
    8746207,
    1948700,
    1951414,
    15118655,
    21984508,
    1946065,
    1729762,
    1730678,
    1955042,
    1729389,
    1735424,
    1730694,
    1947728,
    1735385,
    1955273,
    4062806,
    2666152,
    1933801,
    1955956,
    1824854,
    33905433,
    1829617,
    1932817,
    1735734,
    1957212,
    1948827,
    50200137,
    2670240,
    18250396,
    1826473,
    1938100,
    2674068,
    1952340,
    1738191,
    22680295,
    1731437,
    1946098,
    1730598,
    1750798,
    2669577,
    1932966,
    1729870,
    1955685,
    1943586,
    1738996,
    1728156,
    1728976,
    1931105,
    1932702,
    1955319,
    1826556,
    15498026,
    1953810,
    1930481,
    2670780,
    1733826,
    1829717,
    1750052,
    1949614,
    27178461,
    1750647,
    1823715,
    1952166,
    1733314,
    1937978,
    1948847,
    1737106,
    1948414,
    1931733,
    1732017,
    9886762,
    1739008,
    8745860,
    3238663,
    1942882,
    1947198,
    1727855,
    1947036,
    1950128,
    1826193,
    1828194,
    1733120,
    1943201,
    1823239,
    1828221,
    43399592,
    1949421,
    1823821,
    1954411,
    1826326,
    1953959,
    46852469,
    11245625,
    17071511,
    1823052,
    1734086,
    31896277,
    1732163,
    1824146,
    23107117,
    1823444,
    1950873,
    35658710,
    1947283,
    1825519,
    1739660,
    41704397,
    1732456,
    13873463,
    1955415,
    29263800,
    1955349,
    1732419,
    1824494,
    1950256,
    1737009,
    1734569,
    1731019,
    1933727,
    1932213,
    1729347,
    1825713,
    27947163,
    1737234,
    39908198,
    1938666,
    1946806,
    1948065,
    1823654,
    2674013,
    1938339,
    1829206,
    1823171,
    1828510,
    1952424,
    17364709,
    1952542,
    1954471,
    29819550,
    1829900,
    4062709,
    1947469,
    1734330,
    1942503,
    31747387,
    1827922,
    1951749,
    1737654,
    6648868,
    1824813,
    1947083,
    1947958,
    9576135,
    1737173,
    1937824,
    1829134,
    1954889,
    1947387,
    1953156,
    1737555,
    1739062,
    1824536,
    1735710,
    1829164,
    1949818,
    15419098,
    1823959,
    33623528,
    1739372,
    1935486,
    1955972,
    1738986,
    49874948,
    1828794,
    1828062,
    1938936,
    1729443,
    2673541,
    1934672,
    1955377,
    1730919,
    47978187,
    1730546,
    1728417,
    1729658,
    1825011,
    1950645,
    1948977,
    1733186,
    1943475,
    29789889,
    1951232,
    1750660,
    4062700,
    1736889,
    1943997,
    1949730,
    25984203,
    1950333,
    1955476,
    1955508,
    1735488,
    12149352,
    4062921,
    21824738,
    2664864,
    13770777,
    1955094,
    41458409,
    41278917,
    1930577,
    1943182,
    15419107,
    1943105,
    2663894,
    38290359,
    1940920,
    1931251,
    1734194,
    1739120,
    2674165,
    27866430,
    1733491,
    22621551,
    29789564,
    1823037,
    2853529,
    1736996,
    1934723,
    20962005,
    28929422,
    1729000,
    1732250,
    1950062,
    1951116,
    1952040,
    1937367,
    1942177,
    1733775,
    1949028,
    48417638,
    1954958,
    1950095,
    1939951,
    1830603,
    22680304,
    1825448,
    1735575,
    26021709,
    1733744,
    1733212,
    1733241,
    1942414,
    1953052,
    1936897,
    1955046,
    2673848,
    1947886,
    1728960,
    1951179,
    1824952,
    1827458,
    1941538,
    1828934,
    42444600,
    1737844,
    1946779,
    1934252,
    1737328,
    1948234,
    1823539,
    1935963,
    22680298,
    1829510,
    21862384,
    26306220,
    1735334,
    1948710,
    1825179,
    9258388,
    1954604,
    9629647,
    27142048,
    1937692,
    1729848,
    3402151,
    1954921,
    1829934,
    1733471,
    1824745,
    1941684,
    4062757,
    1935741,
    1931829,
    47930787,
    1824253,
    27066899,
    47196812,
    1738782,
    1736761,
    39811619,
    1933088,
    1734285,
    1947826,
    41453473,
    1931758,
    2670053,
    1954995,
    1729325,
    1956007,
    33363840,
    1730704,
    7757553,
    1948522,
    31788832,
    42144620,
    1728448,
    1942813,
    1954524,
    41365379,
    25089373,
    1953774,
    1739074,
    1824068,
    1951313,
    1823467,
    1731339,
    1946296,
    1947435,
    40707373,
    1750679,
    1940444,
    1733028,
    1946548,
    1735975,
    1823127,
    1737274,
    1946951,
    1733355,
    1825677,
    1949477,
    25215728,
    1827525,
    1827779,
    1946502,
    1939806,
    1826626,
    1828318,
    1747740,
    2673903,
    1950703,
    1954353,
    1737589,
    1948687,
    1729645,
    1939308,
    2663247,
    1952204,
    1948166,
    1948108,
    1949966,
    1942686,
    1954907,
    1738785,
    29787925,
    30205115,
    1933417,
    1825793,
    1736723,
    3283074,
    41108210,
    29789097,
    1730031,
    1829408,
    1941268,
    27972191,
    1727824,
    1823597,
    1949915,
    2674018,
    1750906,
    1943137,
    30841045,
    1942484,
    1955936,
    16605043,
    22680310,
    29788089,
    1732510,
    1950224,
    1729604,
    1955727,
    1955322,
    1932526,
    1947615,
    1827242,
    1943973,
    43822465,
    19928947,
    31261223,
    29788817,
    1952660,
    1950753,
    1733525,
    31077191,
    1954696,
    1749936,
    1829797,
    37911918,
    1951927,
    1826269,
    1730727,
    1826136,
    1737665,
    1946582,
    1955017,
    1947373,
    1948900,
    1938764,
    1737602,
    1739032,
    1936689,
    11618312,
    35313684,
    31823031,
    1949501,
    1829458,
    1823886,
    22680313,
    1738037,
    1955197,
    1939045,
    49917837,
    1736830,
    1948401,
    1940778,
    1948441,
    1955738,
    1825302,
    1823188,
    1729176,
    31159141,
    1824908,
    1930778,
    2669164,
    1955200,
    1943815,
    1732231,
    1942441,
    1735857
  )
  AND pt.stdOccupancy BETWEEN bp.occupancyFrom
  AND bp.occupancyTo
  AND price > 0
  and (
    select
      active
    from
      `steiermark`.object_6 product
    where
      product.o_id = pt.product_id
  )
order by
  minPrice

SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights
              FROM    `steiermark_vacancies`.price_template pt
                   INNER JOIN
                      `steiermark_vacancies`.price_template_base_prices bp
                   ON bp.price_template_id = pt.id
             WHERE     pt.acco_id IN (2669356,1728707,29789987,1824754,1955952,2674021,1948646,9576144,1734130,1827876,1952143,1947843,1936326,1727813,1828360,1933433,11928644,1735985,1828920,1951458,3089986,1823609,1953997,41064007,1950174,1942274,1738871,1954644,1730951,2669983,1736624,1826175,1936218,1950811,1952062,1953112,1824347,1946746,1733895,2670783,44433919,1931440,1955268,1733379,1948260,1941076,1946470,1947355,1930954,1934349,1730657,27066902,8844791,1932470,1750886,1827613,1946528,1937544,1930447,1932776,1948505,8382758,1949086,1949004,1947551,1940590,1951986,1948291,1952996,50929972,22870909,1735505,1952359,1830434,1750628,1737668,1736862,1950988,33294335,1735663,1733965,23899160,1950667,1829479,1732918,1732862,1933865,1941039,10374087,1828871,5554733,1736055,1734240,1823376,30525605,1737436,1949676,2673648,2670885,2673915,1939108,1750860,1942388,1728765,1737987,1955919,1948321,1946671,1826683,2673544,1732645,2670158,50010802,1730342,2664006,1731831,1957280,37868363,1952246,48564332,1955624,1731875,22680307,1729120,2674009,1954940,1955705,1955577,2674170,1951065,1954391,1951675,9629644,1736675,1952501,1734343,1940948,1948486,1943508,1935804,1828716,2663977,1730586,1937469,1828133,1823552,1730377,1957306,1951695,1737642,2669496,1823090,1957246,1952101,1953092,2673689,1954551,1750841,4062830,1731471,1733016,11862006,1825612,4442305,1731048,1949573,1934294,40707377,1951622,4062676,1946839,27066893,1824363,1736773,1954488,4062912,1750909,2670355,1824605,1730858,1733811,1830380,1941470,1728547,1938835,43826963,21577455,1732394,1826686,1948303,8746207,1948700,1951414,15118655,21984508,1946065,1729762,1730678,1955042,1729389,1735424,1730694,1947728,1735385,1955273,4062806,2666152,1933801,1955956,1824854,33905433,1829617,1932817,1735734,1957212,1948827,50200137,2670240,18250396,1826473,1938100,2674068,1952340,1738191,22680295,1731437,1946098,1730598,1750798,2669577,1932966,1729870,1955685,1943586,1738996,1728156,1728976,1931105,1932702,1955319,1826556,15498026,1953810,1930481,2670780,1733826,1829717,1750052,1949614,27178461,1750647,1823715,1952166,1733314,1937978,1948847,1737106,1948414,1931733,1732017,9886762,1739008,8745860,3238663,1942882,1947198,1727855,1947036,1950128,1826193,1828194,1733120,1943201,1823239,1828221,43399592,1949421,1823821,1954411,1826326,1953959,46852469,11245625,17071511,1823052,1734086,31896277,1732163,1824146,23107117,1823444,1950873,35658710,1947283,1825519,1739660,41704397,1732456,13873463,1955415,29263800,1955349,1732419,1824494,1950256,1737009,1734569,1731019,1933727,1932213,1729347,1825713,27947163,1737234,39908198,1938666,1946806,1948065,1823654,2674013,1938339,1829206,1823171,1828510,1952424,17364709,1952542,1954471,29819550,1829900,4062709,1947469,1734330,1942503,31747387,1827922,1951749,1737654,6648868,1824813,1947083,1947958,9576135,1737173,1937824,1829134,1954889,1947387,1953156,1737555,1739062,1824536,1735710,1829164,1949818,15419098,1823959,33623528,1739372,1935486,1955972,1738986,49874948,1828794,1828062,1938936,1729443,2673541,1934672,1955377,1730919,47978187,1730546,1728417,1729658,1825011,1950645,1948977,1733186,1943475,29789889,1951232,1750660,4062700,1736889,1943997,1949730,25984203,1950333,1955476,1955508,1735488,12149352,4062921,21824738,2664864,13770777,1955094,41458409,41278917,1930577,1943182,15419107,1943105,2663894,38290359,1940920,1931251,1734194,1739120,2674165,27866430,1733491,22621551,29789564,1823037,2853529,1736996,1934723,20962005,28929422,1729000,1732250,1950062,1951116,1952040,1937367,1942177,1733775,1949028,48417638,1954958,1950095,1939951,1830603,22680304,1825448,1735575,26021709,1733744,1733212,1733241,1942414,1953052,1936897,1955046,2673848,1947886,1728960,1951179,1824952,1827458,1941538,1828934,42444600,1737844,1946779,1934252,1737328,1948234,1823539,1935963,22680298,1829510,21862384,26306220,1735334,1948710,1825179,9258388,1954604,9629647,27142048,1937692,1729848,3402151,1954921,1829934,1733471,1824745,1941684,4062757,1935741,1931829,47930787,1824253,27066899,47196812,1738782,1736761,39811619,1933088,1734285,1947826,41453473,1931758,2670053,1954995,1729325,1956007,33363840,1730704,7757553,1948522,31788832,42144620,1728448,1942813,1954524,41365379,25089373,1953774,1739074,1824068,1951313,1823467,1731339,1946296,1947435,40707373,1750679,1940444,1733028,1946548,1735975,1823127,1737274,1946951,1733355,1825677,1949477,25215728,1827525,1827779,1946502,1939806,1826626,1828318,1747740,2673903,1950703,1954353,1737589,1948687,1729645,1939308,2663247,1952204,1948166,1948108,1949966,1942686,1954907,1738785,29787925,30205115,1933417,1825793,1736723,3283074,41108210,29789097,1730031,1829408,1941268,27972191,1727824,1823597,1949915,2674018,1750906,1943137,30841045,1942484,1955936,16605043,22680310,29788089,1732510,1950224,1729604,1955727,1955322,1932526,1947615,1827242,1943973,43822465,19928947,31261223,29788817,1952660,1950753,1733525,31077191,1954696,1749936,1829797,37911918,1951927,1826269,1730727,1826136,1737665,1946582,1955017,1947373,1948900,1938764,1737602,1739032,1936689,11618312,35313684,31823031,1949501,1829458,1823886,22680313,1738037,1955197,1939045,49917837,1736830,1948401,1940778,1948441,1955738,1825302,1823188,1729176,31159141,1824908,1930778,2669164,1955200,1943815,1732231,1942441,1735857)
                  
                   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
        ;