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(10988752,10988774,10943691,10943717,10943718,8569412,8569512,8569515,10944014,10944016,4970840,4970901,4970903,4970907,4970909,4970910,4970913,10976400,10963420,10963422,8569786,8569791,8569794,8569801,8569803,7068831,8569808,7068835,7068845,7068849,4971136,4971144,4968472,4968473,4968479,4968480,8067248,8067270,4968509,4968511,4968513,8067307,8067342,10437314,10437316,10437321,10437329,10437330,10437398,10437442,10437443,10437462,10437463,10437464,10437476,10990326,10990327,10990328,10990329,8067699,8067703,8067705,8067706,8067715,4968973,4968974,4968975,7074896,7074897,10990592,10990593,10990594,7066960,4969207,4969259,10938781,10961914,10961915,11000921,11000966,11000967,11000973,11000975,11000976,4969516,10939035,10988194,10962271,10962309,10962310,11001329,11001332,11001336,11001352,11001365,11001366,11001367,10988447,10962562,10985677,8065120,8065121,10931496,10959844,10931515,10931516,10931517,10931518,7072401,7072412,7072413,7072414,7072415,7072420,7072422,7072423,7072424,7072425,7072427,7072431,7072435,7072436,7072437,10999137,10999138,7072483,10931901,10931917,10931925,10931950,10931951,7064694,10932052,10932082,10986495,10932254,10932257,10932263,10986695,10932408,10932409,10932450,10932453,10932537,10932579,7065250,10932605,10932623,7065282,10932642,10932646,10932649,10932686,7065351,7065354,7065360,10932787,10932788,10932791,10932794,7065450,4968018,7071105,10942775,11010851,11010854,7071398,7071399,10943084,10943086,10943087,10943088,10943092,10943093,10943095,10943097,10943100,10943101,10943103,10998183,10998184,10998218,7071540,10985251,10985252,10985253,10998291,10998292,10985308,10985309,10985310,10985316,10998317,10985317,10985323,10985330,10985339,10985348,10985349,10985350,10985351,10985352,10985354,10985355,10985376,10972399,10972403,10985440,10985491,7071808,7071809,10985496,10985497,10985498,10985499,10985540,10985541,10985560,10985561,10985568,10985569,7069035,10956889,10944656,10995945,10944683,10944707,7069305,10944770,10944944,11009424,11009425,11009620,11009626,11009627,11009628,11009632,11009635,11009638,11009639,11009640,11009641,11009642,11009643,10941590,11009658,11009659,11009675,10957682,10941638,8072758,11009708,8072759,8072760,8072761,8072762,11009715,11009723,11009741,11009742,11009769,11009784,3656683,8072974,8072975,8072976,8072977,8072978,8072979,8072980,8072981,8072982,8072983,3656828,7070258,10958003,10958011,10941980,10958130,10958131,11010131,11010134,11010135,11010136,11010137,11010140,11010144,11010149,11010162,11010165,11010212,10958307,10942302,10958452,10958453,10958455,10958456,10942402,11049660,10997598,10967668,10967670,10967671,10623053,10967959,10967964,10967969,10967970,10967973,10967974,10955077,10955082,11007082,10955086,10955091,10955094,10955096,11007104,10968151,10955181,10955183,10955184,10994356,10623743,10981416,10623768,10981453,10981517,8070957,11008077,11008078,10995088,10995089,10995117,8071206,8071245,10619561,10624664,10624666,10925182,10925188,10925193,10925194,10925196,10925205,10925206,10925207,10925212,10925213,10925214,10925215,10925222,10925227,10925228,10925229,10925230,10925232,10925233,10925234,10925235,10925236,10624726,10925237,10925238,10624728,10925243,10925244,10925247,10925248,10925252,10925253,10925254,10925255,10925258,10925259,10925260,10925263,10925269,10925270,10925271,10925272,10925273,10925274,10925275,10925276,10925281,10925284,10925285,10925286,10925287,10925293,10925295,10925296,10925299,10925300,10925303,10925304,10925305,10925310,10925317,10925318,10925326,10925327,10925329,10925330,10925331,10925338,10925342,10925343,10925344,10925347,10925348,10925349,10925350,10925358,10925359,10925360,10925361,10925363,10956598,10624946,10953635,10953636,10953778,10953782,10953783,10953784,10953785,10953837,10953838,10922769,10922770,10922771,10922772,10922773,10922774,10922775,10922776,10922777,10922778,10922779,10922780,10922781,10922782,10922783,10922784,10922785,10922786,10992958,10992959,10967029,10993145,10993147,10993148,10993149,10967173,10993182,10993183,10993184,10622533,10967230,10967232,10622631,10967306,10967377,10967380,10967381,10622853,10622854,10622855,10622856,10967600,10967602,8570151,10991209,10991210,10991211,10991212,10991213,10991214,10991215,10991216,10991217,10930555,10930556,10930892,10930987,10621066,10926956,10616459,10926986,10927022,10927023,10616669,10922220,10922221,10922227,10922230,10922231,10922240,10922251,10922254,10922255,10992469,10992572,9165301,8863842,8864225,9165719,8864271,8864287,8864345,10562686,10562687,10562688,10562708,10562709,10562710,10562719,10562720,10562721,10562729,10562730,10562731,8864447,10562768,6665958,6665963,10559796,10559797,10559805,10559889,10559890,10614907,7057482,10563133,10563156,10563182,10563183,10563192,10563193,10563194,8861933,10560254,10560255,10560256,9187477,8862009,10560402,10560410,7057886,7057887,7057890,7057892,10609449,8862658,10558362,10558364,10564474,10564477,10564480,9188703,10564519,10564520,10564521,10564522,10564529,10564537,10564538,9188731,9188732,9188733,9188747,9188772,9188773,9164791,9164792,9188793,10564619,10564620,10564626,10564704,10564705,10564706,10564707,10564709,10564710,10564762,10558764,9164953,10564796,10564797,10564799,10564802,9165130,10558994,8863742,8863789,9161449,7055648,9185655,4974667,10513779,4974826,4974827,4974828,4974829,9162207,4975090,9162260,9162261,9162445,9162446,9162447,9162448,2809181,7056753,9186626,9186627,2809277,2809609,9163200,8918059,9168451,9160457,4973359,4973421,4973477,4973485,4973486,4973501,4973549,4973575,4973594,4973596,4973626,4973635,4973639,9184822,7055176,4973922,4973924,4973927,4973951,9185198,9185237,9174300,10464877,9174301,9174302,4971167,10466948,10466949,10466952,10466953,9174521,6666519,10465131,10465134,9174672,9182697,9182730,9182731,10471391,10465478,10463568,8916640,8916657,10463614,10463615,10465637,9175085,10465671,10465721,6667301,8563203,10465970,6667407,6667409,8563399,4972397,10468125,10468136,8563476,8917446,10466394,8917478,8917479,8917481,10468478,8917608,8917651,10464648,10462715,10462716,10462719,10464774,10464775,10464776,10464778,10464780,10464781,8917858,10464823,10464824,10464827,10627962,10627968,10175298,10175329,10175340,10175349,10175388,10175638,10175639,10175714,10175715,10175716,10175787,10175788,10175789,10175790,10175803,10170879,10155975,10171008,10156064,10156222,10156224,10163504,10627087,10627088,10627094,10173723,10173732,10627210,10627211,10173733,10163755,10173816,10173817,10173822,10173823,10173830,10627537,10627550,10627551,10627552,10627600,10174214,10174218,10174219,10174220,10174228,10174230,10174237,10174238,10174239,10174245,10174246,10174247,10174248,10174249,10174250,10174260,10174261,10627959,10625022,10625198,10161910,10161915,10161972,10625585,10625587,10172270,10167302,10167303,10625912,10172548,10172644,10172884,10172893,10172894,10172925,10172959,10626461,10631472,10631473,10173007,10173008,10163011,10173020,10173027,10158029,10158038,10173053,10173082,10173083,10631653,10173272,10626758,10626759,10626760,10173283,10626767,10626774,10626775,10626806,10580213,10580251,10580252,10580253,10566355,10566357,10566405,10566555,10578673,10578674,10578675,10578676,10578677,10578678,10578679,10578680,10578681,10578683,10578684,10578685,10581777,10519244,10519245,10519246,10519247,10519248,10519250,10519252,10519254,10529327,10529328,10529329,10529330,10529331,10529332,10529333,10519344,10519350,10519351,10519352,10519353,10519354,10519357,10519358,10519359,10519360,10519361,10527399,10527400,10529424,10521447,10521448,10519451,10519456,10519457,10519462,10519464,10525527,10525530,10519595,10519596,10519831,10519832,10519833,10519834,10519836,10519839,10519948,10519949,10519950,10519951,10530435,10530466,10530467,10522621,10530829,10530830,10422305,10422560,10424575,10421677,10422752,10423056,10423065,10422130,10472895,10472896,10472897,10472923,10472963,10473201,10479213,10479214,10473225,10473226,10479247,10473253,10479307,10479308,10473317,10479329,10479330,10479345,10473347,10479356,10479357,10479358,10479369,10479370,10479371,10479372,10479375,10479376,10479393,10479394,10479395,10479399,10479400,10479401,10479406,10479419,10479420,10479429,10479430,10479431,10473438,10473439,10479443,10479477,10479478,10479479,10479491,10479493,10479497,10479498,10479502,10479508,10479509,10479510,10479511,10479512,10479523,10479524,10479525,10479527,10479528,10479529,10479531,10479542,10479547,10473694,10473695,10473785,10474020,10474021,10474072,10480308,10476327,10476328,10476329,10476330,10476332,10476484,10476609,10480611,10472665,10472668,10480691,10472692,10472693,10472694,10472713,10472714,10472715,10472716,10472731,10472732,10472750,10472777,10472778,10472779,10472789,10472795,10478796,10472796,10472797,10472798,10472801,10472802,10472838,10476843,10472846) 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'