SELECT 
  product_descriptions.product_id, 
  product_descriptions.short_description, 
  IF(
    product_descriptions.short_description = '' 
    OR product_descriptions.short_description IS NULL, 
    product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  product_descriptions 
WHERE 
  product_descriptions.product_id IN (
    206024, 212352, 199359, 212370, 254311, 
    205990, 206029, 198581, 213507, 199221, 
    212367, 205982
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00084

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.10"
    },
    "table": {
      "table_name": "product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "11",
      "rows_examined_per_scan": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.90",
        "eval_cost": "1.20",
        "prefix_cost": "10.10",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (206024,212352,199359,212370,254311,205990,206029,198581,213507,199221,212367,205982)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
198581 <p>Add a piece of unique and sustainable handmade desk art to your space.&nbsp; This piece of sustainable home decor is called,<em> Camouflage</em>, since there are two figures hidden among the leaves on a nice sunny day.&nbsp; Can you find them? <em>Camouflage </em>is a sustainable product is made with nearly 50 hand-cut and folded pieces that were cut from boxes, and then glued onto another box.&nbsp; There are also 16 bright orange triangles of various lengths that radiate from the sun.&nbsp; This small paper-based wall art is approximately 13-1/4 inches in length, 6-3/4 inches in width, and 3/8 inches in depth when flat.&nbsp; <em>Camouflage </em>is intended to sit on a desk or table, but it can be adapted to hang on a wall.&nbsp; Please send me a message if you would like me to add a ribbon to hang.<br></p> <ul><li>Dimensions when flat (approximate) <ul><li>L x W x D = 13-1/4" x 6-3/4" x 3/8"</li><li>May not be completely flat</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Snack boxes (canvas and hand-cut pieces)</li><li>Glue</li></ul></li><li>Colors<ul><li>Pink, yellow, blue, orange, purple, brown, black, green, and white</li></ul></li></ul> <p>Will ship in a small Priority Mail box, but pick-up is highly recommended.</p>
199221 <p>Add a piece of sustainable and one-of-a-kind handmade wall art to your space.&nbsp; This piece of sustainable home decor depicts a dynamic mix in nature with vibrant green leaves, brown trees, and coral colors.&nbsp; This small wall art measures 7 and 1/8 inches in length and 4 and 3/4 inches in width, including the ribbon for hanging, and has a landscape layout.&nbsp; The materials for this upcycled home decor consists of an ice cream box for the canvas, a magazine, glue, and ribbon.&nbsp; The ribbon is slightly off-center, but it can still be hung straight.&nbsp; This collage is thin and not completely flat on the back due to the amount of glue it takes for a project like this. Colors of this eco-friendly wall art are shades of green, shades of coral, brown, and white.</p> <ul><li>Dimensions<ul><li>L X W = 7-1/8" x 4-3/4"</li><li>Thickness = thin</li><li>Not completely flat when laid on the back</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Ice cream box (canvas)</li><li>Magazine</li><li>Glue</li><li>Ribbon (to hang on the wall)</li></ul></li></ul>
199359 <p>This unique and earthy tiger eye statement necklace is sure to capture attention wherever you go.&nbsp; The numerous tiger eye beads ranges from tiny to medium sizes, with the largest front and center tapering to tiny beads toward the clasp.&nbsp; Because each gemstone is different and there are so many of them on each necklace, both necklaces are not the same.&nbsp; Soft brown and warm yellow hues makes this necklace naturally alluring.&nbsp; This chunky tiger eye necklace is also made with stainless steel closure, so it doesn't rust, and water-resistant wire.</p>
205982 <p>Add a piece of handmade&nbsp;upcycled wall art to your space.&nbsp; This unique piece of home decor is titled, <em>Behind the Curtain</em> because a fairy is revealed behind a curtain of leaves.&nbsp; <em>Behind the Curtain</em> is a sustainable product with 55 hand-cut and folded pieces from boxes and then glued on another box.&nbsp; There are also more than 30 small teal triangles all over the canvas. This small paper-based wall art measures approximately 12 inches in length, 8-1/4 inches in width, including the ribbon for hanging, and 3/8 inches in depth.&nbsp; <br></p> <ul><li>Dimensions (approximate) <ul><li>L x W x D = 12" x 8-1/4" (with ribbon) x 3/8"</li></ul><ul><li>May not be completely flat on the back</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Snack boxes (canvas and 55 hand-cut pieces)</li><li>Glue</li><li>Ribbon (to hang on the wall)</li></ul></li><li>Colors<ul><li>Pink, blue, yellow, brown, and green</li></ul></li></ul> <p>Will ship in repurposed box, but pick-up is strongly recommended to prevent damage in transit.</p>
205990 <p></p> <p>This beautifully hand-crafted upcycled card is made from boxes.&nbsp; Each card uses the same patterned or branded box, but each design is unique, because of where they were cut on the box, the size and shape of each piece, and their placements.&nbsp; These upcycled cards are two-sided like a postcard.&nbsp; The front has the pattern and the back is blank for writing.&nbsp; It has smooth writing with any pen or marker, and dark color ink is recommended.&nbsp; Because each style does not have pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; An envelope is included.&nbsp; Cards and envelopes can be recycled or kept as a meaningful one-of-a-kind keepsake.</p> <ul><li>Dimensions:&nbsp;<ul><li>Card:&nbsp;L x W = Approx. 6.25 inches x 3.25 inches&nbsp;</li><li>Envelope (included): L x W = 6.5 inches x 3.5 inches&nbsp;</li></ul></li></ul>
206024 <p>This beautifully hand-crafted upcycled card is made from boxes.&nbsp; Each card uses the same patterned or branded box, but each design is unique, because of where they were cut on the box, the size and shape of each piece, and their placements.&nbsp; These upcycled cards are two-sided like a postcard.&nbsp; The front has the pattern and the back is blank for writing.&nbsp; It has smooth writing with any pen or marker, and dark color ink is recommended.&nbsp; Because each style does not have pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; An envelope is included.&nbsp; Cards and envelopes can be recycled or kept as a meaningful one-of-a-kind keepsake.<br></p> <ul><li>Dimensions:&nbsp;<ul><li>Card:&nbsp;L x W = Approx. 6.25 inches x 3.25 inches</li><li>Envelope (included): L x W = 6.5 inches x 3.5 inches&nbsp;</li></ul></li></ul>
206029 <p>These beautifully unique hand-crafted upcycled cards are made from boxes.&nbsp; Each card has a different design and color palette, along with not having pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; These upcycled cards are two-sided like postcards.&nbsp; They have a patterned side on the front and a blank side on the back for writing. &nbsp;They have smooth writing with any pen or marker, and dark color ink is recommended. This blank card set comes with 3 cards and 3 envelopes.&nbsp; Cards and envelopes can be recycled or kept as meaningful one-of-a-kind keepsakes.<br></p> <ul><li>Dimensions:&nbsp;<ul><li>Cards:&nbsp;L x W = Approx. 5.5 inches x 3.25 inches&nbsp;</li><li>Envelopes (included): L x W = 6.5 inches x 3.5 inches </li></ul></li></ul> <ul><li>Patterns: Coffee, Abstract Painting, and Dreams Collage</li><li>Colors:&nbsp;<ul><li>Coffee: Dark brown, brown, beige, and white</li><li>Abstract Painting: Gray, yellow, green, and purple</li><li>Dreams Collage:&nbsp;Blue, purple, yellow, white, and gray</li></ul></li></ul>
212352 <p>These sleek black obsidian earrings have a minimalist design, so they will pair well with many outfits and suitable for multiple occasions.&nbsp; These earrings are handmade with thin stainless steel wire wrapped around black obsidian gemstones, and attached to niobium ear wires - a hypoallergenic metal.&nbsp; Because niobium is hypoallergenic, these black obsidian earrings are great gifts for loved ones with metal allergies.&nbsp; Black obsidian dangle earrings are short and slender with gender-neutral design.&nbsp; There are two lengths: earrings with two stones on each side are approximately 1 and 5/8 inches long and earrings with three stones are approximately 2 and 1/2 inches long.</p> <p>*<strong>Note</strong>: wire is very soft, so it's possible that earrings would be bent in transit.&nbsp; Carefully bend earrings back to the original design or return it to be fixed.&nbsp; When earrings are not worn, please store them properly, such as hanging them on an earring display, to avoid damage.<br></p>
212367 <p>This pair of handmade butterfly dangle earrings is playfully elegant and perfect for all occasions! Earrings are short, measuring 1.5 inches long.&nbsp; Each earring is made with two wire wrapped sapphire glass beads, and then attached to the butterfly earring posts.&nbsp; The sapphire glass beads shine beautifully in light.&nbsp; Butterfly studs are stainless steel with matte gold color.&nbsp; Let the compliments roll!<br></p>
212370 <p>Look stunning in sapphire! This handmade hypoallergenic jewelry set features a statement necklace and dangle earrings in sapphire and clear beads. The beaded statement necklace has over 150 glass beads, is 18 inches long, and stainless steel closure.&nbsp; The matching dangle earrings are made with surgical stainless steel (medical-grade stainless steel) ear wires with 316 stamps on each ear wire, and two sapphire glass beads dangling on each earring.&nbsp; Earrings are medium-length, measuring 1.75 inches in length.&nbsp; This sapphire jewelry set is an excellent gift for loved ones with metal allergies and people who love compliments.</p>
213507 <p>This elegant statement necklace in deep blue and white pearl is great for work and all occasions.&nbsp; This handmade necklace is 18 inches long.&nbsp; This necklace features a focal point with 5 handmade deep blue glass beads with silver lining, each with a unique look in blue, black, and silver.&nbsp; These deep blue beads are set in between intricately detailed silver plated bead caps and 4 white glass pearl beads.&nbsp; There are 50 glass pearls per necklace and closes with a stainless steel clasp and ring.<br></p>
254311 <p>This pair of handmade hoop earrings are hypoallergenic have a timeless and minimalist design that is great for work in all industries.&nbsp; These hoops are made with medical-grade stainless steel and can be worn by anyone with pierced ears.&nbsp; Stainless steel also does not tarnish.&nbsp; These small surgical stainless steel hoop earrings are also light-weight, so they are comfortable to wear all day.<br></p>