SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (504, 414, 8373) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00035

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions range PRIMARY,product_id,company_id PRIMARY 13 3 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
414 <p style="text-align: justify;">Flat lintels are made of reinforced cellular concrete and used to execute load-bearing lintels in a building. Height of flat lintel beams is 125 mm. Maximal width of covered hole is 250cm. Depending of wall thickness, the elements are installed as single or multiple ones. In order to achieve a load-bearing lintel the elements should be extended by a layer of blocks.</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr bgcolor="#cccccc"> <td colspan="3" style="text-align: center;"><strong>Dimension [mm]</strong></td> <td style="text-align: center;" width="150"><strong>Maximum opening</strong></td> </tr> <tr bgcolor="#cccccc" height="21"> <td style="text-align: center;" width="74"><strong>Length</strong></td> <td style="text-align: center;" width="63"><strong>Height</strong></td> <td style="text-align: center;" width="79"><strong>Thickness</strong></td> <td style="text-align: center;"><strong>[mm]</strong></td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">1300</td> <td rowspan="12"> <p style="text-align: center;">125</p> </td> <td rowspan="12"> <p style="text-align: center;"><strong>115</strong></p> </td> <td style="text-align: center;">900</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">1500</td> <td style="text-align: center;">1100</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">2000</td> <td style="text-align: center;">1500</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">2500</td> <td style="text-align: center;">2000</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">3000</td> <td style="text-align: center;">2500</td> </tr> </tbody> </table> <p>&nbsp;</p> <p><strong>Combination of 115mm and 175mm </strong><strong>lintels in different wall thicknesses.</strong></p> <table border="1" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr bgcolor="#cccccc"> <td align="center"><strong>Wall</strong></td> <td colspan="2" style="text-align: center;"><strong>Lintel</strong></td> </tr> <tr bgcolor="#cccccc" height="21"> <td align="center"><strong>Thickness</strong></td> <td style="text-align: center;"><strong>115 mm </strong></td> <td style="text-align: center;"><strong>175 mm </strong></td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">115 mm</td> <td style="text-align: center;">1x</td> <td style="text-align: center;">-</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">175 mm</td> <td style="text-align: center;">-</td> <td style="text-align: center;">1x</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">240 mm</td> <td style="text-align: center;">2x</td> <td style="text-align: center;">-</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">300 mm</td> <td style="text-align: center;">1x</td> <td style="text-align: center;">1x</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">365 mm</td> <td style="text-align: center;">-</td> <td style="text-align: center;">2x</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">420 mm</td> <td style="text-align: center;">2x</td> <td style="text-align: center;">1x</td> </tr> </tbody> </table> <p>&nbsp;</p>
504 <p style="text-align: justify;">ATLAS UNI GRUNT is an impregnating sealer for priming, manufactured on the basis of the finest quality water dispersion of polymer resins.</p> <ul> <li>reinforces absorptive substrates of any type</li> <li>high yield, quick-drying</li> <li>decreases and unifies substrate absorptiveness</li> <li>for application in temperature up to +30°C</li> <li>improves bonding to the substrate</li> <li>underneath floors and screeds</li> <li>underneath adhesives, plasters, top finishes, paints</li> </ul> <p style="text-align: justify;"><img alt="" src="https://d2d2yzufo5fwh3.cloudfront.net/images/products/atlas/uni%20grunt.JPG?1569329906605" style="width: 331px; height: 60px;" /></p> <h2>Use</h2> <ul> <li style="text-align: justify;">Very short time of drying</li> <li style="text-align: justify;">Reinforces top surface of primed mineral substrates – penetrates into material structure, reinforces it and improves its load-bear capacity.</li> <li style="text-align: justify;">Prevents “taking in” excessive amount of water from the layer applied upon the substrate – limits the absorption of the substrate.</li> <li style="text-align: justify;">Improves yield of paints, top finishes and adhesives – increases yield of materials used for the next layer application, reduces their consumption by sealing structure of a primed substrate.</li> <li style="text-align: justify;">Creates temporary protective layers on subfloors – improves the resistance of the floor to dust deposition, facilitates its cleaning (must not be considered as the final finishing layer).</li> <li style="text-align: justify;">Facilitates application of the next layers – painting coats, adhesives, top finishes and fillers, floors and self-levelling screeds, adhesives for carpets, wallpapers, adhesives for thermal insulation etc.</li> <li style="text-align: justify;">Decreases substrate absorptivity</li> <li style="text-align: justify;">Bonds non-stable substrates</li> <li style="text-align: justify;">For application with a roller, a brush or with a sprayer.</li> <li style="text-align: justify;">Transparent, solvent-free and water-soluble – product is colourless after drying, does not cause substrate discolouration.</li> </ul> <p style="text-align: justify;"><span style="font-weight: bold;">Kinds of primed substrates</span>:</p> <ul> <li>cement floors and screeds, cement and cement-lime plasters and top finishes, walls made of cellular concrete</li> <li>walls made of brick or silicate blocks, walls made of brick or ceramic hollow blocks</li> <li>cement floors and screeds with floor heating, magnesium screeds</li> <li>cladding fixed with cement or gypsum adhesive, mineral waterproofing, cement floors and screeds, anhydride screeds</li> <li>cement, cement-lime, gypsum plasters, gypsum, cement top finishes</li> <li>painting coats made of indoor acrylic and latex paints, wallpapers</li> </ul> <h2>Consumption</h2> <p style="text-align: justify;">The average consumption is 0.05 ÷ 0.2 kg of emulsion for 1 m².</p> <p style="text-align: justify;">In practice, the consumption depends on the substrate absorptiveness.</p> <h2>Packaging</h2> <p>Plastic containers: 5 kg<br /> Pallet: 540 kg in 5 kg containers.</p> ✔reinforces absorptive substrates ✔quick-drying ✔application in temp. up to +30°C ✔improves bonding to the substrate ✔underneath floors and screeds, adhesives, plasters, top finishes, paints ✔check it on baubay.de
8373 <ul><li>Very good adhesion to concrete blocks</li><li>Easy to prepare</li><li>Rapid durability increase</li><li>Used in side connection systems</li><li>Long processing time</li></ul><p><strong>Preparation:</strong></p><p style="text-align: justify;">Stir the bag contents of 6-6.5 liters of pure water using a stirrer. After 5 minutes mix it again. Mortar prepared in this way is ready to use for about 4 hours. In case of partially binded mortar with water, it is unacceptable to mix it with water again. Ready-to-use mortar cannot be mixed with water or other dry mortar to change its consistency. The mortar should be applied on the cellular concrete blocks with a special trowel fitted to wall thickness or with the appropriate notched trowel. During mortar application it is essential to be aware that its surface on the blocks should be flat. Do not use in the traditional brickwork. The outdoor temperature at the time of application of the mortar should not be higher than 50 ˚ C. The mortar should be protected from direct sunlight and wind.</p><p><strong>Efficiency:</strong></p><p>From one 25kg bag it is possible to get 18l of ready to use mortar.</p><p><strong>Consumption</strong></p><table><tbody><tr><td style="text-align: center;">Blocket</td><td style="text-align: center;">Förbrukning</td></tr><tr><td style="text-align: center;">115 mm</td><td style="text-align: center;">1,2 kg/m²</td></tr><tr><td style="text-align: center;">175 mm</td><td style="text-align: center;">1,8 kg/m²</td></tr><tr><td style="text-align: center;">240 mm</td><td style="text-align: center;">2,4 kg/m²</td></tr><tr><td style="text-align: center;">300 mm</td><td style="text-align: center;">3,0 kg/m²</td></tr><tr><td style="text-align: center;">365 mm</td><td style="text-align: center;">3,6 kg/m²</td></tr><tr><td style="text-align: center;">420 mm</td><td style="text-align: center;">4,2 kg/m²</td></tr><tr><td style="text-align: center;">480 mm</td><td style="text-align: center;">4,8 kg/m²</td></tr></tbody></table><p>&nbsp;</p>