SELECT 
  cscart_settings_objects.object_id as object_id, 
  cscart_settings_objects.type as object_type, 
  cscart_settings_objects.name as description, 
  (
    CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END
  ) AS value 
FROM 
  cscart_settings_objects 
  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id 
  AND storefront_values.storefront_id = 1 
  AND storefront_values.company_id = 0 
WHERE 
  1 
  AND (
    FIND_IN_SET(
      'STOREFRONT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'ROOT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:STOREFRONT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:ROOT', cscart_settings_objects.edition_type
    )
  ) 
  AND cscart_settings_objects.object_id = 6508 
ORDER BY 
  cscart_settings_objects.position

Query time 0.00171

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "ordering_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_settings_objects",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "808"
            },
            "used_columns": [
              "object_id",
              "edition_type",
              "name",
              "type",
              "value",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "storefront_values",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "storefront_id",
              "company_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "company_id",
              "storefront_id"
            ],
            "key_length": "11",
            "ref": [
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 0,
            "rows_produced_per_join": 1,
            "filtered": "0.00",
            "unique_row_not_found": true,
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "24"
            },
            "used_columns": [
              "object_id",
              "company_id",
              "value",
              "storefront_id"
            ]
          }
        }
      ]
    }
  }
}

Result

object_id object_type description value
6508 A wk_order_confirm_data_tpl_data a:19:{s:17:"wk_valid_url_days";s:1:"7";s:7:"v_hours";s:1:"0";s:8:"v_minute";s:1:"0";s:4:"days";s:1:"0";s:5:"hours";s:1:"0";s:6:"minute";s:1:"1";s:27:"on_which_order_status_value";s:1:"E";s:18:"order_status_value";s:1:"C";s:27:"order_status_value_unsucess";s:1:"G";s:13:"ch_vendor_dis";s:1:"y";s:11:"ch_customer";s:1:"y";s:16:"custom_email_dis";s:0:"";s:15:"ch_auto_confirm";s:1:"y";s:9:"mail_text";s:6100:"<style> body { font-family: Arial, Helvetica, sans-serif; } td { padding: 20px 10px; } table { border: 1px solid grey; max-width: 800px; margin: 0 auto; padding: 0 0 0 30px; } </style> <table> <tbody><tr> <td colspan="2" style="text-align: center;"><img src="https://webmarco.com/images/logos/3/logo-webmarco-resized.png"></td> <td>&nbsp;</td> </tr> <tr style="background-color: rgb(55, 0, 179);"> <td colspan="2" style="padding: 20px 25px;"> <h1 style="font-size: 22px; text-transform: uppercase; font-weight: 600; text-align: center; color: #fff;">Confermare Ricezione Ordine</h1> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h3><strong>Salve </strong>[#firstname#] [#lastname#]!</h3> <h4><strong>Dettagli del tuo Ordine:</strong></h4> </td></tr> <tr style="background-color: rgb(203, 203, 204);"> <td style="width: 50%;"> <p><strong>Ordine Id</strong>:[#order_id#] </p> <p><strong> </strong></p><p><strong>Data dell'Ordine</strong>:[#order_date#] </p></td> <td style="width: 50%;"> <p>[%% </p> <p><strong>Nome del Prodotto</strong>: [#product_name#] </p> <p><strong>Prezzo del Prodotto</strong>: [#product_price#] </p> <p><strong>Codice del Prodotto</strong>: [#product_code#] </p> <p><strong>Quantità del Prodotto</strong>: [#product_quantity#]<br> </p> <p>%%] </p></td> </tr> <tr> <td colspan="2"> <h2 style="color: #090909; text-align: center;"><strong><br></strong></h2><h2 style="color: #090909; text-align: center;"><strong>Confermare Ricezione Ordine:</strong></h2> </td> </tr> <tr> <td> <div style="background-color: #3ca869; padding: 3px 6px; border-radius: 5px; color: #fff; text-decoration: none; font-weight: 700;"> <p style=" color: #fff; text-decoration: none; font-weight: 700; font-size: 26px; text-align: center;">[#confirm_url#]</p> </div></td> <td> <div style="background-color: #c45f7d; padding: 3px 6px; border-radius: 5px; color: #fff; text-decoration: none; font-weight: 700;"> <p style=" color: #fff !important; text-decoration: none; font-weight: 700; font-size: 26px; text-align: center;"> [#not_confirm_url#]</p> </div></td> </tr> <tr> <td colspan="2" style="text-align: center;"> <p> <strong> Periodo di validità del Link di Conferma: </strong>[#validity_period#]</p> <h2 style="color: #ff8a00; font-size: 34px; font-weight: 500;">Grazie!</h2> </td> </tr> <tr> </tr> <tr> <td colspan="2" style="padding: 20px 30px; background-color: #757f83;"> <table width="250" align="left"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Informazioni di Contatto</h4> </th> </tr> <tr> <td style="text-align: center; color: #fff;"> <p> Corso Crimea 25, 15121 <br> Alessandria, Italy </p> <a href="Tel:+390256568724" style="text-decoration: none; color: rgb(55, 0, 179);"><p>+39 0256568724</p></a> </td> </tr> </tbody></table> <table width="250" align="right"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Ottieni Social</h4> </th> </tr> <tr> <td> <table cellspacing="0" cellpadding="0" align="center"> <tbody><tr> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.facebook.com/WebMarco-100370841579298/?modal=admin_todo_tour"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/facebook%20(1).png?1594382881439"> </a> </td> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.instagram.com/webmarco_/"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/instagram%20(1).png?1594382932219"> </a> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> <tr> <td colspan="2"> <table width="100%"> <tbody><tr> <td style="padding: 10px 0 0 0; padding-bottom: 0;"> <p> <strong style="text-decoration: none; color: rgb(9, 9, 9);"><a href="https://webmarco.com/" style="text-decoration: none; color: #090909;">&copy;&nbsp;Webmarco</a>&nbsp;2020</strong></p> </td> <td style="text-align: right; padding: 10px 0 0 0; padding-bottom: 0;"> <p>Grazie per aver fatto acquisti nel nostro negozio.</p> </td> </tr> </tbody></table> </td> </tr> </tbody></table> ";s:29:"mail_text_to_order_department";s:5293:"<style> body { width: 100%; margin: 0 auto; font-family: Arial, Helvetica, sans-serif; } td { padding: 20px 10px; } table { max-width: 800px; margin: 0 auto; padding: 0 0 0 30px; border: 1px solid grey; } </style> <table> <tbody><tr> <td colspan="2" style="text-align: center;"><img src="https://webmarco.com/images/logos/3/logo-webmarco-resized.png"></td> <td>&nbsp;</td> </tr> <tr style="background-color: rgb(55, 0, 179);"> <td colspan="2" style="padding: 20px 25px;"> <h1 style="font-size: 22px; text-transform: uppercase; font-weight: 600; text-align: center; color: #fff;">Ordine Confermato</h1> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h3><strong>Dettagli dell'Ordine:</strong></h3> </td> </tr> <tr style="background-color: rgb(203, 203, 204);"> <td style="width: 50%;"> <p><strong>Nome del Cliente: </strong> [#firstname#] [#lastname#]</p> <p><strong>Ordine Id</strong>:[#order_id#]</p> <p><strong>Data dell'Ordine</strong>:[#order_date#]</p> <p><strong>Risposta di Consegna</strong>:[#delivery_response#]</p> <p><strong>Data di Conferma della Consegna</strong>:[#delivery_confirm_date#]</p> </td> <td style="width: 50%;"> <p>[%%</p> <p><strong>Nome del Prodotto</strong>: [#product_name#]</p> <p><strong>Prezzo del Prodotto</strong>: [#product_price#]</p> <p><strong>Codice del Prodotto</strong>: [#product_code#]</p> <p><strong>Quantità del Prodotto</strong>: [#product_quantity#]<br></p> <p>%%]</p> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h2 style="color: #ff8a00; font-size: 34px; font-weight: 500;">Grazie!</h2> </td> </tr> <tr></tr> <tr> <td colspan="2" style="padding: 20px 30px; background-color: #757f83;"> <table width="250" align="left"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Informazioni di Contatto</h4> </th> </tr> <tr> <td style="text-align: center; color: #fff;"> <p> Corso Crimea 25, 15121 <br> Alessandria, Italy </p> <a href="Tel:+390256568724" style="text-decoration: none; color: rgb(55, 0, 179);"><p>+39 0256568724</p></a> </td> </tr> </tbody></table> <table width="250" align="right"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Ottieni Social</h4> </th> </tr> <tr> <td> <table cellspacing="0" cellpadding="0" align="center"> <tbody><tr> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.facebook.com/WebMarco-100370841579298/?modal=admin_todo_tour"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/facebook%20(1).png?1594382881439"> </a> </td> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.instagram.com/webmarco_/"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/instagram%20(1).png?1594382932219"> </a> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> <tr> <td colspan="2"> <table width="100%"> <tbody><tr> <td style="padding: 10px 0 0 0; padding-bottom: 0;"> <p> <a href="https://webmarco.com/" style="text-decoration: none; color: #090909;"> <strong>&copy;&nbsp;Webmarco</strong></a> </p> </td> <td style="text-align: right; padding: 10px 0 0 0; padding-bottom: 0;"> </td> </tr></tbody></table> </td> </tr> </tbody></table> ";s:19:"mail_text_to_vendor";s:5421:"<style> body { width: 100%; margin: 0 auto; font-family: Arial, Helvetica, sans-serif; } td { padding: 20px 10px; } table { max-width: 800px; margin: 0 auto; border: 1px solid grey; padding: 0 0 0 30px; } </style> <table> <tbody><tr> <td colspan="2" style="text-align: center;"><img src="https://webmarco.com/images/logos/3/logo-webmarco-resized.png"></td> <td>&nbsp;</td> </tr> <tr style="background-color: rgb(55, 0, 179);"> <td colspan="2" style="padding: 20px 25px;"> <h1 style="font-size: 22px; text-transform: uppercase; font-weight: 600; text-align: center; color: #fff;">Ordine Confermato</h1> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h3><strong>Dettagli dell'Ordine:</strong></h3> </td> </tr> <tr style="background-color: rgb(203, 203, 204);"> <td style="width: 50%;"> <p><strong>Nome del Cliente: </strong> [#firstname#] [#lastname#]</p> <p><strong>Ordine Id</strong>:[#order_id#]</p> <p><strong>Data dell'Ordine</strong>:[#order_date#]</p> <p><strong>Risposta di Consegna</strong>:[#delivery_response#]</p> <p><strong>Data di Conferma della Consegna</strong>:[#delivery_confirm_date#]</p> </td> <td style="width: 50%;"> <p>[%%</p> <p><strong>Nome del Prodotto</strong>: [#product_name#]</p> <p><strong>Prezzo del Prodotto</strong>: [#product_price#]</p> <p><strong>Codice del Prodotto</strong>: [#product_code#]</p> <p><strong>Quantità del Prodotto</strong>: [#product_quantity#]<br></p> <p>%%]</p> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h2 style="color: #ff8a00; font-size: 34px; font-weight: 500;">Grazie!</h2> </td> </tr> <tr></tr> <tr> <td colspan="2" style="padding: 20px 30px; background-color: #757f83;"> <table width="250" align="left"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Informazioni di Contatto</h4> </th> </tr> <tr> <td style="text-align: center; color: #fff;"> <p> Corso Crimea 25, 15121 <br> Alessandria, Italy </p> <a href="Tel:+390256568724" style="text-decoration: none; color: rgb(55, 0, 179);"><p>+39 0256568724</p></a> </td> </tr> </tbody></table> <table width="250" align="right"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Ottieni Social</h4> </th> </tr> <tr> <td> <table cellspacing="0" cellpadding="0" align="center"> <tbody><tr> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.facebook.com/WebMarco-100370841579298/?modal=admin_todo_tour"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/facebook%20(1).png?1594382881439"> </a> </td> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.instagram.com/webmarco_/"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/instagram%20(1).png?1594382932219"> </a> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> <tr> <td colspan="2"> <table width="100%"> <tbody><tr> <td style="padding: 10px 0 0 0; padding-bottom: 0;"> <p> <a href="https://webmarco.com/" style="text-decoration: none; color: #090909;"> <strong>&copy;&nbsp;Webmarco</strong></a> </p> </td> <td style="text-align: right; padding: 10px 0 0 0; padding-bottom: 0;"> </td> </tr> </tbody></table> </td> </tr> </tbody></table> ";s:21:"mail_text_to_customer";s:5313:"<style> body { width: 100%; margin: 0 auto; font-family: Arial, Helvetica, sans-serif; } td { padding: 20px 10px; } table { max-width: 800px; margin: 0 auto; padding: 0 0 0 30px; border : 1px solid grey; } </style> <table> <tbody><tr> <td colspan="2" style="text-align: center;"><img src="https://webmarco.com/images/logos/3/logo-webmarco-resized.png"></td> <td>&nbsp;</td> </tr> <tr style="background-color: rgb(55, 0, 179);"> <td colspan="2" style="padding: 20px 25px;"> <h1 style="font-size: 22px; text-transform: uppercase; font-weight: 600; text-align: center; color: #fff;">Ordine Confermato</h1> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h3><strong>Salve </strong>[#firstname#] [#lastname#]!</h3> <h2 style="color: #ff8a00; font-size: 24px; font-weight: 500;">Il tuo ordine è stato confermato!</h2> <h4><strong>Dettagli del Ordine:</strong></h4> </td></tr> <tr style="background-color: rgb(203, 203, 204);"> <td style="width: 50%;"> <p><strong>Ordine Id</strong>:[#order_id#] </p> <p><strong> </strong></p><p><strong>Data dell'Ordine</strong>:[#order_date#] </p></td> <td style="width: 50%;"> <p>[%% </p> <p><strong>Nome del Prodotto</strong>: [#product_name#] </p> <p><strong>Prezzo del Prodotto</strong>: [#product_price#] </p> <p><strong>Codice del Prodotto</strong>: [#product_code#] </p> <p><strong>Quantità del Prodotto</strong>: [#product_quantity#]<br> </p> <p>%%] </p></td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h2 style="color: #ff8a00; font-size: 34px; font-weight: 500;">Grazie!</h2> </td> </tr> <tr> </tr> <tr> <td colspan="2" style="padding: 20px 30px; background-color: #757f83;"> <table width="250" align="left"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Informazioni di Contatto</h4> </th> </tr> <tr> <td style="text-align: center; color: #fff;"> <p> Corso Crimea 25, 15121 <br> Alessandria, Italy </p> <a href="Tel:+390256568724" style="text-decoration: none; color: rgb(55, 0, 179);"><p>+39 0256568724</p></a> </td> </tr> </tbody></table> <table width="250" align="right"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Ottieni Social</h4> </th> </tr> <tr> <td> <table cellspacing="0" cellpadding="0" align="center"> <tbody><tr> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.facebook.com/WebMarco-100370841579298/?modal=admin_todo_tour"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/facebook%20(1).png?1594382881439"> </a> </td> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.instagram.com/webmarco_/"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/instagram%20(1).png?1594382932219"> </a> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> <tr> <td colspan="2"> <table width="100%"> <tbody><tr> <td style="padding: 10px 0 0 0; padding-bottom: 0;"> <p> <a href="https://webmarco.com/" style="text-decoration: none; color: #090909;"> <strong>&copy;&nbsp;Webmarco</strong></a> </p> </td> <td style="text-align: right; padding: 10px 0 0 0; padding-bottom: 0;"> <p>Grazie per aver fatto acquisti nel nostro negozio.</p> </td> </tr> </tbody></table> </td> </tr> </tbody></table> ";s:23:"mail_text_to_custom_ids";s:5371:"<style> body { width: 100%; margin: 0 auto; font-family: Arial, Helvetica, sans-serif; } td { padding: 20px 10px; } table { max-width: 800px; margin: 0 auto; border: 1px solid grey; padding: 0 0 0 30px; } </style> <table> <tbody><tr> <td colspan="2" style="text-align: center;"><img src="https://webmarco.com/images/logos/3/logo-webmarco-resized.png"></td> <td>&nbsp;</td> </tr> <tr style="background-color: rgb(55, 0, 179);"> <td colspan="2" style="padding: 20px 25px;"> <h1 style="font-size: 22px; text-transform: uppercase; font-weight: 600; text-align: center; color: #fff;">Ordine Confermato</h1> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h3><strong>Dettagli dell'Ordine:</strong></h3> </td> </tr> <tr style="background-color: rgb(203, 203, 204);"> <td style="width: 50%;"> <p><strong>Nome del Cliente: </strong> [#firstname#] [#lastname#]</p> <p><strong>Ordine Id</strong>:[#order_id#]</p> <p><strong>Data dell'Ordine</strong>:[#order_date#]</p> <p><strong>Risposta di Consegna</strong>:[#delivery_response#]</p> <p><strong>Data di Conferma della Consegna</strong>:[#delivery_confirm_date#]</p> </td> <td style="width: 50%;"> <p>[%%</p> <p><strong>Nome del Prodotto</strong>: [#product_name#]</p> <p><strong>Prezzo del Prodotto</strong>: [#product_price#]</p> <p><strong>Codice del Prodotto</strong>: [#product_code#]</p> <p><strong>Quantità del Prodotto</strong>: [#product_quantity#]<br></p> <p>%%]</p> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h2 style="color: #ff8a00; font-size: 34px; font-weight: 500;">Grazie!</h2> </td> </tr> <tr></tr> <tr> <td colspan="2" style="padding: 20px 30px; background-color: #757f83;"> <table width="250" align="left"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Informazioni di Contatto</h4> </th> </tr> <tr> <td style="text-align: center; color: #fff;"> <p> Corso Crimea 25, 15121 <br> Alessandria, Italy </p> <a href="Tel:+390256568724" style="text-decoration: none; color: rgb(55, 0, 179);"><p>+39 0256568724</p></a> </td> </tr> </tbody></table> <table width="250" align="right"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Ottieni Social</h4> </th> </tr> <tr> <td> <table cellspacing="0" cellpadding="0" align="center"> <tbody><tr> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.facebook.com/WebMarco-100370841579298/?modal=admin_todo_tour"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/facebook%20(1).png?1594382881439"> </a> </td> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.instagram.com/webmarco_/"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/instagram%20(1).png?1594382932219"> </a> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> <tr> <td colspan="2"> <table width="100%"> <tbody><tr> <td style="padding: 10px 0 0 0; padding-bottom: 0;"> <p> <a href="https://webmarco.com/" style="text-decoration: none; color: #090909;"> <strong>&copy;&nbsp;Webmarco</strong></a> </p> </td> <td style="text-align: right; padding: 10px 0 0 0; padding-bottom: 0;"> </td> </tr> </tbody></table> </td> </tr> </tbody></table> ";s:32:"mail_text_confirm_by_auto_system";s:5208:"<style> body { background: #e7e7e7; width: 100%; margin: 0 auto; font-family: Arial, Helvetica, sans-serif; } td { padding: 20px 10px; } table { max-width: 800px; margin: 0 auto; padding: 0 0 0 30px; border: 1px solid grey; } </style> <table> <tbody><tr> <td colspan="2" style="text-align: center;"><img src="https://webmarco.com/images/logos/3/logo-webmarco-resized.png"></td> <td>&nbsp;</td> </tr> <tr style="background-color: rgb(55, 0, 179);"> <td colspan="2" style="padding: 20px 25px;"> <h1 style="font-size: 22px; text-transform: uppercase; font-weight: 600; text-align: center; color: #fff;">Ordine Confermato Automaticamente</h1> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h3><strong>Dettagli dell'Ordine:</strong></h3> </td> </tr> <tr style="background-color: rgb(203, 203, 204);"> <td style="width: 50%;"> <p><strong>Ordine Id</strong>:[#order_id#]</p> <p><strong>Data di Conferma della Consegna</strong>:[#delivery_confirm_date#]</p> </td> <td style="width: 50%;"> <p>[%%</p> <p><strong>Nome del Prodotto</strong>: [#product_name#]</p> <p><strong>Prezzo del Prodotto</strong>: [#product_price#]</p> <p><strong>Codice del Prodotto</strong>: [#product_code#]</p> <p><strong>Quantità del Prodotto</strong>: [#product_quantity#]<br></p> <p>%%]</p> </td> </tr> <tr> <td colspan="2" style="text-align: center;"> <h2 style="color: #ff8a00; font-size: 34px; font-weight: 500;">Grazie!</h2> </td> </tr> <tr></tr> <tr> <td colspan="2" style="padding: 20px 30px; background-color: #757f83;"> <table width="250" align="left"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Informazioni di Contatto</h4> </th> </tr> <tr> <td style="text-align: center; color: #fff;"> <p> Corso Crimea 25, 15121 <br> Alessandria, Italy </p> <a href="Tel:+390256568724" style="text-decoration: none; color: rgb(55, 0, 179);"><p>+39 0256568724</p></a> </td> </tr> </tbody></table> <table width="250" align="right"> <tbody><tr> <th style="text-align: center; margin: 0px; text-transform: uppercase; font-size: 16px !important; font-weight: 600; color: #fff !important;"> <h4>Ottieni Social</h4> </th> </tr> <tr> <td> <table cellspacing="0" cellpadding="0" align="center"> <tbody><tr> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.facebook.com/WebMarco-100370841579298/?modal=admin_todo_tour"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/facebook%20(1).png?1594382881439"> </a> </td> <td style="padding: 0px; padding-right: 10px;"> <a href="https://www.instagram.com/webmarco_/"> <img style="background-color: rgb(55, 0, 179); padding: 5px; border-radius: 5px;" width="30" height="30" src="https://webmarco.com/images/icons/instagram%20(1).png?1594382932219"> </a> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> <tr> <td colspan="2"> <table width="100%"> <tbody><tr> <td style="padding: 10px 0 0 0; padding-bottom: 0;"> <p> <a href="https://webmarco.com/" style="text-decoration: none; color: #090909;"> <strong>&copy;&nbsp;Webmarco</strong></a> </p> </td> <td style="text-align: right; padding: 10px 0 0 0; padding-bottom: 0;"> </td> </tr> </tbody></table> </td> </tr> </tbody></table> ";}