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 (
    276551, 276583, 279115, 279095, 276805, 
    276567, 276811, 276584, 276574, 276560, 
    276580, 276566, 279097, 276812, 276815, 
    276803, 276804, 279104, 279255, 276577, 
    279262, 279250, 283189, 287048, 283181, 
    279099, 279109, 287067, 276569, 279103, 
    287052, 276802, 283192, 283186, 283179, 
    283182, 287051, 276556, 287105, 287107, 
    279258, 287108, 287106, 287050, 287059, 
    287064, 287111, 287102
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00145

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "41.05"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "36.25",
        "eval_cost": "4.80",
        "prefix_cost": "41.05",
        "data_read_per_join": "244K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (276551,276583,279115,279095,276805,276567,276811,276584,276574,276560,276580,276566,279097,276812,276815,276803,276804,279104,279255,276577,279262,279250,283189,287048,283181,279099,279109,287067,276569,279103,287052,276802,283192,283186,283179,283182,287051,276556,287105,287107,279258,287108,287106,287050,287059,287064,287111,287102)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
276551 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is taken partially from the edge of the plate, it doesn't lay perfectly flat and has some pretty raised details included.</p> <p>Size is 53 x 35mm&nbsp;</p>
276556 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat with subtle texture in the design.</p> <p>Size is 40 x 25mm&nbsp;</p>
276560 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is slightly curved as it's from the edging of the plate. The surface is smooth, and I've formed it into a cute moon shape</p> <p>Size is 63 x 18 mm&nbsp;</p>
276566 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat and features close ups of green and pink flowers, cut into a crescent moon shape.</p> <p>Size is 60 x 16mm&nbsp;</p>
276567 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat.</p> <p>Size is 43 x 36mm&nbsp;</p>
276569 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat and includes the edge of the plate on one side as a part of the design.</p> <p>Size is 56 x 32mm&nbsp;</p>
276574 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat</p> <p>Size is 54 x 45mm&nbsp;</p>
276577 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is slightly crved and has some texture on it from the edge of the plate.</p> <p>Size is 70 x 21mm&nbsp;</p>
276580 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat with a cute windmill motif.</p> <p>Size is 46 x 28mm&nbsp;</p>
276583 <p>Measuring 75mm tall by 35mm wide. this pendant features a large carved labradorite focal piece, with a beautiful deep blue and green flash. In direct light this piece reveals it’s true depth of color and light play.&nbsp; Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s new-penny look or polished to bring out the highlights.</p>
276584 <p></p> <p>Measuring 57mm tall by 23mm wide. this pendant features a small carved labradorite focal piece, with a pale blue and green flash. In direct light this piece reveals pretty, subtle light play.&nbsp; Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s new-penny look or polished to bring out the highlights.</p> <p></p>
276802 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is taken partially from the edge of the plate, it doesn't lay perfectly flat.</p> <p>Size is 40 x 50mm&nbsp;</p>
276803 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece lays mostly flat</p> <p>Size is 34 x 38mm&nbsp;</p>
276804 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece lays mostly flat</p> <p>Size is 35 x 37mm&nbsp;</p>
276805 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece lays mostly flat with some neat texture on it. This is a heavy ceramic piece.</p> <p>Size is 43 x 42mm&nbsp;</p>
276811 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece has a slight curve to it but lays mostly flat. The surface is smooth, and I've formed it into a cute moon shape</p> <p>Size is 58 x 18 mm&nbsp;</p>
276812 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat</p> <p>Size is 25 x 25mm&nbsp;</p>
276815 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is taken partially from the edge of the plate, it doesn't lay perfectly flat and has some pretty raised details included.</p> <p>Size is 48 x 35mm&nbsp;</p>
279095 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is taken partially from the edge of the plate, it doesn't lay perfectly flat, but pretty close.</p> <p>Size is 36 x 27mm&nbsp;</p>
279097 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece has a bit of a curve to it and doesn't lie flat.</p> <p>Size is 26 x 53mm&nbsp;</p>
279099 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece has a curve to it</p> <p>Size is 25 x 40mm&nbsp;</p>
279103 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat.</p> <p>Size is 38 x 58mm&nbsp;</p>
279104 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece has a bit of a curve to it with some of the plate edging on the back and doesn't lie flat.</p> <p>Size is 40 x 30 mm&nbsp;</p>
279109 <p>I hand-painted these purple fireweed wildflowers on leather and suspended them on sterling silver filled earwires. Accented by a light-catching purple glass bead, these earrings are sure to initiate conversations.</p> <p>These earrings are very long at 110mm from the vase of the earwires and 32mm wide</p>
279115 <p>I hand-painted these purple fireweed wildflowers on leather and suspended them on sterling silver filled earwires. Accented by sterling filled findings, these earrings are sure to initiate conversations.</p> <p>These earrings are very long at 90mm from the bottom of the earwires and 40mm wide</p>
279250 <p>Made from the cross-section of White Walnut (aka Butternut) Tree seeds, the natural intricacies of these earrings invite a second and third look. Measure 30mm x 20mm excluding the earwire.<br></p>
279255 <p>Understated copper wire serpentine around the wooden beads, each bead a unique pattern of black and brown.&nbsp; The nature of the materials allows for these hoops to remain light, allowing for hours of wear without issue. Measure 55mm x 42mm excluding the earwire.<br></p>
279258 <p>Inspired by the aurora, these bead wrapped around these glass focals show subtle mixes of purple and blue within the darkness. Measure 50mm long&nbsp; and 21mm wide excluding the earwire.<br></p>
279262 <p>Super long and dramatic bone horn beads wrapped in organically inspired copper wire shapes. Measure 56mm long&nbsp; and 8mm wide excluding the earwire.<br></p>
283179 <p>Measuring 68mm tall by 35mm wide. this pendant features a handmade lampwork bead by artist Chuckie Mac.&nbsp; Wrapped in raw copper, this piece has already been given an aged patina and polished to create a greater sense of depth and light play, but it will continue to darken and change with age, as is the nature of copper.<br></p>
283181 <p>Dyed magnesite black bears surrounded by a hand-hammered copper frame, accented with dyed stone and multicolored beads. Measure 58mm x 43mm excluding the earwire.<br></p>
283182 <p>Handmade lampwork blueberries surrounded by a hand-hammered copper hoop, accented with matching iridescent blue crystal beads. Measure 60mm x 60mm excluding the earwire.<br></p>
283186 <p>I hand-painted these Alaskan wildflowers on ulu-shaped leather and suspended them on sterling silver filled earwires. <br></p> <p>These earrings are small at 32mm from the base of the earwires and 29mm wide</p>
283189 <p>Cute hand-formed dangle earrings featuring gorgeous Czech glass beads and hand-hammered copper details. Measure 41mm long and 13mm wide excluding the earwire.<br></p>
283192 <p>Measuring 52mm tall by 18mm wide, this pendant features a a gorgeous flashy labradorite, dancing with green and yellow tones. In direct light this piece reveals it’s true depth of color and light play.&nbsp; Wrapped in sterling silver-filled, this piece will darken or develop a patina over time, It can be sealed to maintain its shine or polished to bring out the highlights from the darkening metal.<br></p>
287048 <p>Measuring 85mm tall by 40mm wide. this pendant features a floral carved labradorite focal piece. In direct light this piece reveals it’s true depth of color and light play.&nbsp; Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p>
287050 <p>Measuring 65mm tall by 42mm wide. this pendant features a beautiful purple amethyst. Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p>
287051 <p>Measuring 62mm tall by 36mm wide. this pendant features a gorgeous blue and orange sodalite. Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p>
287052 <p></p> <p>Measuring 80mm tall by 42mm wide. this pendant features a gorgeous polished piece of maligano jasper. Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p> <p></p>
287059 <p>Tiny polar bears suspended inside copper hoops with coordinating blue glass beads. Measure 57mm x 60mm excluding the earwire.</p>
287064 <p>Best fits sizes 5-8, this ring is made with raw copper and glass seed beads. As it is made from raw copper, it could stain your skin where you are wearing it, this doesn't harm you and some folks wear copper intentionally as a purported folk remedy. If you're concerned about skin discoloration, you can paint the inside of the ring with varnish, jewelry wax, or nail polish, or polish it on a regular basis.<br></p>
287067 <p>Hand-formed copper hoop, accented with matching red and amber crystal beads. Measure 55mm x 55mm excluding the earwire.</p>
287102 <p>White imitation sea glass accented with intricately woven copper and flourishes. 45mm long by 20mm wide<br></p>
287105 <p>Blue imitation sea glass accented with intricately woven copper and flourishes. 40mm long by 22mm wide</p>
287106 <p>Green imitation sea glass accented with intricately woven copper and flourishes. 40mm long by 22mm wide</p>
287107 <p>Copper woven and wrapped around a hammered copper base to create small but striking hoops. 33mm long 32mm wide excluding the earwires&nbsp;<br></p>
287108 <p>Hand painted blueberry bushes and handmade lampwork blueberry beads, sure to make you popular during picking season! Measure 80mm long by 36mm wide<br></p>
287111 <p>Mini auroras painted on black leather and suspended from copper handmade findings. Measures 75mm long by 31mm wide excluding the earwire. <br></p>