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 (
    229634, 229562, 242335, 247918, 242908, 
    253418, 229645, 260004, 253617, 229529, 
    229628, 229573
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00166

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.24"
    },
    "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": "9.04",
        "eval_cost": "1.20",
        "prefix_cost": "10.24",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (229634,229562,242335,247918,242908,253418,229645,260004,253617,229529,229628,229573)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
229529 <p>Beautiful fabric mouse pad. Has a non slip underside and is nice and sturdy. <br>The apple fabric would be perfect for any fall fan as well as teachers. </p> <p>The mouse pad is approx. 9” round. </p> <p>*Mouse and keyboard NOT included*</p>
229562 <p>This cute pencil case / zipper pouch features a beautiful retro looking typewriter. It is the perfect addition for any office, school, college setting. These also make cute gifts for friends and can also hold makeup brushes etc.&nbsp;</p> <p>It features a metal zipper with a little pom pom - what a cute eye-catcher.&nbsp;</p> <p>Finished size is 9.5"x3"x2", perfect for most all of pencils and pens out there.&nbsp;</p> <p>Perfect for use as a pencil case or to store makeup including brushes.</p><p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Customization</p> <p>If you would like any custom design not offered in the options, please contact me prior to your purchase. I will then create a custom listing for you. </p> <p>If you need more items than currently available, please contact me. Depending on Fabric choice, I may be able to provide more items. </p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Size: </p> <p>Karl measures approx. 5"W x 5"H x 2"D</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p>
229573 <p>These handmade key fobs are made from 2mm cotton webbing for comfort, when carrying them in your hand. <br>All items are handmade by me. Item therefore may differ slightly from pictures, as fabric placement may be different. </p> <p>Matching purse available in my shop as well! </p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Size: </p> <p>Key Fob measures approx.: 1"W x 4"L</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p>
229628 <p>This is a very traditional zippered pouch, with which you cannot go wrong. It is great to hold cosmetics, make up and other toiletries in style. Use it for the small things laying all over the place to store. </p> <p>Pattern: Sotakhandmade</p> <p>The zipper opens along the top. <br>The makeup purse comes with a little matching pompom, which is another eye catcher and makes it easy to zip it closed and open. </p> <p>All items are handmade by me. Item therefore may differ slightly from pictures, as fabric placement may be different. </p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Customization</p> <p>If you would like any custom design not offered in the options, please contact me prior to your purchase. I will then create a custom listing for you. </p> <p>If you need more items than currently available, please contact me. Depending on Fabric choice, I may be able to provide more items. </p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Size: </p> <p>Small : 5.5""W x 3.5""H x 1.5""D</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p>
229634 <p>This project bag is perfect to hold your current and future knitting / crocheting / macrame projects. The waxed canvas on the outside gives it a one of a kind look. It features a drawstring closure on tope and a zippered front pocket. On the inside is another slip pocket to hold smaller items separate). <br>Dimensions:<br>8" wide x 5" deep x 10" tall</p> <p>Pattern by Noodlehead</p> <p>NOTE: If you are not a fan of the distressed look, just hold a fan to the bag and the creases will become invisible. Just don't hold it there for too long. </p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p>
229645 <p>This zippered pouch with dual zippers can hold everything in a purse or can be used a wristlet by itself. The Large Devon Pouch is the only one you'll need. <br>Optional you can add a macrame wristlet (last pic). The wristlet measures approx.&nbsp;7.25"W x 5"H x 1.5"D </p> <p>The zipper opens along the top. </p> <p>All items are handmade by me. Item therefore may differ slightly from pictures, as fabric placement may be different. </p> <p>Pattern: Sotakhandmade</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Customization</p> <p>If you would like any custom design not offered in the options, please contact me prior to your purchase. I will then create a custom listing for you. </p> <p>If you need more items than currently available, please contact me. Depending on Fabric choice, I may be able to provide more items. </p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Size: </p> <p>Large Devon Pouch measures approx. 7.25"W x 5"H x 1.5"D</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom / leather tabs from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p>
242335 <p>This wristlet using a animal canvas print, is perfect to carry by itself on in a bigger purse. It comes with two card slots inside and a zipper pocket for coins. The zipper wraps around two sides, which makes it easy to access and see what's inside.&nbsp;</p> <p>Pattern: Noddlehead - Yarrow Pouch / Yarrow Wristlet</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Customization</p> <p>If you would like any custom design not offered in the options, please contact me prior to your purchase. I will then create a custom listing for you.&nbsp;</p> <p>If you need more items than currently available, please contact me. Depending on Fabric choice, I may be able to provide more items.&nbsp;</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Size:&nbsp;</p> <p>Card Purse measures approx. 8.75"W x 5" H</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p> <p></p>
242908 <p>This cute pencil case is great for teachers with its prominent and fun apple fabric. It is the perfect addition for any office, school, college setting. These also make cute gifts for friends. And can also hold makeup brushes etc.&nbsp;</p> <p>It features a metal zipper with a little pom pom - what a cute eye-catcher.&nbsp;</p> <p>Finished size is 9.5"x3"x2", perfect for most all of pencils and pens out there.&nbsp;</p> <p>Perfect for use as a pencil case or to store makeup including brushes.</p> <p></p>
247918 <p>This crossbody bag is 9.5”W (at base) x 9”H x 3.5”D and is a beautiful purse, with lots of storage despite it's compact size.&nbsp;</p> <p>It is made from waxed canvas and dry oilskin with an outside slip pocket made from flannel. The waxed canvas provides water protection in the rain. The leather handles and crossbody strap are attached using metal rivets for extra secure handles. So even if you carry your whole life in the purse, the straps will not come off.&nbsp;</p> <p>There is a slip pockets on the interior.&nbsp;</p> <p>The pattern is by Georgia Girl Stitches</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Customization</p> <p>If you would like any custom design not offered in the options, please contact me prior to your purchase. I will then create a custom listing for you.&nbsp;</p> <p>If you need more items than currently available, please contact me. Depending on Fabric choice, I may be able to provide more items.&nbsp;</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p> <p></p>
253418 <p>This wristlet using a funky pink with pops of color canvas print, is perfect to carry by itself on in a bigger purse. It comes with two card slots inside and a zipper pocket for coins. The zipper wraps around two sides, which makes it easy to access and see what's inside.&nbsp;</p> <p>Pattern: Noddlehead - Yarrow Pouch / Yarrow Wristlet</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Customization</p> <p>If you would like any custom design not offered in the options, please contact me prior to your purchase. I will then create a custom listing for you.&nbsp;</p> <p>If you need more items than currently available, please contact me. Depending on Fabric choice, I may be able to provide more items.&nbsp;</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Size:&nbsp;</p> <p>Card Purse measures approx. 8.75"W x 5" H</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p> <p></p>
253617 <p><strong>Find the matching larger size in my store!</strong></p> <p>This beautiful medium sized zipper bag with a recessed zipper is great as an everyday cosmetic bag, for travel or at home. Given the size it can also nicely be used as a project bag for crocheting / knitting projects or other craft projects.&nbsp;</p> <p>Given the personalization options, they would also be a great bridesmaid gift. Just reach out to me if you are looking for something specific.&nbsp;</p> <p>Measurements are approx. 8"W x 5"H x 2.5"D</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p> <p></p>
260004 <p>This crossbody bag is 9.5”W (at base) x 9”H x 3.5”D and is a beautiful purse, with lots of storage despite it's compact size.&nbsp;</p> <p>It is made from waxed canvas and black dry oilskins with an outside slip pocket made from beautiful floral cotton fabric. The waxed canvas and dry oislkin provide water protection in the rain. The leather handles and crossbody strap are attached using metal rivets for extra secure handles. So even if you carry your whole life in the purse, the straps will not come off.&nbsp;</p> <p>There is a slip pockets on the interior.&nbsp;</p> <p>The pattern is by Georgia Girl Stitches</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Customization</p> <p>If you would like any custom design not offered in the options, please contact me prior to your purchase. I will then create a custom listing for you.&nbsp;</p> <p>If you need more items than currently available, please contact me. Depending on Fabric choice, I may be able to provide more items.&nbsp;</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (all Cotton):</p> <p>Item can be washed in machine using the Hand-wash or Delicates Cycle. Tumble dry on low.</p> <p>Please remove the pom pom from the zipper prior to putting the item in the washing machine.</p> <p>If you experience any issues, please contact me. If you have any further questions, please also let me know. I will be happy to answer any questions.</p> <p>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p> <p>Caring Instructions (cork, laminated cotton, faux leather, etc)</p> <p>Item should only be spot cleaned with a damp cloth and water. Putting your item in the washing machine is not recommended, as it may destroy the cork, laminated cotton, faux leather, etc. used to make your item.</p>