Sandbox

SELECT 
  return_policy_descriptions.policy 
FROM 
  cscart_return_policies AS return_policies 
  LEFT JOIN cscart_return_policy_descriptions AS return_policy_descriptions ON return_policy_descriptions.policy_id = return_policies.policy_id 
  AND return_policy_descriptions.lang_code = 'en' 
WHERE 
  return_policies.object_type = 'company' 
  AND return_policies.object_id = 239

Query time 0.00065

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.70"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "return_policies",
          "access_type": "ref",
          "possible_keys": [
            "object_type"
          ],
          "key": "object_type",
          "used_key_parts": [
            "object_type",
            "object_id"
          ],
          "key_length": "95",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.35",
            "data_read_per_join": "112"
          },
          "used_columns": [
            "policy_id",
            "object_type",
            "object_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "return_policy_descriptions",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "policy_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "cscartdb.return_policies.policy_id",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.70",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "policy_id",
            "policy",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

policy
We have a 14-day return policy if the item(s) is a standard item we sell (i.e. not customised or bespoke), damaged or not as described, which means you have 14 days after receiving your item to request a return. Buyer pays return shipping. We also accept exchanges for items and will do everything we can to resolve any issues. Buyer pays return shipping and, if applicable, exchange shipping back to themselves. To be eligible for a return/exchange, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase, and in the event of damaged items/packaging, evidence/photos of the condition. To start a return, you can contact us at info@8thsin.co.uk. Please note that returns will need to be sent to the following address: 8th Sin C/O Laura Haslam 97b Haydn Road Nottingham NG5 2LA United Kingdom If your return/exchange is accepted, we’ll send you instructions on how and where to send your package and if applicable, digital return shipping labels if needed. Buyers need to be able to print the shipping label and any documents such as customs information. Items sent back to us without first requesting a return/exchange will not be accepted. You can always contact us for any return/exchange question at info@8thsin.co.uk. Damages and issues Please inspect your order upon reception and contact us immediately if the item is defective, damaged or if you receive the wrong item, so that we can evaluate the issue and make it right. Exceptions / non-returnable items Certain types of items cannot be returned, such as custom products (such as special orders or personalized items), and personal care goods (such as beauty products). We also do not accept returns for hazardous materials, flammable liquids, or gases. Please get in touch if you have questions or concerns about your specific item. We do not accept returns if your order is returned because you did not pay the customs/import duty on it. Buyers are responsible for any customs and import taxes that may apply. Unfortunately, we cannot accept returns on sale items or gift cards. Exchanges The fastest way to ensure you get what you want is to return the item you have, and once the return is accepted, we will ship the new item. European Union 14 day cooling off period Notwithstanding the above, if the merchandise is being shipped into the European Union, you have the right to cancel or return your order within 14 days, for any reason and without a justification. As above, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase and pay for return shipping. Refunds We will notify you once we’ve received and inspected your return, and let you know if the refund was approved or not. If approved, you’ll be automatically refunded on your original payment method within 10 business days. Please remember it can take some time for your bank or credit card company to process and post the refund too. If more than 15 business days have passed since we’ve approved your return, please contact us at info@8thsin.co.uk.

policy

We have a 14-day return policy if the item(s) is a standard item we sell (i.e. not customised or bespoke), damaged or not as described, which means you have 14 days after receiving your item to request a return. Buyer pays return shipping. We also accept exchanges for items and will do everything we can to resolve any issues. Buyer pays return shipping and, if applicable, exchange shipping back to themselves. To be eligible for a return/exchange, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase, and in the event of damaged items/packaging, evidence/photos of the condition. To start a return, you can contact us at info@8thsin.co.uk. Please note that returns will need to be sent to the following address: 8th Sin C/O Laura Haslam 97b Haydn Road Nottingham NG5 2LA United Kingdom If your return/exchange is accepted, we’ll send you instructions on how and where to send your package and if applicable, digital return shipping labels if needed. Buyers need to be able to print the shipping label and any documents such as customs information. Items sent back to us without first requesting a return/exchange will not be accepted. You can always contact us for any return/exchange question at info@8thsin.co.uk. Damages and issues Please inspect your order upon reception and contact us immediately if the item is defective, damaged or if you receive the wrong item, so that we can evaluate the issue and make it right. Exceptions / non-returnable items Certain types of items cannot be returned, such as custom products (such as special orders or personalized items), and personal care goods (such as beauty products). We also do not accept returns for hazardous materials, flammable liquids, or gases. Please get in touch if you have questions or concerns about your specific item. We do not accept returns if your order is returned because you did not pay the customs/import duty on it. Buyers are responsible for any customs and import taxes that may apply. Unfortunately, we cannot accept returns on sale items or gift cards. Exchanges The fastest way to ensure you get what you want is to return the item you have, and once the return is accepted, we will ship the new item. European Union 14 day cooling off period Notwithstanding the above, if the merchandise is being shipped into the European Union, you have the right to cancel or return your order within 14 days, for any reason and without a justification. As above, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase and pay for return shipping. Refunds We will notify you once we’ve received and inspected your return, and let you know if the refund was approved or not. If approved, you’ll be automatically refunded on your original payment method within 10 business days. Please remember it can take some time for your bank or credit card company to process and post the refund too. If more than 15 business days have passed since we’ve approved your return, please contact us at info@8thsin.co.uk.