Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.default_days AS default_days_3,
  t0.enabled AS enabled_4,
  t0.first_order_message AS first_order_message_5,
  t0.second_order_message AS second_order_message_6,
  t0.restock_message AS restock_message_7
FROM
  remarketing_settings t0
WHERE
  t0.settings_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.default_days AS default_days_3, t0.enabled AS enabled_4, t0.first_order_message AS first_order_message_5, t0.second_order_message AS second_order_message_6, t0.restock_message AS restock_message_7 FROM remarketing_settings t0 WHERE t0.settings_key = 'remarketing' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.default_days AS default_days_3,
  t0.enabled AS enabled_4,
  t0.first_order_message AS first_order_message_5,
  t0.second_order_message AS second_order_message_6,
  t0.restock_message AS restock_message_7
FROM
  remarketing_settings t0
WHERE
  t0.settings_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.default_days AS default_days_3, t0.enabled AS enabled_4, t0.first_order_message AS first_order_message_5, t0.second_order_message AS second_order_message_6, t0.restock_message AS restock_message_7 FROM remarketing_settings t0 WHERE t0.settings_key = 'remarketing' LIMIT 1;

SELECT
  s0_.phone AS phone_0
FROM
  sms_opt_out s0_

SELECT s0_.phone AS phone_0 FROM sms_opt_out s0_;

SELECT
  c.id,
  c.name,
  c.softone_code,
  c.mobile,
  c.phone,
  c.sms_marketing_consent,
  p.purchase_count,
  p.last_purchase,
  (
    SELECT
      MAX(latest.id)
    FROM
      sale latest
    WHERE
      latest.customer_id = c.id
      AND latest.date = p.last_purchase
      AND latest.cancelled = 0
      AND latest.gross_amount > 0
  ) AS last_purchase_id
FROM
  customer c
  JOIN (
    SELECT
      customer_id,
      COUNT(*) AS purchase_count,
      MAX(date) AS last_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
      AND date <= ?
    GROUP BY
      customer_id
  ) p ON p.customer_id = c.id
WHERE
  c.active = 1
  AND p.last_purchase <= ?
ORDER BY
  p.last_purchase ASC,
  c.name ASC,
  c.id ASC

SELECT c.id, c.name, c.softone_code, c.mobile, c.phone, c.sms_marketing_consent,
            p.purchase_count, p.last_purchase,
            (SELECT MAX(latest.id) FROM sale latest WHERE latest.customer_id = c.id AND latest.date = p.last_purchase AND latest.cancelled = 0 AND latest.gross_amount > 0) AS last_purchase_id
            FROM customer c JOIN (
                SELECT customer_id, COUNT(*) AS purchase_count, MAX(date) AS last_purchase FROM sale
                WHERE cancelled = 0 AND gross_amount > 0 AND date <= '2026-10-26' GROUP BY customer_id
            ) p ON p.customer_id = c.id
            WHERE c.active = 1 AND p.last_purchase <= '2026-09-26'
            ORDER BY p.last_purchase ASC, c.name ASC, c.id ASC;

SELECT
  COALESCE(
    s0_.cycle_key, s0_.cycle_reference
  ) AS sclr_0
FROM
  sms_recipient s0_
WHERE
  s0_.cycle_key IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  OR (
    s0_.cycle_reference IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
    AND s0_.submitted_at >= ?
  )

SELECT COALESCE(s0_.cycle_key, s0_.cycle_reference) AS sclr_0 FROM sms_recipient s0_ WHERE s0_.cycle_key IN ('1ad7ee402982cc23cd35754a93fa59e4d39cab6b683eac32414aef367ce62743', 'c1a02445448c060b271d9197048350b6fb8ceaa8433de8627b05b99fb9de5019', '6242063df4b0c77c9b275ebc7a7901b0b203ea986fbd067d670b0d6cba884b7b', '1f443207d07f10365d606f0e76c09fc56f4f9ca8072b14046b81d83e73ba3662', '27b4d7ac6b0b8ae1cb78c4e627593aa5e6227a99e1f277dd73810d495549827c', 'b8f80a035266d8bc83ff09008df354f910ef7185e8a386fc3ecc448e1166b93c', 'ee44dc9176973ea62dbe9187e00d243c86dfd068ac67cb62f07d9b7f5a9b6ac4', 'efafe4ed104c74f58b748128735656bc834f53624f5aa38779c243d9a87e1017', '651b428a82a664280743a44a7c6fff643934431b36cab8d49515b84a1fcd8e56', 'd4f7cd5f2ea64577f0e3ab96bb6ec316fd1628abe528ce7fc3bf16253bd9810e', '5c5b40ac92e2e435422f91fb0aa2cd50d51055af5ffeb0c063a0ab41f5a326d5', '8793a483c9941bae412d26f87edeb1d54b6465e115d4b30206780406911d0fbc', 'abf0d4f1e9bcb6efb149a7c7a991dd145729a2a23982fc15e26c9063957db65f', '0b83f2a1fa241a30f7a703755fabb02bea39a62e2ba7679fc67f65f2eaaec34f', '3ea888af99727e3b9708fddc49befcd1c343d75e7b494e9ad5231007bc783e0c', 'e7f2ceed4c7c47991170edd00157996676350d042f3bd73f257f95fb0db10155', '1342b741c97602ef81f41d75655df3fa05c17f4451e638212d47827e4409c4e6', 'f8835c938b1bf07a7e52158cd1dfdb706fc9e5be622fb4d35104a4c9ed6d38c7', 'ae264fb6d03a6e3fd13956ec447c1831b9de2573077a0b8899eb3e643129c658', '82aec0b6a2f985ca773614371a609612f5b419158634d56124077813ae1421c0', '61a7f9dd16d30111dc83fce7d1cedd64a18ea0343e7e50a96666b9703600ce38', 'f15fe88c09124db719cf2bd128607f6d9e58e578e893bb224324ec36ff09dd6f', '02a11089b53e0779d01f720867f6546163f074834ae6cde61581922c70cc4a9c', '405a50f318cfb2775983bd1ba7a4355740c68eb9a66a38437ef207f35d3eb44a', 'dde08e2a373fb86537644eb690a429a03bae615c686169e6a70ecdb5ee8a0bb7', 'b5903436995d31a46302e85fc280afc90682d07b3a6d21656cc23b6535e38d89', '4f9573a58fc5bd71b9acad1eab29014ca6010dc9d6693d78676b5589325b20e2', '0f26571886def5424bb6154a207fb458d0df53979d54efe47aa846cc20006a94', '02d291ef822ef4bca73e52d6b9b5d3d0e89c1fe20adefdf982f14ad37519ab08', '422fb40f6b0cc1afbd6fe1d8d8d28fa2bd16c9154a0c0c6f33fe03fd823f421a', 'e60e2a5ba140b17076b4a4072675f7ed4e3d3debba41db10b2b323ae5a638f54', 'b7bbca4512477455deb693bd7f5f4e4275b4c012513a30ef838ebf88ebf06968', '13a34e96b5e9c9b6340aeb26529a1b8dd1afbfa2c75660b6cb98582af2da1d7a', 'ce4fbb2ab4fe082f4538c5db9fea05a1838a48e8cf979f96e671fbce56125bb3', 'f4a64690f6f5f0e1ed31515dbba5c47548505171bfda862463dc7fd36b5fc890', 'c978f5c48661b892200629a789ab558b0ea08bc33af6dc67205cc17c4b1e9756', '447be874f2e8ae60db5a6f10e81029ac2129bdda339b357cf03ad838aec3f331', '781c627d1a3b7d46e8248bc4c1fa89a8584556e142e6cd81b5980f74279ff61c', 'ee15cf45f2620219b445ff30a2531762bd6798da2ff15ede3b2f51b78d448e6e', '5432b0830157f0a241f18ecc5a9d86842e0f907b1c59144eaf0680725ce6ed30', 'baa8735ca22c81010e4a081b988b62f01420b8096b6c5e924ea3e2cfe51dffdd', '6087180d1553eae80e20f71639f678c701a8ab00b802432f943effb16010910e', '5de9745f0edcc3520e2753c37f4f50f6e1abb74d97c139849f1fa7c13173c8eb', '04968a00f882ff7a271a225406de3cce1bda34f2270fdc643a9899cafae7d1d1', '09427a830443c72323d3d2240acd9b7bb26abb34a8d64c9541174b8b6b353eda', '5634d950291bbfb56898e504c17b7f492896df22ce10936014c1e2e283a74779', '5fa660328eb0e343913eb32a099ef2deced17f6fae681f58f8dcdf8787d63c5c', '5d06a80b27c7ba80592bb5dc361663af92357a4ae03d2650344d159ece5f5384', 'b7343cd224ef646507d5c51565433a00fb0b9fd535d92643ddad0ed9952971fc', 'dbc734e85555f291404a5e141cf0c14409c72392ca8b8892b91107d85c193014', '40182ded31e39cafa1004ca6812800b40adb0efa6b25af4455418c7013286def', 'eadb1665e8af3ac18c315fbcbd23139c0075c76d522cbb8fd50f30fd00dcd0dd', 'c719d7e84ab274028edd902c7e0ef791b691aca39d7ca1464b49be594371b0da', 'ccbdace9ef8cb15a7502a01cd69fd37fb2ed1118f20ff31009c4639989ac2cf8', 'e059418f2e580747b852928316e57ec7965b1f9e64ecbaca9616832707c5980e', 'fab590e3c23c816b9bc5e215aca28a9e2d54ec4a2f08acd6c42eb02c53e022fb', '4b5e9924a443f8a89cf4cbdc1f29fc207c8dca95c3bed51e5a7202d5215de158', 'e698acf52554338877684bcb67bfff85365d2e670262852102159c8f7a16fdb8', '7afb25ff3d7dc0b2e220d6d37f7c8471cbb3bfa47c99a40362979c6ff4f326b7', '86dd199d5d2214cd2a374552f087ad37ae093974d7615bb02af78ede37c43271', '8da7e636b12fd06d075972f00e7d92f523a364f5116deb4d2e01e2a55c66936b', '1457b857ad6a36fb328c7d87fe47de76f53e23427e6c53e044a89f4c6f9f4824', '299318c42f4a0357cd3214c436f59ded350b2b7f8d317ca674bf1eafe256c05a', 'd8fd5138dbf53e6bd021aef19232a16854554b6ec98146878cc15cedd84556d7', '3e394511f8c824b27e590d360428c169bea8300d2f3211212b9c88c511fe0e87', 'a4be23447fabae4989f6f0de24045bdf4f60b2971ce1165fc8fb4092ea30ed88', 'ffbb96905329d3814746fa5dbb719ab54df3f5b82723c30b768760c30ee8a01a', '68baf8079919a599778c46185733ac44a516fdf80068930d1c09cd714f6c56ea', 'fef08c2708e086e0565bf9bec53db3e3aeaba6cd8315973acb698060d1c3b22d', 'ea5048f34f150e4e51bd2ae690bbd23ff3d17ee4b1dc9cf20d2e938d143a0105', 'ce7ea4389d5e02a280bc1bb684c6c3497dc7ef7650667426604f0776990e940c', '65b27a884fa6071d2f52403ac202e99c061bcb446f801e28bda3a843a66d1f40', 'ec309f8d550bb24a0b1be96bd881d00de4720c3381b62b47310617310c1886e2', '1a8fa4ccee5165a7a1014eab64def7e4189407217cef7886301680e95ee6683d', '1d118a659203d653e03e437d2353eab23c975c3f9a4d1e3d64eba037427e617a', '275218914cafd3e0e6124bb60fab0bd13a160f849e437cc233f8e8a043ccab5b', 'a46ce8c99cc02b5858128837b1f9a486ce7894556ae7edae2eb0e1f81bcf8013', '8bbecfabc35587d00c02cc6a683b9c347ebe3e5ee0832cc37703956214e58ad2', '1fc9b255241ca7ca1dc912e3ab6c6d8c53684a51104d2e114b69cef9b5d0a467', 'c34876eb51814ef367f724154e4db627dd7e3a76cc3c8c245bed826ff799f533', 'c4c50f6fbc4e68a66029b87188bd02c4176359233cbd12bb20e10fd4ed73ddfe', 'a79df69c61cd7a4ce6dae22b85bf91f73170eaf0f62cd92a52e17e26c7d64c6c', '45c78626566e6078bf6c7daf910ad1970e413ec23f9b1e1f312a523f8a7ad14b', 'd51e3c5661edba314add96627650a6a010fc32f3d4368d8b895989d94b613309', '6dd6515cdfc891462f4a039339479026c4622518d210c4f9549c70923391d6e3', '43e24a6db769a6d0afd85702c9671605a77d3f65092ae8a3edff8e1eea439ea4', '361fb74141980b059bedc534d5e06bb7782c32840af5830c3e059cc525344588', 'defdd29581f146f0a20a4ab2c13432596b93b41ea4e6921058408fc148c3f1c9', '3b2fecf9fb569cbcca9bb1d31ea7b1001d88abf59bccfe8634edf86fed92b932', '8588069981f41c08a7ab1dc2efd5b358f36a025681ca77d11c33d5d53004f63f', 'f4b333765cd163db4324b545ae9f037a8bfe3ac2ba903bf405cd94e3722e25d6', '82e86a482e2b2cdbc22d3402700fbdcbd5b761ea0706f7bc9a9f9651bf3a6b6a', '442676b75e3f5b3fb2f282d09ac1eb922735ecabb42a13fa248b6817ee96e687', '61e8d69422e6fc658a209adf482afeccd68033ccbec727588bed7416b466b6f5', '3a09f0b56c6594c6473dbfd81225110a96f6f5f3c284b47bda32ac2c9f1923f5', '3fa3027361bb659f863f9b60e6e577349a45b6284daccd4ab95af753ff1d4f17', '342563726127ad3ebd66c9f701602b590acff4102702dbcb033a8683cdf39480', '20fd7b09559588d836d47166116253bac4720cab9f0ff524561acc36e25cdcda', '9924bea4c8ce9621ff8dd1c359c1fdf00bb3ec0f6f14d556690e61a20a87e873', 'ef8ad63253096a035026cfebcf747d34a2c6705d910698a68ca7a4e366b95919', '00d70d2ff0027fa1db5366d1a43f07ddd38d6607667dc38cc26362a2e207e0f3', '0c5f0dfe610d668d8d766767010369c6ee5b9f75e1f48930a5bffb7db8d8d530', 'e783ae4316fcde3ab3ca51adce544a419c21be3ed1c137e40210b8f19eb3790f', 'bf2f2d1a388b91e8bb91039c5557a415b997500faff8c660b1dfab4a15854bba', 'fdfe0de94d867befe72a08c20ad906779363ad04517430cb8cbf957a062b6223', '36eba759c3a69b50cb823fc1d70a8908d42844f1d9278b2237634b681ecce4be', '8886cce3b9374bf8f0257c47e8c93272c0d3f48dc2debe40ca1c2e0a25296171', '873519cce211cf3ec215d535285e0cd693c281ce88f04206667249049df09ab4', '9d3632b7e1a4e1078a5c352b5d16061a6ab0d6a60972c53e3e9fd39af7a38135', 'f14b1c993cdcf3e6d2bad3e125fde80106c626d27ea5aa6c552ceeeb67468800', 'a812eb0eaa93694fca064ac5e98c83bacd66d209f1445de910522907f36df26c', '35f9af2e9881605921ffab31a1225262eb3c26efac7fe418179436d7d4e9cf99', 'c0281428b1ed5a7188f604b58698452048b0d3b2383aea8f938e65381f6b66f6', 'a9bc012e8ac7ca046c4045faa9ef9fdbecf792f611192b3bd15e52257f80fe1e', '0eb10e360761009c17c6e19ce5a87b91da4fb5b0a3bfb85d129f7f661ab89a8a', '49f8876cf3219d021e7ffb6636028916be7ee1f603952ab0f216d3e355da2e65', '5a379ecc46e8e0c9b7ed96079bd2ac32c7e561294dd49c7c12793bd7f1a200f0', 'c23c999dd37898a014ed9084a30cb64b4a9a321d217f12c267740414499104a4', 'f1eb95fecf20f1791e32293bc59aca7febd016df55daab681422bef4d6ee0d3b', '986df9f92f77c78bcf8e5efb1de961eb8d2f33f0d9f2ae2be22b83923db60f82', 'c885406dcb8681c898df92513f270b382cb036a369178c4347243684e6e0d8d6', '63dabd1bade02280c818ba67124bb6f0f3b22b54a4c71d4f1d67948005141cb0', '073d7f45fc53d5012445a7186f38f429317971add503cac3ad1c7653fd617ad5', 'efc3fd1041058d95dd3efc986aacad7e82cf12ffb2faeb6b9870a0450ae3ae02', '24f6e23100e550fb6516335fc095df4489c839205d7a30c09bb7e01d05a92466', 'ca1d3aca6845517527b1912f96e7508a67929a6beb029313fbec6dfe1470c7b4', '2e578d11d7c84714a31fc70d93a4c1296fd1cd5ac718b869e74853bdf3538ae4', '7c7a90d3cdef66e1830e25c66e526a69d7532c99b9bc6507ad177446e5226a46', '9d0c3e4d7480efced21eff17d76ddb8bd24faeaf6ca80957a314193d726653d8', 'a624861418723e86571f3841f5bf1d9434111d676427cda345930aeef49776e2', '4da8d3d4226b2afe18581813182dce175946f0091882bb71a2eeede721a47f58', '10de33398f66b91c6161fb335ce4be6d6f4ea307b035cd72f11b4da5f3833659', '430a43d793fb44dab9161d68f2884bf3c3d19058eca7809c7872d1e961ba61c3', '888fdd16465259eae598490213220102df261189ca69dce307d82dad796d5c48', 'db049b00c5b076beda8e709d201654fc0108b9f69cfa7f2f1f540bda83f7f957', '122586f31e588ee8541843bcb98d6b55210aa98a08bd5b37ec722883c7f5f039', '189dc7bfb995ed5684890f4cda542c3da326691b97fc50ea5f8336f8ca8bc7de', 'eb84bbfa6847f1ea625ba96504bc68b2cb628232549a157b1c2362ac1fa991d8', 'bd5bbc7258ad6f2ac1a81e443979806bd107ed71cd6ebb9e621f93447220d9bc', '171fca23b244f07e49a85c5553ba2f899fb66b7238f6bee58b3898fb8294576b', '4dcf5f4cc77385525fc8d8bebe6df50ad431062218ccabb81f8e37d6ddc475db', 'fd71011bf475aea1073866275b89b5c31bb97f0210c7550bd229af726fa2b598', '24164367f2fb2e0aa202b74bb346c1fb6a86d38c957cd75f9c132d539a6affe9', '6c8fb555c1073ce8d38b0b7acbf4ffa3ce50d088336f7feea537002a5714ee58', 'b378d93c1b31cae3e13a78b6859e8d97b5f138499ca32d1ae6bbd3ada412a27d', '6f3a6211fde3b49a654e1b89ab43ca237c6359a1f18e54422a2f3a59d35182e5', '5854a2f667d019b9a2a3990c48c3a190eb476213a0ffa3aafe15faa20b9a7f83', '87dda85c68ce578fc37fc6e814927dd76ad52d0ba43a56698b9093851c94f89f', '845b7def672c27dfd39a550ea8212a60c0189290d8d29b106770390820b90eda', '0f5d6fe0276ef63cb4c094c007847ffb18b3c94ce3748a037e1c895bbd56816f', 'cbcd3579faaf670c678d1a094a4708565b118df45ea98a5a63696b47b70a7891', '756ee90a1b8292a3694cb7a7d98d3a115068421dca3c3d47d5839b5fd7f69620', 'e65a4c3203f9332d467d68e33f597ff9af197bdc6291ea2b4476574e1068fcbd', '66c8be51e84f917a386e5b05bf2f29153844577df844f57091e89208907da431', '264236ae1674dbc82d35935f3416c24bfd9cfe8c115118fd4177b58a6410ba1e', 'f2548d04ec211bf29f30e9026ce405fe9a9a4af7ee033eba3edfd8f8b76983dc', '493ee48aff5850e41072e41b0d475b035fb0f7a00bf0097e330391371ad8c10a', 'ba5c2d1544c40a5dd688f1289b627f0c1b729bc4af59368cc335b9914121bc6c', 'd771d74de48d3d8ed553abf9ce6a3102e01b8f066ce4df3a001bbd8c9ef5701f', 'd3b419ec3566722d93b567ade5e5ad4b0e89b8dfcf11af9c33c58d6e0ad5aadd', '4201f8443325bbe797daf0fe3b0f0637c0fe84cfeaff85e083248ab444736426', '04f8b05475cd0f42606e02e748baf2992b5e205141f74c9cd555fadb458d8b02', 'ac8f7ee5140a44a3f6e66fde15bc79d574a4860688d429075c9e46e335e56384', 'fb233d2269eca1261162ec7e16491b5b601544c98c31ae9f0e76d53b5c796241', 'bf1ee145d1bdde0b27b7a80388dc3d2f15ed7b4c888e03ba024ed9eb57c95207', '723a12756e0c4778395c35b68942e7be89825cf422a4a29fd891650a16580d7a', 'bf311aed566dd7866edfbac327282a902a7fe4b250ec03d2fa1d9acf44838496', 'c02e2bf9339cca8742ca88b130e24bc950b2d82dc2d069a049e1bdc8c8846503', '087a77431d88f52b17f07ffde11ce41b2a42f76d86f4d8d9630a5b02e904b73f', '15ba1cb4b6dcc97b3284a5efe49f9c293191404c8e7b8721fc77dfb9546e3060', 'd36209d4614df5d5531f1c532f5354b217a2cfb3c045630a32ada517b60c9064', '26853c084c1ada632f9c72cd0bb5fb18868ce8cbf4d14b773d4cd7cc6f1108f1', '93fc725360b0ee2d2e4c1bc38616a8cc50d2b4d04f866762e1afca4a8a5fbd2a', '80ab80d0505990d1a278276c014ea06c2f7d81e091d00c12c188917c7c2de6df', '50e7289473970f5f2c44b9612b8219813d6e0193a47ac3bf4d2195743f0cda7e', '593260e4a167e81956e16b244b6f00c99560fc59a0ce6e87eed6fee5ab2c048c', '753ca416720a670dd0ad0a001e16883ab6f2013c31b72077664dfcf750c17779', '85ac70edcd62ca5ad22f73be5ef03d431fde3650f9df6e09cfdb0d03e9ff5ad0', 'f65c70161f1aab8c8641e532097fa5c14542cae6fcc80b17a5991a9ff8d56354', '328b13118b24f700c0c232af275bf13316d26f8f942d24a497d3af6b79f83d27', '5a66b445b507c997c9ed4e03a24bbcadb4a9efe10980f6d7ad89604e3ec4b68d', '22b89e99bc17c966b861156ba07d1c226170af23ff17da1fa83a6a656f212c28', '49f75163f1229d0a56d206a62745f7687935c0a3f4f7f7494d6291670873aff8', '3b971c7ed1d74e6b04f4df38965b855ce6755b365bbbb7174beb8c110e8de0b3', 'd26ec760d6d3160232fe7224f01da684aef328da0ebccc1654a4a7026bdcf0dc', 'c75ab94d611ee05d199f587eb0e5e80c599cba49f62c08b33f0b2dff7d63b047', 'ecdef2d55ea0c6d03a72d2bcf04cc8aacd798fa5240ef3a8968856df79d8879a', 'ae66889a6c4c11b8a97c82de40a2a5343be65d4522f4a8d6da79c3c13f97a67d', '6c1097001ff3d76dd744dbf5ce9b0bb1736de22b1ac25c97bf5a0cebdc033d06', '5aea6828dda0ca171aa63d2a0699a7b2bbf70fbdc19b97aaac41f18ea0e0b8a5', '5ca0433c59c27542b7af9ca950ae9d833d22d3813cc9a6050721669e05395175', 'b462a4c1ae14b215a58727523ce71a6105f1afc11b6e047ba15956d2e2ab0a60', '96724affff4832a1c2e742889f88c85d647db0044a6aef3d04cdf6d6d1a19f20', 'b69d3760a765b0bfeb2c024962c982d6b2e6a815e9bc410af164b4db31265f1d', '741964c1f4437d6d67ebd65cf75dd5710c31eae7770cd1c119bc9c2e30d4e04f', '6d3b2e2693e6680bb64eb6489cf6fe1c5b9a48e07cac71726d5217155c6d546b', 'b6d4f1445d6e3d51c2d3183924014b19c5446c86e008bf6b7b3382777f11ceda', 'd6020a65df6c235801f4891fdcc404ba36135782989adf5e72e14492e78390b6', 'ffa733b1aa6afa801fc8421e7845e17101a1c96c5ba745ef784afc8ac93f70b6', 'f36f9eb4804efd68ebb6753bd4671c86f3791f74b0da9d59e7c3729cda4e440f', 'a9648e53252182a27548aca84adb5ec09e3a803ac758de55c43e87d0103770fe', 'f607e0972c9fccb0b367424e908c2a4d9f87aa6bfcd71f6668be492dc00f52f2', 'dfc48681e4c47af531000ed1963804187abc4d766153781e89587416e9b39197', '963758c3c6251a75934e6bbd71c3e1af1c81dc53e52d3ea74ffefaf9fa3084de', 'def116c90df09aa772f4dffd3941f51ad6f394ba5631d8810f78c808c9fc1abb') OR (s0_.cycle_reference IN ('1ad7ee402982cc23cd35754a93fa59e4d39cab6b683eac32414aef367ce62743', 'c1a02445448c060b271d9197048350b6fb8ceaa8433de8627b05b99fb9de5019', '6242063df4b0c77c9b275ebc7a7901b0b203ea986fbd067d670b0d6cba884b7b', '1f443207d07f10365d606f0e76c09fc56f4f9ca8072b14046b81d83e73ba3662', '27b4d7ac6b0b8ae1cb78c4e627593aa5e6227a99e1f277dd73810d495549827c', 'b8f80a035266d8bc83ff09008df354f910ef7185e8a386fc3ecc448e1166b93c', 'ee44dc9176973ea62dbe9187e00d243c86dfd068ac67cb62f07d9b7f5a9b6ac4', 'efafe4ed104c74f58b748128735656bc834f53624f5aa38779c243d9a87e1017', '651b428a82a664280743a44a7c6fff643934431b36cab8d49515b84a1fcd8e56', 'd4f7cd5f2ea64577f0e3ab96bb6ec316fd1628abe528ce7fc3bf16253bd9810e', '5c5b40ac92e2e435422f91fb0aa2cd50d51055af5ffeb0c063a0ab41f5a326d5', '8793a483c9941bae412d26f87edeb1d54b6465e115d4b30206780406911d0fbc', 'abf0d4f1e9bcb6efb149a7c7a991dd145729a2a23982fc15e26c9063957db65f', '0b83f2a1fa241a30f7a703755fabb02bea39a62e2ba7679fc67f65f2eaaec34f', '3ea888af99727e3b9708fddc49befcd1c343d75e7b494e9ad5231007bc783e0c', 'e7f2ceed4c7c47991170edd00157996676350d042f3bd73f257f95fb0db10155', '1342b741c97602ef81f41d75655df3fa05c17f4451e638212d47827e4409c4e6', 'f8835c938b1bf07a7e52158cd1dfdb706fc9e5be622fb4d35104a4c9ed6d38c7', 'ae264fb6d03a6e3fd13956ec447c1831b9de2573077a0b8899eb3e643129c658', '82aec0b6a2f985ca773614371a609612f5b419158634d56124077813ae1421c0', '61a7f9dd16d30111dc83fce7d1cedd64a18ea0343e7e50a96666b9703600ce38', 'f15fe88c09124db719cf2bd128607f6d9e58e578e893bb224324ec36ff09dd6f', '02a11089b53e0779d01f720867f6546163f074834ae6cde61581922c70cc4a9c', '405a50f318cfb2775983bd1ba7a4355740c68eb9a66a38437ef207f35d3eb44a', 'dde08e2a373fb86537644eb690a429a03bae615c686169e6a70ecdb5ee8a0bb7', 'b5903436995d31a46302e85fc280afc90682d07b3a6d21656cc23b6535e38d89', '4f9573a58fc5bd71b9acad1eab29014ca6010dc9d6693d78676b5589325b20e2', '0f26571886def5424bb6154a207fb458d0df53979d54efe47aa846cc20006a94', '02d291ef822ef4bca73e52d6b9b5d3d0e89c1fe20adefdf982f14ad37519ab08', '422fb40f6b0cc1afbd6fe1d8d8d28fa2bd16c9154a0c0c6f33fe03fd823f421a', 'e60e2a5ba140b17076b4a4072675f7ed4e3d3debba41db10b2b323ae5a638f54', 'b7bbca4512477455deb693bd7f5f4e4275b4c012513a30ef838ebf88ebf06968', '13a34e96b5e9c9b6340aeb26529a1b8dd1afbfa2c75660b6cb98582af2da1d7a', 'ce4fbb2ab4fe082f4538c5db9fea05a1838a48e8cf979f96e671fbce56125bb3', 'f4a64690f6f5f0e1ed31515dbba5c47548505171bfda862463dc7fd36b5fc890', 'c978f5c48661b892200629a789ab558b0ea08bc33af6dc67205cc17c4b1e9756', '447be874f2e8ae60db5a6f10e81029ac2129bdda339b357cf03ad838aec3f331', '781c627d1a3b7d46e8248bc4c1fa89a8584556e142e6cd81b5980f74279ff61c', 'ee15cf45f2620219b445ff30a2531762bd6798da2ff15ede3b2f51b78d448e6e', '5432b0830157f0a241f18ecc5a9d86842e0f907b1c59144eaf0680725ce6ed30', 'baa8735ca22c81010e4a081b988b62f01420b8096b6c5e924ea3e2cfe51dffdd', '6087180d1553eae80e20f71639f678c701a8ab00b802432f943effb16010910e', '5de9745f0edcc3520e2753c37f4f50f6e1abb74d97c139849f1fa7c13173c8eb', '04968a00f882ff7a271a225406de3cce1bda34f2270fdc643a9899cafae7d1d1', '09427a830443c72323d3d2240acd9b7bb26abb34a8d64c9541174b8b6b353eda', '5634d950291bbfb56898e504c17b7f492896df22ce10936014c1e2e283a74779', '5fa660328eb0e343913eb32a099ef2deced17f6fae681f58f8dcdf8787d63c5c', '5d06a80b27c7ba80592bb5dc361663af92357a4ae03d2650344d159ece5f5384', 'b7343cd224ef646507d5c51565433a00fb0b9fd535d92643ddad0ed9952971fc', 'dbc734e85555f291404a5e141cf0c14409c72392ca8b8892b91107d85c193014', '40182ded31e39cafa1004ca6812800b40adb0efa6b25af4455418c7013286def', 'eadb1665e8af3ac18c315fbcbd23139c0075c76d522cbb8fd50f30fd00dcd0dd', 'c719d7e84ab274028edd902c7e0ef791b691aca39d7ca1464b49be594371b0da', 'ccbdace9ef8cb15a7502a01cd69fd37fb2ed1118f20ff31009c4639989ac2cf8', 'e059418f2e580747b852928316e57ec7965b1f9e64ecbaca9616832707c5980e', 'fab590e3c23c816b9bc5e215aca28a9e2d54ec4a2f08acd6c42eb02c53e022fb', '4b5e9924a443f8a89cf4cbdc1f29fc207c8dca95c3bed51e5a7202d5215de158', 'e698acf52554338877684bcb67bfff85365d2e670262852102159c8f7a16fdb8', '7afb25ff3d7dc0b2e220d6d37f7c8471cbb3bfa47c99a40362979c6ff4f326b7', '86dd199d5d2214cd2a374552f087ad37ae093974d7615bb02af78ede37c43271', '8da7e636b12fd06d075972f00e7d92f523a364f5116deb4d2e01e2a55c66936b', '1457b857ad6a36fb328c7d87fe47de76f53e23427e6c53e044a89f4c6f9f4824', '299318c42f4a0357cd3214c436f59ded350b2b7f8d317ca674bf1eafe256c05a', 'd8fd5138dbf53e6bd021aef19232a16854554b6ec98146878cc15cedd84556d7', '3e394511f8c824b27e590d360428c169bea8300d2f3211212b9c88c511fe0e87', 'a4be23447fabae4989f6f0de24045bdf4f60b2971ce1165fc8fb4092ea30ed88', 'ffbb96905329d3814746fa5dbb719ab54df3f5b82723c30b768760c30ee8a01a', '68baf8079919a599778c46185733ac44a516fdf80068930d1c09cd714f6c56ea', 'fef08c2708e086e0565bf9bec53db3e3aeaba6cd8315973acb698060d1c3b22d', 'ea5048f34f150e4e51bd2ae690bbd23ff3d17ee4b1dc9cf20d2e938d143a0105', 'ce7ea4389d5e02a280bc1bb684c6c3497dc7ef7650667426604f0776990e940c', '65b27a884fa6071d2f52403ac202e99c061bcb446f801e28bda3a843a66d1f40', 'ec309f8d550bb24a0b1be96bd881d00de4720c3381b62b47310617310c1886e2', '1a8fa4ccee5165a7a1014eab64def7e4189407217cef7886301680e95ee6683d', '1d118a659203d653e03e437d2353eab23c975c3f9a4d1e3d64eba037427e617a', '275218914cafd3e0e6124bb60fab0bd13a160f849e437cc233f8e8a043ccab5b', 'a46ce8c99cc02b5858128837b1f9a486ce7894556ae7edae2eb0e1f81bcf8013', '8bbecfabc35587d00c02cc6a683b9c347ebe3e5ee0832cc37703956214e58ad2', '1fc9b255241ca7ca1dc912e3ab6c6d8c53684a51104d2e114b69cef9b5d0a467', 'c34876eb51814ef367f724154e4db627dd7e3a76cc3c8c245bed826ff799f533', 'c4c50f6fbc4e68a66029b87188bd02c4176359233cbd12bb20e10fd4ed73ddfe', 'a79df69c61cd7a4ce6dae22b85bf91f73170eaf0f62cd92a52e17e26c7d64c6c', '45c78626566e6078bf6c7daf910ad1970e413ec23f9b1e1f312a523f8a7ad14b', 'd51e3c5661edba314add96627650a6a010fc32f3d4368d8b895989d94b613309', '6dd6515cdfc891462f4a039339479026c4622518d210c4f9549c70923391d6e3', '43e24a6db769a6d0afd85702c9671605a77d3f65092ae8a3edff8e1eea439ea4', '361fb74141980b059bedc534d5e06bb7782c32840af5830c3e059cc525344588', 'defdd29581f146f0a20a4ab2c13432596b93b41ea4e6921058408fc148c3f1c9', '3b2fecf9fb569cbcca9bb1d31ea7b1001d88abf59bccfe8634edf86fed92b932', '8588069981f41c08a7ab1dc2efd5b358f36a025681ca77d11c33d5d53004f63f', 'f4b333765cd163db4324b545ae9f037a8bfe3ac2ba903bf405cd94e3722e25d6', '82e86a482e2b2cdbc22d3402700fbdcbd5b761ea0706f7bc9a9f9651bf3a6b6a', '442676b75e3f5b3fb2f282d09ac1eb922735ecabb42a13fa248b6817ee96e687', '61e8d69422e6fc658a209adf482afeccd68033ccbec727588bed7416b466b6f5', '3a09f0b56c6594c6473dbfd81225110a96f6f5f3c284b47bda32ac2c9f1923f5', '3fa3027361bb659f863f9b60e6e577349a45b6284daccd4ab95af753ff1d4f17', '342563726127ad3ebd66c9f701602b590acff4102702dbcb033a8683cdf39480', '20fd7b09559588d836d47166116253bac4720cab9f0ff524561acc36e25cdcda', '9924bea4c8ce9621ff8dd1c359c1fdf00bb3ec0f6f14d556690e61a20a87e873', 'ef8ad63253096a035026cfebcf747d34a2c6705d910698a68ca7a4e366b95919', '00d70d2ff0027fa1db5366d1a43f07ddd38d6607667dc38cc26362a2e207e0f3', '0c5f0dfe610d668d8d766767010369c6ee5b9f75e1f48930a5bffb7db8d8d530', 'e783ae4316fcde3ab3ca51adce544a419c21be3ed1c137e40210b8f19eb3790f', 'bf2f2d1a388b91e8bb91039c5557a415b997500faff8c660b1dfab4a15854bba', 'fdfe0de94d867befe72a08c20ad906779363ad04517430cb8cbf957a062b6223', '36eba759c3a69b50cb823fc1d70a8908d42844f1d9278b2237634b681ecce4be', '8886cce3b9374bf8f0257c47e8c93272c0d3f48dc2debe40ca1c2e0a25296171', '873519cce211cf3ec215d535285e0cd693c281ce88f04206667249049df09ab4', '9d3632b7e1a4e1078a5c352b5d16061a6ab0d6a60972c53e3e9fd39af7a38135', 'f14b1c993cdcf3e6d2bad3e125fde80106c626d27ea5aa6c552ceeeb67468800', 'a812eb0eaa93694fca064ac5e98c83bacd66d209f1445de910522907f36df26c', '35f9af2e9881605921ffab31a1225262eb3c26efac7fe418179436d7d4e9cf99', 'c0281428b1ed5a7188f604b58698452048b0d3b2383aea8f938e65381f6b66f6', 'a9bc012e8ac7ca046c4045faa9ef9fdbecf792f611192b3bd15e52257f80fe1e', '0eb10e360761009c17c6e19ce5a87b91da4fb5b0a3bfb85d129f7f661ab89a8a', '49f8876cf3219d021e7ffb6636028916be7ee1f603952ab0f216d3e355da2e65', '5a379ecc46e8e0c9b7ed96079bd2ac32c7e561294dd49c7c12793bd7f1a200f0', 'c23c999dd37898a014ed9084a30cb64b4a9a321d217f12c267740414499104a4', 'f1eb95fecf20f1791e32293bc59aca7febd016df55daab681422bef4d6ee0d3b', '986df9f92f77c78bcf8e5efb1de961eb8d2f33f0d9f2ae2be22b83923db60f82', 'c885406dcb8681c898df92513f270b382cb036a369178c4347243684e6e0d8d6', '63dabd1bade02280c818ba67124bb6f0f3b22b54a4c71d4f1d67948005141cb0', '073d7f45fc53d5012445a7186f38f429317971add503cac3ad1c7653fd617ad5', 'efc3fd1041058d95dd3efc986aacad7e82cf12ffb2faeb6b9870a0450ae3ae02', '24f6e23100e550fb6516335fc095df4489c839205d7a30c09bb7e01d05a92466', 'ca1d3aca6845517527b1912f96e7508a67929a6beb029313fbec6dfe1470c7b4', '2e578d11d7c84714a31fc70d93a4c1296fd1cd5ac718b869e74853bdf3538ae4', '7c7a90d3cdef66e1830e25c66e526a69d7532c99b9bc6507ad177446e5226a46', '9d0c3e4d7480efced21eff17d76ddb8bd24faeaf6ca80957a314193d726653d8', 'a624861418723e86571f3841f5bf1d9434111d676427cda345930aeef49776e2', '4da8d3d4226b2afe18581813182dce175946f0091882bb71a2eeede721a47f58', '10de33398f66b91c6161fb335ce4be6d6f4ea307b035cd72f11b4da5f3833659', '430a43d793fb44dab9161d68f2884bf3c3d19058eca7809c7872d1e961ba61c3', '888fdd16465259eae598490213220102df261189ca69dce307d82dad796d5c48', 'db049b00c5b076beda8e709d201654fc0108b9f69cfa7f2f1f540bda83f7f957', '122586f31e588ee8541843bcb98d6b55210aa98a08bd5b37ec722883c7f5f039', '189dc7bfb995ed5684890f4cda542c3da326691b97fc50ea5f8336f8ca8bc7de', 'eb84bbfa6847f1ea625ba96504bc68b2cb628232549a157b1c2362ac1fa991d8', 'bd5bbc7258ad6f2ac1a81e443979806bd107ed71cd6ebb9e621f93447220d9bc', '171fca23b244f07e49a85c5553ba2f899fb66b7238f6bee58b3898fb8294576b', '4dcf5f4cc77385525fc8d8bebe6df50ad431062218ccabb81f8e37d6ddc475db', 'fd71011bf475aea1073866275b89b5c31bb97f0210c7550bd229af726fa2b598', '24164367f2fb2e0aa202b74bb346c1fb6a86d38c957cd75f9c132d539a6affe9', '6c8fb555c1073ce8d38b0b7acbf4ffa3ce50d088336f7feea537002a5714ee58', 'b378d93c1b31cae3e13a78b6859e8d97b5f138499ca32d1ae6bbd3ada412a27d', '6f3a6211fde3b49a654e1b89ab43ca237c6359a1f18e54422a2f3a59d35182e5', '5854a2f667d019b9a2a3990c48c3a190eb476213a0ffa3aafe15faa20b9a7f83', '87dda85c68ce578fc37fc6e814927dd76ad52d0ba43a56698b9093851c94f89f', '845b7def672c27dfd39a550ea8212a60c0189290d8d29b106770390820b90eda', '0f5d6fe0276ef63cb4c094c007847ffb18b3c94ce3748a037e1c895bbd56816f', 'cbcd3579faaf670c678d1a094a4708565b118df45ea98a5a63696b47b70a7891', '756ee90a1b8292a3694cb7a7d98d3a115068421dca3c3d47d5839b5fd7f69620', 'e65a4c3203f9332d467d68e33f597ff9af197bdc6291ea2b4476574e1068fcbd', '66c8be51e84f917a386e5b05bf2f29153844577df844f57091e89208907da431', '264236ae1674dbc82d35935f3416c24bfd9cfe8c115118fd4177b58a6410ba1e', 'f2548d04ec211bf29f30e9026ce405fe9a9a4af7ee033eba3edfd8f8b76983dc', '493ee48aff5850e41072e41b0d475b035fb0f7a00bf0097e330391371ad8c10a', 'ba5c2d1544c40a5dd688f1289b627f0c1b729bc4af59368cc335b9914121bc6c', 'd771d74de48d3d8ed553abf9ce6a3102e01b8f066ce4df3a001bbd8c9ef5701f', 'd3b419ec3566722d93b567ade5e5ad4b0e89b8dfcf11af9c33c58d6e0ad5aadd', '4201f8443325bbe797daf0fe3b0f0637c0fe84cfeaff85e083248ab444736426', '04f8b05475cd0f42606e02e748baf2992b5e205141f74c9cd555fadb458d8b02', 'ac8f7ee5140a44a3f6e66fde15bc79d574a4860688d429075c9e46e335e56384', 'fb233d2269eca1261162ec7e16491b5b601544c98c31ae9f0e76d53b5c796241', 'bf1ee145d1bdde0b27b7a80388dc3d2f15ed7b4c888e03ba024ed9eb57c95207', '723a12756e0c4778395c35b68942e7be89825cf422a4a29fd891650a16580d7a', 'bf311aed566dd7866edfbac327282a902a7fe4b250ec03d2fa1d9acf44838496', 'c02e2bf9339cca8742ca88b130e24bc950b2d82dc2d069a049e1bdc8c8846503', '087a77431d88f52b17f07ffde11ce41b2a42f76d86f4d8d9630a5b02e904b73f', '15ba1cb4b6dcc97b3284a5efe49f9c293191404c8e7b8721fc77dfb9546e3060', 'd36209d4614df5d5531f1c532f5354b217a2cfb3c045630a32ada517b60c9064', '26853c084c1ada632f9c72cd0bb5fb18868ce8cbf4d14b773d4cd7cc6f1108f1', '93fc725360b0ee2d2e4c1bc38616a8cc50d2b4d04f866762e1afca4a8a5fbd2a', '80ab80d0505990d1a278276c014ea06c2f7d81e091d00c12c188917c7c2de6df', '50e7289473970f5f2c44b9612b8219813d6e0193a47ac3bf4d2195743f0cda7e', '593260e4a167e81956e16b244b6f00c99560fc59a0ce6e87eed6fee5ab2c048c', '753ca416720a670dd0ad0a001e16883ab6f2013c31b72077664dfcf750c17779', '85ac70edcd62ca5ad22f73be5ef03d431fde3650f9df6e09cfdb0d03e9ff5ad0', 'f65c70161f1aab8c8641e532097fa5c14542cae6fcc80b17a5991a9ff8d56354', '328b13118b24f700c0c232af275bf13316d26f8f942d24a497d3af6b79f83d27', '5a66b445b507c997c9ed4e03a24bbcadb4a9efe10980f6d7ad89604e3ec4b68d', '22b89e99bc17c966b861156ba07d1c226170af23ff17da1fa83a6a656f212c28', '49f75163f1229d0a56d206a62745f7687935c0a3f4f7f7494d6291670873aff8', '3b971c7ed1d74e6b04f4df38965b855ce6755b365bbbb7174beb8c110e8de0b3', 'd26ec760d6d3160232fe7224f01da684aef328da0ebccc1654a4a7026bdcf0dc', 'c75ab94d611ee05d199f587eb0e5e80c599cba49f62c08b33f0b2dff7d63b047', 'ecdef2d55ea0c6d03a72d2bcf04cc8aacd798fa5240ef3a8968856df79d8879a', 'ae66889a6c4c11b8a97c82de40a2a5343be65d4522f4a8d6da79c3c13f97a67d', '6c1097001ff3d76dd744dbf5ce9b0bb1736de22b1ac25c97bf5a0cebdc033d06', '5aea6828dda0ca171aa63d2a0699a7b2bbf70fbdc19b97aaac41f18ea0e0b8a5', '5ca0433c59c27542b7af9ca950ae9d833d22d3813cc9a6050721669e05395175', 'b462a4c1ae14b215a58727523ce71a6105f1afc11b6e047ba15956d2e2ab0a60', '96724affff4832a1c2e742889f88c85d647db0044a6aef3d04cdf6d6d1a19f20', 'b69d3760a765b0bfeb2c024962c982d6b2e6a815e9bc410af164b4db31265f1d', '741964c1f4437d6d67ebd65cf75dd5710c31eae7770cd1c119bc9c2e30d4e04f', '6d3b2e2693e6680bb64eb6489cf6fe1c5b9a48e07cac71726d5217155c6d546b', 'b6d4f1445d6e3d51c2d3183924014b19c5446c86e008bf6b7b3382777f11ceda', 'd6020a65df6c235801f4891fdcc404ba36135782989adf5e72e14492e78390b6', 'ffa733b1aa6afa801fc8421e7845e17101a1c96c5ba745ef784afc8ac93f70b6', 'f36f9eb4804efd68ebb6753bd4671c86f3791f74b0da9d59e7c3729cda4e440f', 'a9648e53252182a27548aca84adb5ec09e3a803ac758de55c43e87d0103770fe', 'f607e0972c9fccb0b367424e908c2a4d9f87aa6bfcd71f6668be492dc00f52f2', 'dfc48681e4c47af531000ed1963804187abc4d766153781e89587416e9b39197', '963758c3c6251a75934e6bbd71c3e1af1c81dc53e52d3ea74ffefaf9fa3084de', 'def116c90df09aa772f4dffd3941f51ad6f394ba5631d8810f78c808c9fc1abb') AND s0_.submitted_at >= '2026-10-25 22:00:00');

SELECT
  s0_.customer_id AS sclr_0,
  MAX(
    COALESCE(
      s0_.accepted_at, s0_.submitted_at
    )
  ) AS sclr_1
FROM
  sms_recipient s0_
WHERE
  s0_.status IN (?, ?, ?)
  AND s0_.customer_id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
GROUP BY
  s0_.customer_id

SELECT s0_.customer_id AS sclr_0, MAX(COALESCE(s0_.accepted_at, s0_.submitted_at)) AS sclr_1 FROM sms_recipient s0_ WHERE s0_.status IN ('accepted', 'unknown', 'sending') AND s0_.customer_id IN (7, 6, 4, 8, 17, 12, 15, 14, 23, 22, 18, 19, 40, 38, 28, 27, 26, 34, 31, 33, 25, 36, 39, 41, 43, 44, 42, 47, 48, 46, 45, 50, 49, 56, 58, 60, 66, 63, 59, 65, 62, 61, 68, 75, 69, 76, 73, 78, 74, 79, 71, 80, 29, 84, 83, 81, 82, 87, 88, 86, 90, 94, 92, 91, 96, 95, 97, 98, 99, 100, 102, 104, 67, 85, 112, 118, 115, 105, 114, 111, 110, 106, 107, 109, 116, 119, 133, 132, 126, 122, 129, 127, 130, 124, 131, 121, 125, 134, 120, 123, 128, 138, 145, 141, 139, 144, 140, 142, 143, 137, 146, 150, 147, 148, 149, 152, 32, 154, 155, 159, 158, 57, 51, 161, 165, 160, 164, 163, 162, 35, 169, 168, 170, 172, 167, 166, 173, 171, 177, 175, 174, 180, 178, 181, 176, 187, 183, 185, 184, 188, 189, 186, 196, 198, 191, 192, 195, 199, 194, 193, 197, 190, 202, 201, 52, 206, 207, 156, 204, 203, 205, 208, 213, 216, 217, 212, 30, 211, 209, 210, 214, 215, 218, 226, 219, 224, 220, 221, 223, 222, 225, 9, 228, 227, 231, 234, 230, 72, 233, 101, 232, 229, 235, 53, 70) GROUP BY s0_.customer_id;

SELECT
  s0_.phone AS phone_0,
  MAX(
    COALESCE(
      s0_.accepted_at, s0_.submitted_at
    )
  ) AS sclr_1
FROM
  sms_recipient s0_
WHERE
  s0_.status IN (?, ?, ?)
  AND s0_.phone IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  s0_.phone

SELECT s0_.phone AS phone_0, MAX(COALESCE(s0_.accepted_at, s0_.submitted_at)) AS sclr_1 FROM sms_recipient s0_ WHERE s0_.status IN ('accepted', 'unknown', 'sending') AND s0_.phone IN ('306980379808', '306943828440', '306951379516', '306938428827', '306972284862', '306988612794', '306986624335', '306943403503', '306976222570', '306972408582', '306977898835', '306974815096', '306982886490', '306956333444', '306972103382', '306951776510', '306931807733', '306959672741', '306948345621', '306955649717', '306942213830', '306942514406', '306987722189', '306978902511', '306974248106', '306945086119', '306942774321', '306936187265', '306949606483', '306942039110', '306945374133', '306970468715', '306974192083', '306974634865', '306971903034', '306937377392', '306944595118', '306971583730', '306987962237', '306986591495', '306978940859', '306945568705', '306943195517', '306945415395', '306976191361', '306940586875', '306987209456', '306948143950', '306939199197', '306982583511', '306944745434', '306959754245', '306955394390') GROUP BY s0_.phone;

SELECT
  c.id,
  c.name,
  c.softone_code,
  c.mobile,
  c.phone,
  c.active,
  c.sms_marketing_consent,
  COALESCE(p.purchase_count, 0) AS purchase_count,
  p.last_purchase
FROM
  customer c
  LEFT JOIN (
    SELECT
      customer_id,
      COUNT(*) AS purchase_count,
      MAX(date) AS last_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
      AND date <= ?
    GROUP BY
      customer_id
  ) p ON p.customer_id = c.id
ORDER BY
  c.name ASC,
  c.id ASC

SELECT c.id, c.name, c.softone_code, c.mobile, c.phone,
            c.active, c.sms_marketing_consent, COALESCE(p.purchase_count, 0) AS purchase_count, p.last_purchase
            FROM customer c LEFT JOIN (
                SELECT customer_id, COUNT(*) AS purchase_count, MAX(date) AS last_purchase FROM sale
                WHERE cancelled = 0 AND gross_amount > 0 AND date <= '2026-10-26' GROUP BY customer_id
            ) p ON p.customer_id = c.id
            ORDER BY c.name ASC, c.id ASC;

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.default_days AS default_days_3,
  t0.enabled AS enabled_4,
  t0.first_order_message AS first_order_message_5,
  t0.second_order_message AS second_order_message_6,
  t0.restock_message AS restock_message_7
FROM
  remarketing_settings t0
WHERE
  t0.settings_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.default_days AS default_days_3, t0.enabled AS enabled_4, t0.first_order_message AS first_order_message_5, t0.second_order_message AS second_order_message_6, t0.restock_message AS restock_message_7 FROM remarketing_settings t0 WHERE t0.settings_key = 'remarketing' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.encrypted_client_id AS encrypted_client_id_3,
  t0.encrypted_api_key AS encrypted_api_key_4,
  t0.sender_name AS sender_name_5,
  t0.oauth_scope AS oauth_scope_6,
  t0.public_base_url AS public_base_url_7,
  t0.enabled AS enabled_8,
  t0.updated_at AS updated_at_9
FROM
  apifon_settings t0
WHERE
  t0.settings_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.encrypted_client_id AS encrypted_client_id_3, t0.encrypted_api_key AS encrypted_api_key_4, t0.sender_name AS sender_name_5, t0.oauth_scope AS oauth_scope_6, t0.public_base_url AS public_base_url_7, t0.enabled AS enabled_8, t0.updated_at AS updated_at_9 FROM apifon_settings t0 WHERE t0.settings_key = 'apifon' LIMIT 1;