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 (
    435279, 435278, 435269, 435268, 435267, 
    435266, 435265, 359804, 359761, 309479, 
    309437, 286353, 286351, 286350, 286347, 
    286346, 286345, 286344, 285793, 285792
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00127

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "28.04"
    },
    "table": {
      "table_name": "cscart_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": 20,
      "rows_produced_per_join": 20,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "24.04",
        "eval_cost": "4.00",
        "prefix_cost": "28.04",
        "data_read_per_join": "136K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (435279,435278,435269,435268,435267,435266,435265,359804,359761,309479,309437,286353,286351,286350,286347,286346,286345,286344,285793,285792)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
285792 <p>Delicious handmade balsamic vinegar cream with 28% natural orange juice.<br />100% from Greek raw materials.<br />Natural product, suitable for vegetarians and vegans.<br />With sweet and sour taste. Rich creamy texture and wonderful aroma based on balsamic vinegar, concentrated must and natural fruit juice. This extremely tasty dressing contains at least 28% orange juice!<br />Gluten free, no preservatives, no dyes, no artificial fragrances.<br />Keep in a cool and shady place. After opening, keep in the refrigerator.</p>
285793 <p>Balsamic Vinegar Dressing with cranberry flavour.<br />It has sweet and sour and fruity taste, rich creamy texture and wonderful aroma based on balsamic vinegar, concentrated must and natural fruit juice.<br />This extremely tasty dressing contains 28% natural cranberry juice.<br />Handmade sweet and sour dressing.<br />100% from Greek fresh raw materials.<br />100% Natural product, suitable for vegetarians and vegans.<br />Gluten free, no preservatives, no dyes, no artificial flavors.</p>
286344 <p></p><p>Homemade Spoon sweet dessert without sugar from small sour cherries, your favorite summer fruits and the most delicious!</p> <p>This extremely tasty spoon sweet contains at least 78% of this fruit. 100% from Greek fresh fruits and fruit juices. Only with natural sugars. No added sugar or other artificial sweetener. 100% Natural product, suitable for vegetarians and vegans. Gluten free, no preservatives, no dyes, no artificial flavors, no glucose. This is a high quality handmade dessert, which follows the traditional Greek cuisine without changing the quality and taste!</p>
286345 <p></p><p>Homemade Spoon sweet dessert without sugar from fresh cherries, one of the most popular summer fruits and one of the most delicious!</p> <p>This extremely tasty spoon sweet contains at least 78% of this fruit. 100% from Greek fresh fruits and fruit juices. Only with natural sugars. No added sugar or other artificial sweetener. 100% Natural product, suitable for vegetarians and vegans. Gluten free, no preservatives, no dyes, no artificial flavors, no glucose.  This is a high quality handmade dessert, which follows the traditional Greek cuisine without changing the quality and taste!</p>
286346 <p></p> <p>Homemade Spoon sweet dessert without sugar from fresh quinces boiled in fruit juices.</p> <p>This extremely tasty spoon sweet contains at least 78% of this fruit. 100% from Greek fresh fruits and fruit juices. Only with natural sugars. No added sugar or other artificial sweetener. 100% Natural product, suitable for vegetarians and vegans. Gluten free, no preservatives, no dyes, no artificial flavors, no glucose. This is a high quality handmade dessert, which follows the traditional Greek cuisine without changing the quality and taste!</p>
286347 <p></p><p>Homemade Spoon sweet dessert without sugar from fresh bergamont of Kiato area of Peloponnese,  cut into strips for a special dessert with a unique aroma.</p> <p>This extremely tasty spoon sweet contains at least 68% of this fruit. 100% from Greek fresh fruits and fruit juices. Only with natural sugars. No added sugar or other artificial sweetener. 100% Natural product, suitable for vegetarians and vegans. Gluten free, no preservatives, no dyes, no artificial flavors, no glucose. This is a high quality handmade dessert, which follows the traditional Greek cuisine without changing the quality and taste!</p>
286350 <p></p><p>Homemade Spoon sweet dessert without sugar from fresh oranges,from Kiato Area of Peloponnese. Favourite citrus fruit that we it's used whole for the preparation of the dessert.</p> <p>This extremely tasty spoon sweet contains at least 78% of this fruit. 100% from Greek fresh fruits and fruit juices. Only with natural sugars. No added sugar or other artificial sweetener. 100% Natural product, suitable for vegetarians and vegans. Gluten free, no preservatives, no dyes, no artificial flavors, no glucose. This is a high quality handmade dessert, which follows the traditional Greek cuisine without changing the quality and taste!</p>
286351 <p></p><p>Homemade spoon sweet dessert without sugar from fresh white grapes from the Corinthian land, the favorite fruits of August and for many people the most delicious!</p> <p>This extremely tasty spoon sweet contains at least 78% of this fruit. 100% from Greek fresh fruits and fruit juices. Only with natural sugars. No added sugar or other artificial sweetener. 100% Natural product, suitable for vegetarians and vegans. Gluten free, no preservatives, no dyes, no artificial flavors, no glucose. This is a high quality handmade dessert, which follows the traditional Greek cuisine without changing the quality and taste!</p>
286353 <p></p><p>Homemade Spoon sweet dessert without sugar from fresh wild figs, one of the favourite summer fruits and for many people the most delicious!</p> <p>This extremely tasty spoon sweet contains at least 68% of this fruit. 100% from Greek fresh fruits and fruit juices. Only with natural sugars. No added sugar or other artificial sweetener. 100% Natural product, suitable for vegetarians and vegans. Gluten free, no preservatives, no dyes, no artificial flavors, no glucose.  This is a high quality handmade dessert, which follows the traditional Greek cuisine without changing the quality and taste!</p>
309437 <p>Malagouzia - a native Greek variety - is found in the vineyards of Peloponnese,</p><p>produces a vivid wine with extraordinary aromas of citrus fruits and mature peach. </p><p>It's pleasant acidity and intense aftertaste will deceive your flavour!</p><p>Served chilled and pairs well with sea food, white meat, pasta, cheese and fruits.</p><p>Protected Geographical Indication Peloponnese </p> <p>Contains 11.5% alcohol</p> <p><br /></p>
309479 <p>Cleans and polishs oxidised surfaces of objects from SILVER,GOLD,BRASS and other precious metals in seconds.</p>
359761 <p>Luminia Stainless & Metals - Cleanliness that last 3 times longer.<br /></p> <p>Luminia has a MICRO-TECH technology with special microparticles that ultra clean and treat all metals:</p> <p>STAINLESS STEEL,SILVER,BRASS,BRONZE,COPPER,TIN,CHROME,CERAMIC and ALUMINIUM. </p>
359804 <ul><li>Cleans professional espresso and coffe machines</li><li>Supports the smooth operation of the machine</li><li>Ensures coffe and espresso of the best quality</li></ul>
435265 <p>Περιέχει σόδα πλύσεως χάρη στην οποία επιτυγχάνεται η μέγιστη προστασία για το πλυντήριο σας ενώ παράλληλα ενισχύεται η δράση του απορρυπαντικού.<br />• Gel super συμπυκνωμένη σύνθεση.<br />• Με υπέροχο άρωμα FIORI DI LOTO<br />• Πώμα με δοσομετρητική μεζούρα .<br />• Ιδανικό για όλους του τύπους πλυντηρίων.<br />• Τέλεια αποτελέσματα ακόμα και στις χαμηλές θερμοκρασίες.<br />• Ιδανικό για χρωματιστά και λευκά ρούχα.</p>
435266 <p>• Περιέχει σόδα πλύσεως χάρη στην οποία επιτυγχάνεται η μέγιστη                                                                                                προστασία για το πλυντήριο σας ενώ παράλληλα ενισχύεται η δράση του απορρυπαντικού.                                                                  • Gel super συμπυκνωμένη σύνθεση.<br />• Με υπέροχο άρωμα White Musk.<br />• Πώμα με δοσομετρητική μεζούρα.<br />• Ιδανικό για όλους του τύπους πλυντηρίων.<br />• Τέλεια αποτελέσματα ακόμα και στις χαμηλές θερμοκρασίες.</p>
435267 <p>Το υγρό πλυντηρίου ρούχων THESS CLEAN                                                                                                                                    αφήνει τα ρούχα σας εκπληκτικά καθαρά                                                                                                                                        και με ένα εξαιρετικό άρωμα φρεσκάδας                                                                                                                                        που διαρκεί όλη τη μέρα.                                                                                                                                                                  Eίναι κατάλληλο για χρωματιστά και                                                                                                                                            λευκά ρούχα.                                                                                                                                                                              Ιδανικό για όλους του τύπους πλυντηρίων.</p>
435268 <p>• Νέα σύνθεση βασισμένη στην παραδοσιακή σόδα πλύσεως με φυσικό ζεόλιθο.<br />• Με την νέα Σόδα πλύσεως με Ζεόλιθο, θα ανακαλύψετε την ανάγκη για λιγότερο απορρυπαντικό άλλα και μαλακτικό.<br />• Αποτρέπει τον σχηματισμό αλάτων που καταστρέφουν το πλυντήριο και τα ρούχα.<br />• Χάρη στον φυσικό Ζεόλιθο ενισχύεται η δράση του απορρυπαντικού και αναδεικνύει το αποτέλεσμα του μαλακτικού .<br />• Αποτρέπει την επανακαθίζηση των ρύπων ,προλαβαίνοντας το γκριζάρισμα.</p>
435269 <p></p><p>Η σόδα πλύσεως REX είναι το παραδοσιακό προϊόν που ανταποκρίνεται στην παραδοσιακά<br />«σύγχρονη επιθυμία» της νοικοκυράς απόλυτη καθαριότητα σε καλή τιμή.<br />H σόδα πλύσεως δρα ευεργετικά σε κάθε πλύση:</p> <p><b>1η δράση</b>: δρα σαν ενισχυτικό για το απορρυπαντικό<br /><b>2η δράση:</b> δρα σαν μαλακτικό ρούχων<br /><b>3η δράση:</b> δρα σαν διαλυτικό λιπαρών λεκέδων και βρωμιάς<br /><b>4η δράση</b>: δρα κατά των ενοχλητικών μυρωδιών<br /><b>5η δράση:</b> δρα σαν αποσκληρυντικό αλάτων</p>
435278 <p>Agiorgitiko meets Cabernet Sauvignon  and they offer us a well balanced wine, with soft and velvet taste and a pallet of dried forest fruit aromas. </p> <p>Pairs great with red meat and cooked dishes.   </p> <p>alc.13,5% vol<br /></p> <p>Served at 10-12 degrees Celsius<br /></p>
435279 <p>The Pink version of Agiorgitiko and Merlot vines, produce a fruity, well balanced wine.</p> <p>Served chilled,is perfect with seafood, pasta, light salads, cheese and fruits.                                                                                       </p> <p>Peloponnese </p> <p>alc.12.5% vol<br /></p>