QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(8068799,8068802,8068803,8068805,10939552,10939553,8068821,10939629,10943438,10943440,10943441,10943442,10943445,10943446,10943598,10943751,10943752,10940006,10940018,10940019,10943835,10943839,10943840,10943843,10943844,10943845,10943849,10943852,10943855,10943858,10943859,10943861,10940112,10940156,10940157,10940160,10940161,10940171,10940173,10940182,10940186,10940187,10940188,10940189,10940193,10940199,4970849,4970850,4970851,4970858,4970859,4970860,4970881,4970882,4970883,4970884,4970885,4970899,4970900,4970901,4970902,4970924,10940324,10940326,10940327,4970957,4970958,4970959,10940343,10940345,10940346,10940347,10940349,4970974,4970982,4970983,4970984,4970985,4970986,4970987,10940400,10940420,10940421,10940429,4971054,4971055,10940462,10940463,10940464,10940465,10940468,10940469,10940474,10940478,10940479,10940480,10940481,10940482,10940483,10940484,10940487,10940489,10940509,10940513,10940515,10940521,10940524,10940527,10940528,10940529,8066892,8066893,8066894,8066908,8066938,8066954,8066955,8066956,8066957,8066958,8066959,8066977,4968259,4968262,4968271,4968275,4968276,4968277,4968278,4968279,4968280,4968281,4968282,4968283,4968284,4968285,4968286,4968287,4968288,4968289,4968290,4968294,8067159,8067160,8067161,8067162,8067163,8067164,8067165,8067166,8067167,8067168,8067183,8067184,8067262,4968608,4968622,4968623,4968624,4968625,4968644,4968647,4968654,4968662,4968663,8067659,8067660,8067661,8067697,8067698,8067699,10938488,10938489,10938508,10938509,10938576,4969252,4969266,4969267,4969268,4969269,10938770,10938771,10938832,10938834,10938836,10938837,10938838,10938839,10938840,10938842,10938845,10938848,10938854,10939099,4969830,4969831,4969832,4969833,4969834,4969835,10939215,8065284,8065285,8075214,8075215,8075216,8075217,8075309,8075310,8075312,4967031,4967069,4967070,4967071,4967072,4967086,4967087,4967088,4967089,4967100,4967156,4967157,4967158,8065911,8065912,8065931,4967309,8066142,8066143,8066144,8066145,8066165,8066166,4967435,8066189,8066202,8066209,8066210,8066214,8066216,8066218,8066224,8066225,8066226,8066242,8066243,8066244,8066245,8066246,8066254,8066255,8066256,8066268,8066269,8066270,8066271,8066272,8066273,8066274,8066275,8066283,8066286,8066287,8066288,8066294,8066296,8066304,8066308,8066309,8066310,8066311,8066318,8066328,8066329,8066330,8066331,8066332,8066333,8066334,8066335,8066336,8066337,8066338,8066339,8066343,8066344,8066345,8066346,8066354,8066355,8066356,8066357,8066358,8066359,8066360,8066362,8066369,8066370,8066371,8066372,8066373,8066374,8066375,8066376,8066377,8066378,8066379,8066380,8066393,8066400,8066411,8066421,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066429,8066430,4967713,8066468,8066498,8066499,8066500,8066501,8066507,8066508,8066509,8066558,8066559,8066560,8066561,8066565,8066566,8066575,8066576,8066577,8066578,8066579,8066585,8066586,8066592,8066593,8066594,8066595,8066596,8066597,4967866,8066607,8066608,8066609,8066610,8066611,8066612,4967885,4967886,4967887,4967888,4967889,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066636,8066637,8066638,8066639,8066640,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066654,8066655,8066656,8066657,8066658,8066661,8066662,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8066670,8066684,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066701,8066702,8066703,8066713,8066714,8066715,8066716,8066717,8066718,8066719,8066720,8066721,8066722,8066723,8066724,8066725,4967996,8066758,8066759,8066774,8066775,8066776,8066777,8066778,8066779,8066780,8066781,8066789,8066790,8066791,8066792,8066793,8066794,8066800,8066801,8066802,8066803,8066804,8066818,8066819,8066820,8066821,8066822,8066823,8066824,8066825,8066826,8066827,8066828,8066829,8066830,8066831,8066832,8066833,8066834,8066838,8066839,8066840,8066841,8066850,8066851,8066852,8066853,8066854,8066862,8066863,8066864,8066865,8066866,8066867,8066868,8066869,8066870,8066880,8073670,8073671,8073672,8073673,8073674,8063986,8063987,8063988,8063989,8074037,8074038,8074039,8074040,8074041,8064348,8064557,8064559,8064560,8064561,8064569,8064778,8074596,8074597,8074598,8074599,8074600,3655646,3655649,3655676,3656209,8072405,8072431,3656306,3656322,3656332,3656370,3656371,3656372,3656373,3656374,3656376,3656419,3656420,3656421,3656422,3656423,3656592,3656593,3656710,3656989,3656991,3656992,3656995,8969904,8969905,8969923,8073546,8073569,8073570,8073571,8073572,8073573,8073574,8073668,8073669,10623006,10623007,10623026,10624730,10624852,10621981,10621986,10621987,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10622012,10622014,10622032,10622033,10622034,10622049,10622050,10622053,10622055,10622060,10622071,10622104,10622105,10622113,10622114,10622115,10622126,10622128,10622204,10622215,10622216,10622220,10622224,10622225,10622226,10622227,10622238,10622239,10622240,10620303,10620307,10620322,10620326,10620338,10620353,10620354,10620355,10620356,10620370,10620373,10620374,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620401,10620402,10620403,10620408,10620414,10620427,10620441,10620465,10620528,10620663,10620664,10620669,10620670,10621110,10621111,10621112,10621113,10621114,10621115,10621119,10621120,10621124,10621144,10621146,10621147,10621148,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621265,10621266,10621267,10621268,10621269,10621270,10621271,10621273,10621274,10621276,10621277,10621280,10621281,10621292,10621293,10621294,10621296,10621300,10621301,10621303,10621304,10621305,10621306,10621307,10621308,10621309,10621310,10621311,10621316,10621317,10621318,10621319,10621320,10621321,10621323,10621324,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621340,10621341,10621343,10621345,10621346,10621347,10621348,10621352,10621353,10621354,10621355,10621375,10621381,10621382,10621383,10621422,10621423,10621424,10621428,10621429,10621430,10621431,10621432,10621433,10621434,10621436,10621438,10621439,10621440,10621441,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621456,10621460,10621461,10621464,10621465,10621480,10621481,10621482,10621483,10621484,10621491,10621492,10621496,10621497,10621498,10621500,10621501,10621502,10621503,10621504,10621511,10621513,10621514,10621521,10621522,10621523,10621529,10621530,10621531,10621532,10621533,10621537,10621538,10621539,10621540,10621541,10621542,10621543,10621544,10621545,10621565,10621572,10621573,10621581,10621582,10621587,10621631,10621632,10621646,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621658,10621689,10621692,10621693,10621694,10621705,10621706,10621742,10621743,10621745,10611053,10611054,10611065,10611066,10611067,10611068,10611069,10611070,10611071,10611072,10611073,10611074,10611077,10611078,10611680,10611794,10609044,10609998,10610001,10610002,10610003,10610004,10610005,10610022,10610059,10564471,10564472,10564473,10564482,10564483,10564488,10610339,10564489,10564496,10564560,10564561,10564562,10564563,10564564,10564565,10564566,10564567,10564568,10564569,10564570,10564571,10564572,10564573,10564574,10564575,10564576,10564577,10564578,10564579,10564580,10564594,10564595,10564596,10564597,10564610,10564611,10564612,10564613,10564624,10564625,10610491,10517634,10517635,10517679,10517681,10419423,10419424,10419698,10419699,10419700,10419701,10419702,10419724,10419725,10419905,10419906,10419917,10420138,10420139,10420140,10416150,10416151,10462883,10462899,10463024,10463027,10463028,10463046,10463099,10463104,10471176,10471177,10471178,10471180,10471181,10471183,10471185,10471186,10471188,10471189,10471190,10471191,10471193,10471194,10471196,10471198,10471199,10471201,10471203,10471204,10471207,10471208,10463371,10463392,10463393,10463394,10463395,10463396,10463402,10463404,10471421,10471433,10471434,10463434,10471435,10463745,10463746,10463749,10463750,10463751,10463771,10471835,8563231,8563248,8563362,8563364,8563365,8563372,8563373,8563400,10470117,10470126,10470129,10470131,10470132,10470134,10470135,8563544,10462330,10462413,10462438,10462444,10462445,10462446,10462448,10462456,10462457,10462459,10462473,10462511,10462516,10462530,10462531,10462538,10462545,10462598,10462606,10462607,10462608,10462612,10462613,10462614,10462653,10462654,10462655,10462656,10462657,10462665,10462724,10462728,10462729,10462771) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'