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 (
    65853, 65864, 65877, 65874, 65863, 65869, 
    65868, 65862, 65850, 65880, 65852, 
    65855, 65854, 65866, 65857, 65876, 
    65858, 65856, 65860, 65859, 65861, 
    65967
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 22,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65853,65864,65877,65874,65863,65869,65868,65862,65850,65880,65852,65855,65854,65866,65857,65876,65858,65856,65860,65859,65861,65967) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65850 <p class="p1"><span class="s1">Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional 40W incandescent bulbs, providing a substantial energy savings without compromising on style. </span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 5 ⅜" x Dia. 2 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37092,
65852 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 5 ⅜" x Dia. 2 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37094,
65853 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 6 ⅞" x Dia. 5" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37095,
65854 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: <span>MOL 11 ¼" x Dia. 6 ¼" </span></li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37096,
65855 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: <span>MOL 11 ¼" x Dia. 6 ¼"</span></li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37097,
65856 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 11 ¼" x Dia. 6 ¼" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37098,
65857 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 11" x Dia.7 ⅞" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37099,
65858 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 11" x Dia.7 ⅞" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37100,
65859 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 11" x Dia.7 ⅞" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37101,
65860 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> 25</span></span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 10 ¼" x Dia. 6 ¾" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37102,
65861 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 6 ⅞" x Dia. 5" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37103,
65862 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 6 ¾" x Dia. 4" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37105,
65863 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 8" x Dia. 4 ¼" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37104,
65864 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span> </p> <p>|break|</p> <ul> <li>Dimensions: MOL 7 ¼" x Dia. 1 ¼" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37106,
65866 <p class="p1"><span class="s1">Illuminate your space with our versatile and energy-efficient LED bulb, designed to seamlessly replace traditional incandescent bulbs of 25W. This bulb enhances vibrant reds and delivers natural skin tones, making it perfect for any setting, from cozy bedrooms to professional workplaces. This bulb is suitable for use in totally enclosed fixtures and wet locations, making it appropriate for both indoor and outdoor applications. </span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 5 ¼" x Dia. 2 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Most Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 36752,
65868 <p><span>Accessorize your fixture with this stylish LED light bulb, the perfect blend of classic charm and modern efficiency! Designed to replace traditional 40W incandescent bulbs, this energy-saving option not only reduces your electricity bill but enhances your décor. With its vintage look, this bulb fits seamlessly into most decorative applications, making it ideal for everything from cozy living rooms to chic restaurants.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 4 ¼" x Dia. 3" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 36072, half chrome,
65869 <p class="p1"><span class="s1">Accessorize your fixture with this stylish LED light bulb, the perfect blend of classic charm and modern efficiency! Designed to replace traditional 40W incandescent bulbs, this energy-saving option not only reduces your electricity bill but enhances your décor. With its vintage look, this bulb fits seamlessly into most decorative applications, making it ideal for everything from cozy living rooms to chic restaurants.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 4 ¼" x Dia. 3" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 36070,
65874 <p class="p1"><span class="s1">Illuminate your space with our versatile and energy-efficient LED bulb, designed to seamlessly replace traditional incandescent bulbs of 25W. This bulb enhances vibrant reds and delivers natural skin tones, making it perfect for any setting, from cozy bedrooms to professional workplaces. This bulb is suitable for use in totally enclosed fixtures and wet locations, making it appropriate for both indoor and outdoor applications. </span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 3 ⅞" x Dia. 1 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Most Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37056, candelabra,
65876 <p class="p1"><span class="s1">Illuminate your space with our versatile and energy-efficient LED bulb, designed to seamlessly replace traditional incandescent bulbs of 40W. This bulb enhances vibrant reds and delivers natural skin tones, making it perfect for any setting, from cozy bedrooms to professional workplaces. This bulb is suitable for use in totally enclosed fixtures and wet locations, making it appropriate for both indoor and outdoor applications. </span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 3 ⅞" x Dia. 1 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Most Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37063, candelabra,
65877 <p class="p1"><span class="s1">Illuminate your space with our versatile and energy-efficient LED bulb, designed to seamlessly replace traditional incandescent bulbs of 25W. This bulb enhances vibrant reds and delivers natural skin tones, making it perfect for any setting, from cozy bedrooms to professional workplaces. This bulb is suitable for use in totally enclosed fixtures and wet locations, making it appropriate for both indoor and outdoor applications. </span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 3 ½" x Dia. 1 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Most Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37065, candelabra,
65880 <p class="p1"><span class="s1">Accessorize your fixture with this stylish LED light bulb, the perfect blend of classic charm and modern efficiency! Designed to replace traditional 60W incandescent bulbs, this energy-saving option not only reduces your electricity bill but enhances your décor. With its vintage look, this bulb fits seamlessly into most decorative applications, making it ideal for everything from cozy living rooms to chic restaurants. </span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 5 ¼" x Dia. 2 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Most Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 36085,
65967