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 = 225 
  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.00090

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
225 478 0 225 A T 0 1647903600 0 0 N 0 0 activity en Herbal Life Termeni is seasoned <p></p> <p><b>Terms and conditions</b> </p> <p>We recommend reading the terms and conditions below carefully. <a href="http://www.programslabire.ro">www.programslabire.ro</a> assumes the right to modify these predictions he will make or to notify.<span></span> </p> <p>Prices include VAT. Photographer displayed are indicative. All products present eg <a href="http://www.programslabire.ro">www.programslabire.ro</a> are valid while stocks last. The team <a href="http://www.programslabire.ro">www.programslabire.ro</a> makes every effort to eliminate oryx errors. <span></span> </p> <p>The products offered by the seller are generally available either in their own stock or in the stock of the authorized importer. For products that are not currently available in stock, the seller will communicate to the customer an estimated delivery time and / or (according to the customer's preference) alternative products, available in stock or that can be brought into stock within the time desired by the customer. The seller will make these proposals to the customer, the choice between these options or the option to completely cancel the order will belong entirely to the customer.<span></span> </p> <p>The seller owns the entire and exclusive property over a good until the moment when he actually collects and fully the price requested from the client for it. From the moment of full and final payment to the seller of the requested price, the client has the full and exclusive property right.<span></span> </p> <p>Seller is not liable for any damage to oryx material nature, immaterial or bodily injury that may result from an allergy or improper use of the products sold. Also, any modifications of the products made by the manufacturer or by the customer do not imply the responsibility of the seller in any way. All information provided by the seller through the site <a href="http://www.programslabire.ro">www.programslabire.ro</a> is given for information purposes and does not engage the responsibility of the seller. <span></span> </p> <p>Informed the personal contact of the customers of the to the seller in order to make orders, both through the site <a href="http://www.programslabire.ro">www.programslabire.ro</a> and by telephone or by e-mail are absolutely necessary in order to make the distance trade.<span></span> </p> <p>The collection of personal contact information, invoiced and delivery are absolutely mandatory, this information being indispensable since it ensures the information and the possession of the client's commanded goods accompanied by fiscal documents and guarantee certificates issued as the case may be, nominatively. The seller may request this information through any means of communication agreed by the customer: by phone, internet or regular mail, the information required is mandatory for the validation of an order, the seller may refuse an order or communicate with a customer if the information provided by him arouses suspicion.<span></span> </p> <p>The parties will communicate in oryx in a mutually agreed manner, either by telephone or by fax, via the Internet or by regular mail, courier, etc. but will have contractual value or will have only those written communications explicitly addressed to the party to whom the communication is made.</p> <p>These clauses are subject exclusively to Romanian legislation. All appeals of validity, interpretation or execution will be addressed only competently to the courts in Bucharest.</p><p>NOTES TO PERSONAL INFORMATION REGARDING DATA PROTECTION According to the requirements of Law no. 677/2001 for the protection of individuals with regard to the processing of personal data is freed circulation of these data, modified and completed yes of Law no. 506/2004 on the processing of personal data and the protection of private prohibitions in the electronic communications sector. We have the obligation to administer safely and only for the specified purposes, give them staff for the provided about you, a member to your family or another person. The purpose of data collection is: informing potential customers about existing offers, obtaining invoice data, delivery and contact in case of orders, direct communication, telephone or internet with clients or potential clients in view of marketing or after-sales support, technical assistance, service .. You are obliged to provide the required data, which are necessary for the purpose of invoicing and delivery of the products ordered by you as a potential customer and for providing after-sales assistance for realized orders. Your refusal determines your inability to honor orders, to answer questions sent by you to assist you if you have previously requested this. The registered information is intended for use by the operator and is communicated only to the following recipients: the operator's staff, the signature of the parcel through which the delivery is made,</p><p>Return policy </p> <p>Remotely purchased products: Remotely purchased products can be returned according to OG 130/2000. The consumer has the right to notify the trader in writing that he will give up the purchase, will be penalized will be invoked for a reason, within 30 working days from the receipt of the product or, in the case of services, from the conclusion of the contract. The return of the products will be made at the customer's expense, the customer will bear all the return transport fees for which the invoice is issued. within 5 working days from the termination of the contract of any nature, refusal to receive, etc. using the same shipping service as the shipment. Carmen Anton - Herbalife Romania Supervisor goes back the value of the order if they were paid by the consumer, within 30 days from the date of written termination of the contract. The refund amount as well as the return conditions do not include the transport costs. Products that show physical means, blows, shards, scratches, shocks, etc. are not accepted for return.<span></span> </p> <p>General return conditions: Packages that do not correspond from an aesthetic point of view will be rejected. In case of misunderstandings, the package will be photographed and a report will be drawn up together with the representative of the courier company in which if it goes specific the condition of the package.<span></span> </p> <p>The results are not a guarantee for all people. A healthy weight control program should include a limited number of calories, a balanced diet and regular physical activity. Herbalife recommends that you consult a physician before beginning any weight control program.<span></span> </p> <p><i>All weight control claims refer to the Herbalife Weight Control Program which includes, but is not limited to, a balanced diet, regular exercise, proper daily fluid intake, nutritional supplements when rested, individual results may vary from person to person.</i><span></span> </p> herbal-life-en-2