Query time 0.01104
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"nested_loop": [
{
"table": {
"table_name": "jmj_pages",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_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": "2K"
},
"used_columns": [
"page_id",
"company_id",
"parent_id",
"id_path",
"status",
"page_type",
"position",
"timestamp",
"usergroup_ids",
"localization",
"new_window",
"use_avail_period",
"avail_from_timestamp",
"avail_till_timestamp",
"facebook_obj_type",
"abt__ut2_microdata_schema_type"
]
}
},
{
"table": {
"table_name": "jmj_page_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id",
"lang_code"
],
"key_length": "9",
"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": "3K"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link"
]
}
}
]
}
}
Result
| page_id |
company_id |
parent_id |
id_path |
status |
page_type |
position |
timestamp |
usergroup_ids |
localization |
new_window |
use_avail_period |
avail_from_timestamp |
avail_till_timestamp |
facebook_obj_type |
abt__ut2_microdata_schema_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
| 21 |
0 |
0 |
21 |
A |
T |
0 |
1208802600 |
0 |
|
0 |
N |
0 |
0 |
activity |
|
en |
Returns and Exchanges |
<section class="ppolicy">
<div class="my-wrapper">
<div class="ppolicy-inner">
<div class="pp-heading-career my-css"><span>RETURN</span> AND <span>REFUND</span></div>
<div class="pp-text-inner">
<p>You may cancel an order from your account before it is shipped. Please note that if the item is made-to-measure, you may only be able to cancel the order before it is shipped provided that the garment hasn’t been altered or made yet. In the rest of the cases, read the below:
</p>
<p>1. Customers can return their order within xx days of the order delivery.</p>
<p>2. All returns must be in unused condition with all original tags and packaging intact.</p>
<p>3. The product amount will be credited back to his/her xplore.com wallet/Bank A/c as requested once we have received the products and the quality check is done.</p>
<p>4. To schedule a return, please fill in the Return Form which is available in the 'My Orders' section of your Xplore Account. The Reverse Pick up facility is available on limited pin-codes.</p>
<p>5. Note: For replacement, kindly follow the return procedure for the product you want to replace, and then let us know the product you require and we will ship the replacement product.</p>
<p>6. All clearance sale products can only be replaced, with no returns.</p>
<p>7. Return postage is your responsibility unless the item is incorrect or faulty, in which case the Seller will refund the return postage.
</p><p>Customers are entitled to a full refund within xx days of receiving an order, provided the item is unworn and immediate packaging is received back in the same condition as it was sent.<br></p>
<p>The items you return must be unworn and in their original condition save for your right to inspect the goods and try on the garments. It is your responsibility to ensure that you package the returned goods adequately so that it arrives back to the Seller undamaged. If you have any further questions on returns, refunds or cancellations please contact the Seller.
</p><p><br></p><p><br></p>
</div>
</div>
</div></section> |
|
|
|
|