SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_pages.page_id = 21 
  AND cscart_page_descriptions.lang_code = 'en' 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND cscart_pages.page_type IN ('T', 'L', 'B', 'F', 'P')

Query time 0.00409

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.37"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_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.10",
            "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",
            "staff_notes",
            "abt__ut2_microdata_schema_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_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.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "6K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link",
            "page_sitemap",
            "ab__custom_page_h1",
            "custom_header",
            "ab__emd_alternative_name"
          ]
        }
      },
      {
        "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.27",
            "eval_cost": "0.10",
            "prefix_cost": "0.37",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "name",
            "object_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      }
    ]
  }
}

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 staff_notes abt__ut2_microdata_schema_type lang_code page description meta_keywords meta_description page_title link page_sitemap ab__custom_page_h1 custom_header ab__emd_alternative_name seo_name seo_path
21 0 0 21 A T 0 1208808000 0 0 N 0 0 activity en Return Policy <div class="policy_pages_align"> <h4 class="page_heading"><img src="https://www.stock2cart.com/images/RETURN%20POLICY.jpg?1569925047327" alt="RETURN%20POLICY.jpg?1569925047327" /><br /></h4><h4 class="page_heading">NO-HASSLE RETURNS</h4> <p>Except as otherwise described below, if you are not satisfied for any reason products may be returned within 30 days of shipment for a full credit or exchange (if the product is undamaged). When you make your return, you’ll need to note credit or exchange. Returned items must be in the original packaging. </p> <h4 class="page_heading">NON-REFUNDABLE ITEMS</h4> <p>Sometimes products may be non-refundable. If you order a non-refundable product, we will contact you prior to fulfilling your order, advise you of the refund restrictions, and offer you the option to cancel. </p> <h4 class="page_heading">HOW TO RETURN AN ITEM</h4> <p>Returns are accepted for exchange or credit within 7 days of purchase. Merchandise that has been worn, used, or altered will not be accepted for return or exchange. Credit is not given for shipping and the customer is responsible for shipping charges to return an item unless the item has a manufacturer defect or the incorrect item was received. </p> <p>Some items, such as special order, may not be available for return or will incur a restocking fee. </p> <p>To make a return, please contact customer service at:<br /> 1800 120-2354<br /> care@stock2cart.com </p> <h4 class="page_heading">Guidelines for Returns & Replacement:</h4> <p>MSDS information is available upon request by emailing care@stock2cart.com or calling (1800-120-2354). </p> <h4 class="page_heading">Product Compliance and Suitability</h4> <p>Jurisdictions have varying laws, codes and regulations governing construction, installation, and/or use of products for a particular purpose. Certain products may not be available for sale in all areas. Stock2cart does not guarantee compliance or suitability of the products it sells with any laws, codes or regulations, nor does Stock2cart accept responsibility for construction, installation and/or use of a product. It is customer’s responsibility to review the product application and all applicable laws, codes and regulations for each relevant jurisdiction to be sure that the construction, installation, and/or use involving the products are compliant. </p> <h4 class="page_heading">Guidelines for Returns & Replacement:</h4> <ol><li>Product is damaged/defective.</li> <li>Differ from the description on the website.</li> <li>Wrong item delivered/Wrong Colour/Wrong Size/Wrong Quantity.</li> <li>Missing parts/accessories.</li> </ol><h4 class="page_heading">Return Eligibility</h4> <ol><li>In case of returning the product, customer needs to inform us within 7 days of receiving the order. In case, if you received a damaged product, it must be reported to us within 48 hours of delivery.</li> <li>If the product is delivered defective or damaged, in that case, customer needs to inform us through Register email ID and sent it to (care@stock2cart.com) or Call us at +91 9962512354 (Helpline Number) within 48 hours from the time of delivery.</li> <li>Products should be unused.</li> <li>All items must be returned in their original condition, with price tags intact, user manual, warranty cards, original accessories and in the original manufacturer’s box/packaging as delivered to you.</li> <li>Invoice should be available.</li> <li>Products marked as "non-returnable" on the product detail page cannot be returned such as Electronics, Cartridges, Safety, Tyres, Electricals & Car-care.</li> </ol><h4 class="page_heading">Returning a Product</h4> <p>There are 2 ways to Return the product. One is to return the product from our side where we send the courier partner and get the product picked up from customers. However, in some cases if we cannot provide return service then customer needs to send the product to us through India Post only. Once, the product is received by us, then we will reverse the courier charges. </p> <p class="page_heading">Steps to follow to Return a Product </p> <ol><li>Customer needs to inform us through call/email within 7 days of receiving the order.</li> <li>Product should be unused.</li> <li>Invoice should be available.</li> <li>We will raise a request for Reverse pickup and try to arrange it from our end. Once the pickup is arranged our courier partner will collect the product within 2-3 business days.</li> <li>Customer needs to pack the product with Brand packing & paste the invoice on it.</li> <li>Customer will handover the product to the courier boy.</li> <li>Once the pick up is done, product will be sent to us by the courier partner.</li> <li>After receiving the product, quality check will be done over the product by our team which takes 2 days time.</li> <li>If product is found damage/defective by our team, We will try to arrange a replacement; however, it depends on the availability of the product.</li> <li>In some cases, where our Logistic Service Provider doesn’t provide reverse pickup facility, customer will have to send the product on his own only through India post at the below mentioned address after the request for reverse pickup is raised:</li> </ol><h4 class="page_heading">GEESYS Technologies India Pvt. Ltd., </h4> <p>No.33, Alandur Road, Saidapet, Chennai – 600015. <br /> Tamil Nadu, India. </p> <ol><li>Once sent, customer needs to share the Courier slip along with the following bank details at Care@stock2cart.com:</li> <li>Account number</li> <li>Account holder name (Same as registered with Stock2cart.com)</li> <li>IFSC Code</li> <li>In case, after receiving the product if we found any discrepancy by our Quality inspection team, we will re-ship product to the customer and in that case customer will have to bear the courier charges for re-shipment in order to receive the product. No courier charges for sending the product will be reimbursed.</li> </ol><h4 class="page_heading">Other Terms and Conditions</h4> <ol><li>Products marked as "non-returnable" on the product detail page cannot be returned such as Electronics, Cartridges, Safety, Tyres, Electricals & Car-care.</li> <li>Product Purchase under clearance sale will not be covered under Return policy.</li> <li>Products sold as combo can’t be returned individually.</li> </ol><h4 class="page_heading"><br /></h4> <h4 class="page_heading">Other Terms and Conditions</h4> <h5 class="page_heading">30-Day Satisfaction Guarantee</h5> <p>If you are not satisfied for any reason products may be returned within 7 days of shipment for a full credit or exchange (provided the product is undamaged). Return documentation should clearly specify credit or exchange. Certain restrictions apply. Please see the applicable product page on <a href="http://www.stock2cart.com">www.stock2cart.com</a> for more information </p> <h5 class="page_heading">Business Customers’ Limited Warranty</h5> <p>Stock2cart warrants any product purchased for use in business or resale against defects in workmanship or materials under normal use for a period of one year from the date of purchase. Any product determined by Stock2cart to be defective in material or workmanship and returned to Stock2cart shipping costs prepaid will, at Stock2cart option, be repaired or replaced or the purchase price refunded. </p> <h5 class="page_heading">Warranty Disclaimer and Limitation of Liability</h5> <p><strong> DISCLAIMER AND LIMITATIONS:-</strong> ALL OTHER WARRANTIES TO ANY BUSINESS CUSTOMER, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTIABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NONINFRINGEMENT OF INTELLECTUAL PROPERTY RIGHTS, ARE SPECIFICALLY DISCLAIMED, EXCEPT WHERE PROHIBITED BY STATE LAW.<br /><strong> LIMITATION OF LIABILITY:-</strong> STOCK2CART EXPRESSLY DISCLAIMS ANY LIABILITY FOR CONSEQUENTIAL, INCIDENTAL, SPECIAL, EXEMPLARY, OR PUNITIVE DAMAGES. STOCK2CART’ LIABILITY IN ALL CIRCUMSTANCES IS LIMITED TO, AND SHALL NOT EXCEED, THE PURCHASE PRICE PAID FOR THE PRODUCT THAT GIVES RISE TO ANY LIABILITY. </p> <h5 class="page_heading">Manufacturer’s Warranty</h5> <p>For information on a specific manufacturer’s warranty, please contact Stock2cart at care@stockcart.com or (1800-120-2354). </p> <h5 class="page_heading">Product Compliance and Suitability</h5> <p>Jurisdictions have varying laws, codes and regulations governing construction, installation, and/or use of products for a particular purpose. Certain products may not be available for sale in all areas. Stock2cart does not guarantee compliance or suitability of the products it sells with any laws, codes or regulations, nor does Stock2cart accept responsibility for construction, installation and/or use of a product. It is customer’s responsibility to review the product application and all applicable laws, codes and regulations for each relevant jurisdiction to be sure that the construction, installation, and/or use involving the products are compliant. </p> <h5 class="page_heading">Cross-Reference Information</h5> <p>Product cross reference comparisons do not imply that products are available or perfectly comparable. CROSS REFERENCED PRODUCTS ARE NOT REPRESENTED OR WARRANTED AS FUNCTIONAL OR PERFORMANCE EQUIVALENTS. Customer shall review all cross referenced product specifications prior to purchase and use to determine suitability of the product for customer’s intended use. </p> </div> Return Polcy - Stock2cart.com Return Polcy - Stock2cart.com Return Polcy - Stock2cart.com returns-policy