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 (
4,
6,
7,
8,
9,
10,
12,
13,
14,
15,
16,
19,
20,
23,
32,
33,
34,
35,
36,
42,
52,
54,
59,
60,
61,
62,
63,
84,
85,
86,
89,
93,
94,
95,
107,
108,
109,
110,
111,
113,
114,
118,
119,
120,
121,
123,
127,
128,
130,
131,
134,
136,
141,
142,
144,
145,
146,
147,
50984,
50985,
50986,
50988,
50992,
50993,
51106,
51107,
51108,
51109,
51110,
51111,
51112,
51113,
51114,
51115,
51116,
51117,
51118,
51161,
51162,
51163,
51164,
51165,
51177,
51178,
51179,
51180,
51182,
51183,
51184,
51185,
51186,
51187,
51188,
51189,
51190,
51191,
51192,
51193,
51194,
51195,
51196,
51197,
51198,
51199,
51200,
51201,
51212,
51213,
51214,
51215,
51216,
51217,
51218,
51219,
51220,
51225,
51226,
51227,
51228,
51229,
51230,
51231,
51232,
51233,
51234,
51235,
51236,
51237,
51238,
51239,
51240,
51241,
51242,
51243,
51244,
51245,
51246,
51247,
51248,
51249,
51250,
51251,
51252,
51253,
51254,
51255,
51256,
51259,
51260,
51261,
51262,
51263,
51264,
51265,
51266,
51267,
51268,
51269,
51270,
51271,
51272,
51273,
51274,
51275,
51276,
51277,
51278,
51279,
51280,
51281,
51282,
51283,
51284,
51285,
51286,
51287,
51288,
51289,
51290,
51291,
51293,
51294,
51310,
51311,
51312,
51313,
51314,
51325,
51327,
51328,
51329,
51330,
51331,
51332,
51336,
51337,
51338,
51339,
51344,
51345,
51346,
51347,
51348,
51350,
51374,
51375,
51376,
51377,
51378,
51379,
51380,
51381,
51382,
51390,
51391,
51392,
51393,
51394,
51444,
51445,
51446,
51447,
51448,
51449,
51450,
51451
)
AND cscart_ult_product_descriptions.company_id = 1
AND cscart_ult_product_descriptions.lang_code = 'ru'