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 (114, 112, 116, 111, 110) 
  AND cscart_product_descriptions.lang_code = 'ru'

Query time 0.00044

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
110 <p> <p>Studio: Warner Bros.</p> <p>Screen Aspect: 4 X 3 FULL FRAME</p> <p>Media Quantity: Multi D</p> <p>Packaging Type: Slipcase - Super Slim</p> <p>Copyright:</p> <p>TM &amp; (c) Warner Bros. Entertainment Inc.</p> <p>Genre: Black Theme or Star</p> <p>Synopsis:</p> <p>Based on Alex Haley's best-selling novel about his African ancestors, Roots followed several generations in the lives of a slave family. The saga began with Kunta Kinte (LeVar Burton), a West African youth captured by slave raiders and shipped to America in the 1700s. The family's saga is depicted up until the Civil War where Kunte Kinte's grandson gained emancipation. Roots made its greatest impression on the ratings and widespread popularity it garnered. On average, 130 million - almost half the country at the time - saw all or part of the series.</p> </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>
111 <p> <p>Official Website: http://lastsamurai.warnerbros.com/</p> <p>Studio: Warner Bros.</p> <p>Theatrical Release Date: 12/04/2003</p> <p>Screen Aspect: 16 X 9 LETTERBOX</p> <p>Run Time: 154 minutes</p> <p>Special Features:</p> <p>Audio Commentary: Commentary by Edward Zwick</p> <p>Deleted Scenes: The Beheading (Behind the Beheading)</p> <p>&nbsp;</p> <p>Algren and Katsumoto</p> <p>&nbsp;</p> <p>Documentaries: History vs. Hollywood: The Last Samurai {History Channel Documentary)</p> <p>Featurette: Tom Cruise: A Warrior's Journey</p> <p>&nbsp;</p> <p>Edward Zwick: Director's Video Journal {Behind-the-scenes production journal - narrated by Ed Zwick and Tom Cruise</p> <p>&nbsp;</p> <p>A World of Detail: Production Design with Lilly Kilvert</p> <p>&nbsp;</p> <p>Silk and Armor: Costume Design with Ngila Dickson</p> <p>&nbsp;</p> <p>Imperial Army Basic Training: From Soldier to Samurai: The Weapons</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>Interviews: Making an Epic: A Conversation with Edward Zwick</p> <p>Other: Japan Premieres {Tokyo &amp; Kyoto red carpet)</p> <p>Packaging Type: Eco Amaray Case</p> <p>Subtitle Languages:</p> <p>English</p> <p>French</p> <p>Spanish</p> <p>Copyright:</p> <p>&copy; 2003 Warner Bros. Entertainment Inc. All Rights Reserved.</p> <p>Genre: Action/Adventure, Drama, Period, War, WESTERN</p> <p>Synopsis:</p> <p>Epic Action Drama. Set in Japan during the 1870s, The Last Samurai tells the story of Capt. Nathan Algren (Tom Cruise), a respected American military officer hired by the Emperor of Japan to train the country's first army in the art of modern warfare. As the Emperor attempts to eradicate the ancient Imperial Samurai warriors in preparation for more Westernized and trade-friendly government policies, Algren finds himself unexpectedly impressed and influenced by his encounters with the Samurai, which places him at the center of a struggle between two eras and two worlds, with only his own sense of honor to guide him.</p> <p>"Two Thumbs Up" - EBERT &amp; ROEPER&nbsp;</p> <p>&nbsp;</p> <p>"A stunning beautiful epic adventure" - ROGER EBERT / EBERT &amp; ROEPER&nbsp;</p> <p>&nbsp;</p> <p>"It's a spectacular epic. Tom Cruise is truly magnificent. - PAUL CLINTON / CNN&nbsp;</p> <p>&nbsp;</p> <p>"Ken Watanabe is magnetic and majestic." - LISA SCHWARZBAUM / ENTERTAINMENT WEEKLY&nbsp;</p> <p>&nbsp;</p> <p>"The Last Samurai is a movie that demands our surrender" - RICHARD SCHICKEL / TIME&nbsp;</p> <p>&nbsp;</p> <p>"Bold and daring. The battle scenes are astonishing!" - JEFFREY LYONS / NBC&nbsp;</p> <p>&nbsp;</p> <p>"The Last Samurai' is a transfixing, majestic experience." - GENE SHAL</p> </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>
112 <p> <p>Studio: Warner Bros.</p> <p>Theatrical Release Date: 12/14/1939</p> <p>Run Time: 238 minutes</p> <p>Special Features:</p> <p>Commentary by Historian Rudy Behlmer</p> <p>&nbsp;</p> <p>Mail-in poster offer</p> <p>Media Quantity: Multi D</p> <p>Packaging Type: Double Eco Amaray Case</p> <p>Copyright:</p> <p>GONE WITH THE WIND, its characters and elements are trademarks of Turner Entertainment Co. &amp; The Stephens Mitchell Trusts. &copy; Turner Entertainment Co.</p> <p>Genre: Classic, Drama, Romance</p> <p>Synopsis:</p> <p>Period romance. War epic. Family saga. Popular fiction adapted with crowd-pleasing brilliance. Star acting aglow with charisma and passion. Moviemaking craft at its height. These are sublimely joined in the words Gone with the Wind. This dynamic and durable screen entertainment of the Civil War-era South comes home with the renewed splendor of a New 70th-Anniversary Digital Transfer capturing a higher-resolution image from Restored Picture Elements than ever before possible. David O. Selznick&rsquo;s monumental production of Margaret Mitchell&rsquo;s Pulitzer Prize-winning book can now enthrall new generations of home viewers with a majestic vibrance that befits one of Hollywood&rsquo;s greatest achievements.</p> </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>
114 Birds of Prey: The Complete Series (DVD) - это полное собрание всех эпизодов популярного телесериала "Птицы Хищницы". Этот набор DVD предлагает зрителям возможность окунуться в захватывающий мир супергероев и динамичных приключений. Сериал "Птицы Хищницы" основан на комиксах DC Comics и рассказывает историю трех мощных женщин-героев: Оракула (Барбара Гордон), Черной Канарейки (Дина Лэнс) и Охотницы (Хелена Кайл). Вместе они образуют команду, которая борется с преступностью и защищает город Готэм от злодеев. Каждый эпизод сериала полон экшена, интриги и эмоциональных поворотов. Зрители будут в восторге от захватывающих сцен боя, впечатляющих спецэффектов и умных диалогов. Команда "Птицы Хищницы" сталкивается с различными противниками, включая знаменитых злодеев из вселенной Бэтмена, таких как Джокер, Пингвин и Китайская Кошка. Набор DVD "Birds of Prey: The Complete Series" включает все 13 эпизодов первого и единственного сезона сериала. Кроме того, он содержит эксклюзивные бонусные материалы, такие как интервью с актерами, за кулисами съемок и комментарии создателей сериала. Это позволяет зрителям получить углубленное понимание процесса создания сериала и узнать больше о любимых персонажах. Набор DVD "Birds of Prey: The Complete Series" - это идеальный выбор для поклонников супергеройских приключений, комиксов DC и фанатов сериала. Он предлагает возможность пережить все эмоции и волнение сериала снова и снова, а также насладиться эксклюзивным контентом, недоступным в эфире. птицы хищники, сериал, DVD, полный набор, диск, коллекционное издание Поиск по словам: "Птицы хищники: Полный сборник серий (DVD)" <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>
116 <p> <p>fficial Website: <a title="http://iamlegend.warnerbros.com/" href="http://iamlegend.warnerbros.com/">http://iamlegend.warnerbros.com/</a></p> <p>Studio: Warner Bros.</p> <p>Theatrical Release Date: 12/13/2007</p> <p>Screen Aspect: 16 X 9 LETTERBOX</p> <p>Special Features:</p> <p>4 awesome animated comics: Death as a gift, Isolation, Sacrificing the Few for the Many and Shelter</p> <p>DVD-ROM PC weblink to intense bonus material databanki chronicling the movie's creation and exploring the history and current status</p> <p>of life-threatening viral infections</p> <p>Packaging Type: Amaray Case</p> <p>Copyright:</p> <p>(c) 2007 A Warner Bros. Entertainment Inc. All Rights Reserved</p> <p>Genre: Action/Adventure, Drama, Horror, Sci-Fi/Fantasy</p> <p>Synopsis:</p> <p>Robert Neville is a brilliant scientist, but even he could not contain the terrible virus that was unstoppable, incurable, and man-made. Somehow immune, Neville is now the last human survivor in what is left of New York City and maybe the world. For three years, Neville has faithfully sent out daily radio messages, desperate to find any other survivors who might be out there. But he is not alone. Mutant victims of the plague -- The Infected -- lurk in the shadows... watching Neville's every move... waiting for him to make a fatal mistake. Perhaps mankind's last, best hope, Neville is driven by only one remaining mission: to find a way to reverse the effects of the virus using his own immune blood. But he knows he is outnumbered... and quickly running out of time.</p> <p>"I Am Legend is mind-blowing excitement..." Pete Hammond / Maxim</p> </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>