SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    129, 130, 131, 132, 133, 134, 135, 136, 
    137, 138, 139, 140
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.41"
    },
    "table": {
      "table_name": "cscart_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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "index_condition": "((`demouniformecomd_db`.`cscart_product_descriptions`.`product_id` in (129,130,131,132,133,134,135,136,137,138,139,140)) and (`demouniformecomd_db`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "7.21",
        "eval_cost": "1.20",
        "prefix_cost": "8.41",
        "data_read_per_join": "54K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description unit_name
129 <p>Take your riding to the next level with the For&eacute; CR1 full carbon road bike, built to be extremely durable and responsive. Feel the adrenalin rush as it accelerates smoothly and corners aggressively. Great for cross-country riding, a triathlon, and even a race.&nbsp; The new Fezzari Fore CR1 is the newest bike to the Fezzari carbon road bike family.&nbsp; It has the same tried and true monocoque carbon frame as the&nbsp; Fore CR2, but is built with a Shimano 105/Ultegra groupo to help save a little on the price.</p> <p>Start with a proprietary Fezzari Racing Design Xr4 monocoque carbon frame that was recently tested as one of the most durable frames on the market.</p> <p>All this translates into exhilaration when you&rsquo;re climbing &ndash; knowing that you&rsquo;re ascending more efficiently &ndash; and confidence on the downhill when you take that corner at high speeds. Our proprietrary frame painting process give one of the best looking finishes available.</p> <p>You get e&nbsp; upgrades over the Catania:</p> <ol> <li> <strong>Upgraded Frame</strong> &ndash; the CR1 has a full monocoque carbon frame vs the Catania&rsquo;s aluminum alloy frame. The carbon frame is lighter and will absorb more of the road chatter when riding.</li> <li> <strong>Upgraded Seatpost</strong> &ndash; the larger diameter 31.6mm seatpost is stiffer and lighter.</li> <li> <strong>Upgraded Wheels</strong> &ndash; The CR1 gets a lighter and more aero dynamic wheel whith looks to go with it.</li> </ol> <p>Who will want this bike? If you&rsquo;ve been biking and plan to get into it more, and you want to get something that will grow with you as you grow in the sport (but you&rsquo;re not willing to pay the price of a CR3 or CR5), then this is the bike for you. It gets you on a full monocoque carbon fiber frame and still gives you the confidence you won't miss a shift with the Shimano 105/Ultegra drivetrain. You&rsquo;ll have the confidence that you can ride with anyone, anytime.</p>
130 <table class="defTBL" style="word-wrap: break-word; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; line-height: 18px; text-align: left; background-color: #ffffff;" width="79%"> <thead style="word-wrap: break-word;"> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">DR-210TM Technical Specifications</strong></div> </th> </tr> </thead> <tbody style="word-wrap: break-word;"> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Display</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Digits</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">12</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Digitron</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Special</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Large Display</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Printer</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Speed - lines/second</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">4.4</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Print Color</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">2 Color-Black/Red</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Ribbon</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Ink Ribbon</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">RB-02</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Features</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Decimal Selector</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Floating or fixed decimal 0,1,2,3,4,6</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Item Counter</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Independent Memory</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Printing Reference Numbers</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Tax Calculation</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Automatic Constants</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Independent Add Register</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Grand Total</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">MU/MD</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Feed</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Right Shift Key</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Round Off</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Round Up</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Cut Off</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">ADD Mode</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Cost/Sell/Margin</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Paper</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">2-1/4 inch plain</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Power</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">AC</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Unit Dimensions</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Size (inches)&nbsp; H x W x L</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">4-3/10" x 8-2/5" x 15"</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Weight oz/lbs</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">3.7 lbs</div> </td> </tr> </tbody> </table> <p> <p style="word-wrap: break-word; margin-top: 10px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; line-height: 1.25em; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;">Technical Specifications Subject to Change</p> </p>
131 <p class="MsoPlainText">The new Catania features carbon fork, carbon seatpost, Ultegra derailleur, and the new Fezzari Racing Design R3A frame with increased aerodynamic properties and a sleeker look.</p> <p class="MsoPlainText">The Catania road bike is a great all-around bike. If you want to get into road biking or want a bike that is durable, high-performing, and as comfortable as a road bike can get, the Catania is for you.</p> <p class="MsoPlainText">The Catania features the R3A frame with compact geometry. Compact geometry means that we shorten the seat tube slightly, which makes the bike a little lighter and reduces lateral flex (you don&rsquo;t want your bike flexing side to side when you&rsquo;re pedaling). It also allows your riding position to be a little more upright.</p> <p class="MsoPlainText">Add to that a great set of components, including: Shimano Ultegra derailleur and Shimano 105 shifters for smooth shifting Fezzari Carbon II fork to minimize the road chatter; FSA Gossamer crank with external oversized bearings that make it pedal smoother and more efficiently; Alex double-wall rims that are extremely durable; Maxxis performance tires; and a Fezzari Racing Design Ultra XR saddle that is one of the most comfortable road saddles you&rsquo;ll ride.</p>
132 <p>Easily connect via Wi-Fi without any monthly service fees. The Samsung Galaxy Player can access the internet and apps anywhere there is an available hotspot. The sleek, lightweight 6.42 oz. design fits in any pocket and the brilliant 5&rdquo; LCD delivers incredible viewing quality.</p>
133 <p>Easily connect via Wi-Fi without any monthly service fees. The Samsung Galaxy Player can access the internet and apps anywhere there is an available hotspot. The sleek, lightweight 4.27 oz. design fits in any pocket and the brilliant 4&rdquo; Super Clear LCD delivers incredible viewing quality.</p>
134 <p>Don't let the compact appearance of the Creative ZEN Style M300 MP3 player fool you. For a media player this tiny, you&rsquo;d be amazed at the array of features it can offer for a remarkably affordable price.</p>
135 <p>The ZEN line of portable media players has long been associated with the highest quality in audio playback, and the Creative ZEN Touch 2 continues to uphold this standard. But that's not all it offers. What makes this player truly stand out from the rest is that you can stream music wirelessly to compatible Bluetooth&reg; headphones or speakers such as Creative's ZiiSound D5 and WP-300, and surf the Internet too.</p>
136 <p> <p>The Time of the AZURE is Here!</p> <p>&nbsp;</p> <p>Aksys Games, a publisher of interactive entertainment software, is proud to announce that the next installment in the hit fighting game series BlazBlue, BlazBlue: Continuum Shift EXTEND, will be coming to North America as a PlayStation&reg;Vita launch title! With the devious, all new playable character Relius Clover, new story scenarios, new gameplay modes, and competitively balanced action, BlazBlue: Continuum Shift EXTEND makes a grand return to home consoles and the new frontier!</p> <p>BlazBlue: Continuum Shift EXTEND Key Features:</p> <p>&nbsp;</p> <p>Enhanced Story Mode: Relive and rediscover the events that took place in BlazBlue: Calamity Trigger or venture forth into one of four all new story scenarios!</p> <p>New and Revised Game Modes to Explore: Take on the strongest of foes in Unlimited Mars Mode, dungeoneer your way to the bottom of Abyss Mode, or lead an army to victory in Legion Mode!</p> <p>Fully Revised Combat System: All characters, new and old, have been thoroughly rebalanced and armed with all new strategies and combos to take your game to the top!</p> <p>Improved Online Multiplayer: Battle it out in BlazBlue&rsquo;s acclaimed online mode with all new multiplayer features, such as online team battles!</p> <p>SHIP DATE: February 14, 2012</p> <p>GENRE: Fighting</p> <p>PLAYER(S): 1 Local, 2-6 Online</p> </p>
137 <p> <p>he ULTIMATE heroes from Marvel and Capcom collide again in Ultimate Marvel vs. Capcom 3. Every epic character from the original blockbuster returns to the fray alongside 12 new fighters,&nbsp;</p> <p>8 over-the-top new stages and enhanced gameplay.</p> <p>COMING SOON: Ultimate Marvel Vs. Capcom 3 for PlayStation&reg;Vita system! It's the full console experience packed with 50 legendary characters*, local and Wi-Fi multiplayer, touch panel controls, and exclusive new features.</p> <p>UNLEASH YOUR ULTIMATE</p> <p>ANYTIME, ANYWHERE</p> <p>LAUNCHING with the PlayStation&reg;Vita system on 2/22/12&nbsp;</p> <p>OUT NOW on Xbox 360 and PlayStation&reg;3 system</p> </p>
138 <p> <p>BEAUTY &amp; HIGH SPEED DRIFTING AROUND THE WORLD!</p> <p>The high-octane racing franchise drifts onto the PlayStation&reg;Vita delivering stunning graphics and heart-pounding action that players can truly feel. Ridge Racer&reg; features high-speed action, high-performance racing machines, and all-new gameplay additions creating an edge-of-your-seat experience only possible on the PlayStation&reg;Vita. Racing fans can also take the action online and tear up the track against players from around the globe using the PlayStation&reg;Vita &ldquo;near&rdquo; and Wi-Fi functionality and race against other players&rsquo; ghosts anywhere at anytime.</p> <p> <p>Vivid, next generation high-contrast graphics and advanced lighting effects powered by the PlayStation&reg;Vita painting processor</p> <p>An immersive audio experience with a dynamic soundscape that changes and evolves with each race according to the movement of your machine.</p> <p>All-new custom drift system enables players to tune the action to suit their style of driving. All new "Machine Upgrade Map" customization allows players to upgrade functional parts and create their own original machines</p> <p>New introduction of the Planetary League allows players to join in one of four racing teams and race against other players from around the world both at real-time and "anywhere at any time" by exchanging ghosts via "near" functionality.</p> <p>Compete against up to 7 other players from around the world with online (ad-hoc, Wi-Fi) multiplayer.</p> </p> </p>
139 <p> <p>Shinobido 2: Revenge of Zen is the sequel to Shinobido: Way of the Ninja, featuring the series&rsquo; trademark stealth action gameplay with the addition of new stylish assassin moves and a dynamic storyline. Developed by Acquire, the story is set six months after the events of the previous opus, with the Utakata region once again at the center of the storm and embroiled in a civil war involving the mysterious Magic Mirror. Players will take the role of Zen, a man who has suffered betrayal at the hands of his companions and the loss of his home. Saved by the Asuka clan of Utakata, Zen makes up his mind to live as an assassin and begins a perilous journey in search of revenge.</p> <p>Dynamic Storyline: Interact with three factions with different choices affecting the power balance between the factions and resulting in diverging storylines.</p> <p>Stealth action gameplay for a master assassin: Employ a variety of deadly finishing moves which vary according to the location. Activate the Zankoku for bullet-time action and use the Ninja Flying ability to freely explore environments.</p> <p>New &lsquo;near&rsquo; network features: Boost your inventory by receiving gift items from other players using the PlayStation&reg;Vita near feature.</p> <p>Original PS Vita rear touch panel gameplay features: &nbsp;Use the rear touch panel to change to a first person view and launch long range weapons at enemies.</p> </p>
140 <p>This easy-to-carry, powerful speaker system frees your iPod/iPhone music for your active lifestyle. Enjoy your entire content library whenever you want, wherever you go.</p>