Sandbox

SELECT 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'en' 
  AND lang.name = 'cpcg.template_info'

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "lang",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "lang_code",
        "name"
      ],
      "key_length": "392",
      "ref": [
        "const",
        "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": "408"
      },
      "used_columns": [
        "lang_code",
        "name",
        "value"
      ]
    }
  }
}

Result

value
You can use letters, symbols and numbers. Any number will be converted to random number, any letter will be converted to any random letter. Upercased letter will be saved. Unique product code will be generated automatically. If you want to fix any letter or number on your template - use <b>%</b> symbol before symbol your want to fix. Example: H%D8 can be converted to GD9 or JD1, D is fixed. If you want to use product ID numbers on your product code - use <b>#</b>. <b>#</b> wull be replaced by product id value. Example: HD-# template can be converted to product with ID 287 to HE-287 or DW-287. This rules also works on category templates.

value

You can use letters, symbols and numbers. Any number will be converted to random number, any letter will be converted to any random letter. Upercased letter will be saved. Unique product code will be generated automatically. If you want to fix any letter or number on your template - use % symbol before symbol your want to fix. Example: H%D8 can be converted to GD9 or JD1, D is fixed. If you want to use product ID numbers on your product code - use #. # wull be replaced by product id value. Example: HD-# template can be converted to product with ID 287 to HE-287 or DW-287. This rules also works on category templates.