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 (8347, 8350) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00031

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		2	Using index condition

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
8347		<p style="text-align: justify;"><span class="upper">ATLAS PLASTERING MIX</span> - traditional cement plaster of category III</p> <p style="text-align: justify;"><span style="font-weight: bold;">Double layer plaster of category 0-III</span> – the plaster consists of two layers: the “initial scratch coat” and the “surface floating coat” (it can be additionally covered with a finishing coat layer made of white, cement - based ATLAS REKORD finishing coat).</p> <p style="text-align: justify;"><span style="font-weight: bold;">Suitable for manual and machine application </span>– the mix is available in two versions: for manual or machine plastering (packages additionally marked with letter M).</p> <h2>The main characteristics</h2> <ul> <li>manual or machine application</li> <li>high plasticity</li> <li>compressive strength, CS II</li> <li>layer thickness 6 – 30 mm</li> <li>for plastering walls and ceilings</li> <li>layer thickness: 6 - 30 mm</li> <li>consumption: 25 kg/ 1.3-1.4 m²/ 10 mm thickness</li> <li>compressive strength: 1.5 ÷ 5.0 N/m²</li> <li>for ceilings and walls made of bricks, blocks, hollow bricks and other similar ceramic or silicate materials; </li> <li>surfaces: concrete, aerated concrete, chip-cement boards, cement and cement-lime plasters.</li> </ul> <h2>Consumption</h2> <p> </p> <p>One 25 kg bag is sufficient to obtain 1.3 ÷ 1.4 m2 of 10 mm thick plaster.</p> <h2>Packaging</h2> <p> </p> <p style="text-align: justify;">Paper bags: 25 kg and 30 kg (for machine application)<br /> Pallet: 1050 kg in 25 kg bags, 1080 kg in 30 kg bags</p>		✓plastering mix ✓for plastering of walls made of ceramic, silicate brick, cellular concrete, concrete hollow blocks ✓increased bonding ✓plasticized, easy to apply ✓layer thickness 6-30 mm ✓plastering of walls and ceilings ✓check it now!
8350		<p style="text-align:">Atlas Rekord white, a cement-based mortar, smooths the surface of walls – the use of aggregate with a diameter of 0.2 mm makes it possible to obtain a very smooth surface. Enables smoothing the thin-coat structural plasters – laid on either traditional plasters or on thermal insulation layers (is not an element of thermal insulation systems). Improves the quality of damaged cement-based and cement-lime plastersand of concrete substrates.</p> <ul style="text-align: justify;"> <li>for finishing walls and ceilings</li> <li>for typical mineral substrates; cement and cement-lime plasters, concrete, appropriately prepared gypsum substrates</li> <li>contains fine aggregate – up to 0,2 mm</li> <li>strengthened with microfibres</li> <li>compressive strength: 3.5 ÷ 7.5 N/mm²</li> <li>layer thickness: 1 - 10 mm</li> </ul> <h2>Properties</h2> <ul style="text-align: justify;"> <li><strong>White colour</strong> – based on white, fine type of cement, perfectly replaces gypsum finishing coats in places where they can be exposed to damage - on external walls and in wet rooms.</li> <li><strong>Resistant to micro-cracks</strong> – it contains special microfibres additionally reinforcing its structure.</li> <li><strong>Contains hydrophobic agents</strong> – they reduce the absorbing capacity of the mortar but do not limit its vapour permeability.</li> </ul> <h2>Consumption</h2> <p style="text-align:">The average consumption is ca. 1.5 kg of mix / 1 m² / 1 mm of layer thickness.</p> <h2>Packaging</h2> <p style="text-align:">Paper bags: 25 kg<br /> Pallet: 1050 kg in 25 kg bags</p>		✓Smoothens the surface of walls and ceilings ✓Resistant to micro-cracks ✓white color ✓on typical mineral substrates ✓reinforced microfibers ✓based on white cement ✓check it now!