SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    6918, 6919, 6920, 6921, 6922, 6923, 6924, 
    6925, 6926, 6927, 6928, 6929, 6930, 
    6931, 6932, 6933, 6934, 6935, 6936, 
    6937, 6938, 6939, 6940, 6941, 6942, 
    6943, 6944, 6945, 6946, 6947, 6948, 
    6949
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00085

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "table": {
      "table_name": "q_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (6918,6919,6920,6921,6922,6923,6924,6925,6926,6927,6928,6929,6930,6931,6932,6933,6934,6935,6936,6937,6938,6939,6940,6941,6942,6943,6944,6945,6946,6947,6948,6949)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
6918 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 15.6" laptop to school, the office or the local cafe.</p>
6919 <ul><li>Form-fitting sleeve ensures a precise fit for your laptop or MacBook with up to a 13.3" screen</li> <li>A seamless wrap of Impact Foam padding provides top to bottom protection</li> <li>Woven webbing along each side adds subtle texture to the clean design</li> <li>Slimline case protects your device on its own or in your favorite bag</li> <li>Available in a variety of fresh colors to fit any personality</li> </ul><p>A traditional sleeve complete with protective foam padding and sophisticated, stylish details.</p>
6920 <ul><li>Compatible with most compact camcorders & CSC cameras.</li> <li>Semi-rigid, molded EVA case safeguards your camcorder and accessories.</li> <li>Angled camcorder pocket is designed for simple, speedy retrieval.</li> <li>Detachable, adjustable shoulder strap and grab handle for easy transport.</li> </ul><p>A grooved, shock-absorbing front panel protects compact camcorders from everyday abuse. Unzip the main compartment to slide your camcorder into the tailored, padded interior pocket where you can be assured it will remain secure.</p>
6921 <ul class="bullet"><li>Compatible with most SLRs with a zoom lens.</li> <li>Patent pending hammock system suspends your SLR above the bottom of case, providing superior impact protection.</li> <li>Memory foam on interior helps protect your delicate LCD screen.</li> <li>Three zippered pockets store accessories.</li> <li>Water-proof EVA base withstands the elements and allows the case to stand up on its own.</li> <li>Removable, padded shoulder strap.</li> </ul>
6922 <ul><li>Compatible with 1 action camera, such as GoPro, attachments sized up to a 3-way, remote control and other accessories.</li> <li>Protect camera by separating accessories with adjustable, padded divider wall.</li> <li>Zippered pocket and mesh pouches store accessories and attachments.</li> <li>Water-resistant DuraBase offers protection and stability from the ground up.</li> <li>Organization panel provides storage for cords, SD cards, manual and other small accessories.</li> <li>Dual zippers on the main compartment designed to fit a luggage lock for extra security.</li> <li>Top grab handle for easy transport.</li> </ul><p>A rugged, protective case designed to keep up with your adventurous side. Fits a GoPro, 3-way, remote control, mounts and accessories.</p>
6923 <ul><li>Files remain crisp and unbent in their designated pocket separated from your electronics</li> <li>Front pocket stores bulky power cords neatly in the bottom and out of the way</li> <li>Organizer panel in front pocket with dedicated storage for an external hard drive pens and other accessories</li> <li>Zippered front pocket keeps your smartphone secure yet easily accessible</li> <li>Comfortable removable shoulder strap and padded handle for easy portability</li> </ul>
6924 A Modern Take on Pure Practicality, This Slim Case Holds a 15.6'' Laptop and I Pad Plus Your Daily Must-Haves. Room at The Bottom for A Power Adapter and An Exterior Smartphone Pocket Round out The Reasons This Will Be Your Weekday Go-To<br /><ul><li>Files Remain Crisp and Unbent in Their Designated Pocket, Separated from Your Electronics.</li> <li>Front Pocket Stores Bulky Power Cords Neatly in The Bottom and Out of The Way.</li> <li>Organizer Panel in Front Pocket with Dedicated Storage for An External Hard Drive, Pens and Other Accessories.</li> <li>Zippered Front Pocket Keeps Your Smartphone Secure yet Easily Accessible.</li> <li>Comfortable, Removable Shoulder Strap and Padded Handle for Easy Portability.</li> </ul><p> </p>
6925 <ul class="bullet"><li>Fully Customizable Storage Protects a Variety of Dslr and Drone Equipment Plus Accessories.</li> <li>Compatible with Drones up To 320 X 280 X 100 Mm Including Dji Mavic Pro, Dji Mavic Spark, Yuneec Breeze.</li> <li>Dedicated Slip Pocket for An I Pad/10.1" Tablet.</li> <li>Secure Tripod Attachment with Adjustable Strap.</li> <li>Exterior Pockets Organize Camera Accessories and Personal Items.</li> <li>Zippered Lid Pocket Provides Storage for Personal Items.</li> <li>Mesh Side Pocket Stores a Water Bottle.</li> <li>Durable Exterior Constructed of 1680 D Polyester.</li> </ul>
6926 <ul class="bullet"><li>Fits a Mirrorless Camera with Kit Lens.</li> <li>Adjustable, Padded Divider Provides Custom Protection.</li> <li>Front Zippered Pocket Keeps Accessories Secure yet Accessible.</li> <li>Mesh Side Pockets Conveniently Store a Lens Cap and Small Accessories.</li> <li>Removable, Adjustable Shoulder Strap, Comfortable Grab Handle and Belt Loops Provide Multiple Carry Options.</li> <li>Internal Memory Card Pouch.</li> <li>Durable Exterior Constructed of 1680 D Polyester.</li> </ul>
6927 <ul class="bullet"><li>Fits a DSLR camera with kit lens.</li> <li>Adjustable, padded divider provides custom protection.</li> <li>Front zippered pocket keeps accessories secure yet accessible.</li> <li>Internal zippered pocket and secure memory card pouches.</li> <li>Mesh side pockets conveniently store a lens cap and small accessories.</li> <li>Removable, adjustable shoulder strap, comfortable grab handle and belt loops provide multiple carry options.</li> <li>Durable exterior constructed of 1680D polyester.</li> </ul>
6928 <ul class="bullet"><li>Fits a Dslr Camera with Lens and Accessories.</li> <li>Adjustable, Padded Dividers Provide Custom Protection.</li> <li>Front Zippered Pocket with Mesh Slip Pockets Keeps Accessories Secure yet Accessible.</li> <li>Internal Zippered Pocket and Secure Memory Card Pouches.</li> <li>Mesh Side Pockets Conveniently Store a Lens Cap and Small Accessories.</li> <li>Removable, Adjustable Shoulder Strap, Comfortable Grab Handle and Belt Loops Provide Multiple Carry Options.</li> <li>Durable Exterior Constructed of 1680 D Polyester.</li> </ul>
6929 <ul class="bullet"><li>Padded Laptop Compartment Provides Quality Protection.</li> <li>Protective I Pad or 10.1 Inch Tablet Storage.</li> <li>Zippered Accessory Storage with Slip Pockets.</li> <li>Cord Organization Loop Provides Convenient In-Case Charging Capability.</li> <li>Separate File Compartment Stores Folders, Magazines and Loose Papers.</li> <li>Removable, Padded Shoulder Strap.</li> <li>Convenient Carry Handles.</li> <li>Luggage Strap Securely Attaches Slim Case to Most Rolling Luggage.</li> </ul>
6930 <ul class="bullet"><li>Padded Laptop Compartment Provides Quality Protection.</li> <li>Protective I Pad or 10.1 Inch Tablet Storage.</li> <li>Additional Storage Compartment Keep Daily Essentials Separate from Hardware.</li> <li>Zippered Accessory Storage with Slip Pockets.</li> <li>Cord Organization Loop Provides Convenient In-Case Charging Capability.</li> <li>Removable, Padded Shoulder Strap.</li> <li>Convenient Carry Handles.</li> <li>Luggage Strap Securely Attaches Slim Case to Most Rolling Luggage.</li> </ul>
6931 <ul class="bullet"><li>Designed to fit an SLR camera with standard zoom lens attached.</li> <li>Side zippered pockets store an extra battery, cables, lens cap, or small accessories.</li> <li>Lid unzips to create a wide opening for easy, quick access to the grip of your camera.</li> <li>Padded base protects your camera and lens.</li> <li>Internal zippered pocket stores memory cards, a lens cloth and small accessories.</li> <li>Integrated belt loop, padded handle and removable shoulder strap offer multiple carrying options.</li> </ul>
6932 <ul><li><span>Rich Material Clean Lines and Stylish Accents Give Professional Laptop Sleeves a New Standard.</span></li> <li><span>USB Pen Key Flash Drives Slim Line Case Protects Your Device on Its Own or In Your Favorite Bag.</span></li> <li><span class="a-list-item">Fits Device Dimensions: 13.8 X 1.2 X 11.4" (lx Wx H).</span></li> <li><span class="a-list-item">Spacious Front Pocket Stores Accessories and A Power Brick.</span></li> <li><span class="a-list-item">Dual Zipper Pulls Open Wide for Smooth, Quick Access.</span></li> <li><span class="a-list-item">Glossy Nylon Twill, Metal Rivet Accents and Unique Thread Detail Create a Refined, Professional Style.</span></li> </ul>
6933 <ul class="bullet"><li>Padded Storage for A Laptop up To 11.6".</li> <li>Dedicated Slip Pocket for A 10.5" Tablet.</li> <li>Quick-Access Front Pocket Stores a Phone and Small Accessories.</li> <li>Removable, Padded Shoulder Strap Adjusts for A Custom Fit.</li> <li>Padded Carry Handles Ensure Comfortable Transport.</li> <li>Luggage Strap Securely Attaches Slim Case to Most Rolling Luggage.</li> <li>Melange Fabric, Copper Touchpoints and Trim Details Create a Modern Professional Look.</li> </ul>
6934 <ul class="bullet"><li>Padded storage for a laptop up to 14".</li> <li>Dedicated slip pocket for a 10.5" tablet.</li> <li>Quick-access front pocket stores a phone and small accessories.</li> <li>Removable, padded shoulder strap adjusts for a custom fit.</li> <li>Padded carry handles ensure comfortable transport.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Melange fabric, copper touchpoints and trim details create a modern professional look.</li> </ul>
6935 <ul class="bullet"><li>Thickly Padded Storage for A Laptop up To 15.6".</li> <li>Dedicated Slip Pocket for A 10.5" Tablet.</li> <li>Spacious Main Compartment Stores Notebooks, Headphones and Other Bulky Items.</li> <li>Additional Compartment with Organization Panel and Volume for Power Brick Storage.</li> <li>Quick Access Front Pocket with Organization for Small Electronics.</li> <li>Two Side Pockets for Water Bottles or Go-To Items.</li> <li>Luggage Strap Securely Attaches Bag to Most Rolling Luggage.</li> <li>Elastic Strap Management Loops Neatly Secure Excess Strap Material.</li> <li>Melange Fabric, Copper Touchpoints and Trim Details Create a Modern Professional Look.</li> </ul>
6936 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 11.6" laptop to school, the office or the local cafe.</p>
6937 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 14" laptop to school, the office or the local cafe.</p>
6938 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 15" laptop to school, the office or the local cafe.</p>
6939 <ul><li>Removable Shoulder Strap Adjusts for A Custom Fit.</li> <li>Luggage Strap Securely Attaches Slim Case to Most Rolling Luggage.</li> <li>Dedicated I Pad or 10.1" Tablet Compartment.</li> <li>Multiple Zippered Pockets Store Accessories.</li> <li>Durable Polyester Material Withstands Your Ever-Changing Schedule.</li> </ul><p>Slim Attache with Heathered Fabric Is Perfect for Protecting and Transporting Your 15.6" Laptop to School, the Office or The Local Cafe.</p>
6940 <ul><li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag.</li> <li>Durable Polyester Material Withstands Your Ever-Changing Schedule.</li> <li>3/4 Zipper Opens Wide for Easy Access.</li> </ul><p>Correlating textures and playful color accents give this protective laptop sleeve a stylish edge.</p>
6941 <ul><li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag.</li> <li>Durable Polyester Material Withstands Your Ever-Changing Schedule.</li> <li>3/4 Zipper Opens Wide for Easy Access.</li> </ul><p>Correlating Textures and Playful Color Accents Give This Protective Laptop Sleeve a Stylish Edge.</p>
6942 <ul class="bullet"><li>Form fitting sleeve ensures a precise fit for your laptop or MacBook with up to a 13 point 3 inch screen</li> <li>A seamless wrap of Impact Foam padding provides top to bottom protection</li> <li>Woven webbing along each side adds subtle texture to the clean design</li> <li>Slimline case protects your device on its own or in your favorite bag</li> <li>Available in a variety of fresh colors to fit any personality</li> </ul>
6943 <ul class="bullet"><li>Form-Fitting Sleeve Ensures a Precise Fit for Your Laptop or Mac Book with Up to A 13.3 Inch Screen.</li> <li>A Seamless Wrap of Impact Foam Padding Provides Top to Bottom Protection.</li> <li>Woven Webbing Along Each Side Adds Subtle Texture to The Clean Design.</li> <li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag.</li> <li>Available in A Variety of Fresh Colors to Fit Any Personality.</li> </ul>
6944 <ul class="bullet"><li>Form Fitting Sleeve Ensures a Precise Fit for Your Laptop or Mac Book with Up to A 13 Point 3 Inch Screen</li> <li>A Seamless Wrap of Impact Foam Padding Provides Top to Bottom Protection</li> <li>Woven Webbing Along Each Side Adds Subtle Texture to The Clean Design</li> <li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag</li> <li>Available in A Variety of Fresh Colors to Fit Any Personality</li> </ul>
6945 <ul class="bullet"><li>Sleeve Designed to Fit a  14 Inches Laptop Plus Dedicated Pocket for 10 Inches Tablet</li> <li>Dual Density Foam Padding Cushions the Exterior and Prevents Internal Scratching</li> <li>Slimline Case Protects Your Portable Electronics While Minimizing Bulk</li> <li>Compact Design Allows This Case to Fit Easily Into Any Bag</li> <li>Stylish and Trendy Exterior to Express Your Personality</li> </ul>
6946 <ul><li>Molded Eva Sleeve Holds a Laptop with Up to A 11 Inches Screen</li> <li>An Assortment of Colors and A Unique Seat Belt Style Keep You Looking Good While on The Move</li> <li>Thick Quilted Padding Keeps Your Device Protected and Snugly in Place to Prevent It from Sliding Around</li> <li>Clam Shell Design and Integrated Airflow Channels Allow You to Use Your Laptop While Still in The Sleeve without The Risk of Overheating</li> <li>Padded Carry Handles for Comfortable Transportation</li> </ul>
6947 <ul><li>Molded Eva Sleeve Holds a Laptop with Up to A 13.3" Screen.</li> <li>An Assortment of Colors and A Unique Seatbelt Style Keep You Looking Good While on The Move.</li> <li>Thick, Quilted Padding Keeps Your Device Protected and Snugly in Place to Prevent It from Sliding Around.</li> <li>Clamshell Design and Integrated Airflow Channels Allow You to Use Your Laptop While Still in The Sleeve without The Risk of Overheating.</li> <li>Padded Carry Handles for Comfortable Transportation.</li> </ul><p>The Sleek Shape of This Molded EVA Case Provides Slimline Protection for 13.3" Laptops without Sacrificing Style or Design.</p>
6948 <ul><li>Compatible with Most Sl Rs with A Zoom Lens</li> <li>Patent Pending Hammock System Suspends Your Slr Above the Bottom of The Case, Providing Superior Impact Protection</li> <li>Memory Foam on Interior Helps Protect Your Delicate Lcd Screen</li> <li>Three Zippered Pockets Store Accessories</li> <li>Water-Proof Eva Base Withstands the Elements and Allows the Case to Stand up On Its Own</li> <li>Removable, Padded Shoulder Strap</li> </ul><p>This Tough and Ready Slr Holster Was Designed to Keep Pace with Your Approach to Photography. Rugged Styling with A Professional Grade Interior and Organization Will Take You Anywhere the Shots Are Waiting.</p>
6949 <ul><li>Compatible with Most Sl Rs with A Zoom Lens.</li> <li>Patent Pending Hammock System Suspends Your Slr Above the Bottom of The Case, Providing Superior Impact Protection.</li> <li>Memory Foam on Interior Helps Protect Your Delicate Lcd Screen.</li> <li>Three Zippered Pockets Store Accessories.</li> <li>Water-Proof Eva Base Withstands the Elements and Allows the Case to Stand up On Its Own.</li> <li>Removable, Padded Shoulder Strap.</li> </ul><p>This Tough and Ready Slr Holster Was Designed to Keep Pace with Your Approach to Photography. Rugged Styling with A Professional Grade Interior and Organization Will Take You Anywhere the Shots Are Waiting.</p>