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' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  cscart_pages.page_id = 48 
  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.00048

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_pages const PRIMARY PRIMARY 3 const 1
1 SIMPLE cscart_page_descriptions const PRIMARY PRIMARY 9 const,const 1
1 SIMPLE cscart_ult_objects_sharing const PRIMARY PRIMARY 159 const,const,const 1 Using index
1 SIMPLE cscart_seo_names ref PRIMARY,dispatch PRIMARY 206 const,const,const,const 3 Using where

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 lang_code page description meta_keywords meta_description page_title link custom_header seo_name seo_path
48 1 0 48 A T 0 1370210400 0 0 N 0 0 activity en baubay.de <h2>Telefonnummer</h2> <p><span style="color: rgb(0, 0, 0);">0049 30 75 43 92 86 (Mon - Fr.: 08:00 - 16:00)</span></p> <h2>E-Mail</h2> <p><a href="mailto:info@baubay.de">info@baubay.de</a></p> <h2>Kontaktformular</h2> <div class="ty-wysiwyg-content ty-mb-s" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: &quot;Open Sans&quot;, sans-serif; margin-bottom: 10px; overflow-wrap: break-word;"> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 6px 0px; text-align: left;"><a class="ty-btn ty-btn__primary" href="https://www.baubay.de/schreiben-sie-uns.html" rel="nofollow" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); background: rgb(26, 188, 156); font-size: 14px; text-decoration-line: none; outline: 0px; color: white; cursor: pointer; border: 1px solid rgba(0, 0, 0, 0); transition: background 200ms ease 0s; display: inline-block; margin-bottom: 0px; padding: 6px 14px; vertical-align: middle; line-height: 1.42857; user-select: none; border-radius: 3px;">Schreiben Sie uns</a></p> </div> <h2>Bankverbindung</h2> <table cellpadding="0" cellspacing="0"> <tbody> <tr style="font-size: 1.0em; background-color: white; color: black; border: 1px solid #e3e3e3; !important"> <td width="100">Bank:</td> <td style="width: 300px;">mBank (Commerzbank Group)</td> </tr> <tr> <td width="100">IBAN:</td> <td style="width: 300px;"><span id="navigation:bankingNavigation:ibanView:iban">PL13114014430000394304001003</span></td> </tr> <tr> <td width="100">Swift (BIC):</td> <td style="width: 300px;"><span id="navigation:bankingNavigation:bicView:bic">BREXPLPWXXX</span></td> </tr> </tbody> </table> <p>&nbsp;</p> <h2>Ansprechpartner</h2> <table border="1" cellpadding="1" cellspacing="1"> <tbody> <tr style="background-color: white; color: black; border: 1px solid #e3e3e3; !important"> <td style="text-align: center;"><font color="#333333">Marc</font></td> <td style="text-align: center;"><font color="#333333">Christoph</font></td> <td style="text-align: center;"><font color="#333333">Anna</font></td> </tr> <tr> <td><img height:="200" src="/images/marc.jpg" style="border: 1px solid black;" width:="200" /></td> <td><img height:="200" src="/images/krzysztof.jpg" style="border: 1px solid black;" width:="200" /></td> <td><img height:="200" src="/images/anna.jpg" style="border: 1px solid black;" width:="200" /></td> </tr> </tbody> </table> <!-- <p>&nbsp;</p> <h1>Karte</h1> <div align="center"><iframe frameborder="0" height="500" marginheight="0" marginwidth="0" scrolling="no" src="https://mapy.google.pl/maps?f=q&amp;source=s_q&amp;hl=de&amp;geocode=&amp;q=wa%C5%82cz+ko%C5%82obrzeska+56&amp;sll=53.287654,16.459923&amp;sspn=0.006311,0.014784&amp;gl=pl&amp;ie=UTF8&amp;hq=&amp;hnear=Ko%C5%82obrzeska+56,+Wa%C5%82cz,+Wa%C5%82ecki,+Zachodniopomorskie&amp;ll=52.0000000,10.000000&amp;spn=2.318397,4.669189&amp;z=7&amp;output=embed" width="900"></iframe></div> <table cellpadding="0" cellspacing="0"> <tbody> <tr> <td width="130"><strong>Entfernungen</strong></td> <td width="70">&nbsp;</td> </tr> <tr> <td width="130">Berlin</td> <td width="70">281 km</td> </tr> <tr> <td>Potsdam</td> <td>318 km</td> </tr> <tr> <td>Rostock</td> <td>392 km</td> </tr> <tr> <td>Dresden</td> <td>387 km</td> </tr> <tr> <td>Magdeburg</td> <td>445 km</td> </tr> <tr> <td>Schwerin</td> <td>466 km</td> </tr> <tr> <td>Leipzig</td> <td>473 km</td> </tr> <tr> <td>Hannover</td> <td>583 km</td> </tr> <tr> <td>Erfurt</td> <td>584 km</td> </tr> <tr> <td>Bremen</td> <td>658 km</td> </tr> <tr> <td>Kassel</td> <td>673 km</td> </tr> <tr> <td>Nürnberg</td> <td>720 km</td> </tr> <tr> <td>Dortmund</td> <td>784 km</td> </tr> <tr> <td>Frankfurt am M.</td> <td>829 km</td> </tr> <tr> <td>Wiesbaden</td> <td>854 km</td> </tr> <tr> <td>Köln</td> <td>866 km</td> </tr> <tr> <td>München</td> <td>870 km</td> </tr> <tr> <td>Stuttgart</td> <td>915 km</td> </tr> </tbody> </table> <p>&nbsp;</p> <table border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td colspan="2" style="width: 100px;">Firmenangaben</td> </tr> <tr> <td style="width: 100px;">Firma:</td> <td style="width: 250px;"><img alt="" data-cke-saved-src="/images/ak.gif" src="/images/ak.gif" /></td> </tr> <tr> <td width="100">Steuernummer:</td> <td width="250">2322 / 246 / 00598</td> </tr> <tr> <td width="100">Ust-IdNr.:</td> <td width="250"><span style="color: rgb(15, 17, 17); font-family: &quot;Amazon Ember&quot;, Arial, sans-serif; font-size: 12px;">DE332557606</span></td> </tr> <tr> <td width="100">Straße:</td> <td width="250">Kolobrzeska 56</td> </tr> <tr> <td width="100">Stadt:</td> <td width="250">Walcz</td> </tr> <tr> <td width="100">PLZ:</td> <td width="250">78-600</td> </tr> </tbody> </table> --/> --> contacts
48 1 0 48 A T 0 1370210400 0 0 N 0 0 activity en baubay.de <h2>Telefonnummer</h2> <p><span style="color: rgb(0, 0, 0);">0049 30 75 43 92 86 (Mon - Fr.: 08:00 - 16:00)</span></p> <h2>E-Mail</h2> <p><a href="mailto:info@baubay.de">info@baubay.de</a></p> <h2>Kontaktformular</h2> <div class="ty-wysiwyg-content ty-mb-s" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: &quot;Open Sans&quot;, sans-serif; margin-bottom: 10px; overflow-wrap: break-word;"> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 6px 0px; text-align: left;"><a class="ty-btn ty-btn__primary" href="https://www.baubay.de/schreiben-sie-uns.html" rel="nofollow" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); background: rgb(26, 188, 156); font-size: 14px; text-decoration-line: none; outline: 0px; color: white; cursor: pointer; border: 1px solid rgba(0, 0, 0, 0); transition: background 200ms ease 0s; display: inline-block; margin-bottom: 0px; padding: 6px 14px; vertical-align: middle; line-height: 1.42857; user-select: none; border-radius: 3px;">Schreiben Sie uns</a></p> </div> <h2>Bankverbindung</h2> <table cellpadding="0" cellspacing="0"> <tbody> <tr style="font-size: 1.0em; background-color: white; color: black; border: 1px solid #e3e3e3; !important"> <td width="100">Bank:</td> <td style="width: 300px;">mBank (Commerzbank Group)</td> </tr> <tr> <td width="100">IBAN:</td> <td style="width: 300px;"><span id="navigation:bankingNavigation:ibanView:iban">PL13114014430000394304001003</span></td> </tr> <tr> <td width="100">Swift (BIC):</td> <td style="width: 300px;"><span id="navigation:bankingNavigation:bicView:bic">BREXPLPWXXX</span></td> </tr> </tbody> </table> <p>&nbsp;</p> <h2>Ansprechpartner</h2> <table border="1" cellpadding="1" cellspacing="1"> <tbody> <tr style="background-color: white; color: black; border: 1px solid #e3e3e3; !important"> <td style="text-align: center;"><font color="#333333">Marc</font></td> <td style="text-align: center;"><font color="#333333">Christoph</font></td> <td style="text-align: center;"><font color="#333333">Anna</font></td> </tr> <tr> <td><img height:="200" src="/images/marc.jpg" style="border: 1px solid black;" width:="200" /></td> <td><img height:="200" src="/images/krzysztof.jpg" style="border: 1px solid black;" width:="200" /></td> <td><img height:="200" src="/images/anna.jpg" style="border: 1px solid black;" width:="200" /></td> </tr> </tbody> </table> <!-- <p>&nbsp;</p> <h1>Karte</h1> <div align="center"><iframe frameborder="0" height="500" marginheight="0" marginwidth="0" scrolling="no" src="https://mapy.google.pl/maps?f=q&amp;source=s_q&amp;hl=de&amp;geocode=&amp;q=wa%C5%82cz+ko%C5%82obrzeska+56&amp;sll=53.287654,16.459923&amp;sspn=0.006311,0.014784&amp;gl=pl&amp;ie=UTF8&amp;hq=&amp;hnear=Ko%C5%82obrzeska+56,+Wa%C5%82cz,+Wa%C5%82ecki,+Zachodniopomorskie&amp;ll=52.0000000,10.000000&amp;spn=2.318397,4.669189&amp;z=7&amp;output=embed" width="900"></iframe></div> <table cellpadding="0" cellspacing="0"> <tbody> <tr> <td width="130"><strong>Entfernungen</strong></td> <td width="70">&nbsp;</td> </tr> <tr> <td width="130">Berlin</td> <td width="70">281 km</td> </tr> <tr> <td>Potsdam</td> <td>318 km</td> </tr> <tr> <td>Rostock</td> <td>392 km</td> </tr> <tr> <td>Dresden</td> <td>387 km</td> </tr> <tr> <td>Magdeburg</td> <td>445 km</td> </tr> <tr> <td>Schwerin</td> <td>466 km</td> </tr> <tr> <td>Leipzig</td> <td>473 km</td> </tr> <tr> <td>Hannover</td> <td>583 km</td> </tr> <tr> <td>Erfurt</td> <td>584 km</td> </tr> <tr> <td>Bremen</td> <td>658 km</td> </tr> <tr> <td>Kassel</td> <td>673 km</td> </tr> <tr> <td>Nürnberg</td> <td>720 km</td> </tr> <tr> <td>Dortmund</td> <td>784 km</td> </tr> <tr> <td>Frankfurt am M.</td> <td>829 km</td> </tr> <tr> <td>Wiesbaden</td> <td>854 km</td> </tr> <tr> <td>Köln</td> <td>866 km</td> </tr> <tr> <td>München</td> <td>870 km</td> </tr> <tr> <td>Stuttgart</td> <td>915 km</td> </tr> </tbody> </table> <p>&nbsp;</p> <table border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td colspan="2" style="width: 100px;">Firmenangaben</td> </tr> <tr> <td style="width: 100px;">Firma:</td> <td style="width: 250px;"><img alt="" data-cke-saved-src="/images/ak.gif" src="/images/ak.gif" /></td> </tr> <tr> <td width="100">Steuernummer:</td> <td width="250">2322 / 246 / 00598</td> </tr> <tr> <td width="100">Ust-IdNr.:</td> <td width="250"><span style="color: rgb(15, 17, 17); font-family: &quot;Amazon Ember&quot;, Arial, sans-serif; font-size: 12px;">DE332557606</span></td> </tr> <tr> <td width="100">Straße:</td> <td width="250">Kolobrzeska 56</td> </tr> <tr> <td width="100">Stadt:</td> <td width="250">Walcz</td> </tr> <tr> <td width="100">PLZ:</td> <td width="250">78-600</td> </tr> </tbody> </table> --/> --> contacts