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 (
    584, 573, 561, 556, 553, 549, 545, 541, 
    525, 521, 517, 513, 507, 497, 492, 489, 
    486, 482, 455, 453, 452, 451, 450, 449, 
    448, 447, 446, 445, 444, 443, 442, 394, 
    378, 377, 371, 369, 368, 362, 228, 219, 
    218, 217, 212, 211, 210, 209, 207, 206
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00090

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "33.61"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "index_condition": "((`betaatif_store`.`cscart_product_descriptions`.`product_id` in (584,573,561,556,553,549,545,541,525,521,517,513,507,497,492,489,486,482,455,453,452,451,450,449,448,447,446,445,444,443,442,394,378,377,371,369,368,362,228,219,218,217,212,211,210,209,207,206)) and (`betaatif_store`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "28.81",
        "eval_cost": "4.80",
        "prefix_cost": "33.61",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
206 <p><strong>DINING TABLE CONTAIN OF TABLE + 6 CHAIRS </strong></p>
207 <pre class="tw-data-text tw-text-large tw-ta"><span style="font-size:12pt;font-family:arial, helvetica, sans-serif;"><strong><span class="Y2IQFc">Bedroom with bed + comedian + desk + 3 wardrobes + mirror</span></strong></span></pre>
209 <p><strong> DINING TABLE CONTAIN OF TABLE + 12 CHAIRS + BUFFET + MIRROR</strong></p>
210 <p>SOFA SET CONTAIN OF 1 THREE SEAT SOFA + 2 TWO SEAT SOFA </p>
211 <pre class="tw-data-text tw-text-large tw-ta"><span style="font-size:12pt;font-family:arial, helvetica, sans-serif;"><strong><span class="Y2IQFc">Bedroom with bed + comedian + desk + 3 wardrobes + mirror</span></strong></span></pre>
212 <p><strong> DINING TABLE CONTAIN OF TABLE + 12 CHAIRS + BUFFET + MIRROR</strong></p>
217 <pre class="tw-data-text tw-text-large tw-ta"><span style="font-size:12pt;font-family:arial, helvetica, sans-serif;"><strong><span class="Y2IQFc">Bedroom with bed + comedian + desk + 3 wardrobes + mirror</span></strong></span></pre>
218 <pre class="tw-data-text tw-text-large tw-ta"><span style="font-size:12pt;font-family:arial, helvetica, sans-serif;"><strong><span class="Y2IQFc">Bedroom with bed + comedian + desk + 3 wardrobes + mirror</span></strong></span></pre>
219 <pre class="tw-data-text tw-text-large tw-ta"><span style="font-size:12pt;font-family:arial, helvetica, sans-serif;"><strong><span class="Y2IQFc">Bedroom with bed + comedian + desk + 3 wardrobes + mirror</span></strong></span></pre>
228 <p>BEDROOM CONTAINS OF BED 108*200 + 2 COMEDINO + DRESSER WITH MIRROR + CUPBOARD 6 SASH + <span class="Y2IQFc">DRESSER CHAIR</span></p>
362 <p>BEDROOM CONTAINS OFBED 180*200 + 2 COMEDINO + DRESSER WITH MIRROR + DRESSER CHAIR + CHEST OF DRAWER + CUPBOARD 6 SASH</p>
368 <p>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 6 SASH</p>
369 BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 6 SASH
371 <p>BEDROOM CONTAINS OF BED180*200 + 2COMEDINO +DRESSER WITH MIRROR + CUPBOARD 5 SASH</p>
377 <p>BEDROOM CONTAINS OF : BED 180*200 + 2 COMEDINO + DRESSER WITH MIRROR + CUPBOARD 6 SASH</p> <p> </p>
378 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
394 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
442 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
443 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
444 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
445 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
446 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
447 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
448 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
449 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
450 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
451 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
452 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
453 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
455 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
482 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
486 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
489 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
492 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
497 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
507 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
513 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
517 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
521 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
525 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
541 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
545 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
549 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
553 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
556 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
561 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
573 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>
584 <p>This collection allows you to feel the originality through the exquisite designs and the soft yarns of attractive colors that combine the touch of life and the feeling of luxury for any home. Manufactured from thick, soft and heat-resistant 100% polypropylene yarn, this range helps provide floor coverings that are easy to maintain, clean and also stain resistant.<br /><br /><strong>important note:</strong><br /><br />The digital images shown are ultra-accurate colors that represent the look or feel of the actual rug, but some slight differences in color tones may appear when comparing digital images and the actual product and this is beyond our responsibility as it is due to different computer monitors displaying the images.</p>