Sandbox

SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  AND cscart_page_descriptions.lang_code = 'en' 
  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 = 'vn' 
WHERE 
  1 
  AND cscart_pages.parent_id IN (7) 
  AND cscart_pages.status IN ('A') 
  AND cscart_pages.page_type IN ('B') 
  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.use_avail_period = 'N' 
    OR (
      cscart_pages.use_avail_period = 'Y' 
      AND cscart_pages.avail_from_timestamp <= 1782487835 
      AND (
        cscart_pages.avail_till_timestamp >= 1782487835 
        OR cscart_pages.avail_till_timestamp = 0
      )
    )
  ) 
ORDER BY 
  cscart_pages.timestamp desc 
LIMIT 
  0, 20

Query time 0.00063

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_pages.`timestamp` desc",
            "table": {
              "table_name": "cscart_pages",
              "access_type": "ALL",
              "possible_keys": ["parent_id"],
              "rows": 28,
              "filtered": 35.7142868,
              "attached_condition": "cscart_pages.parent_id = 7 and cscart_pages.`status` = 'A' and cscart_pages.page_type = 'B' 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.use_avail_period = 'N' or cscart_pages.use_avail_period = 'Y' and cscart_pages.avail_from_timestamp <= 1782487835 and (cscart_pages.avail_till_timestamp >= 1782487835 or cscart_pages.avail_till_timestamp = 0))"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "cscart_page_descriptions",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["page_id", "lang_code"],
          "ref": ["demov2026.cscart_pages.page_id", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_page_descriptions.lang_code = 'en')"
        }
      },
      {
        "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": ["demov2026.cscart_pages.page_id", "const", "const", "const"],
          "rows": 3,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_seo_names.`type` = 'a' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'vn')"
        }
      }
    ]
  }
}

Result

page_id	parent_id	id_path	status	page_type	position	timestamp	use_avail_period	facebook_obj_type	lang_code	page	description	seo_name	seo_path
41	7	7/41	A	B	100	1781547680	N	activity	en	For those who love sound quality we have awesome Pioneer speakers! (Demo)	<h2>Demo article title h2</h2><p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p><h3>Demo article title h3</h3><p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p><p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	for-those-who-love-sound-quality-we-have-awesome-pioneer-speakers-demo-vn	7
42	7	7/42	A	B	200	1781547680	N	activity	en	New arrivals of Nintendo Wii games! (Demo)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	new-arrivals-of-nintendo-wii-games-demo-vn	7
43	7	7/43	A	B	300	1781547680	N	activity	en	Only in our store! Famous American WeatherMaster tents! (Demo)	<h2>Demo article title h2</h2><p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p><h3>Demo article title h3</h3><p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p><p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	only-in-our-store-famous-american-weathermaster-tents-demo-vn	7
44	7	7/44	A	B	400	1781547680	N	activity	en	We got the best tracks of legendary B.B.King (Demo)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	we-got-the-best-tracks-of-legendary-b-b-king-demo-vn	7
45	7	7/45	A	B	500	1781547680	N	activity	en	Looking for a keypad Nokia phone and can't find one? We still have them! (Demo)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	looking-for-a-keypad-nokia-phone-and-cant-find-one-we-still-have-them-demo-vn	7
46	7	7/46	A	B	600	1781547680	N	activity	en	Afraid of zombies? Preparing for apocalypse? (Demo)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	afraid-of-zombies-preparing-for-apocalypse-demo-vn	7
47	7	7/47	A	B	700	1781547680	N	activity	en	True American classic! Drifter cruisers (Demo)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	true-american-classic-drifter-cruisers-demo-vn	7
10	7	7/10	A	B	0	1415736000	N		en	How to Distribute Money between Vendors	<p>PayPal Complete Payments (Multiparty) is a solution that allows marketplaces to accept payments and split them between the vendors involved, while the marketplace takes its cut.</p><!--CUT--><p>To use PayPal Complete Payments (Multiparty), you must first contact PayPal and become approved for the use of this solution.</p><p>After that, you’ll be able to <a href="https://docs.cs-cart.com/latest/user_guide/payment_methods/paypal_commerce_platform.html" target="_blank">set up a payment method that uses PayPal Complete Payments (Multiparty)</a>. It’s important that vendors connect their accounts to your marketplace. If all of the vendors whose products are being bought connect their accounts, then customers will be offered that PayPal payment method at checkout.</p><p>In this case, everyone benefits:<ul><li>Customers benefit from having to pay only once.</li><li>You benefit from not having to split the money between vendors.</li><li>Vendors benefit from getting the money from their sold products.</li></ul></p>	how-to-distribute-money-between-vendors-vn	7
9	7	7/9	A	B	0	1415526000	N		en	Why You Need a Subscription Model for Your Vendors	<p>When you run a multi-vendor marketplace, you offer other entrepreneurs a service by allowing them to sell their products on your territory. To help you earn money for that service, Multi-Vendor comes with the built-in “Vendor plans” functionality.</p><!--CUT--><p>The vendor plans allow you to:<ul><li>Take a one-time or periodic (monthly / yearly) fee from your vendors.</li><li>Take commission from each transaction (percentage, fixed, or both).</li><li>Impose restrictions on the number of products and maximum revenue.</li><li>Give more privileges to vendors with higher-tier plans.</li><li>Decide which storefronts and categories will be available to vendors with this or that plan.</li><li>Offer certain vendors a microstore—it is a section of the site available by a direct link, where only the products of a specific vendor appear.</li></ul></p><p>Follow us on <a href="https://www.facebook.com/cscart.official" target="_blank">Facebook</a> and <a href="https://twitter.com/cscart" target="_blank">Twitter</a> to stay in the loop. To learn about other useful CS-Cart functionality, check out our <a href="https://www.youtube.com/user/cscartvideos" target="_blank">YouTube channel</a>.</p>	why-you-need-a-subscription-model-for-your-vendors-vn	7
8	7	7/8	A	B	0	1415316000	N		en	Check out CS-Cart Marketplace	<p>CS-Cart is feature-packed out of the box. But if you’re looking for something more for your project, we have CS-Cart Marketplace — the official store with add-ons and themes for CS-Cart.</p><div style="text-align: center; margin: 15px auto;"><a class="button ty-btn ty-btn__primary" href="https://marketplace.cs-cart.com/" title="GO TO MARKETPLACE" target="_blank">GO TO MARKETPLACE</a></div><p>Make your CS-Cart store more powerful, beautiful, functional, and user-friendly.</p><!--CUT--><p>CS-Cart Marketplace can help you:<ul><li>extend the functionality of your site;</li><li>create a unique look and feel for it;</li><li>get extra tools for promoting the site, and more;</li><li>save your time for what’s really important.</li></ul></p><p>Filter add-ons by their developer and field of use; choose them by rating, reviews, and compatibility with your CS-Cart version. If you have questions on some add-on or theme, contact its developer right from the product page.</p>	check-out-cs-cart-marketplace-vn	7