SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    4718, 4793, 4754, 4691, 4823, 4878, 4832, 
    4722, 4719, 4717, 4716, 4701, 4714, 
    4702, 4712, 4709, 4707, 4711, 4708, 
    4704, 4703, 6114, 4705, 4710
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4718,4793,4754,4691,4823,4878,4832,4722,4719,4717,4716,4701,4714,4702,4712,4709,4707,4711,4708,4704,4703,6114,4705,4710)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4691 <p>1800 mAh Li-Ion battery for RLN6544 and RLN6561 wireless speaker microphone. </p> APX 3000 Battery, APX 6000XE Battery, APX 7000 Battery, APX 6000 Battery, APX 4000XE Battery, APX 4000 Battery, APX 3000 Battery, APX 4000 Battery, APX 4000XE Battery, APX 6000 Battery, APX 6000XE Battery, APX 7000 Battery, APX 7000XE Battery, APX 1500 Battery, APX 4500 Battery, APX 6500 Battery, APX 7500 Battery, XPR 4350 Battery, XPR 4380 Battery, XPR 4550 Battery, XPR 4580 Battery, XPR 5350 Battery, XPR 5380 Battery, XPR 5550 Battery, XPR 5580 Battery, APX 7000XE; Batteries
4701 <p>Replacement Dual Unit Charger </p> APX 3000 Bluetooth Accessory, XPR 5580 Bluetooth Accessory, XPR 5550 Bluetooth Accessory, XPR 5380 Bluetooth Accessory, XPR 5350 Bluetooth Accessory, XPR 4580 Bluetooth Accessory, XPR 4550 Bluetooth Accessory, XPR 4380 Bluetooth Accessory, XPR 4350 Bluetooth Accessory, APX 7500 Bluetooth Accessory, APX 6500 Bluetooth Accessory, APX 4500 Bluetooth Accessory, APX 1500 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4702 <p>D Ring Swivel Clip (12 pack) </p> APX 3000 Bluetooth Accessory, APX 7500 Bluetooth Accessory, APX 6500 Bluetooth Accessory, APX 4500 Bluetooth Accessory, APX 1500 Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory
4703 <p>Covert Audio Kit for Mission Critical Wireless PTT Pod </p> APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4704 <p>Y-Adapter and Retention Hook for Mission Critical Wireless Push-to-Talk Pod </p> APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4705 <p>Accessory Kit, Completely Discreet Wireless Surveillance Kit </p> APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4707 <p>This mission-critical wireless push-to-talk pod offers a fast and flexible way to seamlessly and wirelessly connect with any earpiece connected to your radio. Whether a radio is under your coat or out of your reach, you can access it using your wireless PTT pod — just tuck it in a pocket or clip it on a jacket.</p><p>This PTT supports the fast push-to-talk central to Motorola's mission-critical wireless solutions, so you can be sure every word is heard and every word is secure.</p><p>This pod can operate as a standalone wireless PTT pod or can be ordered as part of the Completely Discreet Wireless Surveillance Kit or ordered to power the Mission Critical Wireless earbuds NNTN8294 or NNTN8295.</p> NTN2571A, APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, NTN-2571, NTN-2571A
4708 <p>This earpiece is designed specifically for first responders. Seamless, streamlined and encrypted with strong 128 bit keys. This lightweight earpiece can be worn comfortably for long shifts common in public safety and performs well in loud environments. </p> APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4709 <p>Swivel clip for Operations Critical and Enhanced Operations Critical Wireless pods</p> APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4710 APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4711 <p>Mission Critical Wireless Covert Pack-N-Go Kit, Basic. Kit includes: NNTN8296 Basic Mission Critical Wireless Covert Kit, NTN2571 Mission Critical Wireless Push-to-Talk (PTT) Pod and NNTN8442 Mission Critical Wireless Remote Control Unit </p> APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4712 <p>Mission Critical Wireless Covert Pack-N-Go Kit, Advanced. Kit includes: All contents of Covert Pack-n-Go Kit plus RLN4922 Completely Discreet Earpiece Kit and NNTN8385 Wireless Neckloop Y-adapter </p> APX 3000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory
4714 <p>Ear Straps (qty 10) for secure attachment to the ear</p> APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory
4716 <p>This wireless earbud has a simple, discreet design for business users wearing professional attire or for public safety users working undercover. This earbud has an inline microphone that is ideal for transmissions in loud environments and comes with 3 sizes of eartips for optimal comfort. The short coiled cord enables easy placement on a lapel or shirt pocket.</p><p>This earbud must be connected to the appropriate push-to-talk pod. Police officers and other first responders wanting a secure solution with fast pairing will need to order the (NTN2571), while professional users wanting a cost-effective wireless solution need to order (NNTN8127).</p> XPR 6100 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, NNTN-8294, NNTN-8294A
4717 <p>This wireless earbud has a simple, discreet design for business users wearing professional attire or for public safety users working undercover. This earbud has an inline microphone that is ideal for transmissions in loud environments and comes with 3 sizes of eartips for optimal comfort. The long cord gives you flexibility in where you clip the PTT on your belt or shirt pocket. </p><p>This earbud must be connected to the appropriate push-to-talk pod. Police officers and other first responders wanting a secure solution with fast pairing will need to order the (NTN2571), while professional users wanting a cost-effective wireless solution need to order (NNTN8127). </p> XPR 6100 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, NNTN-8295, NNTN-8295A
4718 XPR 6100 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, APX 3000 Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, XPR 6100 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth
4719 <p>1- Wire Surveillance kit with Translucent Acoustic tube for Wireless PTT Pods </p> XPR 6100 Bluetooth Accessory, SL7590 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory
4722 <p>Earpiece with 12" cable and push to talk pod. (For Enhanced Operations Critical Wireless with Touch Pairing) This earpiece is designed specifically for first responders. Seamless, streamlined and encrypted with strong 128 bit keys. This lightweight earpiece can be worn comfortably for long shifts common in public safety and performs well in loud environments. </p> NTN2570A, NTN2570B, XPR 6100 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, NTN-2570, NTN-2570A
4754 <p>Wireless RSM Vehicular Charger. Compatible with RLN6554.</p> APX 3000 Charger, XPR 5580 Charger, XPR 5580 Charger, XPR 5550 Charger, XPR 5380 Charger, XPR 5350 Charger, XPR 4580 Charger, XPR 4550 Charger, XPR 4380 Charger, XPR 4350 Charger, APX 7500 Charger, APX 6500 Charger, APX 4500 Charger, APX 1500 Charger, APX 7000XE Charger, APX 7000 Charger, APX 6000XE Charger, APX 6000 Charger, APX 4000XE Charger, APX 4000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Charger, APX 1500 Charger, APX 4500 Charger, APX 6500 Charger, APX 7500 Charger, XPR 4350 Charger, XPR 4380 Charger, XPR 4550 Charger, XPR 4580 Charger, XPR 5350 Charger, XPR 5380 Charger, XPR 5550 Chargers, RLN6554, RLN6554A, RLN-6554, RLN-6554A, PMLN-6716, PMLN-6716A
4793 <p>XBT HeadsetHB, Heavy Duty Headset , BT </p><p>*ONLY COMPATIBLE WITH APX MODELS WITH FULL KEYPAD. Minimum radio requirements: Code-Plug Version - R13.00.01 Firmware - R13.00.05 Option Board - R08.00.00 </p> RLN6491A, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE Headset, XPR 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 6580 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headset, XPR 5350 Headset, XPR 5380 Headset, XPR 5550 Headset, XPR 5580 Headsets/Lapel Mics/Surveillance Kits
4823 <p>Mission-Critical wireless remote speaker microphone With battery and rotating clip for all APX Series radios.</p> APX 3000 Speaker Mic, APX 4000 Speaker Mic, XPR 5580 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Mic, APX 1500 Speaker Mic, APX 4500 Speaker Mic, APX 6500 Speaker Mic, APX 7500 Speaker Mic, XPR 4350 Speaker Mic, XPR 4380 Speaker Mic, XPR 4550 Speaker Mic, XPR 4580 Speaker Mic, XPR 5350 Speaker Mic, XPR 5380 Speaker Mic, XPR 5550 Speaker Microphones
4832 <p>Compatible with APX radios, this APX accessory is a wireless remote speaker microphone with battery, clip and dual unit charger.</p> APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 3000 Speaker Mic, APX 7000XE Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Microphones, RLN-6554, RLN-6554A, RLN 6554
4878 APX 1000 Headset, APX 7000XE Headset, APX 7000XE Headset, APX 7000 Headset, APX 6000XE Headset, APX 6000 Headset, APX 4000XE Headset, APX 4000 Headset, APX 3000 Headset, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headsets/Lapel Mics/Surveillance Kits
6114 <p>The Motorola Critical Wireless Bluetooth Audio Earpiece has 2 operation modes, LMR and WAVE 5000. It is designed to allow you the convenience of Bluetooth technology by enabling you to comfortably wear it for long periods of time. This Bluetooth earpiece is exclusively designed with PTT functionality for bluetooth radio applications and optimized to work with Motorola Solutions two-way radios and WAVE OnCloud applications. </p> TLK100, TLK 100, TLK-100, TLK100 earpiece, WAVE earpiece, TLK bluetooth, WAVE bluetooth, bluetooth earpiece