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 = 3 
  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.00612

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
3 0 0 3 A T 0 1208808000 0 0 N 0 0 activity en Privacy policy <p><img src="images/privacy.jpg" alt="privacy.jpg" /></p><div class="policy_pages_align"> <h4 class="page_heading" style="text-align:center;">Thank you for visiting stock2cart.com.<br /></h4> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us"><strong>stock2cart.com </strong> (hereinafter referred to as " stock2cart ") is committed to safeguarding its users' privacy (hereinafter referred to as “Your” "You") accessing its website (i.e. stock2cart.com) and has provided this Privacy Policy to familiarize You with the manner in which stock2cart collects, uses and discloses Your information collected through the Website. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Before you subscribe to and/or begin participating in or using website, SMESHOPS believes that You have fully read, understood and accept the terms and conditions of this privacy policy. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">The Policy applies to all information that stock2cart has about You and Your account </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">If you do not agree to or wish to be bound by the terms and conditions of this privacy policy, please do not proceed further to use this website. </span> </p> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">This Policy should be at all times read along with the <a href="http://www.stock2cart.com/terms-of-use">Terms of Use</a> of the Website. </span> </p> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">This privacy policy tells you how we use personal information collected at this site. Please read this privacy policy before using the site or submitting any personal information. By using the site, you are accepting the practices described in this privacy policy. These practices may be changed, but any changes will be posted and changes will only apply to activities and information on a going forward, not retroactive basis. You are encouraged to review the privacy policy whenever you visit the site to make sure that you understand how any personal information you provide will be used. </span><span lang="en-us" xml:lang="en-us"><br /></span><span lang="en-us" xml:lang="en-us"><br /></span><strong class="page_heading"><span lang="en-us" xml:lang="en-us">Note:</span></strong><span lang="en-us" xml:lang="en-us"> </span><i><span lang="en-us" xml:lang="en-us"> the privacy practices set forth in this privacy policy are for IndustryBuying.com only. If you link to other web sites, please review the privacy policies posted at those sites. </span></i> </p> <p><i></i> </p><i></i> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"> </span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Collection of Information</h2> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;line-height:inherit;"><span lang="en-us" xml:lang="en-us">We collect personally identifiable information, like names, postal addresses, email addresses, etc., when voluntarily submitted by our visitors. The information you provide is used to fulfill you specific request. This information is only used to fulfill your specific request, unless you give us permission to use it in another manner, for example to add you to one of our mailing lists. </span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Cookie/Tracking Technology</h2> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;line-height:inherit;"><span lang="en-us" xml:lang="en-us">The Site uses cookies and tracking technology depending on the features offered. Cookies and tracking technology are useful for gathering information such as browser type and operating system, tracking the number of visitors to the Site, and understanding how visitors use the Site. Cookies can also help customize the Site for visitors. Personal information cannot be collected via cookies and other tracking technology, however, if you previously provided personally identifiable information, cookies may be tied to such information. Aggregate cookie and tracking information may be shared with third parties. </span> </p> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><strong class="page_heading">COLLECTION OF INFORMATION </strong> </p> <p><strong class="page_heading"></strong> </p><strong class="page_heading"></strong> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Stock2cart collects personal and non-personal information when they register to gain access to the services provided by the Stock2cart or at other specific instances when they are requested to provide us with their personal & non-personal information (“Information”). Personal Information shall include, but not limited to, information regarding Your name, date of birth, gender, address, telephone number, e-mail address, etc. You can always choose not to provide information and in such cases, if the information required is classified as mandatory, You will not be able to avail of that part of the Services, features or content. You can add or update Your Personal Information on a regular basis. When You update information, Stock2cart will keep a copy of the prior version for its records. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Stock2cart primary goal in collecting information is to provide the user with a customized experience on our websites. This includes personalized services, interactive communication and other services. Stock2cart collects Your Personal Information in order to record, support and facilitate Your participation in the activities You select, track Your preferences, to notify You of any updated information and new activities and other related functions offered by Stock2cart, keep You informed about latest content available on the Website, special offers, and other products and services of Stock2cart, to provide You with a customized Website experience, to assist You with customer service or technical support issues, to follow up with You after Your visit, to otherwise support Your relationship with Stock2cart or to prevent fraud and unlawful use. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Certain information may be collected when you visit the Website and such information may be stored in server logs in the form of data. Through this Data Stock2cart understand the use and number of user visiting the Website. Some or all data collected may be shared with the sponsors, investors, advertisers, developer, strategic business partners of Stock2cart. While using the Website, SMESHOPS's servers (hosted by a third party service provider) may collect information indirectly and automatically about Your activities on the Website; for instance by way of cookies. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Promotions that run on our website may be sponsored by companies other than SMESHOPS or may be co-sponsored by Stock2cart and another company. We use third-party service providers to serve ads on our behalf across the internet and sometimes on the Website. They may collect information about Your visits to our Website. Stock2cart uses the log file which includes but not limited to internet protocol (IP) addresses, browser software, number of clicks, number of unique visitors, internet service provider, exit/referring pages, type of platform, date/time stamp, screen resolution etc. for analysis that helps us provide you improved user experience and services. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">We record buying and browsing activities of our users including but not limited to YOUR contact details and profiles and uses the same to provide value-added services to our users. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">We use them to administer the site, track a user's movement and gather broad demographic information for aggregate use. Once a user registers, he/she is no longer anonymous to Stock2cart and it is deemed that the user has given Stock2cart the right to use the personal & non personal information. </span> </p> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">Please note our website is also not a risks proof website. </span><span lang="en-us" xml:lang="en-us"><br /><strong class="page_heading"><br /></strong></span> </p> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"><strong class="page_heading">Distribution of Information</strong></span> </p> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"><strong class="page_heading"></strong></span>As a general rule, Stock2cart will not disclose or share any of the user's personally identifiable information except when Stock2cart has the user's permission or under special circumstances, such as when Stock2cart believes in good faith that the law requires it or as permitted in terms of this policy. </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us"> Stock2cart may also disclose account information in special cases when Stock2cart has reasons to believe that disclosing this information is necessary to identify, contact or bring legal action against someone who may be violating Stock2cart 's Terms of Services or may be causing injury to or interference with (either intentionally or unintentionally) Stock2cart 's rights or property, other Stock2cart website users, or if Stock2cart deems it necessary to maintain, service, and improve its products and services. Personal information collected may be transferred and shared in the event of a sale. </span> </p> <p class="MsoNormal" style="margin-bottom:.0001pt;"><span lang="en-us" xml:lang="en-us">You are required to submit Your information at the time of making an online purchase on the Website. Stock2cart uses an online payment gateway that is operated by a third party and the information that You share with Stock2cart is transferred and shared with such third party payment gateway operator. The said operator may also have access to Your online purchase history/details that You make from the Website. Extremely sensitive information like Your credit-card details are transacted upon secure sites of approved payment gateways which are digitally under encryption, thereby providing the highest possible degree of care as per current technology. You are advised, however, that internet technology is not 100% safe and You should exercise discretion on using the same. </span> </p> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">We may disclose to third party services certain personally identifiable information listed below: </span> </p> <ul><li><span lang="en-us" xml:lang="en-us">1 )Information you provide us such as name, email, mobile phone number </span></li> <li><span lang="en-us" xml:lang="en-us"></span><span lang="en-us" xml:lang="en-us">2 )Information we collect as you access and use our service, including device information, location and network carrier </span></li> <li><span lang="en-us" xml:lang="en-us">3) This information is shared with third party service providers so that we can: </span></li> <li><span lang="en-us" xml:lang="en-us"></span><span lang="en-us" xml:lang="en-us">A )Personalize the app for you </span></li> <li><span lang="en-us" xml:lang="en-us">B )Perform behavioral Analytics </span></li> </ul><p class="MsoListParagraphCxSpLast" style="margin-bottom:.0001pt;text-indent:-18pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"></span> </p> <p class="MsoNormal" style="margin-bottom:.0001pt;background-color:#FFFFFF;vertical-align:baseline;line-height:inherit;"><span lang="en-us" xml:lang="en-us"> </span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Use of Information</h2> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Business information is used to display the user's business listing or product offerings across our website to fetch maximum business opportunities for the user. If you upload any content on the Website and the same may be available to the other users of the Website. Stock2cart will not be liable for the disclosure and dissemination of such content to any third parties. Once the user's content is displayed on our website, the user may start receiving business enquiries through email, phone calls or SMS notifications, from third parties that might or might not be of their interest, Stock2cart does not exercise any control over it. </span> </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">Stock2cart</span><span lang="en-us" xml:lang="en-us"> may, if You so choose, send direct advertisement mailers to You at the address given by You which could contain details of the products or services displayed on </span><span lang="en-us" xml:lang="en-us">Stock2cart</span><span lang="en-us" xml:lang="en-us"> or of any third party not associated with </span><span lang="en-us" xml:lang="en-us">Stock2cart</span><span lang="en-us" xml:lang="en-us">. You have the option to opt-out of this direct or third party mailer by clicking at the unsubscribed link option attached to e-mail. </span><span lang="en-us" xml:lang="en-us">Stock2cart</span><span lang="en-us" xml:lang="en-us"> respects Your privacy and if You do not want to receive e-mail or other communications from </span><span lang="en-us" xml:lang="en-us">Stock2cart</span><span lang="en-us" xml:lang="en-us">. </span> </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"> </span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Protection of Information</h2> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Stock2cart takes necessary steps, within its limits of commercial viability and necessity, to ensure that the user's information is treated securely. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">We request our users to sign out of their Stock2cart account and close their browser window when they have finished their work. This is to ensure that others cannot access their personal or business information and correspondence, if the user shares the computer with someone else or is using a computer in a public place.­ </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Unfortunately, no data transmission over the Internet can be guaranteed to be 100% secure. As a result, while Stock2cart strives to protect the user's personal & business information, it cannot ensure the security of any information transmitted to Stock2cart and you do so at your own risk. Once Stock2cart receives your transmission, it makes best efforts to ensure its security in its systems. Please keep in mind that whenever you post personal & business information online, that is accessible to the public, you may receive unsolicited messages from other parties. </span> </p> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;"><span lang="en-us" xml:lang="en-us">Stock2cart is not responsible for any breach of security or for any actions of any third parties that receive Your Information. The website is also linked to many other sites and we are not/shall be not responsible for their privacy policies or practices as it is beyond our control. </span> </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">Notwithstanding anything contained in this Policy or elsewhere, Stock2cart shall not be held responsible for any loss, damage or misuse of Your Information, if such loss, damage or misuse is attributable to a Force Majeure Event (as defined in Terms of Use). <br /><br /></span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Disclosure</h2> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">In situations when </span><span lang="en-us" xml:lang="en-us">Stock2cart</span><span lang="en-us" xml:lang="en-us"> is legally obligated to disclose information to the government or other third parties, </span><span lang="en-us" xml:lang="en-us">Stock2cart</span><span lang="en-us" xml:lang="en-us"> will do</span><span lang="en-us" xml:lang="en-us"></span> </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"> </span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Commitment to Data Security</h2> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;line-height:inherit;"><span lang="en-us" xml:lang="en-us">Your personally identifiable information is kept secure. Only authorized employees, agents and contractors (who have agreed to keep information secure and confidential) have access to this information. </span> </p> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"></span> </p> <h5 style="margin-top:0cm;background-color:#FFFFFF;"><strong class="page_heading">Links to third party sites:</strong></h5> <p><strong class="page_heading"></strong> </p><strong class="page_heading"></strong> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us">Links to third party sites are provided by website as a convenience to user(s) and Stock2cart has not have any control over such sites i.e. content and resources provided by them. Stock2cart may allow user(s) access to content, products or services offered by third parties through hyperlinks (in the form of word link, banners, channels or otherwise) to such Third Party's web site. You are cautioned to read such sites' terms and conditions and/or privacy policies before using such sites in order to be aware of the terms and conditions of your use of such sites. Stock2cart believes that user(s) acknowledge that Stock2cart has no control over such third party's site, does not monitor such sites, and Stock2cart shall not be responsible or liable to anyone for such third party site, or any content, products or services made available on such a site. </span> </p> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"></span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Online Advertising We Use</h2> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;line-height:inherit;"><span lang="en-us" xml:lang="en-us">We use Google Analytics Advertising Features for remarketing to advertise across the Internet. Remarketing will display relevant ads tailored to you based on what parts of the IndustryBuying.com website you have viewed by placing a cookie on your machine. THIS COOKIE DOES NOT IN ANYWAY IDENTIFY YOU OR GIVE ACCESS TO YOUR COMPUTER. The cookie is used to say "This person visited this page, so show them ads relating to that page." Google Analytics remarketing allows us to tailor our marketing to better suit your needs and only display ads that are relevant to you. </span> </p> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;line-height:inherit;"><span lang="en-us" xml:lang="en-us">If you do not wish to participate in our remarketing, you can opt out by using the <a href="https://tools.google.com/dlpage/gaoptout/">Google Analytics Opt-out Browser Add-on</a>.</span> </p> <p style="margin:0cm 0cm .0001pt;vertical-align:baseline;line-height:inherit;"><span lang="en-us" xml:lang="en-us">We reserve the right to make changes to this policy. Any changes to this policy will be posted. </span> </p> <p style="margin:0cm;margin-bottom:.0001pt;vertical-align:baseline;"><span lang="en-us" xml:lang="en-us"></span> </p> <h2 class="page_heading" style="margin-top:0cm;vertical-align:baseline;">Changes in Privacy Policy </h2> <p>The policy may change from time to time so please check periodically. The revised Policy shall be made available on the Website. Your continued use of the Website, following changes to the Policy, will constitute your acceptance of those changes. Any disputes arising under this Policy shall be governed by the laws of India. </p> <p class="page_heading">THIS DOCUMENT IS AN ELECTRONIC RECORD IN TERMS OF INFORMATION TECHNOLOGY ACT, 2000 AND RULES THERE UNDER AS APPLICABLE AND THE AMENDED PROVISIONS PERTAINING TO ELECTRONIC RECORDS IN VARIOUS STATUTES AS AMENDED BY THE INFORMATION TECHNOLOGY ACT, 2000. THIS ELECTRONIC RECORD IS GENERATED BY A COMPUTER SYSTEM AND DOES NOT REQUIRE ANY PHYSICAL OR DIGITAL SIGNATURES. PLEASE READ THE FOLLOWING TERMS AND CONDITIONS OF USE AGREEMENT CAREFULLY. IF YOU DO NOT AGREE TO THESE TERMS, EXIT THIS PAGE AND DO NOT ACCESS OR USE THE PLATFORM. </p> </div> Stock2cart Privacy Policy Stock2cart Privacy Policy Stock2cart Privacy Policy privacy-policy