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 (
    10043, 10042, 10414, 10040, 10030, 10032, 
    10461, 10435, 10442, 10425, 10429, 
    10445
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00046

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

Result

product_id	full_description	meta_description
10030	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></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><strong>Tile</strong></td> <td>24</td> <td>0,42 m<sup>2</sup></td> <td>15 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>0,8 lm</td> <td>7 kg</td> </tr> </tbody> </table>	MONSANTO BEIGE corner ➟ for inside and outside ➟ quick and easy assembly ❄ frost-resistant ➟ perfect for facades ✓ visual authenticity of the demolition brick ➟ height - 7.8 cm
10032	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></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><strong>Tile</strong></td> <td>32</td> <td>0,47 m<sup>2</sup></td> <td>15,00 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>14</td> <td>0,84 lm</td> <td>10,8 kg</td> </tr> </tbody> </table>	SANTORINI ✔ for inside and outside ✔ based on concrete and mineral raw materials ✔ height - 6 cm
10040	<p style="text-align: justify;">Long brick in modernist style with rich texture of raw concrete. Tiles have slightly torn edges with visible surface pitting. <strong>DUBLIN </strong>matches metallic surfaces, glass and oiled wood. Geometric structure suits both industrial interiors in combination with white color and vivid colors such as yellow, lime or magenta. As a facade tile it emphasizes the shape of modern, minimalist architecture. Construction of the tiles (bricks with joint) provides easy installation.</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>14</td> <td>0.52 m<sup>2</sup></td> <td>18.0 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>8</td> <td>0.66 lm</td> <td>8.5 kg</td> </tr> </tbody> </table>	Corner DUBLIN ✔ for inside and outside ✔ height - 8.3cm
10042	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></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><strong>Tile</strong></td> <td>12</td> <td>0,46 m<sup>2</sup></td> <td>13,7 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>12</td> <td>1,2 lm</td> <td>13,5 kg</td> </tr> </tbody> </table>	NEPAL GRAPHITE corner ✔ suitable for inside and outside ✔ made of concrete ✔ low weight ✔ dark grey ✔ modern design ✔ height - 10cm
10043	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></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><strong>Tile</strong></td> <td>30</td> <td>0,59 m<sup>2</sup></td> <td>15,5 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>0,76 lm</td> <td>7,5 kg</td> </tr> </tbody> </table>	Corner AMSTERDAM BEIGE ✔ for inside and outside ✔ based on concrete and mineral raw materials ✔ height - 7.6cm
10414	<p style="text-align: justify;">Loft is a brick-like tile with slightly rounded soft edges. Available in white and red, it matches modern architecture and minimalist interiors. The Loft will do great both on the entire wall surface as well as on its fragments, especially in small rooms. The Loft tile will not only decorate the room but will designate zones, which in turn is important in spacious interiors that combine several functions.</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>38</td> <td>0,6 m<sup>2</sup></td> <td>7,5 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>16</td> <td>1,17 lm</td> <td>4,7 kg</td> </tr> </tbody> </table>	Corner LOFT RED ✔ suitable for interiors ✔ based on synthetic plaster ✔ easy assembly ✔ height - 6.3cm \| Have a look now! ☎ 030 30 807 169
10425	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>22-24</td> <td>1 m<sup>2</sup></td> <td>21 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>1,8 lm</td> <td>9 kg</td> </tr> </tbody> </table>	JURA CREAM corner ✔ suitable for interiors and exteriors ✔ easy assembly \| In the online shop! ☎ 030 30 807 169
10429	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>7</td> <td>0,54m<sup>2</sup></td> <td>16,8 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>7</td> <td>1 lm</td> <td>16,8 kg</td> </tr> </tbody> </table>	Corner LYON BEIGE ✔ suitable for inside and outside ✔ made of concrete ✔ reminiscent of the sun-drenched wall ✔ weatherproof \| Buy online ! ☎ 030 30 807 169
10435	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>15</td> <td>0.75 m<sup>2</sup></td> <td>16.3 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>7</td> <td>1.19 lm</td> <td>9.5 kg</td> </tr> </tbody> </table>	ROMA DESERT corner ✔ suitable for inside and outside ✔ made of concrete ✔ reminiscent of the sun-drenched wall ✔ weatherproof ✔ height - 16 cm \| buy online
10442	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></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><strong>Tile</strong></td> <td>32</td> <td>0,52m<sup>2</sup></td> <td>14,4 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>12</td> <td>0,87 lm</td> <td>8,7 kg</td> </tr> </tbody> </table>	Corner BOSTON GRAPHITE with integrated joint ✔ suitable for inside and outside ✔ made of concrete ✔ height - 7.3cm \| Order now ! ☎ 030 30 807 169
10445	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></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><strong>Tiles</strong></td> <td>57</td> <td>0.91 m<sup>2</sup></td> <td>20 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>24</td> <td>1.75 lm</td> <td>13 kg</td> </tr> </tbody> </table>	Corner CAMBRIDGE CREAM ✔ suitable for inside and outside ✔ made of concrete ✔ height - 6 cm \| Order now ! ☎ 030 30 807 169
10461	<table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></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><strong>Tile</strong></td> <td>5</td> <td>0,32 m<sup>2</sup></td> <td>11,60 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>5</td> <td>0,58 lm</td> <td>11,55 kg</td> </tr> </tbody> </table>	Corner GRENADA VOLCANIC ✔ for inside and outside ✔ made of concrete ✔ reminds of the atmosphere of Spanish cities ✔ height - 11.7cm \| Online! ☎ 030 30 807 169