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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    4150, 4151, 4050, 3930, 4189, 4037, 4038, 
    4039, 4040, 4025, 4119, 4126, 4127, 
    4072, 4145, 4146, 4147, 4060, 3974, 
    4041, 4103, 4148, 4102, 4366, 4064, 
    4062, 4101, 4063, 4074, 4075
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4150,4151,4050,3930,4189,4037,4038,4039,4040,4025,4119,4126,4127,4072,4145,4146,4147,4060,3974,4041,4103,4148,4102,4366,4064,4062,4101,4063,4074,4075)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
3930 <ul><li>Thunderstorm - 5 way adjustable wrap bracelets - adjustable with a stainless steel signature button on genuine leather</li><li>Approximate dimensions (wrapped): 9cm x 3cm x 3cm</li><li>Our african thunderstorms are the inspiration behind this gorgeous deep blue and smokey grey wrap bracelet</li><li>Perfect for day and night</li></ul>
3974 <ul><li>Salad servers with wild olive and bone design </li></ul>
4025 <ul><li>A beautiful African <b>trade bead necklace</b> with a unique,custom design - handmade pieces from West Africa </li></ul>
4037 <ul><li>Tonga baskets are <b>baskets woven by the Tonga women of the Southern Province of Zambia</b>, who are renowned for their basket weaving</li><li>The baskets have a distinctive design with a square bottom forming the foundation of the basket</li><li>It takes approximately two weeks to complete a basket about 35 cm in diameter</li></ul>
4038 <ul><li>Tonga baskets are <b>baskets woven by the Tonga women of the Southern Province of Zambia</b>, who are renowned for their basket weaving</li><li>The baskets have a distinctive design with a square bottom forming the foundation of the basket</li><li>It takes approximately two weeks to complete a basket about 35 cm in diameter</li></ul> <p></p>
4039 <ul><li>Tonga baskets are <b>baskets woven by the Tonga women of the Southern Province of Zambia</b>, who are renowned for their basket weaving</li><li>The baskets have a distinctive design with a square bottom forming the foundation of the basket</li><li>It takes approximately two weeks to complete a basket about 35 cm in diameter</li></ul><p></p>
4040 <ul><li>Tonga baskets are <b>baskets woven by the Tonga women of the Southern Province of Zambia</b>, who are renowned for their basket weaving</li><li>The baskets have a distinctive design with a square bottom forming the foundation of the basket</li><li>It takes approximately two weeks to complete a basket about 35 cm in diameter</li></ul>
4041 <ul><li>For centuries South Africa's Zulu people have been famous for the sturdy and beautiful baskets they weave from grasses and palm leaf. The weaving was so tight that the best <em>ukhamba</em> baskets were actually used to store beer</li><li>Today these baskets are still woven in the countryside, but the Zulus living in urban area have invented a <em>new</em> kind of basket, the <em>imbenge</em> basket woven entirely of recycled telephone wire</li><li>The baskets are as bright and colorful as the telephone wire, and very sturdy</li><li>They are also completely washable! In recent years people in craft cooperatives in the the neighboring nation of Zimbabwe have developed their own distinct style of telephone wire basket, which we are also offering here</li><li>These baskets are all one-of-a-kind, and our inventory is constantly changing</li></ul>
4050 <p></p> <ul><li>A beautifully decorated mud cloth throw also known as 'Bao' </li><li><strong>Bao</strong> is a traditional mancala board game played in most of East Africa</li><li>It is most popular among the Swahili people of Tanzania and Kenya; the name itself "Bao" is the Swahili word for "board" or "board game"</li><li>In Tanzania, and especially Zanzibar, a "bao master" (called <em>bingwa</em>, "master"; but also <em>fundi</em>, "artist") is held in high respect</li></ul>
4060 <ul><li>Stylish and colourful hanging beads for decor/display/interior </li></ul>
4062 <p></p> <ul><li>Yaruba basket - Nigeria - West Africa</li><li>Dimensions: 20cm x 11cm x 14cm</li><li>These intricate, one of a kind, vintage leather & beaded baskets are used for carrying a variety of daily items</li><li>Among the Yoruba tribe, beadwork is the province of the Ifa diviner, something akin to a holy man</li><li>Worn by Babalawo (diviners), beaded baskets such as this would hold the diviner's regalia and cowrie shells that would be tossed onto the ground and interpreted by the diviner</li><li>Please note that many of our handmade items are one of a kind,perfectly imperfect,vintage and have indigenous decorative repair work which we believe adds to the intrinsic value and beauty of the items</li><li>No two items are exactly the same</li></ul>
4063 <p>Yaruba basket - Nigeria - West AfricaDimensions: 20cm x 11cm x 14cmThese intricate, one of a kind, vintage leather & beaded baskets are used for carrying a variety of daily itemsAmong the Yoruba tribe, beadwork is the province of the Ifa diviner, something akin to a holy manWorn by Babalawo (diviners), beaded baskets such as this would hold the diviner's regalia and cowrie shells that would be tossed onto the ground and interpreted by the divinerPlease note that many of our handmade items are one of a kind,perfectly imperfect,vintage and have indigenous decorative repair work which we believe adds to the intrinsic value and beauty of the itemsNo two items are exactly the same<br /></p><p></p>
4064 <ul><li>Yaruba basket - Nigeria - West Africa</li><li>Dimensions: 20cm x 11cm x 14cm</li><li>These intricate, one of a kind, vintage leather & beaded baskets are used for carrying a variety of daily items</li><li>Among the Yoruba tribe, beadwork is the province of the Ifa diviner, something akin to a holy man</li><li>Worn by Babalawo (diviners), beaded baskets such as this would hold the diviner's regalia and cowrie shells that would be tossed onto the ground and interpreted by the diviner</li><li>Please note that many of our handmade items are one of a kind,perfectly imperfect,vintage and have indigenous decorative repair work which we believe adds to the intrinsic value and beauty of the items</li><li>No two items are exactly the same</li></ul> <p></p>
4072 <ul><li>Batik / Bone beads are popular in most African countries and <b>are handcrafted from bone</b></li><li>Then are then dyed through the batik method to give them color, most often black and white, or lovely shades of brown</li></ul>
4074 <ul><li>Yoruba beads have essentially been a part of this fashion as these beads adorn our necks, wrists, waists and ankles, it doesn’t come as much of a shock when said that beads were traded for humans during the trans-Atlantic slave era</li><li>Not only for fashion, many of these beads have their importance rooted in our socio-cultural and traditional beliefs, without much ado we will see more about Traditional neck beads (Necklace)</li><li>Yoruba neck beads/necklace popularly called <b>ILEKE</b> are usually pieces of wood, metal and glasses which are usually tied together using a tiny but strong rope and are worn on our necks</li><li>They come in different colours and forms, this colour and form tells us the story behind such beads; if it’s associated to any title or not, their importance, its function and a whole lot of other things</li><li>There are many types of necklace in Yoruba land with each having its function</li></ul>
4075 <p></p><ul><li>Yoruba beads have essentially been a part of this fashion as these beads adorn our necks, wrists, waists and ankles, it doesn’t come as much of a shock when said that beads were traded for humans during the trans-Atlantic slave era</li><li>Not only for fashion, many of these beads have their importance rooted in our socio-cultural and traditional beliefs, without much ado we will see more about Traditional neck beads (Necklace)</li><li>Yoruba neck beads/necklace popularly called <b>ILEKE</b> are usually pieces of wood, metal and glasses which are usually tied together using a tiny but strong rope and are worn on our necks</li><li>They come in different colours and forms, this colour and form tells us the story behind such beads; if it’s associated to any title or not, their importance, its function and a whole lot of other things</li><li>There are many types of necklace in Yoruba land with each having its function</li></ul>
4101 <ul><li>Yaruba Crown - Nigeria - West Africa</li><li>Approximate dimensions:48cm x 14cm x 30cm</li><li>A beaded cone-shaped crown with a long fringe of beads that covers the wearer's face is the most important symbol of Yoruba kingship</li><li>Beaded crowns signify that the king-wearer can trace his ancestry to Odudua, the mythical founder of the sixteen original Yoruba kingdoms</li></ul> <p><br /></p>
4102 <ul><li>Swan bowl - Wooden carving - Handmade</li></ul>
4103 <ul><li>Wooden Bark Bowl - Hand carved - Handmade</li><li>(Bowl only)</li></ul>
4119 <ul><li>These <b>boxes</b> are made in <b>box</b> and covered with <b>leather</b>, they are the fruit of an artisanal know-how of the <b>Tuareg</b> tribes</li><li>Niger - West Africa</li><li>Approximate dimensions: 4cm x 5cm x 10cm</li></ul>
4126 <ul><li>Tuareg necklace - Tuareg - North & West Africa</li><li>Approximate dimensions: 26cm x 6cm x 4cm</li><li>Among the nomadic Tuareg people of northern Africa, jewelry has meaning</li><li>Multi-tasking need not exclude beauty</li><li>Jewelry offers a portable outlet for artistic expression, religious and historical reference, and displays of wealth</li><li>Like many people with ancient traditions, the Tuareg assign firm roles to men, women, and children</li><li>Among such roles lies the creation of the handicrafts that they use to live their lives, perpetuate their history, and express their culture. Among the Tuareg, only men manufacture the stunning silver jewelry for which their people are famed</li></ul> <p><span></span></p>
4127 <ul><li>Tuareg necklace - Tuareg - North & West Africa</li><li>Approximate dimensions: 26cm x 6cm x 4cm</li><li>Among the nomadic Tuareg people of northern Africa, jewelry has meaning</li><li>Multi-tasking need not exclude beauty</li><li>Jewelry offers a portable outlet for artistic expression, religious and historical reference, and displays of wealth</li><li>Like many people with ancient traditions, the Tuareg assign firm roles to men, women, and children</li><li>Among such roles lies the creation of the handicrafts that they use to live their lives, perpetuate their history, and express their culture. Among the Tuareg, only men manufacture the stunning silver jewelry for which their people are famed</li></ul>
4145 <ul><li>Venda bowl </li><li>Large</li><li>Approximate dimensions:364cm x 6cm x 23cm</li></ul>
4146 <ul><li>Venda bowl</li><li>Medium</li><li>Approximate dimensions:6.5cm x 20cm x 20cm</li></ul>
4147 <ul><li>Venda Bowl</li><li>Small</li><li>Approximate dimensions:36cm x 6cm x 23cm</li></ul>
4148 <ul><li>African shield</li><li>Approximate dimensions: 44cm x 13cm x 13cm</li></ul>
4150 <ul><li>Sun Mask - Burkino Faso - West Africa</li><li>Aprroximate dimensions:22cm x 12cm x 12 cm</li><li>Reportedly used in Bwa dance performances to celebrate the farming season, this style of mask is commonly called a "sun" mask</li><li>With its circular design and radiating, triangular pattern of dark brown and white pigments, it can easily be seen as depicting the light of the sun</li></ul>
4151 <ul><li>Sun Mask - Burkino Faso - West Africa</li><li>Aprroximate dimensions:22cm x 12cm x 12 cm</li><li>Reportedly used in Bwa dance performances to celebrate the farming season, this style of mask is commonly called a "sun" mask</li><li>With its circular design and radiating, triangular pattern of dark brown and white pigments, it can easily be seen as depicting the light of the sun</li></ul> <p></p>
4189 <ul><li>Mounted Tikar Clay Beaded Bangles are made by the Tikar of Cameroon, a group that is part of the Bantu Cameroon-Bamileke people in southern Africa</li><li>Originally made as a piece of jewelry to be worn, most Tikar Beaded Bangles today are made as decorative pieces for display, as their vibrant glass beads in a simple circle form create a striking visual impact</li><li>To create each bangle, a solid ring of clay is fired and then overlaid with individually placed strands of glass seed beads</li><li>Style your Tikar Clay Beaded Bangle atop a stack of coffee table books or nestled into a group of picture frames</li><li>A standalone piece, these bangles are lovely gift items available in a variety of colors. Includes iron display stand</li></ul>
4366 <ul><li>Yaruba basket - Nigeria - West Africa</li><li>Dimensions: 20cm x 11cm x 14cm</li><li>These intricate, one of a kind, vintage leather & beaded baskets are used for carrying a variety of daily items</li><li>Among the Yoruba tribe, beadwork is the province of the Ifa diviner, something akin to a holy man</li><li>Worn by Babalawo (diviners), beaded baskets such as this would hold the diviner's regalia and cowrie shells that would be tossed onto the ground and interpreted by the diviner</li><li>Please note that many of our handmade items are one of a kind,perfectly imperfect,vintage and have indigenous decorative repair work which we believe adds to the intrinsic value and beauty of the items. No two items are exactly the same</li></ul>