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 (
    14465, 14466, 14467, 14468, 14469, 14470, 
    14471, 14472, 14473, 14474, 14475, 
    14476, 14477, 14478, 14479, 14480
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.41"
    },
    "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": 16,
      "rows_produced_per_join": 16,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (14465,14466,14467,14468,14469,14470,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "35.21",
        "eval_cost": "3.20",
        "prefix_cost": "38.41",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
14465 <ul><li>Once you have purchased the item, we will ship the product on that day or day after.</li><li> US shipping will take 8-15 business days, while international shipping requires up to 20-25 business.</li></ul>
14466 <ul><li>The 62mm-82mm ring adapter easily screws onto the front of any 62mm lens, and converts the thread size of your lens to the thread size of any other 82mm accessory (such as filters, hoods, flashes and lens converters).</li> </ul>
14467 <p>Specification This reverse adapter ring allows you to mount a specific front threaded lens in reverse on any specific SLR camera. Reversing the lens greatly increases the macro reproduction capabilities Return Policy We offer a 14-day Money Back Guarantee excluding your original shipping and handling charges Contact us for a return authorization and shipping instructions. Buyer pays the return shipping cost.Please keep the product in original package. For item at free shipping, an actual shipping fee will be deducted from the final refund.</p>
14468 <ul><li>Introduction: This high quality automatic macro Extension Tube Set is designed to enable a lens to focus closer than its normal set minimum focusing distance. Getting closer has the effect of magnifying your subject (making it appear larger in the viewfinder and in your pictures). </li><li>They are exceptionally useful for macro photography, enabling you to convert almost any lens into a macro lens at a fraction of the cost while maintaining its original optical quality. The DG extension tubes have no optics.</li><li> They are mounted in between the camera body and lens to create more distance between the lens and film plane. By moving the lens father away from the film or CCD sensor in the camera, the lens is forced to focus much closer than normal. </li><li>The greater the length of the extension tube, the closer the lens can focus. It comes as a set (10mm+16mm). It contains 2pcs tubes in different length 10mm/16mm, which can be used in any combination or individually to obtain the different magnification. Designed with electronic contacts,which make it support automatic focusing,automatic exposure,etc. It enables you to use all shooting modes of the camera,exposure compensation is required Specification: Diameter of the tubes: Approx. 62mm Tube length: 10mm,16mm Material: Built in Metal Bayonet & Plastic Body Compatible camera: All Canon EOS EF-M mount camera Such as Canon EOS M M2 M3 M5 M6 M10 M50 M100 etc. Package included: 1× Extension tube 10mm +16mm set</li></ul>
14469 <ul><li>This is the perfect replacement cap that is a direct fit to the Sony 16-50mm OSS lens. </li><li>It comes with a sturdy strap to attach it to your camera to prevent loss. </li><li>This cap is specifically size for the 16-50mm OSS lens it will not fit any other Sony lenses.</li></ul>
14470 <ul><li>Slip-On lens cap, made of flexible plastic, black. Diameters are the inside dimensions of the lens cap. </li><li>This corresponds with the outside diameter of the lens (or filter) which is covered with the lens cap.</li></ul>
14471 <ul><li>You cannot see most astronomical objects with your naked eye.</li><li> Looking through the finder scope gives you 18X more light, allowing many astronomical objects to become visible to your eye. </li><li>The 6x30 finder scope has a small 30mm aperture objective and 6X magnification</li><li> an extremely useful little telescope.The Astromania finder scope gives you a wide field of view to make locating objects that much easier. Imagine you have the telescope roughly, not yet precisely, pointed at object. The large field of view means you can already see the object at the edge of the image. </li><li>The built-in crosshairs now come to your aid. They let you move the object exactly into the centre of the image which means it is also already accurately centred in the main telescope.</li></ul>
14472 <ul><li>The iGadgitz small flexible mini tripod lets you position your camera almost anywhere to help you capture the perfect shot. Completely flexible and versatile, it simply & securely fastens to your camera in seconds.</li><li>Featuring flexible leg joints that bend and rotate in all directions so you can wrap it securely to or on just about anything. Wrap it around poles, posts, railings, branches, rocks and much more.</li><li>Rubber feet grips provide enhanced stability on uneven surfaces. The tripod fits easily in your camera bag without adding noticeable weight - it weighs just 68g with height of 17.5cm only!</li><li>Whether you're taking a shot of you and your friends whilst camping or lining up the next landscape whilst walking, you'll be happy you have this handy little tripod close at hand.</li></ul>
14473 <ul><li><strong></strong></li><li>You can wired charger 2 Devices and 1 wireless charge simultaneously.</li><li>For wireless charging, your mobile device must be equipped with a Qi wireless receiver.</li><li>Qi Charger with 20000 mAh Battery</li><li>Integrates a Qi wireless charging transmitter and a slim, large-capacity rechargeable battery.</li><li><strong>Qi Compatible</strong></li><li>Supports Qi wireless charging standard v1.1 and v1.0, and can charge at up to 1A (5 W) for devices including (but not limited to):</li><li>- Samsung Galaxy Note 8/S8/S7/S6/S8+/S7 Edge</li><li>- Google Nexus 5/6/7</li><li>- HTC Droid DNA, 8X</li><li>- LG G6/G5/G4, Lucid</li><li>- iPhone 8/8 Plus/X</li><li>- iPhone 7/7 Plus/6(s)/6(s) Plus with wireless charging case</li><li><strong>Faster Wired Charging and Recharging</strong></li><li>Featuring QualComm QuickCharge 3.0 input and output, can rapidly charge QC-compatible Android phones on the go.?PD charger is not supported?</li><li><strong>Versatile</strong></li><li>Can charge up to three Android or iOS devices simultaneously via Qi wireless and USB ports at 5V. Supports adaptive pass-through mode for charging up to two mobile devices and itself.</li><li>USB Output: DC 5V 2.1A</li><li>Wireless Charger Output: DC 5V 1A</li><li>Wireless Charging Distance: no more than 8mm</li><li>Dimensions: 170*80*24mm</li></ul>
14474 <ul><li>Handcrafted in Spain by leather artisans, Piel frama phone cases are renowned worldwide for their exquisite quality and workmanship. Piel frama uses only the finest locally-sourced materials, eco-friendly manufacturing techniques and careful attention to Detail. The result is a soft, supple leather Product that is extremely durable, ergonomic and that has a minimal impact on the environment. </li><li>A superior leather goods manufacturer since 1945, Piel frama made their first mobile phone case in 1984, the same Year modern cell phones were introduced. The pioneering case Maker uses natural and biodegradable products to tan and finish the full-grain leather materials, as well as in its glues. Every case is carefully cut, assembled and sewn by hand. If you desire the look and feel of luxury in handmade Spanish leather, a Piel frama case is the ultimate Product for you. More than just lasting protection for your technology investment, these cases are truly a work of art.</li></ul>
14475 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">COVER EVERY CORNER: Most of our customers have this camera set up and running in five minutes or less. 340° degree rotation and 95° degree tilt capabilities. The 110° wide-angle lens records distortion-free. Auto-Cruise mode continually surveys the area and you also have the option to select up to 8 locations for it to cruise to.</span></li><li><span class="a-list-item">BEST IN CLASS IMAGE QUALITY & NIGHT VISION: State-of-the-art Wide Dynamic Range (WDR) capabilities won’t let you down in case of sudden lighting changes that would normally contribute to poor overall image quality. Eight infrared pearls at a wavelength of 940nm capture detailed videos at night.</span></li><li><span class="a-list-item">LET THE LENS DISAPPEAR + FUN TIME-LAPSE: The YI Dome Camera X’s unique eyelid design lets the lens disappear in its casing when turned off or switched to Privacy Mode. Compress up to 6 hours of continuous recording into short clips between 5-30 seconds.</span></li><li><span class="a-list-item">IMPORTANT ALERTS ONLY + STAY CONNECTED: Differentiates humans and pets from moving objects, resulting in more relevant alerts for you. Its abnormal sound detection will alert you of noises such as a baby crying. Paired with its and two-way audio-feature, t</span></li></ul>
14476 <p>Wii to HDMI, a converter for the Wii console, has video and audio outputs in digital HDMI 480p format. It is great to converts your Wii to your HDTV / monitor with this Wii to HDMI Converter. Use one HDMI cable (not included), plug and play for true-to-life video/audio effects on your TV/monitor.Description:HDMI upscale to 480p high definition outputProvides advanced signal processing with great precision, colors, resolutionsHigh quality, state of the art motion adaptive de-interlacing for 480i, 576i input.No power adaptor, no messy cords - just one HDMI cable (not included)Power Consumption: Below 2WSupported Video Input Mode: Includes all the display modes of the Wii console (480i, 480p, 576i)Input Interface: Wii AV Multi Out PlugOutput Interface: HDMI ConnectorAudio Jack: 3.5mm stereo audio jackSize (L x W x H): Approx. 2.5 x 1.35 x 0.6 inch / 63 x 34 x 15mmPackage Includes:1 x Wii2 HDMI ConverterNOTE: Being a member of HDCP Protocol, the products have been approved by HDCP Protocol.</p>
14477 <ul><li>PES 2008 takes soccer to the next level. The game features a brand new intelligence system, called Teamvision, that adapts and reacts to players own gameplay styles to ensure that the computer controlled opponents are always challenging and forcing the player to think and chance their style of play to avoid being out-thought by the game. It learns counter attacks that target your weaknesses and looks to exploit any repetitive tactics players use.</li><li>Meanwhile in PES 2008 defenders react better to danger, closing down the ball and charging at shots and the goalkeepers will hold shots that are closer to them as well.</li><li>Teammates make more intelligent runs into space and the close control has been sharpened to ensure quick and fluid passing and speedy attacks can be built.</li></ul>
14478 <p>The Settlers: Rise Of An Empire (PC DVD)</p>
14479 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">SHOW YOUR COMMITMENT TO THE CAUSE WITH THE REVOLUTIONARY SPIRIT PACK! Strike fear into the hearts of the KPA with the Red Skull motorbike skin and Golden Pistol skin in Campaign, and give your Co-Op character a head-start in Resistance Mode with instant unlocks of the Marksman Rifle, Sniper Scope and Remote Explosives.</span></li><li><span class="a-list-item">Wage Guerrilla Warfare - this is no linear shooter; learn the art of guerrilla warfare and use ambush, infiltration and hit and run tactics against your foe in thrilling un-scripted firefights</span></li><li><span class="a-list-item">Build the Resistance - recruit revolutionaries to the cause, establish bases and safehouses, capture and customise a deadly arsenal, and build improvised, homebrew weapons for your Guerrilla Tool Kit</span></li><li><span class="a-list-item">Ignite the Revolution - from oppressed citizen to revolutionary leader, an epic single-player campaign tells the story of the second War of Independence. The dynamic, evolving world responds to your actions as an oppressed nation rises up in defiance against the occupation</span></li><li><span class="a-list-item">Online Co-OP - Form a Resistance Cell with your friends online, and wage guerrilla warfare against the military might of the KPA in thrilling narrative-driven Missions across occupied Philadelphia. Unlock new skills, earn weapon blueprints, rare equipment and combat gear to upgrade and customise your personal roster of Freedom Fighters, as you and your teammates go from rookie civilians to battle hardened soldiers.</span></li></ul>
14480 <ul><li>The Age of Kings and Age of Empires II: The Conquerors Expansion Pack together into one compelling package, including bonus content: a random map compilation plus 3 recorded games to learn from the masters!In Age of Empires II The Age of Kings - sequel to the award-winning Age of Empires - you have 1000 years to lead your people through the Middle Ages to greatness. Control one of the most powerful civilizations of the time. Decide whether to conquer the world through military might, rule through commerce and diplomacy, or seize power by means of intrigue and regicide.</li><li> There are many paths to power but only one civilization will reign supreme.</li><li>Choose the path to greatness - Will it be an economic path created out of craftsmanship, trade, and technology? Or a military route of siege and naval warfare? Command one of 13 civilizations - Including the Franks, Japanese, Byzantines, Vikings, Mongols, and Celts. </li><li>Each has unique attributes, units, buildings, and technologies based on its historical counterpart. Battle alongside heroes of the day - Who will fight for victory under your flag? With historically-based campaigns it could be Joan of Arc, William Wallace, Genghis Khan, Saladin, or Barbarossa. Conquer a worthy opponent over the MSN GamingZone, LAN or modem. Or a nearly human artificial intelligence opponent in single player mode. New and bigger lands - With the random map generator you will always have new lands to explore and conquer, no matter how many times you play. Create your own scenarios - The Map Editor allows you to build your own massive campaigns. Lead swiftly and with ease - Production queues, gathering points and customizable hotkeys make it fast and simple to manage your forces and plan battles. New Heroes to Discover. New Worlds to Conquer. Created by the developers of the Award-Winning best selling strategy game, Age o</li></ul>