SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    4970, 4963, 4974, 4978, 4956, 4962, 4959, 
    12457, 11777, 12268, 12270, 12271, 
    12272, 12275, 12276, 12255, 12257, 
    12258, 12259, 12260, 12261, 12262, 
    12269, 12263, 12264, 12265, 12266, 
    12267, 12273, 12274
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00067

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": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4970,4963,4974,4978,4956,4962,4959,12457,11777,12268,12270,12271,12272,12275,12276,12255,12257,12258,12259,12260,12261,12262,12269,12263,12264,12265,12266,12267,12273,12274)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
4956 <p><br /></p> <ul><li><span class="a-list-item">21.5-inch (diagonal) 4096-by-2304 Retina 4K display</span></li><li><span class="a-list-item">3.6GHz quad-core 8th-generation Intel Core i3</span></li><li><span class="a-list-item">AMD Radeon Pro 555X graphics</span></li><li><span class="a-list-item">Ultrafast SSD storage</span></li><li><span class="a-list-item">Two Thunderbolt 3 (USB-C) ports</span></li><li><span class="a-list-item">Four USB-A ports</span></li><li><span class="a-list-item">Gigabit Ethernet port</span></li><li><span class="a-list-item">FaceTime HD camera</span></li><li><span class="a-list-item">802.11ac Wi-Fi and Bluetooth 4.2</span></li><li><span class="a-list-item">iMac, Magic Keyboard, Magic Mouse 2, Power cord, Lightning to USB Cable</span></li></ul> <p></p>
4959 <table><tbody><tr><td><b>Brand</b></td><td><span class="a-size-base">Apple</span></td></tr><tr><td><b>CPU Model</b></td><td><span class="a-size-base">Core i5</span></td></tr><tr><td><br /></td><td></td></tr><tr><td><b>Ram Memory Installed Size</b></td><td><span class="a-size-base">8 GB</span></td></tr><tr><td><b>Model Name</b></td><td><span class="a-size-base">IMac</span></td></tr></tbody></table> <h1>About this item</h1> <ul><li><span class="a-list-item">27-inch (diagonal) 5120-by-2880 Retina 5K display</span></li><li><span class="a-list-item">3.1GHz 6-core 10th-generation Intel Core i5</span></li><li><span class="a-list-item">AMD Radeon Pro 5300 graphics</span></li><li><span class="a-list-item">Ultrafast SSD storage</span></li><li><span class="a-list-item">Two Thunderbolt 3 (USB-C) ports</span></li><li><span class="a-list-item">Four USB-A ports</span></li><li><span class="a-list-item">Gigabit Ethernet port</span></li><li><span class="a-list-item">1080p FaceTime HD camera</span></li><li><span class="a-list-item">802.11ac Wi-Fi and Bluetooth 5.0</span></li><li><span class="a-list-item">iMac, Magic Keyboard, Magic Mouse 2, Power cord, Lightning to USB Cable</span></li></ul>
4962 <table><tbody><tr><td><b>CPU Model</b></td><td><span class="a-size-base">Intel Xeon</span></td></tr><tr><td><b>Computer Memory Size</b></td><td><span class="a-size-base">128 GB</span></td></tr><tr><td><b>Ram Memory Installed Size</b></td><td><span class="a-size-base">128 GB</span></td></tr><tr><td><b>Graphics RAM Type</b></td><td><span class="a-size-base">VRAM</span></td></tr></tbody></table> <h1>About this item</h1> <ul><li><span class="a-list-item">Apple 27" iMac Pro with Retina 5K Display (Late 2017) - Magic Keyboard with Numeric Keypad (Space Gray) - Magic Mouse 2 (Space Gray) - Lightning to USB Cable - Power Cord - Apple 1 Year Warranty (90 Days Technical Support)</span></li><li><span class="a-list-item">Operating System: macOS</span></li><li><span class="a-list-item">Processor: Intel Xeon W 10-Core 3.0GHz (turbo 4.5GHz) 23.75MB cache</span></li><li><span class="a-list-item">Memory: 128GB DDR4 SDRAM 2666 MHz ECC</span></li><li><span class="a-list-item">Available Memory Slots: None</span></li></ul> <table><tbody><tr><th>Brand</th><td>Apple</td></tr><tr><th>Item model number</th><td>iMac Pro</td></tr><tr><th>Item Weight</th><td>41 pounds</td></tr><tr><th>Processor Brand</th><td>Intel</td></tr><tr><th>Processor Count</th><td>10</td></tr><tr><th>Computer Memory Type</th><td>DDR4 SDRAM</td></tr></tbody></table>
4963 <table><tbody><tr><td><b>Brand</b></td><td><span class="a-size-base">Apple</span></td></tr><tr><td><b>Operating System</b></td><td><span class="a-size-base">Mac OS</span></td></tr><tr><td><b>CPU Manufacturer</b></td><td><span class="a-size-base">Apple</span></td></tr><tr><td><b>Standing screen display size</b></td><td><span class="a-size-base">13 Inches</span></td></tr><tr><td><b>RAM</b></td><td><span class="a-size-base">8 GB</span></td></tr></tbody></table> <h1>About this item</h1> <ul><li><span class="a-list-item">MacBook Air 13.3" with Retina Display (Gold) - 30W USB Type-C Power Adapter - USB Type-C Charging Cable (6.56' / 2m) - Apple 1 Year Limited Warranty</span></li><li><span class="a-list-item">Retina display with True Tone</span></li><li><span class="a-list-item">1.1GHz quad-core 10th-generation Intel Core i3 processor, Turbo Boost up to 3.5GHz</span></li><li><span class="a-list-item">8GB 3733MHz LPDDR4X memory</span></li></ul> <p></p> <p></p>
4970 <p></p> <table><tbody><tr><td><b>Brand</b></td><td><span class="a-size-base">Apple</span></td></tr><tr><td><b>Operating System</b></td><td><span class="a-size-base">Mac OS</span></td></tr><tr><td><b>CPU Manufacturer</b></td><td><span class="a-size-base">Intel</span></td></tr><tr><td><b>Screen Size</b></td><td><span class="a-size-base">13 Inches</span></td></tr><tr><td><b>Computer Memory Size</b></td><td><span class="a-size-base">16 GB</span></td></tr></tbody></table> <h1>About this item</h1> <ul><li><span class="a-list-item">Tenth-generation quad-core Intel Core i5 processor</span></li><li><span class="a-list-item">Brilliant Retina display with True Tone technology</span></li><li><span class="a-list-item">Backlit Magic Keyboard</span></li><li><span class="a-list-item">Touch Bar and Touch ID</span></li><li><span class="a-list-item">Intel Iris Plus Graphics</span></li><li><span class="a-list-item">Ultrafast SSD</span></li><li><span class="a-list-item">Four Thunderbolt 3 (USB-C) ports</span></li><li><span class="a-list-item">Up to 10 hours of battery life</span></li><li><span class="a-list-item">802.11ac Wi-Fi</span></li><li><span class="a-list-item">Force Touch trackpad</span></li></ul>
4974
4978 <p><br /></p> <ul><li><span class="a-list-item">Ninth-generation 6-Core Intel Core i7 Processor</span></li><li><span class="a-list-item">Stunning 16-inch Retina Display with True Tone technology</span></li><li><span class="a-list-item">Touch Bar and Touch ID</span></li><li><span class="a-list-item">AMD Radeon Pro 5300M Graphics with GDDR6 memory</span></li><li><span class="a-list-item">Ultrafast SSD</span></li><li><span class="a-list-item">Intel UHD Graphics 630</span></li><li><span class="a-list-item">Six-speaker system with force-cancelling woofers</span></li><li><span class="a-list-item">Four Thunderbolt 3 (USB-C) ports</span></li><li><span class="a-list-item">Up to 11 hours of battery life</span></li><li><span class="a-list-item">802.11AC Wi-Fi</span></li></ul>
11777 <p>Please note This KIT is available on order the ETA will be 3-4 working days from date of purchase.</p>
12255 <p>HP 250 G8 Intel Celeron N4020 4GB DDR4 2400 1 DIMM 500GB 5400rpm Intel AC 1x1+BT 4.2 15.6 HD LCD NO OPTICAL DRIVE Mobile Intel Graphics Media Accelerator WINDOWS 10 Home Emerging Markets 64</p>
12257 <p>HP 250 G8 Intel Core i3 1005U 4GB DDR4 2666 1 DIMM 500GB 5400rpm Intel AC 1x1+BT 4.2 15.6 HD LCD NO OPTICAL DRIVE Mobile Intel Graphics Media Accelerator WINDOWS 10 Professional 64</p>
12258 <p>HP 250 G8 Intel Core i5 1035U 4GB DDR4 2666 1 DIMM 500GB 5400rpm Intel AC 1x1+BT 4.2 15.6 HD LCD Mobile NO OPTICAL DRIVE Intel Graphics Media Accelerator WINDOWS 10 Home Emerging Markets 64</p>
12259 <p>HP 250 G8 Intel Core i5 1035U 4GB DDR4 2666 1 DIMM 500GB 5400rpm Intel AC 1x1+BT 4.2 15.6 HD LCD NO OPTICAL DRIVE Mobile Intel Graphics Media Accelerator WINDOWS 10 Professional 64</p>
12260 <p>HP 250 G8 Intel Core i5 1135U 8GB DDR4 2666 1 DIMM 256GB PCIe NVMe Value Intel AC 1x1+BT 4.2 15.6 FHD LCD NO OPTICAL DRIVE Mobile Intel Graphics Media Accelerator WINDOWS 10 Professional 64</p>
12261 <p>HP 250 G8 , Intel® Core i5-1035G1 Processor (6M Cache, 1.0 GHz) , 15.6 HD SVA eDP anti-glare WLED-backlit slim (1366x768) , 4GB DDR4-2666 1DIMM - 2 SLOT / MAX 16GB , 1TB 5400RPM , No Optical drive , Intel® UHD Graphics , Windows® 10 Pro x64 , Realtek RTL8822CE 802.11a/b/g/n/ac (1x1) Wi-Fi® with Bluetooth® 4.2 Combo , No HSPA Module , (1) HDMI 1.4b, (1) USB Type-C 3.2 Gen1, (2) USB-A 3.2 Gen1, (1) RJ-45, (1) Headphone / Mic-in combo jack , 1 Year carry in warranty</p>
12262 <p>HP 250 G8 , Intel® Core i7-1065G7 Processor (8M Cache, 1.3 GHz) , 15.6 FHD SVA eDP anti-glare WLED-backlit slim (1920x1080) , 8GB DDR4-2666 1DIMM - 2 SLOT / MAX 16GB , 256GB PCIe NVMe Value , No Optical drive , Intel® Iris® Plus Graphics , Windows® 10 Pro x64 , Realtek RTL8822CE 802.11a/b/g/n/ac (1x1) Wi-Fi® with Bluetooth® 4.2 Combo , No HSPA Module , (1) HDMI 1.4b, (1) USB Type-C 3.2 Gen1, (2) USB-A 3.2 Gen1, (1) RJ-45, (1) Headphone / Mic-in combo jack , 1 Year carry in warranty</p>
12263 <p>HP ProBook 450 G8 Intel Core i3-1115 4GB DDR4 3200 1 DIMM 256GB PCIe NVMe SSD AC 2x2+BT 5 15.6 HD LCD NO OPTICAL DRIVE Mobile Intel® Graphics Media Accelerator WINDOWS 10 Professional 64 bit</p>
12264 <p>HP ProBook 450 G8 Intel Core i5-1135 4GB DDR4 3200 1DIMM 256GB PCIe NVMe SSD RT AC 2x2+BT 5 15.6 HD LCD NO OPTICAL DRIVE Mobile Intel® Graphics Media Accelerator WINDOWS 10 Professional 64</p>
12265 <p>HP ProBook 450 G8 Intel Core i5-1135 8GB DDR4 3200 1 DIMM 512GB PCIe NVMe IntelWiFi6AX201ax2x2MUMIMOnvP160MHz+BT5 Intel Graphics Media Accelerator 15.6 FHD LCD WINDOWS 10 Professional 64</p>
12266 <p>HP ProBook 450 G8 Intel Core i5-1135 8GB DDR4 3200 1 DIMM 512GB PCIe NVMe SSD Intel WiFi 6 AX201 ax 2x2 MU-MIMO nvP 160MHz + BT5 nVidia MX450 2GB Graphics 15.6 FHD LCD WINDOWS 10 Professional 64</p>
12267 <p>HP ProBook 450 G8 Intel Core i7-1165 8GB DDR4 2666 (2x4GB) 512GB PCIe NVMe Intel Wi-Fi 6 AX201 ax 2x2 MU-MIMO nvP +BT 5 nVidia MX450 2GB Graphics 15.6 HD LCD WINDOWS 10 Professional 64</p>
12268 <p>HP ProBook 440 G8 , Intel® Core i5-1135G7 Processor (8M Cache, up to 4.20 GHz) , 14" FHD UWVA eDP anti-glare, narrow bezel flat for HD camera (1920x1080) , 8GB DDR4-3200 2DIMM - 2 SLOT / MAX 32GB , 256GB PCIe NVMe Value , No Optical Drive , Intel® Iris® Xe Graphics , Windows® 10 Pro x64 , Intel® Dual Band Wi-Fi 6 AX201 802.11a/b/g/n/ac (2x2) WLAN and Bluetooth® 5 Combo , No HSPA Module , (1) HDMI 1.4b, (1) USB 3.1 Type-C, (3) USB 3.1 Gen1, (1) R-J45, (1) Headphone / Microphone Combo Jack , 1 Year carry in warranty</p>
12269 <p>HP ProBook 440 G8 , Intel® Core i7-1165G7 Processor (12M Cache, up to 4.7 GHz) , 14" FHD UWVA eDP anti-glare, narrow bezel flat for HD camera (1920x1080) , 8GB DDR4-3200 1DIMM - 2 SLOT / MAX 32GB , 512GB PCIe NVMe Value , No Optical Drive , Intel® Iris® Xe Graphics , Windows® 10 Pro x64 , Intel® Dual Band Wi-Fi 6 AX201 802.11a/b/g/n/ac (2x2) WLAN and Bluetooth® 5 Combo , No HSPA Module , (1) HDMI 1.4b, (1) USB 3.1 Type-C, (3) USB 3.1 Gen1, (1) R-J45, (1) Headphone / Microphone Combo Jack , 1 Year carry in warranty</p>
12270 <p>HP EliteBook 830 G8 , Intel® Core i5-1135G7 Processor (8M Cache, up to 4.20 GHz) , 13.3" FHD Bent, anti-glare UWVA eDP+PSR Low Power Ambient Light Sensor for HD+IR Camera for WWAN 4G (1920x1080) , 8GB DDR4-3200 1DIMM - 2 SLOT / MAX 64GB , 256GB PCIe NVMe Value , No Optical Drive , Intel® Iris® Xe Graphics , Windows® 10 Pro x64 , Intel® Dual Band Wi-Fi 6 AX201 802.11a/b/g/n/ac (2x2) WLAN and Bluetooth® 5 Combo , No HSPA Module , (2) USB 3.1 Gen 1, (2) Thunderbolt 4 , (1) HDMI 2.0b, (1) Headphone/Microphone combo port , 3 Year carry in warranty</p>
12271 <p>HP EliteBook 830 G8 , Intel® Core i7-1165G7 Processor (12M Cache, up to 4.7 GHz) , 13.3" FHD Bent, anti-glare UWVA eDP+PSR Low Power Ambient Light Sensor for HD+IR Camera for WWAN 4G (1920x1080) , 8GB DDR4-3200 1DIMM - 2 SLOT / MAX 64GB , 256GB PCIe NVMe Value , No Optical Drive , Intel® Iris® Xe Graphics , Windows® 10 Pro x64 , Intel® Dual Band Wi-Fi 6 AX201 802.11a/b/g/n/ac (2x2) WLAN and Bluetooth® 5 Combo , No HSPA Module , (2) USB 3.1 Gen 1, (2) Thunderbolt 4 , (1) HDMI 2.0b, (1) Headphone/Microphone combo port , 3 Year carry in warranty</p>
12272 <p>HP EliteBook 830 G8 , Intel® Core i7-1165G7 Processor (12M Cache, up to 4.7 GHz) , 13.3" FHD Bent, anti-glare UWVA eDP+PSR with HP Sure View, Ambient Light Sensor for HD+IR camera for WWAN 4G (1920x1080) , 16GB DDR4-3200 1DIMM - 2 SLOT / MAX 64GB , 512GB PCIe NVMe Value , No Optical Drive , Intel® Iris® Xe Graphics , Windows® 10 Pro x64 , Intel® Dual Band Wi-Fi 6 AX201 802.11a/b/g/n/ac (2x2) WLAN and Bluetooth® 5 Combo , Intel® XMM 7360 LTE-Advanced, Fibocom LTE/HSPA+ w/GPS , (2) USB 3.1 Gen 1, (2) Thunderbolt 4 , (1) HDMI 2.0b, (1) Headphone/Microphone combo port , 3 Year carry in warranty</p>
12273 <p>HP ProBook x360 435 G8 + HP Pro Pen , AMD® Ryzen 5 5600U Processor (16M Cache, GHz base clock 2.3 GHz) , 13.3" FHD UWVA eDP BrightView WLED-backlit touch screen with HD + IR camera (1920x1080) , 8GB DDR4-3200 1DIMM - 2 SLOT / MAX 32GB , 256GB PCIe NVMe Value , No Optical Drive , AMD Radeon Graphics , Windows® 10 Pro x64 , Intel® Wi-Fi 6 AX200 802.11a/b/g/n/ac/ax (2x2) Bluetooth® 5 Combo , No HSPA Module , (1) HDMI 1.4b, (1) USB 3.1 Type-C, (2) USB 3.1 Gen1, (1) Headphone / Microphone Combo Jack , 1 Year carry in warranty</p>
12274 <p>HP ProBook x360 435 G8 + HP Pro Pen , AMD® Ryzen 7 5800U Processor (16M Cache, GHz base clock 1.9 GHz) , 13.3" FHD UWVA eDP BrightView WLED-backlit touch screen with HD + IR camera (1920x1080) , 8GB DDR4-3200 1DIMM - 2 SLOT / MAX 32GB , 256GB PCIe NVMe Value , No Optical Drive , AMD Radeon Graphics , Windows® 10 Pro x64 , Intel® Wi-Fi 6 AX200 802.11a/b/g/n/ac/ax (2x2) Bluetooth® 5 Combo , No HSPA Module , (1) HDMI 1.4b, (1) USB 3.1 Type-C, (2) USB 3.1 Gen1, (1) Headphone / Microphone Combo Jack , 1 Year carry in warranty</p>
12275 <p>HP Elite x2 G8 , Intel® Core i5-1135G7 Processor (8M Cache, up to 4.20 GHz) , 13" WUXGA+ IPS BrightView Corning® Gorilla® Glass 5 (1920x1280) , On-board 8GB LPDDR4-4266 SDRAM , 256GB PCIe NVMe Value , No Optical drive , Intel® Iris® Xe Graphics , Windows® 10 Pro x64 , Intel® Dual Band Wi-Fi 6 AX201 802.11a/b/g/n/ac (2x2) WLAN and Bluetooth® 5 Combo , Intel® XMM 7360 LTE-Advanced, Fibocom LTE/HSPA+ w/GPS , On Tablet : (2) Thunderbolt 4, (1) USB Type-C, (1) Headphone/Mic combo , 3 Year carry in warranty</p>
12276 <p>HP Elite x2 G8 + Wacom AES 2.0 Pen with App Launch Button G3 , Intel® Core i7-1165G7 Processor (12M Cache, up to 4.7 GHz) , 13" WUXGA+ IPS BrightView Corning® Gorilla® Glass 5 with HP Sure View Privacy screen (1920x1280) , On-board 16GB LPDDR4-4266 SDRAM , 512GB PCIe NVMe Value , No Optical drive , Intel® Iris® Xe Graphics , Windows® 10 Pro x64 , Intel® Dual Band Wi-Fi 6 AX201 802.11a/b/g/n/ac (2x2) WLAN and Bluetooth® 5 Combo , Intel® XMM 7360 LTE-Advanced, Fibocom LTE/HSPA+ w/GPS , On Tablet : (2) Thunderbolt 4, (1) USB Type-C, (1) Headphone/Mic combo , 3 Year carry in warranty</p>
12457 <p><b>Capacity:</b> 32GB </p> <p><b>Ports and Interfaces</b> </p> <ul><li>HDMI 1.44 </li><li>802.11ac Wi‑Fi with MIMO </li><li>10/100BASE-T Ethernet </li><li>Bluetooth 4.0 wireless technology </li><li>IR receiver </li><li>USB-C for service and support </li><li>Built-in power supply</li></ul> <p><b>Processor :</b>  A8 chip with 64-bit architecture</p> <p><b>System Requirements</b> </p> <ul><li>Purchases, rentals, and Home Sharing require an Apple ID that you use for the App Store and other Apple services. </li><li>Requires 802.11 wireless, Ethernet network, or broadband internet access </li><li>Requires acceptance of the software license terms at apple.com/legal/sla </li><li>Requires HDMI cable (sold separately)</li></ul> <p><b>Compatibility</b> </p> <ul><li>Apple TV HD is compatible with HDTVs with HDMI4 </li><li>Apple TV HD is compatible with Bluetooth keyboards</li></ul> <p><b>In the Box</b> </p> <ul><li>Apple TV HD </li><li>Apple TV Remote </li><li>Power cord </li><li>Lightning to USB cable </li><li>Documentation</li></ul> <p></p>