Query time 0.00049
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.10"
},
"nested_loop": [
{
"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": "6K"
},
"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",
"override_delivery_days",
"delivery_days",
"stripe_connect_account_id",
"stripe_connect_account_type",
"paypal_commerce_platform_account_id"
]
}
},
{
"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.25",
"eval_cost": "0.10",
"prefix_cost": "0.70",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"wearethehelpful_scalesta_net.cscart_discussion.thread_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.20",
"prefix_cost": "1.40",
"data_read_per_join": "896"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), (`wearethehelpful_scalesta_net`.`cscart_discussion_posts`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"wearethehelpful_scalesta_net.cscart_discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.20",
"prefix_cost": "2.10",
"data_read_per_join": "32"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), (`wearethehelpful_scalesta_net`.`cscart_discussion_rating`.`thread_id` = `wearethehelpful_scalesta_net`.`cscart_discussion`.`thread_id`), true)"
}
}
]
}
}
Result
| company_id |
lang_code |
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 |
override_delivery_days |
delivery_days |
stripe_connect_account_id |
stripe_connect_account_type |
paypal_commerce_platform_account_id |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 23 |
en |
|
<p>The supplier of the goods of your order is Day Brothers Limited, trading as FieldGoods, whose registered address is 10 Dewey Street, SW17 8TQ. Company Number <strong>12554880. </strong>All communications are to be made to .</p>
<p>When we refer to ‘you’ and ‘your’ we mean the user of the website and the purchaser of the goods. We will confirm acceptance of your order by e-mail to the address given and the sending of this e-mail and, whether or not it is received, binds the contract between us. </p>
<p>We reserve the rights to terminate, refuse or modify any discounts at any time and without notice. You must pay in full for the goods (including any applicable delivery charges) at the time of placing your order. Ownership in the goods we supply to you will not pass until we have received all sums due and payable by you for or in connection with the goods, including (where applicable) delivery charges. We may correct an error appearing on the website or withdraw any product from sale without incurring liability. Price and availability is also subject to change without notice. We reserve the right to cancel and refund an order without notice.</p>
<p>Our products are made in a kitchen which stores and handles nuts and other potential allergens however our labels state clearly when they are present in any of the ingredient list in any meal. We do not guarantee any product is free of an allergen, even if it is not listed on the ingredient list.It is the customer’s responsibility to check the ingredient list to check for any allergens they wish to avoid. If in any doubt please contact ellandsam@fieldgoods.co.uk for further information.</p><p>By purchasing products from FieldGoods, you are agreeing to the terms and conditions of sale, which apply to all transactions on fieldgoods.co.uk.</p>
<p>Buying from our website means we must have the following information:</p>
<p>Your address, including the postcode of the billing address associated with the payment card.Your mobile telephone number.Your email address, so we can supply you with important information such as your order confirmation and changes to the FieldGoods delivery service.</p>
<p>FieldGoods only sells products on our website to the end user and they should not, in any way, be resold without our prior written consent.</p>
<p> </p>
<p>Product Prices</p>
<p>The price of goods charged shall be as quoted on the web site at the time you confirm your order with us. Excluding any inadvertent technical error on pricing, we will honour any prices as published at the time of placing your order. Your credit card shall only be charged for items dispatched to you. If you order a large portion-size of a meal and it is not available then we will endeavour to supply the same number of total portions but in smaller tray sizes. Your card will not be charged extra if the price of these smaller trays is greater than the ordered amount.</p>
<p>If shortages of a product mean that the total price of the dispatched goods fall below any delivery threshold, FieldGoods shall honour the original delivery charge. Prices of goods do not include the delivery charge.</p><p><br></p><p>Delivery</p>
<p>Delivery Delays. We are not responsible for delivery delays outside of our control. If delivery is delayed we will contact you as soon as possible to let you know and we will take steps to minimise the effect of the delay. If your order cannot be delivered on the expected delivery date, we may contact you to arrange a suitable alternative for the next available delivery date, or you may contact us in writing to request a refund.
</p>
<p>If you are not at home for delivery please notify the courier for your order to be left in your chosen ‘safe place’. If you do not specify your ‘safe place’ at checkout, the delivery driver will leave it in a place they deem safe at their absolute discretion. If we have left your Products in your ‘safe place’, or another place deemed safe by the delivery driver, and they are stolen or damaged, we do not accept any liability for such. We may offer you a refund at our complete discretion.
</p>
<p>The goods will be delivered to the address you provide at checkout, this address is confirmed on your order confirmation. Once an order is shipped this address cannot change. We are not liable for any delays or missed deliveries if the delivery address provided is erroneous, any replacements or refunds are entirely at the discrestion of the business.</p>
<p>What will happen if you do not give required information to us. We may need certain information from you so that we can supply the products to you, for example, your name, email address, contact telephone number, billing address and delivery address, which will be requested as part of the ordering process. If you do not give us this information within a reasonable time of us asking for it, or if you give us incomplete or incorrect information, we may end our contract with you. We will not be responsible for supplying the products late or not supplying any part of them if this is caused by you not giving us the information we need within a reasonable time of us asking for it. </p>
<p>The following refers to our delivery service. If no special instructions are added during the delivery details screen of the order process, as the customer you are agreeing to sign for the delivery. No boxes shall be returned to the depot; they shall be left at the delivery address and chargeable to you, the customer. Special requirements shall be followed, but please make sure that they are deemed ‘reasonable’ e.g. allowing ample space in freezers for the delivery boxes. Or instructions to knock at a neighbour’s house should mean it is within short walking distance of your property, and does not involve the courier travelling any further. Due to circumstances beyond our control such as weather and traffic conditions we may not always be able to deliver by the time specified. In this situation we shall try to deliver later in the day. </p>
<p> </p>
<p>Cancelling an order</p>
<p>(United Kingdom Distance Selling Regulations)</p>
<p>As an online retailer we are governed by the UK Distance Selling Regulations. However, as we are selling perishable goods, the regulations relating to the return of unwanted goods do not directly apply to us. For more information, please go to www.dti.gov.uk. Orders can be cancelled any time up until midnight the day before dispatch.</p>
<p>Rejecting an unwanted order will not result in a refund. As our goods are perishable they will be destroyed by the courier upon rejection and therefore not warrant a refund.</p>
<p>Our refund policy</p>
<p>If you are unsatisfied with any of the items in your order or any part of the delivery service from FieldGoods please contact us by emailing us via the Contact Us page of the website.</p>
<p>As we sell perishable goods, we ask that you – the customer – inspect the food once you have opened the box. If you are unhappy with the goods, please contact us immediately on 07828 166702. At our discretion, we shall be happy to exchange or refund any item you feel does not our quality standards, or any item that has been damaged in transit. If we have sent you an incorrect item, please notify us as soon as possible.</p>
<p>Obviously we shall not charge you for incorrect items. We operate an open and honest policy at FieldGoods and will work our hardest to make sure we can accommodate and act on any problems or suggestions.</p>
<p><br></p> |
FieldGoods |
|
|
A |
FieldGoods |
|
|
|
|
|
ellandsam@fieldgoods.co.uk |
+447979082540 |
|
|
|
none |
Y |
|
1729793383 |
20 |
|
0 |
|
a:4:{s:14:"company_fields";a:6:{i:37;s:7:"Kathryn";i:38;s:7:"Gooding";i:53;s:11:"Ready Meals";i:54;s:11:"Ready Meals";i:55;s:30:"Upmarket, female skewed, 30-50";i:56;s:54:"Nationwide UK excluding some specific remote postcodes";}s:15:"admin_firstname";s:7:"Kathryn";s:14:"admin_lastname";s:7:"Gooding";s:6:"fields";a:0:{}} |
364914575 |
1 |
9 |
N |
N |
N |
0 |
0 |
0 |
0 |
N |
0 |
acct_1QqxQdFNO0feF2TJ |
S |
|
Launch - 15% |
fieldgoods |
|
|
23_0 |