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.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (192, 195, 196, 204, 194) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00027

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 5 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
192 <p><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">Tracklisting:</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">1. Black And White America</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">2. Come On Get It</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">3. In The Black</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">4. Liquid Jesus</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">5. Rock Star City Life</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">6. Boongie Drop</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">7. Stand</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">8. Superlove</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">9. Everything</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">10. I Can't Be Without You</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">11. Looking Back On Love</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">12. Life Ain't Ever Been Better Than It Is Now</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">13. The Faith Of A Child</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">14. Sunflower</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">15. Dream</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">16. Push</span></p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
194 <p><span style="color: #000000; font-family: Arial, Geneva, 'sans serif'; text-align: left; background-color: #ffffff;">U218 Singles is the first single-disc collection - including 16 of their best-known songs. Also included are two brand-new tracks recorded with producer Rick Rubin at Abbey Road Studios in London: "The Saints Are Coming" (with Green Day) and "Window in the Skies."</span></p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
195 <p><p>2DVD edition of the 2010 Crossroads Guitar Festival. Featuring: Eric Clapton, Jeff Beck,Sheryl Crow,Vince Gill, Buddy Guy, B.B. King,John Mayer, Bill Murray,Steve Winwood,Ronnie Wood, ZZ Top,and more PLUS behind-the-scenes footage and interviews.</p><p>&nbsp;</p><p>DVD 1</p><p>&nbsp;</p><p>01 Promise Land - By Sonny Landreth with Eric Clapton</p><p>02 Z. Rider - By Sonny Landreth with Eric Clapton</p><p>03 Traveling Shoes - By Robert Randolph &amp; The Family Band</p><p>04 Going Down - By Pino Daniele, Joe Bonamassa, Robert Randolph &amp; The Family Band</p><p>05 Killing Floor - By Robert Cray with Jimmie Vaughan &amp; Hubert Sumlin</p><p>06 Six Strings Down - By Jimmie Vaughan with Robert Cray &amp; Hubert Sumlin</p><p>07 Waiting For The Bus - By ZZ Top</p><p>08 Jesus Just Left Chicago - By ZZ Top</p><p>09 Gypsy Blood - By Doyle Bramhall II</p><p>10 In My Time Of Dying (Jesus Make Up My Dying Bed) - By Doyle Bramhall II</p><p>11 Bright Lights - By Gary Clark Jr.</p><p>12 Long Road Home - By Sheryl Crow with Derek Trucks, Susan Tedeschi, Doyle Bramhall II &amp; Gary Clark Jr.</p><p>13 Our Love Is Fading - By Sheryl Crow with Eric Clapton, Doyle Bramhall II &amp; Gary Clark Jr.</p><p>14 Blackwaterside - By Bert Jansch</p><p>15 Mississippi Blues - By Stefan Grossman &amp; Keb' Mo'</p><p>16 Roll And Tumble Blues - By Stefan Grossman</p><p>17 One More Last Chance - By Vince Gill with Keb' Mo', James Burton, Earl Klugh &amp; Albert Lee</p><p>18 Mystery Train - By Vince Gill with James Burton, Albert Lee, Keb' Mo' &amp; Earl Klugh</p><p>19 Lay Down Sally - By Vince Gill with Sheryl Crow, Keb' Mo', Albert Lee, James Burton &amp; Earl Klugh</p><p>20 Angelina - By Earl Klugh</p><p>21 Vonetta - By Earl Klugh</p><p>22 Who Did You Think I Was - By John Mayer Trio</p><p>23 Ain't No Sunshine - By John Mayer Trio</p><p>&nbsp;</p><p>DVD 2</p><p>&nbsp;</p><p>01 Midnight In Harlem - By Derek Trucks &amp; Susan Tedeschi Band</p><p>02 Coming Home - By Derek Trucks &amp; Susan Tedeschi Band with Warren Haynes</p><p>03 Soulshine - By Warren Haynes</p><p>04 Don't Keep Me Wondering - By David Hidalgo &amp; Cesar Rosas with Derek Trucks</p><p>05 Space Captain - By Derek Trucks &amp; Susan Tedeschi Band with Warren Haynes, David Hidalgo, Cesar Rosas &amp; Chris Stainton</p><p>06 Five Long Years - By Buddy Guy with Jonny Lang &amp; Ronnie Wood</p><p>07 Miss You - By Buddy Guy with Jonny Lang &amp; Ronnie Wood</p><p>08 Hammerhead - By Jeff Beck</p><p>09 Nessun Dorma - By Jeff Beck</p><p>10 Crossroads</p><p>11 Hands Of The Saints - By Citizen Cope &amp; Eric Clapton</p><p>12 I Shot The Sheriff</p><p>13 Shake Your Money Maker - By Eric Clapton &amp; Jeff Beck</p><p>14 Had To Cry Today - By Steve Winwood &amp; Eric Clapton</p><p>15 Voodoo Chile - By Eric Clapton &amp; Steve Winwood</p><p>16 Dear Mr. Fantasy - By Steve Winwood &amp; Eric Clapton</p><p>17 The Thrill Is Gone - By B.B. King &amp; Ensemble</p><div></div></p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
196 <p>&nbsp;</p><p>Official Release #90&nbsp;</p><p>Released: 22 September 2011</p><p>Label: Zappa Records&nbsp;</p><p>Catalog Number: ZR 20012</p><p>Produced/Composed/Arranged by Frank Zappa</p><p>CD Compilation by Gail Zappa &amp; Joe Travers</p><p>Tracklisting:</p><p>&nbsp;</p><p>01. Feeding The Monkies at Ma Maison 20:12</p><p>02. Buffalo Voice 11:34</p><p>03. Secular Humaism 6:37</p><p>04. Worms From Hell 5:31</p><p>05. Samba Funk 11:29</p><p>&nbsp;</p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
204 <p><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">Collecting The Police's drummer's solo work on one CD.&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">Track Listing:</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">1. Too Kool To Kalypso&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">2. Don't Box Me In</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">3. Tulsa Tango</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">4. Koteja&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">5. Serengeti Long Walk</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">6. Equalizer Main Title</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">7. Anacott Steel</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">8. Slither</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">9. Night Drive&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">10. Taxi Ride Home</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">11. Bill Is Dead</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">12. Wield the Spade&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">13. Look Up&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">14. Rain</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">15. Childhood Friends</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">16. Mud Lions&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">17. Pizica Degli Ucci</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">18. Chrystal/Drive Daisy/End Title</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">19. George Trip/End Montage/End Title</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">20. Big Drum Tribe&nbsp;</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">21. Regret</span><br style="color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #000000;" /><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; text-align: left; background-color: #ffffff; color: #000000;">(5OCD09)</span></p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>