Sandbox

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 (
    300242, 300253, 300264, 300265, 299417, 
    299505, 299514, 299540, 299541, 299576, 
    299729, 299731
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00162

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.85",
        "eval_cost": "1.20",
        "prefix_cost": "10.05",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (300242,300253,300264,300265,299417,299505,299514,299540,299541,299576,299729,299731)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id	short_description	full_description
299417		Included in this listing is: (1) 12 stainless steel tumbler, with lid and rubber straw and also a sippy top. This cup will grow with your child. You can also add your child’s name if you wish at no extra charge.
299505		This listing is for the vinyl decal only - no shirt is included Create your own shirt in a matter of minutes. Decal is available in your choice of vinyl colors and sizes to match any size shirt. All you need to do is iron it on ( instructions will be included )
299514		Vinyl decal can be used on any surface indoors or outdoors. Decorate your car window, door, laptop, notebook or just about anything that has a smooth surface. Use your imagination! Made from durable outdoor vinyl. This will last for years. You pick the size and color. All decals can also be made into Iron-On Vinyl for shirts, backpacks, totebags, etc. Contact me for pricing on the size you need. Available in various matte and glitter options.
299540		Decorate your campsite! Let everyone know who you are, where you are from or just how crazy you are! Personalization is free if you would like it. Vinyl decal can be used on any surface indoors or outdoors. Decorate your camper wall, propane tank, cooler, serving tray, tablecloth, mug, bucket or just about anything that has a smooth surface. Use your imagination! Size guide: Coffee mug or travel cup - 2-4” wide depending on how large the cup Window decal - 4-8” if in the corner of window Window decal - 7-12” if in the center of window 5 gallon bucket - 10” tall Made from durable outdoor vinyl. This will last for years. You pick the size and color. All decals can also be made into Iron-On Vinyl for shirts, backpacks, totebags, etc. Contact me for pricing on the size you need. Available in various matte and glitter options.
299541		Decorate your campsite! Let everyone know who you are, where you are from or just how crazy you are! Personalization is free if you would like it. Vinyl decal can be used on any surface indoors or outdoors. Decorate your camper wall, propane tank, cooler, serving tray, tablecloth, mug, bucket or just about anything that has a smooth surface. Use your imagination! Size guide: Coffee mug or travel cup - 2-4” wide depending on how large the cup Window decal - 4-8” if in the corner of window Window decal - 7-12” if in the center of window 5 gallon bucket - 10” tall Made from durable outdoor vinyl. This will last for years. You pick the size and color. All decals can also be made into Iron-On Vinyl for shirts, backpacks, totebags, etc. Contact me for pricing on the size you need. Available in various matte and glitter options.
299576		Decorate your campsite! Let everyone know who you are, where you are from or just how crazy you are! Personalization is free if you would like it. Vinyl decal can be used on any surface indoors or outdoors. Decorate your camper wall, propane tank, cooler, serving tray, tablecloth, mug, bucket or just about anything that has a smooth surface. Use your imagination! Size guide: Coffee mug or travel cup - 2-4” wide depending on how large the cup Window decal - 4-8” if in the corner of window Window decal - 7-12” if in the center of window 5 gallon bucket - 10” tall Made from durable outdoor vinyl. This will last for years. You pick the size and color. All decals can also be made into Iron-On Vinyl for shirts, backpacks, totebags, etc. Contact me for pricing on the size you need. Available in various matte and glitter options.
299729		Each flag is 12"W x 18"L with rolled hem edges with a 1.75" opening for the topper. Polypropylene material. Please note that some of the colors of vinyl may have to change depending on what color material you choose. I will send you a computerized proof before I actually put it together. Turn around time may depend on how long it takes for you to approve your proof. The flag will be made within a day or 2 of your approval. Ordering more than one? Shipping discount is automatically applied for each additional flag ordered. Though this fabric should not fade, nor will it fray, I was recently notified that "This fabric has a high thermal expansion coefficient which limits its high-temperature applications making it susceptible to UV degradation if exposed long term." Hence, placing your flag in the shaded area of your garden will extend its life.
299731		Each flag is 12"W x 18"L with rolled hem edges with a 1.75" opening for the topper. Polypropylene material. Please note that some of the colors of vinyl may have to change depending on what color material you choose. I will send you a computerized proof before I actually put it together. Turn around time may depend on how long it takes for you to approve your proof. The flag will be made within a day or 2 of your approval. Ordering more than one? Shipping discount is automatically applied for each additional flag ordered. Though this fabric should not fade, nor will it fray, I was recently notified that "This fabric has a high thermal expansion coefficient which limits its high-temperature applications making it susceptible to UV degradation if exposed long term." Hence, placing your flag in the shaded area of your garden will extend its life.
300242		This listing is for the vinyl decal only - no shirt is included Create your own shirt in a matter of minutes. Decal is available in your choice of vinyl colors and sizes to match any size shirt. All you need to do is iron it on ( instructions will be included )
300253		Decorate your campsite! Let everyone know who you are, where you are from or just how crazy you are! Personalization is free if you would like it. Vinyl decal can be used on any surface indoors or outdoors. Decorate your camper wall, propane tank, cooler, serving tray, tablecloth, mug, bucket or just about anything that has a smooth surface. Use your imagination! Size guide: Coffee mug or travel cup - 2-4” wide depending on how large the cup Window decal - 4-8” if in the corner of window Window decal - 7-12” if in the center of window 5 gallon bucket - 10” tall Made from durable outdoor vinyl. This will last for years. You pick the size and color. All decals can also be made into Iron-On Vinyl for shirts, backpacks, totebags, etc. Contact me for pricing on the size you need. Available in various matte and glitter options.
300264		Decorate your campsite! Let everyone know who you are, where you are from or just how crazy you are! Personalization is free if you would like it. Vinyl decal can be used on any surface indoors or outdoors. Decorate your camper wall, propane tank, cooler, serving tray, tablecloth, mug, bucket or just about anything that has a smooth surface. Use your imagination! Size guide: Coffee mug or travel cup - 2-4” wide depending on how large the cup Window decal - 4-8” if in the corner of window Window decal - 7-12” if in the center of window 5 gallon bucket - 10” tall Made from durable outdoor vinyl. This will last for years. You pick the size and color. All decals can also be made into Iron-On Vinyl for shirts, backpacks, totebags, etc. Contact me for pricing on the size you need. Available in various matte and glitter options.
300265		Decorate your campsite, tire cover or even camper! Let everyone know who you are, where you are from or just how crazy you are! Personalization is free if you would like it. Vinyl decal can be used on any surface indoors or outdoors. Decorate your camper wall, propane tank, cooler, serving tray, tablecloth, mug, bucket or just about anything that has a smooth surface. Use your imagination! Size guide: Window decal - 4-8” if in the corner of window Window decal - 7-12” if in the center of window 5 gallon bucket - 10” tall Tire cover or camper door, side panel, etc. sizes - 12" + Made from durable outdoor vinyl. This will last for years. You pick the size and color. Note: sizes larger than 12" may come in 2 pieces.