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 = 300 
  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', 'V')

Query time 0.00135

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.20"
    },
    "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.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": "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.20",
            "prefix_cost": "0.00",
            "data_read_per_join": "5K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link",
            "ab__custom_page_h1",
            "page_sitemap"
          ]
        }
      },
      {
        "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": "1.00",
            "eval_cost": "0.20",
            "prefix_cost": "1.20",
            "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 abt__ut2_microdata_schema_type lang_code page description meta_keywords meta_description page_title link ab__custom_page_h1 page_sitemap seo_name seo_path
300 0 0 300 A T 0 1660600800 0 0 N 0 0 activity en Privacy Policy <p><span style="color: rgb(34, 34, 34); font-size: 32px; font-weight: 700;">Privacy Policy</span><br></p> <p>This Privacy Policy describes the use and collecting of information for a number of purposes, such as account information or information of your interactions with our services.</p> <h2>1. Information Collected. </h2> <p>WebMarco uses data collection in order to offer services and identify a natural(existing) person.</p> <h3>When information is collected?&nbsp; (Information provided by you)</h3> <p>When you register for our Services, purchase and/or register domain names, use any of our Services. </p> <p>What information is collected? </p> <ul><li>Information you provide when creating a account on WebMarco, specifically first name, last name, email address. </li><li>Purchases of paid services offered by WebMarco. Payment information such as country of issuance, expiration date of the card is information used for our payment process </li><li>All means of communications contain data/information provided by you. (email, costumer support, costumer messages, etc.) </li><li>Promotion, deals you offer on your website as a vendor. </li><li>Purchase of products on WebMarco. Any purchase made includes information you provide to complete the payment process. </li><li>When making a purchase of products on WebMarco, delivery information is required for further procedures. (postal address, city, full name, email address, account ID, etc.) </li></ul> <p>All specifications mentioned above are part of the information provided by you to WebMarco. </p> <p>&nbsp; </p> <h2>2. Data Protection.</h2> <p>All data collected and processed by WebMarco is in regulation with GDPR (General Data Protection Regulation) according to EU standards and legal terms.</p> <p>European General Data Protection Regulation (GDPR)</p> <p>All countries that fall under the DGPR laws and regulations, may use data protection laws, including right to:</p> <ul><li>Request access to personal data </li><li>Request delectation/correction of data </li><li>Process of data </li><li>Request the limit of use or processing of your personal data </li><li>Right to complain to supervisory authority for any believed breach of law. </li></ul> <p>&nbsp; </p> <h2>3. Your rights and consent.</h2> <p>WebMarco may collect and share data with consent for better use at your direction. This information can be share with 3rd parties when authorized by you. </p> <ul><li>You can exercise your rights over Personal Data/ Information being used by WebMarco or 3rd parties. You have the right to object to the use of your data at any time, as well as make changes to the data collected by WebMarco to better use on your end. </li><li>If you believe that your Personal Data was wrongly used, you have the right to file a complaint with a supervisory authority. </li><li>Users may contact Vendors personally regarding personal data on websites powered by WebMarco. </li></ul> <p>&nbsp; </p> <p>&nbsp; </p> <h2>4. 3rd party links (where/ who the data is shared)</h2> <p>WebMarco has a number of partners whose services come in hand with the services provided by WebMarco. Information may be shared to the mentioned 3rd parties if we believe this information might become helpful to the services provided. When you register on WebMarco information filled out (example: name, last name, email, phone number, etc.) is used to identify each individual for further registrations and use of services. When purchasing a product or services provided by us, all information related to your purchase (example: postal address, account ID, account name, email address, etc.) may be used in future noticed. </p> <p>*According to legal rights and Data Protection. </p> <p>&nbsp; </p> <h2>5. Cookies</h2> <p>Cookies are a string of information provided from the visitor's browser each time that a visitor enter or returns to a website. Automatic cookies and other forms of technologies like pixel tags help us identify and track usage, visitors, preferences for our Services/Products. </p> <p>Cookies used on WebMarco are essential for our website and services in order to perform basic functions and features. This includes account-related functions, which allow users to register and store preferences such as account name, languages, and ensure all functions and services are operating properly. </p> <p>Below we have listed the types of cookies used on WebMarco and their functions. </p> <ul><li>Analytics and Performance </li><li>Advertising </li></ul> <p>These cookies allow us to improve and optimize performance by collecting data on users who interact with our website, pages and other analytic data. By doing so we can analyze our users interests and improve their experience on our website. </p> <p>These cookies are used by our advertising partners to provide you with content, advertisements and preferences relevant to you or your online business. </p> <p>We use both session-based and persistent cookies on our websites. </p> <p>&nbsp; </p> <p>&nbsp; </p> <h2>6. Tracking</h2> <p>Advertisement appearing on any of our Services may be delivered by other advertising networks. These advertising networks may use tracking technologies (such as cookies) to collect information from you about the use of our services. By tracking this information WebMarco and other advertising networks are able to determine your interests and preferences. </p> <p>&nbsp; </p> <p>These technologies are used mostly for stability, security, functionality, performance and advertising purposes. </p> <p>&nbsp; </p> <h2>7. Changes to Policy</h2> <p>Privacy Policy can be update at any time found reasonable to reflect changes and updates in technology, law requirements or any other reason determined as necessary by us. After the update of these changes, "Effective Date" will represent the accurate date when these changes were made and will be visible to all visitors. </p> <p>You will be notified for any changes made on the way we collect and process personal information. </p> <p>&nbsp; </p> <h2>8. Contact us (forms of contact)&nbsp; &nbsp;</h2> <p>If you have any questions, complaint, comments or recommendations feel free to contact us on any of our forms of contact.</p><p><br></p> <p>Email: info@webmarco.com </p> <p>Phone:&nbsp;&nbsp; +390256568724</p> <p>WebMarco -Your Business Partner </p> <p>Street Pontida 71, 15121 Alessandria (AL) Italy </p> Privacy Policy Privacy Policy Privacy Policy privacy-policy-list