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 = 'tr' 
WHERE 
  cscart_pages.page_id = 21 
  AND cscart_page_descriptions.lang_code = 'tr' 
  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.00056

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_seo_names ref PRIMARY,dispatch PRIMARY 206 const,const,const,const 2 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 lang_code page description meta_keywords meta_description page_title link seo_name seo_path
21 0 0 21 A T 0 1208808000 0 0 N 0 0 tr Returns and Exchanges <h1 class="ty-main-title">Policy on Returns and Exchanges</h1> <div class="ty-list-container ty-decimal"> <div class="ty-column5"> <div class="ty-refund__item"> <div class="ty-list-image"> <img src="images/companies/1/pages/refund_b1.jpg"> </div> <div class="ty-list-text big"> <span class="ty-list-item">1</span>Pack all the items in the original packing. Items bought as sets must be returned in sets. </div> </div> </div> <div class="ty-column5"> <div class="ty-refund__item"> <div class="ty-list-image"> <img src="images/companies/1/pages/refund_b2.jpg"> </div> <div class="ty-list-text big"> <span class="ty-list-item">2</span>Fill in the return request form attached to the order. </div> </div> </div> <div class="ty-column5"> <div class="ty-refund__item"> <div class="ty-list-image"> <img src="images/companies/1/pages/refund_b3.jpg"> </div> <div class="ty-list-text big"> <span class="ty-list-item">3</span>Attach a copy of the sales check, specify the method of refund (a postal order or a transfer to the bank account). </div> </div> </div> <div class="ty-column5"> <div class="ty-refund__item"> <div class="ty-list-image"> <img src="images/companies/1/pages/refund_b1.jpg"> </div> <div class="ty-list-text big"> <span class="ty-list-item">4</span>Send the parcel to this address:<br> 3993 Hanover Street, New York, NY 10016 </div> </div> </div> <div class="ty-column5"> <div class="ty-refund__item"> <div class="ty-list-image"> <img src="images/companies/1/pages/refund_b5.jpg"> </div> <div class="ty-list-text big"> <span class="ty-list-item">5</span>After you have sent the parcel, please inform us of that by sending an email to <a href="mailto:sales@example.com">sales@example.com</a>. </div> </div> </div> </div> <h2 class="ty-main-title">Eligibility of Items for Return or Exchange</h2> <div class="ty-list-container ty-column2"> <div class="ty-column3-1"> <div class="ty-list-image"> </div> </div> <div class="ty-column3-2"> <div class="ty-list-text big"> Customers have the right to return any purchased items without defining the reason within <span class="ty-red">14 (fourteen) calendar days</span> from the moment of receiving those items from the Seller or the Seller's representatives. The items can be returned if their consumer properties, factory labels, and ready-for-sale condition are preserved. <br> <br> To return the items, Customers must submit the copy of proof of purchase and fill in the return request form. <br> <br> </div> </div> <div class="ty-column3-1"> </div> <div class="ty-column3-1"> <div class="ty-list-image"> </div> </div> <div class="ty-column3-2"> <div class="ty-list-text big"> Rules on returning and exchanging Items with discovered defects: <br> <br> Customers are entitled to notify the Seller of any discovered defects and demand to rectify them within <span class="ty-red">30 (thirty) calendar days</span> from the moment of the receiving the Items from the Seller or the Seller's representatives. The only exception are defects caused by improper handling of the Items by the Customer. <br> <br> Customers have the right to refuse to take Items and ask for a money refund. In this case the Items must be returned to the Seller, and their consumer properties, factory labels, and ready-for-sale condition are preserved. <br> <br> To return the Items, you must submit the copy of proof of purchase and fill in the return request form. <br> <br> </div> </div> <div class="ty-column3-2"> </div> </div> <div class="ty-about-container ty-flag-left ty-list-container"> <div class="ty-notice clearfix"> <div class="ty-about-banner ty-column7"> <img src="images/companies/1/pages/about_flag.png"> </div> <div class="ty-about-description ty-column2 ty-list-text big"> Our return and refund policy is described above. According to NYS law, stores are legally required to post their refund policy. If a store does not post any return policy, the law requires the store to accept returns within 30 days of purchase. </div> </div> </div> returns-and-exchanges