Symfony Profiler

SELECT
  name
FROM
  properties
WHERE
  ctype = "document"
  AND name LIKE "json-ld-%"
GROUP BY
  name

SELECT name FROM properties WHERE ctype = "document" AND name LIKE "json-ld-%" GROUP BY name;

SELECT
  object_localized_11_en.o_id as o_id,
  object_localized_11_en.o_type as o_type
FROM
  object_localized_11_en
  LEFT JOIN object_collection_demiDate_11 dates ON dates.o_id = object_localized_11_en.oo_id
  LEFT JOIN object_collection_demiStartTime_11 times ON times.o_id = object_localized_11_en.oo_id
WHERE
  (
    (
      o_parentId in (
        select
          o_id
        from
          object_12
        where
          town__id in (
            11550,
            11552,
            11546,
            11938,
            11563,
            11553,
            11561,
            11562,
            11540,
            11554,
            11551,
            3896604,
            11548,
            11547,
            11545,
            11543,
            11549,
            11550,
            11552,
            11546,
            11938,
            11563,
            11553,
            11561,
            11562,
            11540,
            11551,
            11554,
            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,
            29785444,
            29785442,
            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,
            11195,
            11196,
            11191,
            11194,
            11190,
            3192509,
            11197,
            11409,
            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,
            11465,
            11466,
            11464,
            11463,
            1612603
          )
          AND o_published = 1
      )
    )
    AND (
      needAcco is null
      or needAcco = 0
    )
    AND (
      object_localized_11_en.o_id in (
        select
          o_parentId
        from
          object_10
        where
          packageOnly is null
          or packageOnly = 0
      )
    )
    AND (
      object_localized_11_en.o_id in (
        select
          o_id
        from
          object_collection_demiDate_11
        where
          (
            object_collection_demiDate_11.to > 1732575600
            and object_collection_demiDate_11.from < 1764111600
          )
      )
    )
    AND (dates.to > 1732575600)
    AND object_localized_11_en.o_type IN ('object', 'folder')
  )
  AND object_localized_11_en.o_published = 1
ORDER BY
  dates.from ASC,
  dates.to ASC,
  times.time ASC,
  `order`

SELECT object_localized_11_en.o_id as o_id, object_localized_11_en.o_type as o_type FROM object_localized_11_en LEFT JOIN object_collection_demiDate_11 dates ON dates.o_id = object_localized_11_en.oo_id LEFT JOIN object_collection_demiStartTime_11 times ON times.o_id = object_localized_11_en.oo_id WHERE ((o_parentId in (select o_id from object_12 where town__id in (11550,11552,11546,11938,11563,11553,11561,11562,11540,11554,11551,3896604,11548,11547,11545,11543,11549,11550,11552,11546,11938,11563,11553,11561,11562,11540,11551,11554,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,29785444,29785442,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,11195,11196,11191,11194,11190,3192509,11197,11409,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,11465,11466,11464,11463,1612603) AND o_published = 1))  AND (needAcco is null or needAcco = 0)  AND (object_localized_11_en.o_id in (select o_parentId from object_10 where packageOnly is null or packageOnly = 0))  AND (object_localized_11_en.o_id in (select o_id from object_collection_demiDate_11 where (object_collection_demiDate_11.to > 1732575600 and object_collection_demiDate_11.from < 1764111600)))  AND (dates.to > 1732575600)  AND  object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1 ORDER BY dates.from ASC, dates.to ASC, times.time ASC, `order`   ;

SELECT
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 2566824
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 2566824)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

SELECT
  object_39.o_id as o_id,
  object_39.o_type as o_type
FROM
  object_39
WHERE
  fid = 'bbe9dd0c-d667-443b-aff7-ffe61920774b'
  AND object_39.o_type IN ('object')
ORDER BY
  `o_published` DESC
LIMIT
  2

SELECT object_39.o_id as o_id, object_39.o_type as o_type FROM object_39 WHERE fid='bbe9dd0c-d667-443b-aff7-ffe61920774b' AND  object_39.o_type IN ('object') ORDER BY `o_published` DESC   LIMIT 2;

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
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 2589127
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 2589127)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

SELECT
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 2589170
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 2589170)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

SELECT
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 2589153
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 2589153)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

SELECT
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 2589081
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 2589081)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

SELECT
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 275894
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 275894)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

SELECT
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 38973787
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 38973787)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

SELECT
  min(price) p
from
  object_collection_demiPricePrice_58
WHERE
  o_id in (
    select
      o_id
    from
      object_58
    where
      o_published = 1
      and o_id in (
        select
          dest_id
        from
          object_relations_10
        where
          src_id in (
            select
              o_id
            from
              object_10
            where
              o_published = 1
              and o_id in (
                select
                  dest_id
                from
                  object_relations_11
                where
                  src_id = 2566859
              )
              and src_id not in (
                select
                  src_id
                from
                  object_relations_10
                where
                  dest_id = 27527855
                  and fieldname = 'holidayThemes'
              )
          )
      )
  )

SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 2566859)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))));

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

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

SELECT
  object_localized_11_en.o_id as o_id,
  object_localized_11_en.o_type as o_type
FROM
  object_localized_11_en
WHERE
  (
    o_id in (
      2566824,
      2566859,
      2589081,
      2589127,
      2589153,
      2589170,
      38973787,
      275894,
      275894,
      275894,
      7780383,
      8086279,
      8086279,
      8086279,
      8086279,
      8167001,
      11031281,
      11031294,
      11031820,
      13400308,
      11031319,
      11031319,
      19910387,
      19910395,
      17015714,
      11616598,
      27736061,
      14043963,
      15659562,
      16540678,
      16540678,
      16540678,
      16540678,
      16540678,
      23813976,
      19400317,
      19400317,
      19400317,
      19400317,
      19400317,
      19764417,
      20709029,
      6052991,
      6053007,
      11283166,
      7362863,
      31833558,
      7362256,
      26934679,
      14043580,
      38343234,
      13690328,
      14076362,
      36362226,
      36362390,
      36519347,
      14383736,
      26934343,
      26934343,
      27152704,
      27152704,
      26608409,
      14624161,
      1992169,
      16306208,
      30095488,
      30177961,
      30177986,
      30178011,
      30440781,
      1395031,
      14012808,
      14012808,
      32621795,
      32701752,
      33904980,
      33905060,
      33905060,
      33905068,
      34345077,
      34345077,
      34345077,
      34345077,
      34345077,
      34345077,
      34345077,
      33905076,
      33905076,
      35522253,
      35522253,
      35522370,
      35522381,
      35522381,
      34776154,
      35522101,
      35522111,
      35522237,
      35617545,
      35617545,
      35617545,
      35617545,
      35617762,
      35617762,
      35617749,
      35617749,
      35617749,
      35700739,
      35753917,
      35753939,
      35618095,
      35908970,
      35908970,
      35950683,
      35950683,
      35950693,
      35950693,
      35753965,
      35753965,
      35753965,
      35753965,
      35617857,
      35992211,
      37709964,
      37709989,
      36035024,
      36034312,
      35991002,
      31037202,
      31037216,
      39269169,
      14849580,
      39269181,
      14913999,
      33102160,
      34554520,
      34554787,
      34554798,
      34554809,
      34554891,
      34554901,
      34554911,
      34554921,
      34554933,
      34554943,
      34554953,
      32703242,
      1394856,
      5161458,
      5161469,
      5161545,
      5161545,
      5161545,
      36862814,
      36862814,
      36862814,
      36862814,
      36862814,
      36863094,
      36278469,
      14914328,
      25414333,
      25414333,
      2591921,
      34066094,
      34066094,
      41971814,
      1395640,
      1395640,
      20709274,
      35659220,
      30724860,
      43782063,
      41368966,
      41368966,
      41368966,
      41368966,
      41368966,
      41368966,
      41368966,
      41368966,
      41368966,
      41368966,
      41368966,
      15374855,
      13979816,
      32621915,
      32662775,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      13948248,
      18471669,
      18471669,
      32938522,
      1394832,
      1394832,
      15135646,
      15135646,
      27152995,
      49259082,
      12630589,
      4065525,
      12586588,
      12586588,
      12585349,
      14012026,
      14012026,
      14012026,
      14012026,
      14012026,
      14012026,
      14012026,
      14012026,
      12592028,
      12592734,
      12593305,
      12594035,
      13818514,
      13818514,
      13818514,
      13818514,
      32662788,
      32662994,
      4065687,
      14557577,
      14557577,
      14557577,
      14557577,
      14557577,
      14557577,
      14557577,
      32663119,
      14075457,
      12944069,
      12944069,
      12944069,
      12944069,
      4443383,
      18701851,
      14012222,
      14012222,
      11653373,
      11653373,
      11653373,
      11653373,
      11653373,
      12630144,
      12630144,
      14415073,
      16306584,
      30724966,
      7512454,
      7512465,
      7512476,
      1394939,
      1394939,
      1394953,
      1394953,
      33704134,
      41413607,
      1394889,
      1394889,
      1395702,
      7901762,
      41619135,
      33059583,
      33059583,
      33059583,
      33059583,
      33059583,
      33059583,
      1395449,
      1395437,
      25414130,
      25414130,
      1395381,
      1395405,
      1395418,
      15135590,
      42315304,
      42315304,
      42315304,
      42315304,
      42315304,
      27946232,
      28019291,
      42493377,
      42493388,
      42698003,
      42698003,
      42698003,
      42698003,
      42698003,
      42698003,
      42698003,
      42698003,
      5161489,
      42698697,
      42697666,
      42698459,
      42742362,
      42742368,
      42742362,
      42742368,
      42742362,
      42742368,
      42742362,
      42742368,
      18433001,
      18433001,
      42830497,
      42830507,
      42830497,
      42830507,
      42830497,
      42830507,
      42830507,
      42830625,
      42830625,
      42830625,
      42830625,
      41795373,
      45440858,
      33333444,
      36091522,
      36091535,
      36091545,
      36091555,
      36091565,
      13135550,
      41618828,
      41618828,
      30177417,
      43691625,
      43692182,
      43692182,
      296666,
      296666,
      43782440,
      44225083,
      44225083,
      44225162,
      44225172,
      44282241,
      1395169,
      2566344,
      33372294,
      44281504,
      44386516,
      44386716,
      5225154,
      275323,
      44573470,
      44869975,
      2405566,
      2405566,
      4063990,
      14383060,
      14383060,
      14383060,
      14383060,
      14383060,
      14383060,
      14383060,
      14660106,
      45440191,
      45440475,
      45489235,
      45538356,
      2766521,
      45583273,
      45583273,
      45583424,
      45583823,
      45747038,
      45932156,
      45884637,
      45884637,
      45884637,
      45884637,
      45884637,
      45884637,
      45884637,
      45884637,
      45884637,
      45884637,
      45884637,
      46238539,
      46460933,
      46460933,
      46460933,
      46460933,
      36908177,
      36908177,
      36908177,
      36908177,
      36908177,
      46648624,
      46648633,
      46648633,
      46648633,
      46648633,
      46648633,
      46648633,
      46648633,
      47201129,
      47559716,
      47602667,
      47293285,
      29829605,
      36034380,
      36034380,
      48569434,
      48569434,
      49168160,
      49304735,
      49304735,
      49304735,
      49305181,
      49305181,
      49305181,
      1395480,
      25760379,
      25760379,
      7049765,
      49587230,
      49680138,
      14383078,
      49969402,
      49827307,
      50158516,
      50158516,
      50535697,
      50584068,
      50678715,
      47604426,
      47604448,
      46095619,
      46095619,
      46097099,
      46097099,
      46766359,
      46766359,
      43692959,
      35618106,
      35700663,
      1394970,
      16110763,
      42653256,
      38505363,
      38344039,
      51021659,
      49827753,
      37667199,
      43442351,
      31037686,
      41970851,
      45840895,
      46298178,
      50253494,
      50584232,
      35659220,
      45840895,
      42315304,
      42315304,
      42315304,
      42315304,
      42315304,
      1394361,
      1394939,
      1394939,
      1394953,
      1394953,
      19593264,
      38211017,
      50584232,
      46298178,
      19593264,
      38211017,
      50584232,
      50584232,
      50584232,
      9314968,
      36091522,
      36091535,
      36091545,
      36091555,
      36091565,
      9924716,
      9314968,
      42994525,
      35700752,
      35700641,
      35700641,
      35700641,
      41971460,
      26060191,
      26060191,
      41971421,
      35618106,
      35700663,
      36091522,
      36091535,
      36091545,
      36091555,
      36091565
    )
    AND object_localized_11_en.o_type IN ('object', 'folder')
  )
  AND object_localized_11_en.o_published = 1
ORDER BY
  FIELD(
    o_id,
    2566824,
    2566859,
    2589081,
    2589127,
    2589153,
    2589170,
    38973787,
    275894,
    275894,
    275894,
    7780383,
    8086279,
    8086279,
    8086279,
    8086279,
    8167001,
    11031281,
    11031294,
    11031820,
    13400308,
    11031319,
    11031319,
    19910387,
    19910395,
    17015714,
    11616598,
    27736061,
    14043963,
    15659562,
    16540678,
    16540678,
    16540678,
    16540678,
    16540678,
    23813976,
    19400317,
    19400317,
    19400317,
    19400317,
    19400317,
    19764417,
    20709029,
    6052991,
    6053007,
    11283166,
    7362863,
    31833558,
    7362256,
    26934679,
    14043580,
    38343234,
    13690328,
    14076362,
    36362226,
    36362390,
    36519347,
    14383736,
    26934343,
    26934343,
    27152704,
    27152704,
    26608409,
    14624161,
    1992169,
    16306208,
    30095488,
    30177961,
    30177986,
    30178011,
    30440781,
    1395031,
    14012808,
    14012808,
    32621795,
    32701752,
    33904980,
    33905060,
    33905060,
    33905068,
    34345077,
    34345077,
    34345077,
    34345077,
    34345077,
    34345077,
    34345077,
    33905076,
    33905076,
    35522253,
    35522253,
    35522370,
    35522381,
    35522381,
    34776154,
    35522101,
    35522111,
    35522237,
    35617545,
    35617545,
    35617545,
    35617545,
    35617762,
    35617762,
    35617749,
    35617749,
    35617749,
    35700739,
    35753917,
    35753939,
    35618095,
    35908970,
    35908970,
    35950683,
    35950683,
    35950693,
    35950693,
    35753965,
    35753965,
    35753965,
    35753965,
    35617857,
    35992211,
    37709964,
    37709989,
    36035024,
    36034312,
    35991002,
    31037202,
    31037216,
    39269169,
    14849580,
    39269181,
    14913999,
    33102160,
    34554520,
    34554787,
    34554798,
    34554809,
    34554891,
    34554901,
    34554911,
    34554921,
    34554933,
    34554943,
    34554953,
    32703242,
    1394856,
    5161458,
    5161469,
    5161545,
    5161545,
    5161545,
    36862814,
    36862814,
    36862814,
    36862814,
    36862814,
    36863094,
    36278469,
    14914328,
    25414333,
    25414333,
    2591921,
    34066094,
    34066094,
    41971814,
    1395640,
    1395640,
    20709274,
    35659220,
    30724860,
    43782063,
    41368966,
    41368966,
    41368966,
    41368966,
    41368966,
    41368966,
    41368966,
    41368966,
    41368966,
    41368966,
    41368966,
    15374855,
    13979816,
    32621915,
    32662775,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    13948248,
    18471669,
    18471669,
    32938522,
    1394832,
    1394832,
    15135646,
    15135646,
    27152995,
    49259082,
    12630589,
    4065525,
    12586588,
    12586588,
    12585349,
    14012026,
    14012026,
    14012026,
    14012026,
    14012026,
    14012026,
    14012026,
    14012026,
    12592028,
    12592734,
    12593305,
    12594035,
    13818514,
    13818514,
    13818514,
    13818514,
    32662788,
    32662994,
    4065687,
    14557577,
    14557577,
    14557577,
    14557577,
    14557577,
    14557577,
    14557577,
    32663119,
    14075457,
    12944069,
    12944069,
    12944069,
    12944069,
    4443383,
    18701851,
    14012222,
    14012222,
    11653373,
    11653373,
    11653373,
    11653373,
    11653373,
    12630144,
    12630144,
    14415073,
    16306584,
    30724966,
    7512454,
    7512465,
    7512476,
    1394939,
    1394939,
    1394953,
    1394953,
    33704134,
    41413607,
    1394889,
    1394889,
    1395702,
    7901762,
    41619135,
    33059583,
    33059583,
    33059583,
    33059583,
    33059583,
    33059583,
    1395449,
    1395437,
    25414130,
    25414130,
    1395381,
    1395405,
    1395418,
    15135590,
    42315304,
    42315304,
    42315304,
    42315304,
    42315304,
    27946232,
    28019291,
    42493377,
    42493388,
    42698003,
    42698003,
    42698003,
    42698003,
    42698003,
    42698003,
    42698003,
    42698003,
    5161489,
    42698697,
    42697666,
    42698459,
    42742362,
    42742368,
    42742362,
    42742368,
    42742362,
    42742368,
    42742362,
    42742368,
    18433001,
    18433001,
    42830497,
    42830507,
    42830497,
    42830507,
    42830497,
    42830507,
    42830507,
    42830625,
    42830625,
    42830625,
    42830625,
    41795373,
    45440858,
    33333444,
    36091522,
    36091535,
    36091545,
    36091555,
    36091565,
    13135550,
    41618828,
    41618828,
    30177417,
    43691625,
    43692182,
    43692182,
    296666,
    296666,
    43782440,
    44225083,
    44225083,
    44225162,
    44225172,
    44282241,
    1395169,
    2566344,
    33372294,
    44281504,
    44386516,
    44386716,
    5225154,
    275323,
    44573470,
    44869975,
    2405566,
    2405566,
    4063990,
    14383060,
    14383060,
    14383060,
    14383060,
    14383060,
    14383060,
    14383060,
    14660106,
    45440191,
    45440475,
    45489235,
    45538356,
    2766521,
    45583273,
    45583273,
    45583424,
    45583823,
    45747038,
    45932156,
    45884637,
    45884637,
    45884637,
    45884637,
    45884637,
    45884637,
    45884637,
    45884637,
    45884637,
    45884637,
    45884637,
    46238539,
    46460933,
    46460933,
    46460933,
    46460933,
    36908177,
    36908177,
    36908177,
    36908177,
    36908177,
    46648624,
    46648633,
    46648633,
    46648633,
    46648633,
    46648633,
    46648633,
    46648633,
    47201129,
    47559716,
    47602667,
    47293285,
    29829605,
    36034380,
    36034380,
    48569434,
    48569434,
    49168160,
    49304735,
    49304735,
    49304735,
    49305181,
    49305181,
    49305181,
    1395480,
    25760379,
    25760379,
    7049765,
    49587230,
    49680138,
    14383078,
    49969402,
    49827307,
    50158516,
    50158516,
    50535697,
    50584068,
    50678715,
    47604426,
    47604448,
    46095619,
    46095619,
    46097099,
    46097099,
    46766359,
    46766359,
    43692959,
    35618106,
    35700663,
    1394970,
    16110763,
    42653256,
    38505363,
    38344039,
    51021659,
    49827753,
    37667199,
    43442351,
    31037686,
    41970851,
    45840895,
    46298178,
    50253494,
    50584232,
    35659220,
    45840895,
    42315304,
    42315304,
    42315304,
    42315304,
    42315304,
    1394361,
    1394939,
    1394939,
    1394953,
    1394953,
    19593264,
    38211017,
    50584232,
    46298178,
    19593264,
    38211017,
    50584232,
    50584232,
    50584232,
    9314968,
    36091522,
    36091535,
    36091545,
    36091555,
    36091565,
    9924716,
    9314968,
    42994525,
    35700752,
    35700641,
    35700641,
    35700641,
    41971460,
    26060191,
    26060191,
    41971421,
    35618106,
    35700663,
    36091522,
    36091535,
    36091545,
    36091555,
    36091565
  )
LIMIT
  8