Sandbox

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 (8364, 8371, 9818) 
  AND cscart_ult_product_descriptions.company_id = 2 
  AND cscart_ult_product_descriptions.lang_code = 'se'

Query time 0.00036

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	full_description	promo_text
8364	<p style="text-align: justify;"><strong>GRUNT</strong> is a product designed for surface priming, composed using top-quality acrylic resin. It forms a strong bond within the base, thus creating a hydrophobic (water-proof) coating.  </p> <h2>Application</h2> <p style="text-align: justify;">For use both indoors and outdoors, for priming of concrete and cement bases, aerated concrete blocks, gypsum plasterboards and cardboards; applied prior to installing ceramic tiles, paints, wallpapers, glues, floor leveling and self-leveling floor. It greatly reduces the surface's absorption rates, diminishes dusting  and  prevents  excessive  attrition.  </p> <p style="text-align: justify;">Before you begin, clear the surface of any dirt, oil etc. It has to be dry, too. Apply GRUNT with a painting brush/roller or have it sprayed on the surface. For heavily absorbent surfaces, you might want to lay two or three layers of GRUNT for best effect. For use on plasterboards and cardboards, GRUNT works best mixed with water on a 1:1 ratio. Having finished laying one layer of GRUNT, you must wait 4 hours before you might lay another one. The surface's temperature should not be lower than +5 not higher than +40 C.  </p> <h2>Average consumption</h2> <p style="text-align: justify;">0,05 - 0,2 l / m²</p>
8371	<p style="text-align: justify;">Impregnat for brick slips is a milk-white, water-soluble silicon emulsion with a little admixture of solvent designed for surface hydrophobisation of building materials such as: porous concrete tiles, concrete window sills and roofs, gypsum blocks, cellular concrete, roof tiles, cement-lime plasters and, in certain cases, acrylic plasters.</p> <p style="text-align: justify;"><strong>Use: </strong>In order to achieve correct impregnation results it is necessary to adequately prepare the application surface. The surface should be evenly porous, dry, clean and free from grease. STEGU tiles should be impregnated together with joints at least 7 days after work completion. New cement-lime and acrylic plasters, as well as concrete must not be impregnated earlier than 24-30 days after the end of work. Surfaces repaired with the use of PCC-type mortar or filler should be impregnated after 6 days. Treated surfaces should be impregnated in dry weather and moderate wind conditions, at external temperatures in the range from +5 to +30°C. Prior to work, carefully secure all non-impregnated surfaces (e.g. window panels, metal and wooden parts, polished stones). In case of fouling, clean the surface immediately with mineral spirits.</p> <p style="text-align: justify;"><strong>Application: </strong>Impregnation can be performed using a brush or by spraying. The application method depends on the absorbability and structure of the material. In order to achieve the best results, it is recommended to impregnate the surface twice, at short intervals and using the ‘wet to wet’ method (i.e. depending on the ambient temperature and porosity of the material the second layer should be applied within 30 minutes from the application of the first one i.e. when the surface is still wet). Surface should be impregnated completely and evenly.</p> <p style="text-align: justify;"><strong>Consumption: </strong>Consumption of the impregnating agent depends on the absorbability of the treated material, as well as application method and amounts up to 10 m² per 1 litre of the emulsion (with a one impregnation). Store in original containers, in roofed and dry rooms, at temperatures in the range from +5 to +25°C.</p>	<p style="background: #ddd; text-align: justify;"><strong>CONSUMPTION</strong> of the impregnating agent depends on the absorbability of the treated material, as well as application method and amounts <strong>up to 10 m² per 1 litre</strong> of the emulsion (with a one impregnation).</p>
9818	<p style="text-align: justify;"><span style="font-size:18px;"><strong>TIMBER 1 (WOOD)</strong></span></p> <p style="text-align: justify;">Nya framsteg inom tillverkningstekniken har lett till att skapa utsökta, realistiska trälookplattor, vilket ger den autentiska utseendet och strukturen till hållbart, vattenbeständigt betonghantverksklädsel. Timmer är ett exempel på en betongplatta som imiterar oregelbunden struktur av naturligt trä, som har en stor potential att bli slagen produkt nästa säsong. Kommer i tre unika färger, var och en, kan Timber vara ett modernt ackompanjemang till en modern inredning och fasad eller en vintageaccent till en mer rustik miljö.</p> <p style="text-align: justify;">✓ Interiör och exteriör dekorativ betongplatta</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105">Package</td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td>Tile</td> <td>7</td> <td>0,43 m<sup>2</sup></td> <td>13,8 kg</td> </tr> </tbody> </table>	<p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>7 bitar per kartong</strong></p><p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.43 m<sup>2</sup> per kartong</strong></p>