Query time 0.00144
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "system",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "448"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "system",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
]
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "15K"
},
"used_columns": [
"company_id",
"status",
"company",
"lang_code",
"address",
"city",
"state",
"country",
"zipcode",
"email",
"phone",
"url",
"storefront",
"secure_storefront",
"entry_page",
"redirect_customer",
"countries_list",
"timestamp",
"shippings",
"logos",
"request_user_id",
"request_account_name",
"request_account_data",
"tax_number",
"registered_from_storefront_id",
"plan_id",
"pre_moderation",
"pre_moderation_edit",
"pre_moderation_edit_vendors",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"paypal_commerce_platform_account_id",
"discreet_shipping",
"shipstation_enabled",
"shipstation_fulfillment",
"shipstation_api_key",
"shipstation_api_secret",
"shipstation_api_connected",
"shipstation_webhook_id",
"shipstation_store_id",
"shipstation_warehouse_name",
"shipstation_warehouse_street1",
"shipstation_warehouse_street2",
"shipstation_warehouse_street3",
"shipstation_warehouse_country",
"shipstation_warehouse_state",
"shipstation_warehouse_city",
"shipstation_warehouse_postal_code",
"shipstation_warehouse_phone",
"shipstation_warehouse_residential",
"shipstation_warehouse_id",
"shipengine_enabled",
"shipengine_api_key",
"shipengine_api_connected",
"shipengine_webhook_id",
"shipengine_account_id",
"shipengine_external_account_id",
"shipengine_api_key_id",
"discreet_shipping_shop_name",
"vacation_mode",
"vacation_start_date",
"vacation_end_date",
"tagline",
"shopify_token",
"shopify_link_app",
"shopify_api_key",
"shopify_api_secret",
"stripe_connect_account_id",
"stripe_connect_account_type",
"chitchats_enabled",
"chitchats_client_id",
"chitchats_api_key",
"royal_mail_enabled",
"royal_mail_api_key"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description",
"terms",
"i18n_company",
"i18n_address",
"i18n_city"
]
}
},
{
"table": {
"table_name": "cscart_vendor_plan_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_id",
"lang_code"
],
"key_length": "10",
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "792"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"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": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"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.10",
"prefix_cost": "0.45",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"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.80",
"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.00",
"eval_cost": "0.10",
"prefix_cost": "0.90",
"data_read_per_join": "24"
},
"used_columns": [
"policy_id",
"policy",
"lang_code"
]
}
},
{
"table": {
"table_name": "shop_policies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"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.10",
"prefix_cost": "1.00",
"data_read_per_join": "24"
},
"used_columns": [
"company_id",
"lang_code",
"shop_policies"
]
}
}
]
}
}
Result
| company_id |
lang_code |
shop_policies |
return_policy |
company_description |
terms |
i18n_company |
i18n_address |
i18n_city |
status |
company |
address |
city |
state |
country |
zipcode |
email |
phone |
url |
storefront |
secure_storefront |
entry_page |
redirect_customer |
countries_list |
timestamp |
shippings |
logos |
request_user_id |
request_account_name |
request_account_data |
tax_number |
registered_from_storefront_id |
plan_id |
pre_moderation |
pre_moderation_edit |
pre_moderation_edit_vendors |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
paypal_commerce_platform_account_id |
discreet_shipping |
shipstation_enabled |
shipstation_fulfillment |
shipstation_api_key |
shipstation_api_secret |
shipstation_api_connected |
shipstation_webhook_id |
shipstation_store_id |
shipstation_warehouse_name |
shipstation_warehouse_street1 |
shipstation_warehouse_street2 |
shipstation_warehouse_street3 |
shipstation_warehouse_country |
shipstation_warehouse_state |
shipstation_warehouse_city |
shipstation_warehouse_postal_code |
shipstation_warehouse_phone |
shipstation_warehouse_residential |
shipstation_warehouse_id |
shipengine_enabled |
shipengine_api_key |
shipengine_api_connected |
shipengine_webhook_id |
shipengine_account_id |
shipengine_external_account_id |
shipengine_api_key_id |
discreet_shipping_shop_name |
vacation_mode |
vacation_start_date |
vacation_end_date |
tagline |
shopify_token |
shopify_link_app |
shopify_api_key |
shopify_api_secret |
stripe_connect_account_id |
stripe_connect_account_type |
chitchats_enabled |
chitchats_client_id |
chitchats_api_key |
royal_mail_enabled |
royal_mail_api_key |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 130 |
en |
Policy of the online store of handmade wood products:
Welcome to RoyalTabula, where we pride ourselves on offering exquisite handcrafted wood products made with precision and passion. Please review our policies below to understand how we strive to provide a shopping experience for our valued customers:
Product Authenticity:
We guarantee that all of our wood products are handcrafted by experienced craftsmen using high quality materials. Each piece is crafted with meticulous attention to detail, resulting in unique and authentic pieces that showcase the beauty of natural wood.
Descriptions and images of goods.
We make every effort to provide accurate product descriptions and high-resolution images to help you make an informed purchasing decision. However, please note that due to the handcrafted nature of our products, slight variations in color, pattern and size may occur, adding to their charm and uniqueness.
Order Processing Time:
Because our products are handmade to order, processing time ranges from 7 to 14 business days before your order is ready to ship. Custom orders or personalized items may require additional processing time, which will be advised to you upon confirmation of your order.
Shipping and Delivery:
We offer worldwide shipping, excluding countries subject to international sanctions. Shipping costs and times may vary depending on your location and shipping method. Once your order has been shipped, you will receive a tracking number so you can track the status of your delivery.
Customs and Duties:
Please be advised that international orders may be subject to customs duties, taxes, and fees imposed by the destination country's customs authorities. These charges are the responsibility of the recipient and are not included in the shipping costs paid at checkout. We recommend contacting your local customs office for more information on potential charges before placing your order.
Returns and Exchanges:
We want you to be completely satisfied with your purchase from RoyalTabula. If for any reason you are not satisfied with your order, please contact our customer service team within 7 days of receiving the item to initiate a return or exchange. Please note that personalized or custom made items cannot be returned unless they arrive damaged or faulty.
Damaged or defective item.
In the rare event that you receive a damaged or defective item, please contact us immediately and provide photographic evidence of the problem. We will work with you to promptly resolve the issue with a replacement or refund.
Customer Service:
Our dedicated customer service team is always ready to assist you with any questions, concerns or requests you may have. Whether you need help with product selection, order status or after-sales support, we are committed to providing you with fast and friendly service.
Feedback and Reviews:
We value your feedback and appreciate your shopping experience with us. If you are satisfied with your purchase, we would love to hear product reviews or feedback from you. Your feedback helps us improve our products and services for future customers.
Thank you for choosing RoualTabula to produce handcrafted wood products. We are honored to be a part of your journey to bring the beauty of natural wood into your home. If you have additional questions or need assistance, please do not hesitate to contact us. |
Return and Replacement Policy for Damaged Items:
At RoyalTabula, we strive to ensure that every product you receive meets the highest standards of quality and craftsmanship. In the unlikely event that you receive a damaged or defective item, we are here to assist you with our easy returns and replacement process. Please review the following policy regarding damaged goods:
1. **Damage Notice:** Upon receipt of your order, please inspect the item carefully for any signs of damage or defects. If you find any problems with your purchase, please contact our customer service team within 24 hours of receiving your order to report the damage. We may request photographic evidence of damage to help us assess the problem.
2. **Return Authorization:** Once you report the damage to our customer service team, we will provide you with instructions on how to proceed with the return or replacement process. In some cases, we may require you to return the damaged item to us for inspection and inspection. Please wait for our confirmation and instructions before returning the item.
3. **Return Eligibility:** To be eligible for a return or replacement due to damage or defect, the item must be in its original condition and packaging. We reserve the right to refuse returns or replacements on items that show signs of misuse, neglect or intentional damage.
4. **Return Shipping** In most cases, we will provide you with a prepaid shipping label or arrange for the damaged item to be couriered from your location. Please follow our customer service instructions to ensure your return process goes smoothly and efficiently. Return shipping costs for damaged or defective items will be covered by RoyalTabula.
5. **Replacement or Refund.** Once the returned item has been received and inspected, we will issue a replacement or refund, depending on your preference and item availability. If a replacement is not possible, we will refund the full purchase price of the product, including all applicable taxes and shipping charges.
6. **Timely Resolution** We understand the inconvenience of receiving a damaged item and strive to resolve the issue as quickly as possible. Our customer service team will keep you informed throughout the return and replacement process, providing updates on the status of your request.
7. **Customer Satisfaction** Your satisfaction is our top priority and we work hard to ensure you are completely satisfied with your purchases from RoyalTabula. If you have any questions, concerns or feedback regarding our return and replacement policy for damaged items, please do not hesitate to contact us. We are here to help you every step of the way.
Thank you for choosing RoyalTabula for your. We look forward to creating a unique product that perfectly matches your style and preferences. If you have additional questions or need assistance, please do not hesitate to contact us. |
Dear ones, we do not stop our work because of the situation in our country. We consistently do our job and fulfill our responsibilities. You don't have to worry! Rest assured; We will fulfill your order as soon as possible. Our location allows us to continue working. Please pray for Ukraine, we need your support! |
|
RoyalTabula |
Prospekt Mira, 253 |
Chernihiv |
A |
RoyalTabula |
Prospekt Mira, 253 |
Chernihiv |
74 |
UA |
14007 |
royaltabula@gmail.com |
+380984571761 |
https://www.etsy.com/shop/RoyalTabula |
|
|
none |
Y |
|
1715164149 |
|
|
273 |
|
a:4:{s:14:"company_fields";a:8:{i:37;s:0:"";i:38;s:0:"";i:52;s:19:"www.royaltabula.com";i:58;s:0:"";i:54;s:0:"";i:55;s:0:"";i:56;s:0:"";i:57;s:0:"";}s:15:"admin_firstname";s:0:"";s:14:"admin_lastname";s:0:"";s:6:"fields";a:5:{i:65;s:0:"";i:61;s:0:"";i:62;s:0:"";i:63;s:0:"";i:64;s:0:"";}} |
def5020066a418bbd69460287a5918cb8dabb9b2e8d54a12f88f3586eb4cdd6b3f8f021a05664c5efa5e06c72f8faa8d2ecf7b19ac6fb6f858caf1056ec6f9ffcaa9da9f8491722f1bc5c2996798ce298afc8beb5efd |
1 |
1 |
N |
N |
N |
0 |
0 |
0 |
0 |
L4NCVU6KEBZXU |
Y |
N |
Y |
|
|
N |
0 |
|
|
|
|
|
|
|
|
|
|
N |
0 |
N |
|
N |
0 |
|
|
|
RoyalTabula |
0 |
0 |
0 |
|
|
|
|
|
|
|
N |
|
|
N |
|
Beta Plan |
royaltabula |
|
|
130_0 |