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 = 'fr' 
WHERE 
  cscart_pages.page_id = 20 
  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')

Query time 0.08288

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "table": {
      "table_name": "cscart_pages",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["page_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_page_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["page_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "PRIMARY",
      "key_length": "206",
      "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
      "ref": ["const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_seo_names.`type` = 'a' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'fr')"
    }
  }
}

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 commercial_id lang_code page description meta_keywords meta_description page_title link seo_name seo_path
20 0 0 20 A T 0 1682028000 0 0 N 0 0 activity 0 en Contact Us! <div class="contact-container"><h4>Contact us</h4><p> At <strong>DENXIAD</strong> , we are passionate and dedicated to providing you with an exceptional experience.</p><p> Whether you have questions about our dentures, need assistance with an order, <span style="color: var(--redactor2-text-color);">or simply want to share your feedback, our team is ready to listen.</span></p><h3> How to Contact Us</h3><p> <strong>By Email:</strong><br> For any questions or assistance, send us an email at <a href="mailto:contact@denxiad-france.com">contact@denxiad-france.com</a> .<br> Our team is committed to responding to you within 24 hours.</p><p> <strong>Contact Form:</strong><br> You can also use our online contact form to send us your requests.</p><p> Simply fill in the required fields and click "Submit".</p><p> We will process your request within 24 hours.</p><p> Your satisfaction is our priority.</p><p> Please feel free to contact us with any questions or concerns, we are here to help!</p><h3> Direct Contacts</h3><ul><li> <strong>Customer Service:</strong> <a href="mailto:avisclient@denxiad-france.com">avisclient@denxiad-france.com</a></li><li> <strong>Billing:</strong> <a href="mailto:facturation@denxiad-france.com">facture@denxiad-france.com</a></li><li> <strong>Support:</strong> <a href="mailto:support@denxiad-france.com">support@denxiad-france.com</a></li><li> <strong>Payments:</strong> <a href="mailto:paiements@denxiad-france.com">payments@denxiad-france.com</a></li></ul><h3> Our Subsidiaries</h3><p> We are present in several countries to serve you better.</p><p> Here are the contact details of our subsidiaries:</p><table><tbody><tr><th> Country</th><th> E-mail</th></tr><tr><td> Austria</td><td> <a href="mailto:autriche@denxiad.com">austria@denxiad.com</a></td></tr><tr><td> Belgium</td><td> <a href="mailto:belgique@denxiad.com">belgique@denxiad.com</a></td></tr><tr><td> China</td><td> <a href="mailto:chine@denxiad.com">china@denxiad.com</a></td></tr><tr><td> Spain</td><td> <a href="mailto:espagne@denxiad.com">spain@denxiad.com</a></td></tr><tr><td> Holland</td><td> <a href="mailto:hollande@denxiad.com">hollande@denxiad.com</a></td></tr><tr><td> Italy</td><td> <a href="mailto:italie@denxiad.com">italy@denxiad.com</a></td></tr><tr><td> Luxembourg</td><td> <a href="mailto:luxembourg@denxiad.com">luxembourg@denxiad.com</a></td></tr><tr><td> Norway</td><td> <a href="mailto:norvege@denxiad.com">norway@denxiad.com</a></td></tr><tr><td> United Kingdom</td><td> <a href="mailto:uk@denxiad.com">uk@denxiad.com</a></td></tr><tr><td> Suede</td><td> <a href="mailto:suede@denxiad.com">suede@denxiad.com</a></td></tr><tr><td> Swiss</td><td> <a href="mailto:suisse@denxiad.com">suisse@denxiad.com</a></td></tr></tbody></table><p><strong><br></strong></p><p> <strong>DENXIAD</strong> is expanding, stay tuned for the next openings!</p><p> <span style="color: rgb(192, 80, 77);"><b>DENXIAD</b> because you are worth it!</span><br></p></div><style> body { font-family: 'Roboto', sans-serif; background-color: #f7f7f7; color: #333; } .contact-container { border: 2px solid #e30613; /* Rouge vif */ padding: 20px; margin: 20px; background-color: #ffffff; font-size: 16px; line-height: 1.6; box-shadow: 0px 0px 10px rgba(0, 0, 0, 0.1); } .contact-container h2, .contact-container h3 { font-weight: 700; color: #e30613; /* Rouge vif */ } .contact-container p { margin-bottom: 15px; } .contact-container ul { list-style-type: none; padding: 0; } .contact-container ul li { margin-bottom: 10px; } .contact-container a { color: #8cc63e; /* Vert lime */ text-decoration: none; } .contact-container a:hover { text-decoration: underline; } .contact-container table { width: 100%; border-cocollapse: collapse; margin-top: 20px; } .contact-container table, .contact-container th, .contact-container td { border: 1px solid #ccc; } .contact-container th, .contact-container td { padding: 8px; text-align:left; }</style> Contact Us contactez-nous