SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    9966, 9967, 9968, 9969, 9970, 9971, 9972, 
    9973, 9974, 9975, 9976, 9977, 9978, 
    9979, 9980, 9981, 9982, 9983, 7798, 
    7797, 7779, 7778, 7777, 7776, 7775, 
    7772, 7771, 6913, 6914, 6915, 6916, 
    6917
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00085

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "table": {
      "table_name": "q_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (9966,9967,9968,9969,9970,9971,9972,9973,9974,9975,9976,9977,9978,9979,9980,9981,9982,9983,7798,7797,7779,7778,7777,7776,7775,7772,7771,6913,6914,6915,6916,6917)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
6913 <ul class="bullet"><li>Fully customizable storage protects a variety of DSLR and drone equipment plus accessories.</li> <li>Compatible with drones up to 320 x 280 x 100 mm including DJI Mavic Pro, DJI Mavic Spark, Yuneec breeze.</li> <li>Thickly padded laptop compartment protects a 14" PC/15" MacBook Pro.</li> <li>Top zipper pocket provides quick access to DSLR camera.</li> <li>Included rain cover stows behind back panel when not in use.</li> <li>Secure tripod attachment with adjustable strap.</li> <li>Internal mesh pockets and secure elastic bands store accessories, cables and propellers.</li> <li>Exterior pockets organize camera accessories and personal items.</li> <li>Luggage strap securely attaches backpack to most rolling luggage.</li> <li>Durable exterior constructed of 1680D polyester.</li> </ul>
6914 <ul class="bullet"><li>Designed to fit an SLR camera with attached lens (up to 70-200mm), a DJI Mavic Pro (or drones up to 320mm x 260mm x 120mm) and a variety of accessories.</li> <li>15" MacBook Pro or 14" PC fit in the padded laptop compartment.</li> <li>Side straps adjust to secure a tripod or other bulky items.</li> <li>Weather hood fits snugly over the bag to protect from the elements (when not in use, roll into its stuff sack for storage).</li> <li>Front pocket provides storage for any non-camera items you require.</li> <li>A padded front panel ensures your camera and accessories are protected from impact.</li> <li>Convenient mesh water bottle pouch.</li> <li>Innovative strap management system eliminates messy, hanging straps.</li> </ul>
6915 <ul class="bullet"><li>Thickly padded storage for a laptop up to 15.6".</li> <li>Dedicated slip pocket for a 10.5" tablet.</li> <li>2-in-1 bag can be carried as a briefcase or a backpack.</li> <li>Additional compartment for files, books and headphones.</li> <li>Removable, padded shoulder strap adjusts for a custom fit.</li> <li>Front pocket with organization panel.</li> <li>Quick-access front pocket stores small accessories.</li> <li>Melange fabric, copper touchpoints and trim details create a modern professional look.</li> <li>Backpack straps tuck away when not in use.</li> <li>Multiple grab handles for use in either briefcase or backpack mode.</li> </ul>
6916 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 13" laptop to school, the office or the local cafe.</p>
6917 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 13" laptop to school, the office or the local cafe.</p>
7771 <p><br />Nanopresso M-Case is made of durable EVA material and soft fabric interior lining.<br />It is specially designed to fit around the Nanopresso with the addition of the adapter ring from the NS Adapter or the Barista Kit.<br />The case helps protect from any bumps, scratches and dust.</p>
7772 <div class="jsx-115903991 jsx-3349621030" style="margin-bottom:0px;padding:0px;border-width:0px;font-size:12px;line-height:inherit;font-family:'Proxima Nova', 'Helvetica Neue', Arial, sans-serif;vertical-align:baseline;color:rgb(64,69,83);background-color:rgb(255,255,255);"><div class="jsx-1889249662 overviewSection" style="margin-bottom:0px;padding:0px;border-width:0px;font:inherit;vertical-align:baseline;"><ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Efficient and easy to use semi-automatic piston that controls the amount of extracted coffee.</li><li class="jsx-1889249662">Heat sink that absorbs heat and protects your hands while operating.</li><li class="jsx-1889249662">Comes equipped with built in espresso cup and scoop.</li></ul></div></div>
7775 <br /><ul><li> <ul><li>The NS Adapter allows the Nanopresso to use NS CAPSULES to prepare espresso.</li> </ul></li> </ul><br /><ul><li> <ul><li>The advantage of using capsules is that the coffee is mechanically ground, measured, and tamped with a higher precision than we are capable of doing by hand.</li> </ul></li> </ul><br /><ul><li> <ul><li>There is very little left for error, so your espresso is consistent every single time. Pods are convenient, mess free and easier to clean after use.</li> </ul></li> </ul>
7776 <br /><ul><li><ul><li>The Barista Kit is a full set of accessories packed in a small container.</li> </ul></li></ul><br /><ul><li><ul><li>It expands the Nanopresso capabilities by giving you the possibility to prepare double espresso (16 grams of ground coffee) up to 120ml.</li> </ul></li></ul><br /><ul><li><ul><li>Thanks to its high pressure extraction of 18 bar, Nanopresso takes full advantage of the larger filter basket and surpasses the extraction quality of most home espresso machine.</li> </ul></li></ul><br /><ul><li><ul><li>Coffee lovers will be pleased to enjoy unbelievably rich espresso. The double espresso basket is a unique feature that can not be found in any other portable espresso machine.</li> </ul></li></ul>
7777 <ul><br /><li>COMPACT &amp; FEATHERWEIGHT - Whether you're going away for few hours or few weeks, space and weight are major factors when selecting your travel equipment</li><br /><li>INNOVATIVE &amp; POWERFUL - With the help of the semi-automatic piston, small quantities of water are injected into the coffee adapter. After a few pushes, the optimal extraction pressure is achieved and a rich and bold espresso is extracted</li><br /><li>CONVENIENT &amp; EVOLUTIVE - Minipresso doesn't require compressed air, N2O cartridges or electricity for its operation. Hand operated, you are free to prepare coffee drinks that you love</li><br /></ul><br /><p>Minipresso GR is your best choice to savor all the varieties of ground coffee and enjoy an authentic espresso wherever you are. Compact, lightweight and sturdy, Minipresso will make you smile when you get the first drip of espresso from this little coffee bullet.</p>
7778 <ul><br /><li>COMPACT &amp; FEATHERWEIGHT - Whether you're going away for few hours or few weeks, space and weight are major factors when selecting your travel equipment</li><br /><li>INNOVATIVE &amp; POWERFUL - With the help of the semi-automatic piston, small quantities of water are injected into the coffee adapter. After a few pushes, the optimal extraction pressure is achieved and a rich and bold espresso is extracted</li><br /><li>CONVENIENT &amp; EVOLUTIVE - Minipresso doesn't require compressed air, N2O cartridges or electricity for its operation. Hand operated, you are free to prepare coffee drinks that you love</li><br /></ul><br /><p>Minipresso NS is your best choice to quickly and efficiently enjoy delicious espresso wherever you are. Compatible with Nespresso* capsules, in which the coffee is ground, measured, tamped with high precision, there is very little left for error. Your espresso looks great and taste fantastic every time.</p>
7779 <ul><li>MASSIVE POWER - Built around a newly patented pumping system, the Nanopresso is capable of reaching, with the h elp of your hands, a maximum of 18 bars (261 PSI) of pressure</li><li>THE SMALLEST - Nanopresso's ergonomic design and shorter length makes it easy to hold and easy to pack</li><li>EVEN LIGHTER At just 336 grams, Nanopresso is engineered to be extremely light</li><li>EASY CLEANING - After each shot, Nanopresso maintenance takes only few seconds</li></ul><p><br /></p><p>Packed with new features and capabilities, which will drastically improve the way you prepare your favorite coffee, Nanopresso is one of the best and most versatile espresso machines. A truly unique addition to your coffee toolkit!</p>
7797 <br /><ul><li><ul><li>MASSIVE POWER - Built around a newly patented pumping system, the Nanopresso is capable of reaching, with the help of your hands, a maximum of 18 bars (261 PSI) of pressure</li> </ul></li></ul><br /><ul><li><ul><li>THE SMALLEST - Nanopresso's ergonomic design and shorter length makes it easy to hold and easy to pack</li> </ul></li></ul><br /><ul><li><ul><li>EVEN LIGHTER At just 336 grams, Nanopresso is engineered to be extremely light</li> </ul></li></ul><br /><ul><li><ul><li>EASY CLEANING - After each shot, Nanopresso maintenance takes only few seconds</li> </ul></li></ul><br /><br />Package includes:- Nanopresso for Ground Coffee<br />- Adapter for NS Capsules<br />- Protective case<br />- Built-in espresso cup<br />- Filter basket<br />- Scoop & Brush<br />- Multi-language instruction book and two stickers<br />Packed with new features and capabilities, which will drastically improve the way you prepare your favorite coffee, Nanopresso is one of the best and most versatile espresso machines. A truly unique addition to your coffee toolkit!
7798
9966 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Elevates iMac or external display to your optimal viewing height up to 93 mm 3 3 point 66 in</span></li> <li><span class="a-list-item">Creates hidden desktop storage for hard drives hubs or personal items</span></li> <li><span class="a-list-item">Features a reversible walnut aluminum front plate and padded leather top</span></li> <li><span class="a-list-item">Internal shelf adusts to four different screen height options</span></li> <li><span class="a-list-item">Works with all iMacs and most displays</span></li> <li><span class="a-list-item">Displays fit up to maximum base depth of 235 mm 9 point 25 in and max base witdth of 235 mm 9 point 25 in</span></li> </ul>
9967 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Genuine leather case for Apple Pencil</span></li> <li><span class="a-list-item">Magnetically attaches to most iPad cases</span></li> <li><span class="a-list-item">Helps transport and protect Apple Pencil with your iPad</span></li> <li><span class="a-list-item">Compatible with Apple Smart Cover, Apple Smart Keyboard and Twelve South Surface Pad for iPad Pro</span></li> </ul>
9968 <ul><li><span>A built-in typing/sketching angle protects your wrists for long sessions on iPad</span></li> <li><span>An incorporated display stand allows you to show your work anywhere</span></li> <li><span>Hardback covers, crush resistant spine and a soft interior lining keep iPad safe wherever you go</span></li> <li><span>iPad Pro and 2018 versions include Apple Pencil storage in the spine</span></li> </ul><p><span>BookBook for iPad is a gorgeous leather case designed to fit the family of iPads like a glove. Each BookBook is a handmade, one-of-a-kind, hardback leather case designed to protect and enhance your iPad experience.</span></p>
9969 <ul><li><span>Vintage style leather portfolio case for iPad Pro 12.9</span></li> <li><span>Unique book design protects and disguises iPad for added security</span></li> <li><span>Integrated kickstand angles iPad for comfortable sketching and typing</span></li> <li><span>Converts to adjustable display and movie watching stand</span></li> <li><span>Interior pocket stores Apple Pencil or iPad stylus inside spine</span></li> </ul>
9970 <ul><li><span>Allows wireless headphones to connect to wired headphone jacks</span></li> <li><span>Use to pair AirPods with airline in-flight entertainment systems</span></li> <li><span>Listen to your health club’s TVs with your wireless sport headphones</span></li> <li><span>Built-in battery lasts up to 8 hours & recharges via USB</span></li> </ul><p><span>Wish you could listen to in-flight TV with your AirPods? Want to hear the gym cardio machine's TV audio with your wireless headphones? Now you can, thanks to AirFly - a tiny device that connects wireless headphones to wired-audio jacks on planes, in fitness centers and anywhere else wired headphones were previously required.</span></p>
9971 <p><span>Compatible with all Qi enabled smartphones iPhone Pixel Galaxy etc</span><br /><span>Works with cases up to 3mm thick and up to 6 point 5 inches tall</span><br /><span>Qi certified fast charger delivers up to 10W wireless power</span><br /><span>New Zealand pine frame holds any 5 inches x 7 inches photo</span></p> <p>Looking for a wireless phone charger that does not like another dock or charger Meet PowerPic the picture frame that wirelessly charges your phone</p> <p>PowerPic has hidden Qi charger is capable of providing up to 10 watts of fast charging power just set any Qi compatible phone inside the frame to begin charging The contemporary frame is made of New Zealand Pine and holds any 5 inches x 7 inches photo</p>
9972 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9973 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9974 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> <li>Easy to attach and hang to your car seat</li> <li>Have fun characters</li> <li>Can watch videos or play games comfortably</li> </ul>
9975 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9976 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9977 <ul><li>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9978 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9979 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">The ZENS Dual Aluminum Wireless Charger has an ultra thin design that is made from one piece high grade aluminum and it is designed to efficiently fast charge two devices simultaneously The charger supports Apple and Samsung fast charge with a maximum output of 20W 2 x 10w The charger comes with a power adapter</span></li> <li><span class="a-list-item">Charging your device wirelessly has never been easier The charging pad itself is powered via an included adapter that features ultra low standby power Charging stops when your phone reaches full charge, then resumes as battery life drops Simply place your Qi enabled device on the charger and it will begin charging</span></li> <li><span class="a-list-item">The underlying inductive technology ensures foolproof charging every time your device is placed on the charger Your phone can be freely placed and doesnt have to be locked into position A flawless performance is ensured time and again</span></li> </ul>
9980 <ul><li><span>Max total output of 20W 2 10W</span></li> <li><span>Supports Apple and Samsung Fast Charge</span></li> <li><span>Ultra thin 8mm design</span></li> <li><span>Made out of one piece high grade aluminium</span></li> <li><span>Changes two devices and an Apple Watch simultaneously</span></li> <li><span>Power adapter included EU</span></li> <li><span>MFi certified</span></li> <li><span>Qi certified</span></li> </ul>
9981 <div> <ul><li><span>Max 5W output</span></li> <li><span>4500mAh capacity (recharge your phone up to 2 times)</span></li> <li><span>Adhesive grip; keeps phone in place while charging</span></li> <li><span>Wirelessly rechargeable</span></li> <li><span>USB-C cable included</span></li> </ul></div> <p>With a sleek ultra slim design the ZENS Powerbank Wireless Charger is a fantastic space saving way to charge your smartphone everywhere at home in the office or on the go</p> <p>Designed for quick and intuitive charging this powerbank allows you to charge any compatible smartphone without the tangle of power cords</p> <p>With a strong 4500 mAh capacity this wireless charging solution fuels your mobile device and keeps it going at any place and time</p>
9982 <div>With a sleek ultra slim design the ZENS Powerbank Wireless Charger is a fantastic space saving way to charge your smartphone everywhere at home in the office or on the go</div> <ul><li> Max 5W output</li> <li>9000mAh capacity recharge your phone up to 4 times</li> <li>Wirelessly charges two devices simultaneously</li> <li>Wirelessly rechargeable</li> <li>USB C cable included</li> <li>Qi certified</li> </ul><p>Designed for quick and intuitive charging this powerbank allows you to charge any compatible smartphone without the tangle of power cords</p> <p>With a strong 4500 mAh capacity this wireless charging solution fuels your mobile device and keeps it going at any place and time</p>
9983 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">The ZENS Single Aluminum Wireless Charger has an ultra thin design that is made from one piece high-grade aluminum and it is designed to efficiently fast charge a single device The charger supports Apple and Samsung fast charge with a maximum output of 10W The charger comes with a braided USB C cable and power adapter</span></li> <li><span class="a-list-item">Charging your device wirelessly has never been easier The charging pad itself is powered via an included USB cable and adapter that features ultra low standby power Charging stops when your phone reaches full charge then resumes as battery life drops Simply place your Qi enabled device on the charger and it will begin charging</span></li> <li><span class="a-list-item">The underlying inductive technology ensures foolproof charging every time your device is placed on the charger Your phone can be freely placed and doesnt have to be locked into position A flawless performance is ensured time and again</span></li> </ul>