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 (
    273653, 274149, 273584, 274159, 273774, 
    273917, 274014, 274052, 277121, 276772, 
    273782, 274054, 274290, 273809, 273807, 
    285487, 276798, 287053, 285573, 291359, 
    393245, 340444, 333844, 345724
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00468

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "20.50"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "18.10",
        "eval_cost": "2.40",
        "prefix_cost": "20.50",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (273653,274149,273584,274159,273774,273917,274014,274052,277121,276772,273782,274054,274290,273809,273807,285487,276798,287053,285573,291359,393245,340444,333844,345724)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
273584 <p>Salem is a newly made rug. . . made with hand hooked wool strips on a linen base. &nbsp;It's very primitive and would look well on wall or floor. &nbsp;It measures 20 x 29. &nbsp;I made it using strips of my hand dyed wool from my leftover "noodle bag". &nbsp;As with all my big hooked pieces, this was finished off with cording and tapestry yarn to give it a nice finished edge. &nbsp;It comes with a letter that covers how to care for the rug, &nbsp;and its value for insurance. &nbsp;Salem is a copyrighted design by Lib Callaway, to which I own all rights.</p>
273653 <p>Pies for sale is a fun kitchen rug. . . made with hand hooked wool strips on a linen base. &nbsp;It's folk artsy and would look well on wall or floor. &nbsp;It measures 16 x 44. &nbsp;I made it using &nbsp;my hand dyed wools, chosen from my large stash . &nbsp;As with all my big hooked pieces, this was finished off with cording and tapestry yarn to give it a nice finished edge. &nbsp;It comes with a letter that covers how to care for the rug, &nbsp;and its value for insurance. &nbsp;Pies for &nbsp;Sale, is a copyrighted design by me, to which I own all rights. &nbsp;The pattern is available via my website New Earth Designs for a one time use.</p>
273774 <p>Comstock is an eyecatching rug, both modern and antique in appearance. &nbsp;I made this rug with hand hooked wool strips on a linen base. &nbsp;It's eye catching and would look well on wall or floor. &nbsp;It measures 35 x 38. &nbsp;I had a wonderful time colour &nbsp;planning it with loads of colour and textured wool,from my stash. &nbsp;As with all my big hooked pieces, this was finished off with cording and tapestry yarn to give it a nice finished edge. &nbsp;It comes with a letter that covers how to care for the rug, &nbsp;and its value for insurance. &nbsp;Comstock is a Lib Callaway design. &nbsp;The pattern is available via my website New Earth Designs for a one time use to make your own rug.</p>
273782 <p>Bernie's pot has a very sunny, warm look. &nbsp;I made this rug in 1990 with hand hooked wool strips on a burlap base. &nbsp;Its vivid warmth brightens up the room it is currently hanging in. &nbsp;Before we moved 4 years ago, this rug was just one more in a vast pile of completed rugs. &nbsp;It had not been hung or used. &nbsp;It measures 22 x 34. &nbsp; &nbsp;As with all my big hooked pieces, this was finished off with cording and tapestry yarn to give it a nice finished edge. &nbsp;It comes with a letter that covers how to care for the rug, &nbsp;and its value for insurance. &nbsp;Bernies pot is a &nbsp;Yankee&nbsp;&nbsp;Peddlar&nbsp;design. &nbsp;</p>
273807 <p>The potting shed is a wall hanging that provides a "fool the eye" look to your room! &nbsp;I made this hanging in about 1990, with hand hooked wool strips on a burlap &nbsp;base, and is backed with a velveteen type fabric. &nbsp;It measures 20 x 30. &nbsp; As with all my big hooked pieces, this was finished off with cording and tapestry yarn to give it a nice finished edge. &nbsp;It comes with a letter that covers how to care for the rug, &nbsp;and its value for insurance. &nbsp;Potting Shed is a copyrighted design, to which I own the rights. &nbsp;The pattern is available via my website New Earth Designs for a one time use to make your own rug.</p>
273809 <p>The name of the design is Fantail Turkey, but he's such a colourful bird that I named him LibIRDace when I was hooking his feathers! &nbsp; I made this rug with hand hooked wool strips on a linen base. &nbsp;He would love to be in view for Thanksgiving, but he would be equally happy on the floor or wall. . perhaps in a den or man cave. &nbsp; It measures 21 x 34. &nbsp;It was fun to hook on, and I love that the bright wools in his feathers are rather subtle from a distance. &nbsp; I used a lot of textured wools, that I dyed. &nbsp;As with all my big hooked pieces, this was finished off with cording and tapestry yarn to give it a nice finished edge. &nbsp;It comes with a letter that covers how to care for the rug, &nbsp;and its value for insurance. &nbsp;Fantail Turkey is a copyrighted Lib Callaway design, to which I own the rights. &nbsp;The pattern is available via my website New Earth Designs for a one time use to make your own rug.</p>
273917 <p>Mini note card assortment packs. . . each unique and different. &nbsp;Each pack contains the same amount of card stock, but will contain an assortment of mini sizes, from 12 cards to 24. &nbsp;I will choose for you. &nbsp;Perfect for thank you's, gift cards, lunchbox notes, stocking stuffers, whenever you need just to jot a little message. &nbsp;</p>
274014 <p>2 pair of hand knit felted cozy boot style slippers. &nbsp;These are about 8.5 to 9.5 for size; they are loose on my 8.5 narrow foot. &nbsp; They are made of 100 % wool yarn. &nbsp;The earth toned slippers have a little glitz on the top. &nbsp;The earth toned slippers measure about 10.5", the striped pair about 11.5. &nbsp;They are thicker than plain knitted.<br>If &nbsp;they should need cleaning, do not machine wash or use hot or cold water! &nbsp;They will change size if you do. &nbsp;A gentle hand wash in warm water is best. &nbsp;Please check your foot size against the measurement to make sure before ordering, as normally I do not take returns But do let me know if there is a problem, as there are exceptions.</p> <p></p>
274052 <p>These bright and cheerful slippers are hand knit in wool yarn, then gently felted. &nbsp; On one pair, &nbsp;I have added a decorative wood button, which has also has a touch of glue on the thread for security. The foot length is 6". &nbsp;For age about 2-5 months. &nbsp;A wonderful baby shower gift; no need to wrap as each pair comes in an organza gift bag!<br>As these are made from soft and cozy wool, gentle hand washing in tepid water is recommended to avoid shrinking. Squeeze dry in a towel, then air dry.</p> <p></p>
274054 <p>These bright and cheerful moccasins for preemies and newborn are hand knit in wool yarn, then gently felted. &nbsp; The soles and trim are in a contrasting color, and &nbsp;I have added a decorative wood button, which has also has a touch of glue on the thread for security. The foot length is about 3 1/2 to 4". &nbsp; &nbsp;A wonderful baby shower gift; no need to wrap as each pair comes in an organza gift bag!<br>As these are made from soft and cozy wool, gentle hand washing in tepid water is recommended to avoid shrinking. Squeeze dry in a towel, then air dry.</p><p></p>
274149 <p>A sweet little bunny hooked rug, perfect for a nursery or wherever you choose. &nbsp;Although I made it some years ago, like many I make this has never been used, and can be hung or placed on the floor. &nbsp;It's a&nbsp;&nbsp;Yankee Peddlar pattern, and I made it using my hand dyed wool material, cut into strips and hooked. &nbsp;</p>
274159 <p>A very antique look hand hooked rug, made from an old design, and hooked using my hand dyed wool. &nbsp;It is signed and dated. &nbsp; It has not been used. . . just made and added to the others I've made. &nbsp;It measures 19 x 34 and colours are various purples, blues and rose. &nbsp;It has a nice primitive look to it. &nbsp; Directions for taking care of it will be included. &nbsp;It can be hung on the wall, or used on the floor.</p>
274290 <p></p> <p>From a New Earth Designs pattern, I hooked this floral bellpull in lavenders, pinks, roses and greens. &nbsp;A piece like this is shaded. . . uses narrow cut wool strips. . about 4/32" wide with each colour being in a range of values. &nbsp;So, it is much like painting. I used an antique black mix of colours for the background. &nbsp;Then, it was professional backed with a mauve material and attached to the wooden "hardware" top and bottom (not included in finished size of 8 x 48). &nbsp;Occasionally it was brought out and hung for a few weeks at a time in my studio. &nbsp;(A bell is not attached, as I had curious cats!)<br>Bellpulls are wonderful to hang in narrow but long wall spaces to add colour and interest. . .and do attach a bell to ring, if you want hubby to make you a cup of cocoa!</p>
276772 <p>These bright and cheerful infant slippers are hand knit in a self striping wool yarn. &nbsp;This yarn creates a bit of interest in subtle color changes. &nbsp;I have added a decorative wood &nbsp;button, which has also has a touch of glue on the thread for security. &nbsp;The foot length is about 3", with a bit of give; fits on average, preemie to 2 months. &nbsp;A wonderful baby shower gift; no need to wrap as each pair comes in an organza gift bag!<br>As these are made from soft and cozy wool, gentle hand washing in tepid water is recommended to avoid shrinking. &nbsp;Squeeze dry in a towel, then air dry.</p> <p></p>
276798 <p>Offered here is a 19 x 49 hand hooked folky rug "Main Street", &nbsp;a copyrighted Lib Callaway design, which I own the rights to. &nbsp;I hooked it using my hand dyed wools, &nbsp;in 1990. &nbsp; &nbsp;This rug has never been used and so is in excellent condition. &nbsp;It is signed and dated; my initials are in the flag, and the clock is set at 9 for 1990. &nbsp;It would look great on a wall!</p>
277121 <p>Christmas mini note card assortment packs. . . each unique and different. &nbsp;Each pack contains the same amount of card stock, but will contain an assortment of mini sizes, from 12 cards to 24. &nbsp;I will choose for you. &nbsp;Perfect for thank you's, gift cards, lunchbox notes, stocking stuffers, whenever you need just to jot a little message. &nbsp;</p>
285487 <p>Offered here is a 30 x 54 hand hooked garden vegetable runner that I designed and hooked using my hand dyed wool. &nbsp;This particular piece has not been used and is in excellent condition. &nbsp;It has a saying going down the long sides. . ."plant your seeds all in a row, one for the birds and one to grow."<br>Perfect for a country kitchen!</p>
285573 <p>Offered here is a 23 x 35 hand hooked floral wide cut rug "Spring Fever", that I &nbsp;designed and hooked using my hand dyed wool, &nbsp;in 1994, signed and dated. &nbsp;This particular piece has not been used except for exhibits, and is in excellent condition, having been kept rolled up on a shelf with others. &nbsp;All hooked pieces are steam pressed before shipping.</p>
287053 <p>Offered here is a 10 x 20 hand hooked patriotic mat "Home of &nbsp;Brave", that I designed and hooked using my hand dyed wool. &nbsp;It's been a popular pattern, and available thru me. This particular piece has been hung on the wall for occasional holiday use and thus is in excellent condition. &nbsp;It will be steam pressed before it is mailed.<br>I teach at home as well as at several schools yearly. It's a busy life, but fun and colourful! Also, i own 2 businesses, New Earth Designs and Lib Callaway designs, both are copyrighted patterns for traditional rug hooking, so i spend a fair bit of time printing patterns too.<br>In over 50 years of hooking, I've accumulated (as well as gifted and sold) a lot pf pieces. . .It's time to pare down and let other people enjoy these.</p> <p></p>
291359 <p></p> <p>Here is hand hooked shoulder bag, of a primitive flower basket. &nbsp;It was hooked using my hand dyed wool fabric, cut into strips. &nbsp;I made this several years ago, and had it professionally sewn and lined with matching floral fabric.<br>Although it was briefly displayed at a few fairs . . . it was never &nbsp;used and was kept neatly put away. I love the bag's fabric. . . sort of a dusty mauve.<br>A great gift for a gardening friend.<br>It measures &nbsp;13 across by 15 down. &nbsp;The handle is a sturdy strap type.</p>
333844 <p>2 pair of hand knit felted cozy boot style slippers. &nbsp;These are about 8.5 to 9.5 for size; they are loose on my 8.5 narrow foot. &nbsp; They are made of 100 % wool yarn. &nbsp;The earth toned slippers have a little glitz on the top. &nbsp;The earth toned slippers measure about 10.5", the striped pair about 11.5. &nbsp;They are thicker than plain knitted.<br>If &nbsp;they should need cleaning, do not machine wash or use hot or cold water! &nbsp;They will change size if you do. &nbsp;A gentle hand wash in warm water is best. &nbsp;Please check your foot size against the measurement to make sure before ordering, as normally I do not take returns But do let me know if there is a problem, as there are exceptions.</p> <p></p>
340444 <p>2 pair of hand knit felted cozy boot style slippers. &nbsp;These are about 8.5 to 9.5 for size; they are loose on my 8.5 narrow foot. &nbsp; They are made of 100 % wool yarn. &nbsp;The earth toned slippers have a little glitz on the top. &nbsp;The earth toned slippers measure about 10.5", the striped pair about 11.5. &nbsp;They are thicker than plain knitted.<br>If &nbsp;they should need cleaning, do not machine wash or use hot or cold water! &nbsp;They will change size if you do. &nbsp;A gentle hand wash in warm water is best. &nbsp;Please check your foot size against the measurement to make sure before ordering, as normally I do not take returns But do let me know if there is a problem, as there are exceptions.</p> <p></p>
345724 <p>2 pair of hand knit felted cozy boot style slippers. &nbsp;These are about 8.5 to 9.5 for size; they are loose on my 8.5 narrow foot. &nbsp; They are made of 100 % wool yarn. &nbsp;The earth toned slippers have a little glitz on the top. &nbsp;The earth toned slippers measure about 10.5", the striped pair about 11.5. &nbsp;They are thicker than plain knitted.<br>If &nbsp;they should need cleaning, do not machine wash or use hot or cold water! &nbsp;They will change size if you do. &nbsp;A gentle hand wash in warm water is best. &nbsp;Please check your foot size against the measurement to make sure before ordering, as normally I do not take returns But do let me know if there is a problem, as there are exceptions.</p> <p></p>
393245 <p>2 pair of hand knit felted cozy boot style slippers. &nbsp;These are about 8.5 to 9.5 for size; they are loose on my 8.5 narrow foot. &nbsp; They are made of 100 % wool yarn. &nbsp;The earth toned slippers have a little glitz on the top. &nbsp;The earth toned slippers measure about 10.5", the striped pair about 11.5. &nbsp;They are thicker than plain knitted.<br>If &nbsp;they should need cleaning, do not machine wash or use hot or cold water! &nbsp;They will change size if you do. &nbsp;A gentle hand wash in warm water is best. &nbsp;Please check your foot size against the measurement to make sure before ordering, as normally I do not take returns But do let me know if there is a problem, as there are exceptions.</p> <p></p>