SELECT 
  jmj_pages.*, 
  jmj_page_descriptions.* 
FROM 
  jmj_pages 
  INNER JOIN jmj_page_descriptions ON jmj_pages.page_id = jmj_page_descriptions.page_id 
WHERE 
  jmj_pages.page_id = 28 
  AND jmj_page_descriptions.lang_code = 'en' 
  AND (
    jmj_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, jmj_pages.usergroup_ids) 
    OR FIND_IN_SET(1, jmj_pages.usergroup_ids)
  ) 
  AND jmj_pages.page_type IN ('T', 'L', 'B', 'F')

Query time 0.00097

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
28 0 0 28 A T 0 1208802600 0 0 N 0 0 activity en Terms & Conditions <section class="ppolicy"> <div class="my-wrapper"> <div class="ppolicy-inner"> <div class="pp-heading-career my-css"><span>TERMS</span> OF USE</div> <div class="pp-text-inner"> <p>Welcome to Xplore. Here are our house rules to make your journey comfortable and easy. These ‘Terms & Conditions’ constitute an electronic record within the meaning of the applicable law. This electronic record is generated by a computer system and does not require any physical or digital signatures. </p> <p> <strong>Privacy Policy -</strong> Please review our policy, which also governs your visit to this site, to understand our practices. </p> <p> <strong>Electronic Communications -</strong> When you visit the site or send e-mails to us, you are communicating with us electronically. You consent to receive communications from us electronically. We will communicate with you by e-mail or by posting notices on this site. You agree that all agreements, notices, disclosures and other communications that we provide to you electronically satisfy any legal requirement that such communications be in writing. Copyright - All content included on this site, such as text, graphics, logos, button icons, images, audio clips, digital downloads, data compilations, and software, is the property of Xplore or its affiliates or its content suppliers and protected by Indian copyright laws. The compilation of all content on this site is the exclusive property of Xplore or its affiliates and protected by Indian copyright laws. All software used on this Site is the property of Xplore, its affiliates or its software suppliers and is protected by Indian copyright laws.</p> <p> <strong>Trademarks -</strong> Xplore, the Xplore logo, and other marks indicated on our Site are trademarks of Xplore or its affiliates in other states. Other graphics, logos, page headers, button icons, scripts, and service names are trademarks or trade dress of Xplore or its affiliates. Xplore and its affiliates trademarks and trade dress may not be used in connection with any product or service that is not Xplore or its affiliates&nbsp;as applicable, in any manner that is likely to cause confusion among users, or in any manner that disparages or discredits Xplore or its affiliates. All other trademarks not owned by Xplore or its affiliates that appear on this site are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored by Xplore or its affiliates. License and site access - License to Use Our services. We grant you a limited, non-exclusive, non-transferable, and revocable license to use our services - subject to the Terms and the following restrictions in particular: </p> <p> Don’t Use Our services to Break the Law. You agree that you will not violate any laws in connection with your use of the services. This includes any law that may apply to you. For example, it’s your responsibility to obtain any permits or licences that your shop requires, and to meet applicable legal requirements in the applicable jurisdiction(s). This includes the sale and delivery of your items, such as age verification upon delivery, where required by law. You may not sell anything that violates any laws; you must comply with our privacy policy, and you may not engage in fraud (including false claims or infringement notices), theft, anti-competitive conduct, threatening conduct, or any other unlawful acts or crimes against Xplore, another Xplore user, or a third party.</p> <p> Pay Your Bills. You are responsible for paying all fees that you owe to Xplore. Except as set forth below, you are also solely responsible for collecting and/or paying any applicable taxes for any purchases or sales you make through our services. In addition, Xplore will calculate, collect, and remit sales tax where applicable.</p><p> </p> <p> Don’t Try to Harm Our Systems. You agree not to interfere with or try to disrupt our services, for example by distributing a virus or other harmful computer code. </p> <p> <strong>Termination - </strong>Termination by You. We'd hate to see you go, but you may terminate your account with Xplore at any time from your account settings. Terminating your account will not affect the availability of some of the content that you posted through the services prior to termination. Oh, and you’ll still have to pay any outstanding bills. Termination By Xplore. We may terminate or suspend your account (and any accounts Xplore determines are related to your account) and your access to the services should we have reason to believe you, your content, or your use of the services violate our Terms. If we do so, it’s important to understand that you don’t have a contractual or legal right to continue to use our services, for example, to sell or buy on our websites or mobile apps. Generally, Xplore will notify you that your account has been terminated or suspended unless you’ve repeatedly violated our Terms or we have legal or regulatory reasons preventing us from notifying you. </p> <p> <strong>Limitation of Liability -</strong> Xplore does not manufacture, store, or inspect any of the items sold through our services. We provide the venue; the items in our marketplaces are produced, listed, and sold directly by independent sellers, so Xplore can't and does not make any warranties about their quality, safety, or even their legality. Any legal claim related to an item you purchase must be brought directly against the seller of the item. You release Xplore from any claims related to items sold through our services, including defective items, misrepresentations by sellers, or items that caused physical injury (like product liability claims). You can use the services to interact with other individuals, either online or in person. Please be careful and exercise caution and good judgement in all interactions with others, especially if you are meeting someone in person. </p> <p> <strong>Applicable Law -</strong> By visiting this site, you agree that the laws of India will govern these Terms of Use and any dispute of any sort that might arise between you and Xplore or its affiliates. </p> <p> <strong>Disputes -</strong> If you have a dispute with us relating to the Service, in the first instance please contact us via our Help Centre and attempt to resolve the dispute with us informally.</p> <p> <strong>Changes to the Terms -</strong> We may update these terms from time to time. If we believe that the changes are material, we’ll definitely let you know by posting the changes through the services and/or sending you an email or message about the changes. That way you can decide whether you want to continue using the services. Changes will be effective upon the posting of the changes unless otherwise specified. You are responsible for reviewing and becoming familiar with any changes. Your use of the services following the changes constitutes your acceptance of the updated terms.</p> <p> Xplore reserves the right to change, suspend, or discontinue any of the services for you, any or all users, at any time, for any reason, including those laid out in Xplore’s policies under these Terms of Use. We will not be liable to you for the effect that any changes to the services may have on you, including your income or your ability to generate revenue through the services. </p> </div> </div> </div> </section>