SELECT 
  cscart_promotions.*, 
  cscart_promotion_descriptions.name, 
  cscart_promotion_descriptions.detailed_description, 
  cscart_promotion_descriptions.short_description 
FROM 
  cscart_promotions 
  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id 
  AND cscart_promotion_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id 
WHERE 
  1 
  AND IF(
    from_date, from_date <= 1734010657, 
    1
  ) 
  AND IF(to_date, to_date >= 1734010657, 1) 
  AND status IN ('A', 'H') 
  AND cscart_promotions.zone = 'catalog' 
  AND (
    storefronts_promotions.storefront_id = 1 
    OR storefronts_promotions.storefront_id IS NULL
  ) 
ORDER BY 
  cscart_promotions.stop_other_rules desc, 
  cscart_promotions.priority asc

Query time 0.00136

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "71.12"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "36.55"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_promotions",
            "access_type": "ALL",
            "rows_examined_per_scan": 43,
            "rows_produced_per_join": 4,
            "filtered": "10.00",
            "cost_info": {
              "read_cost": "13.74",
              "eval_cost": "0.86",
              "prefix_cost": "14.60",
              "data_read_per_join": "344"
            },
            "used_columns": [
              "promotion_id",
              "company_id",
              "conditions",
              "bonuses",
              "to_date",
              "from_date",
              "priority",
              "stop",
              "zone",
              "conditions_hash",
              "status",
              "number_of_usages",
              "users_conditions_hash",
              "stop_other_rules"
            ],
            "attached_condition": "(if(`webmarco`.`cscart_promotions`.`from_date`,(`webmarco`.`cscart_promotions`.`from_date` <= 1734010657),1) and if(`webmarco`.`cscart_promotions`.`to_date`,(`webmarco`.`cscart_promotions`.`to_date` >= 1734010657),1) and (`webmarco`.`cscart_promotions`.`status` in ('A','H')) and (`webmarco`.`cscart_promotions`.`zone` = 'catalog'))"
          }
        },
        {
          "table": {
            "table_name": "cscart_promotion_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "promotion_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "webmarco.cscart_promotions.promotion_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 4,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "4.30",
              "eval_cost": "0.86",
              "prefix_cost": "19.76",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "promotion_id",
              "name",
              "short_description",
              "detailed_description",
              "lang_code"
            ]
          }
        },
        {
          "table": {
            "table_name": "storefronts_promotions",
            "access_type": "index",
            "key": "idx_storefront_id",
            "used_key_parts": [
              "storefront_id"
            ],
            "key_length": "4",
            "rows_examined_per_scan": 40,
            "rows_produced_per_join": 36,
            "filtered": "21.25",
            "using_index": true,
            "using_join_buffer": "Block Nested Loop",
            "cost_info": {
              "read_cost": "7.50",
              "eval_cost": "7.31",
              "prefix_cost": "34.57",
              "data_read_per_join": "584"
            },
            "used_columns": [
              "storefront_id",
              "promotion_id"
            ],
            "attached_condition": "(<if>(found_match(storefronts_promotions), ((`webmarco`.`storefronts_promotions`.`storefront_id` = 1) or isnull(`webmarco`.`storefronts_promotions`.`storefront_id`)), true) and <if>(is_not_null_compl(storefronts_promotions), (`webmarco`.`storefronts_promotions`.`promotion_id` = `webmarco`.`cscart_promotions`.`promotion_id`), true))"
          }
        }
      ]
    }
  }
}

Result

promotion_id company_id conditions bonuses to_date from_date priority stop zone conditions_hash status number_of_usages users_conditions_hash stop_other_rules name detailed_description short_description
59 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:21:{i:1;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:399:"9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10393,10394,10395,10023";}i:2;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67551";s:10:"value_name";s:12:"Marco - Alpa";}i:3;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"66278";s:10:"value_name";s:11:"Marco - Sev";}i:4;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"64567";s:10:"value_name";s:12:"Marco - Mini";}i:5;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67578";s:10:"value_name";s:11:"Marco - Mog";}i:6;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67594";s:10:"value_name";s:11:"Marco - 500";}i:7;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67595";s:10:"value_name";s:12:"Marco - 1000";}i:8;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67596";s:10:"value_name";s:12:"Marco - 1500";}i:9;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"64569";s:10:"value_name";s:11:"Marco - Ton";}i:11;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"64542";s:10:"value_name";s:11:"Marco - Woi";}i:12;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"65030";s:10:"value_name";s:12:"Marco - Bebe";}i:13;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67620";s:10:"value_name";s:12:"Marco - 2000";}i:14;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67619";s:10:"value_name";s:12:"Marco - 2500";}i:15;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"66102";s:10:"value_name";s:12:"Marco - Cosy";}i:16;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"64566";s:10:"value_name";s:11:"Marco - Pen";}i:17;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67634";s:10:"value_name";s:11:"Marco - Ser";}i:19;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"66138";s:10:"value_name";s:11:"Marco - Esc";}i:22;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"65031";s:10:"value_name";s:11:"Marco - Def";}i:23;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"65029";s:10:"value_name";s:11:"Marco - Div";}i:24;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67566";s:10:"value_name";s:11:"Marco - Vau";}i:25;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"lte";s:9:"condition";s:7:"feature";s:5:"value";s:0:"";s:10:"value_name";s:0:"";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"50";}} 0 0 0 N catalog categories=9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10393,10394,10395,10023;feature=67551;feature=66278;feature=64567;feature=67578;feature=67594;feature=67595;feature=67596;feature=64569;feature=64542;feature=65030;feature=67620;feature=67619;feature=66102;feature=64566;feature=67634;feature=66138;feature=65031;feature=65029;feature=67566;feature= A 6 N Marco Kids - 50% (All Collections)
67 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:9:{i:4;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67595";s:10:"value_name";s:12:"Marco - 1000";}i:5;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67596";s:10:"value_name";s:12:"Marco - 1500";}i:6;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67620";s:10:"value_name";s:12:"Marco - 2000";}i:7;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67594";s:10:"value_name";s:11:"Marco - 500";}i:8;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67619";s:10:"value_name";s:12:"Marco - 2500";}i:9;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:458:"9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522";}i:10;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67612";s:10:"value_name";s:3:"50%";}i:11;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:2:"eq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67613";s:10:"value_name";s:3:"20%";}i:12;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"66102";s:10:"value_name";s:0:"";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"20";}} 0 0 0 N catalog feature=67595;feature=67596;feature=67620;feature=67594;feature=67619;categories=9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522;feature=67612;feature=67613;feature=66102 A 0 N Marco Kids - 20%
77 0 a:3:{s:3:"set";s:3:"any";s:9:"set_value";s:1:"1";s:10:"conditions";a:2:{i:1;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:5:"10450";}i:2;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:2:"eq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"66149";s:10:"value_name";s:12:"Marco - Polo";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"50";}} 0 0 0 N catalog categories=10450;feature=66149 A 1 N Marco Kids Polo - 50%
26 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:1:{i:2;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:8:"products";s:5:"value";s:299:"3612,3613,3614,3615,3616,3617,3618,3621,3623,3624,3625,3626,3627,3629,3631,3632,3635,3636,3637,3638,3639,3640,3641,3642,3644,3645,3647,3648,3653,3656,3657,3662,3663,3664,3666,3668,3669,3670,3671,3672,3673,3674,3675,3677,3678,3679,3680,3681,3682,3684,3685,3687,3688,5005,5083,3601,3603,3604,3606,3608";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"30";}} 0 0 0 N catalog products=3612,3613,3614,3615,3616,3617,3618,3621,3623,3624,3625,3626,3627,3629,3631,3632,3635,3636,3637,3638,3639,3640,3641,3642,3644,3645,3647,3648,3653,3656,3657,3662,3663,3664,3666,3668,3669,3670,3671,3672,3673,3674,3675,3677,3678,3679,3680,3681,3682,3684,3685,3687,3688,5005,5083,3601,3603,3604,3606,3608 A 0 N Sconto 30% !!! - Lady R di Rosina Mosca
29 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:1:{i:2;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:8:"products";s:5:"value";s:409:"5083,5552,5556,5557,5560,5561,5562,5565,5573,5574,5578,5583,5697,5699,5701,5702,5703,5704,5705,5707,5708,5709,5710,5712,5713,5714,5716,5717,5718,5719,5720,5722,5723,5724,5725,5727,5729,5730,5804,5805,5806,5807,5820,5821,5822,5823,5824,5825,5826,5827,5844,5845,5846,5847,5850,5853,5855,5856,5857,5859,5861,5862,5863,5867,5885,5886,5887,5889,5896,5897,5898,5899,5900,5901,5902,5903,5906,5907,5908,5910,5911,7309";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"15";}} 0 0 0 N catalog products=5083,5552,5556,5557,5560,5561,5562,5565,5573,5574,5578,5583,5697,5699,5701,5702,5703,5704,5705,5707,5708,5709,5710,5712,5713,5714,5716,5717,5718,5719,5720,5722,5723,5724,5725,5727,5729,5730,5804,5805,5806,5807,5820,5821,5822,5823,5824,5825,5826,5827,5844,5845,5846,5847,5850,5853,5855,5856,5857,5859,5861,5862,5863,5867,5885,5886,5887,5889,5896,5897,5898,5899,5900,5901,5902,5903,5906,5907,5908,5910,5911,7309 A 0 N Sconto 15%!!! - Lady R
60 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:3:{i:2;a:5:{s:17:"condition_element";s:4:"1012";s:8:"operator";s:3:"neq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"66102";s:10:"value_name";s:12:"Marco - Cosy";}i:3;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:458:"9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522";}i:4;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:2:"eq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67612";s:10:"value_name";s:3:"50%";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"50";}} 0 0 0 N catalog feature=66102;categories=9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522;feature=67612 A 0 N Marco Kids - 50%
62 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:2:{i:1;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:464:"9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522";}i:2;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:2:"eq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67595";s:10:"value_name";s:0:"";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:8:"to_fixed";s:14:"discount_value";s:1:"9";}} 0 0 0 N catalog categories=9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522;feature=67595 A 2 N Marco Kids PROMO - 1000
63 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:2:{i:1;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:464:"9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522";}i:2;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:2:"eq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67596";s:10:"value_name";s:0:"";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:8:"to_fixed";s:14:"discount_value";s:4:"13.5";}} 0 0 0 N catalog categories=9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522;feature=67596 A 0 N Marco Kids PROMO - 1500
65 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:2:{i:1;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:458:"9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522";}i:2;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:2:"eq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67619";s:10:"value_name";s:12:"Marco - 2500";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:8:"to_fixed";s:14:"discount_value";s:4:"22.5";}} 0 0 0 N catalog categories=9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522;feature=67619 A 0 N Marco Kids PROMO - 2500
66 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:2:{i:1;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:10:"categories";s:5:"value";s:458:"9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522";}i:2;a:5:{s:17:"condition_element";s:4:"1129";s:8:"operator";s:2:"eq";s:9:"condition";s:7:"feature";s:5:"value";s:5:"67620";s:10:"value_name";s:0:"";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:8:"to_fixed";s:14:"discount_value";s:4:"17.9";}} 0 0 0 N catalog categories=9997,9998,9999,10000,10001,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10034,10035,10036,10037,10038,10040,10041,10073,10077,10078,10117,10165,10166,10167,10168,10374,10375,10376,10377,10378,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10450,10451,10452,10513,10514,10515,10516,10522;feature=67620 A 0 N Marco Kids PROMO - 2000
78 0 a:3:{s:3:"set";s:3:"all";s:9:"set_value";s:1:"1";s:10:"conditions";a:1:{i:2;a:3:{s:8:"operator";s:2:"in";s:9:"condition";s:8:"products";s:5:"value";s:6:"435443";}}} a:1:{i:1;a:3:{s:5:"bonus";s:16:"product_discount";s:14:"discount_bonus";s:13:"by_percentage";s:14:"discount_value";s:2:"20";}} 0 0 0 N catalog products=435443 A 3 N TEST PROMO