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(8838408,8838409,8838410,8838411,8838412,8838413,8838414,8838415,8067639,8067640,8067641,8067642,8067643,8067644,8067645,8067646,8067647,8067648,8067649,8067650,8067651,8067652,8067653,11039202,11039203,11039204,11039205,11039206,11039207,11039208,11039209,11039210,11039211,11039212,11039213,11039214,11039215,11039216,11039217,11039218,11039219,11039220,11039221,11039222,11039223,11039224,11039225,11039226,11039227,11039228,11039229,11039230,11039231,11039232,11039233,11039234,11039235,11039236,11039237,11039238,11039239,11039240,11039241,11039242,11039243,11039244,11039245,11039246,11039247,11039248,11039249,11039250,11039251,11039252,11039253,11039254,11039255,11039256,11039257,11039258,11039259,11039260,11039261,11039262,11039263,11039264,11039265,11039266,11039267,11039268,11039269,11039270,11039271,11039272,11039273,11039274,11039275,11039276,11039277,11039278,11039279,11039280,11039281,11039282,11039283,11039284,11039285,11039286,11039287,11039288,11039289,11039290,11039291,11039292,11039293,11039294,11039295,11039296,11039297,11039298,11039299,11039300,11039301,11039302,11039303,11039304,11039305,11039306,11039307,11039308,11039309,11039310,11039311,11039312,11039313,11039314,11039315,11039316,11039317,11039318,11039319,11039320,11039321,11039322,11039323,11039324,11039325,11039326,11039327,11039328,11039329,11039330,11039331,11039332,11039333,11039334,11039335,11039336,11039337,11039338,11039339,11039340,11039341,11039342,11039343,11039344,11039345,11039346,11039347,11039348,11039349,11039350,11039351,11039352,11039353,11039354,11039355,11039356,11039357,11039358,11039359,11039360,11039361,11039362,11039363,11039364,11039365,11039366,11039367,11039368,11039369,11039370,11039371,11039372,11039373,11039374,11039375,11039376,11039377,11039378,11039379,11039380,11039381,11039382,11039383,11039384,11039385,11039386,11039387,11039388,11039389,11039390,11039391,11039392,11039393,11039394,11039395,11039396,11039397,11039398,11039399,11039400,11039401,11039402,11039403,11039404,11039405,11039406,11039407,11039408,11039409,11039410,11039411,11039412,11039413,11039414,11039415,11039416,11039417,11039418,11039419,10942928,10942929,10942930,10942931,10942932,10942933,10942934,10942935,10942936,10942937,10942938,8861337,8861339,3656470,8565284,8565285,8565286,8565287,8565288,8565289,10923638,10923639,10923640,10923641,10923642,10923643,10923644,10923645,10923646,10923647,10923648,10923649,10923650,10923651,10923652,10923653,10923654,10923655,10923656,10923657,10923658,10923659,10923660,10923661,10923662,10923663,10923664,10923665,10923666,10923667,10923668,10923669,10923670,10923671,10923672,10923673,10923674,10923675,10923676,10923677,10923678,10923679,10923680,10923681,10923682,10923683,10923684,10923685,10923686,10923687,10923688,10923689,10923690,10923691,10923692,10923693,10923694,10923695,10923696,10923697,10923698,10923699,10923700,10923701,10923702,10923703,10923704,10923705,10923706,10923707,10923708,10923709,10923710,10923711,10923712,10923713,10923714,10923715,10923716,10923717,10923718,10923719,10923720,10923721,10923722,10923723,10923724,10923725,10923726,10923727,10923728,10923729,10923730,10923731,10923732,10923733,10923734,10923735,10923736,10923737,10923738,10923739,10923740,10923741,10923742,10923743,10923744,10923745,10923746,10923747,10923748,10923749,10923750,10923751,10923752,10923753,10923754,10923755,10923756,10923757,10923758,10923759,10923760,10923761,10923762,10923763,10923764,10923765,10923766,10923767,10923768,10923769,10923770,10923771,10923772,10923773,10923774,10923775,10923776,10923777,10923778,10923779,10923780,10923781,10923782,10923783,10923784,10923785,10923786,10923787,10923788,10923789,10923790,10923791,10923792,10923793,10923794,10923795,10923796,10923797,10923798,10923799,10923800,10923801,10923802,10923803,10923804,10923805,10923806,10923807,10923808,10923809,10923810,10923811,10923812,10923813,10923814,10923815,10923816,10923817,10923818,10923819,10923820,10923821,10923822,10923823,10923824,10923825,10923826,10923827,10923828,10923829,10923830,10923831,10923832,10923833,10923834,10923835,10923836,10923837,10923838,10923839,10923840,10923841,10923842,10923843,10923844,10923845,10923846,10923847,10923848,10923849,10923850,10923851,10923852,10923853,10923854,10923855,10923856,10923857,10923858,10923859,10923860,10923861,10923862,10923863,10923864,10923865,10923866,10923867,10923868,10923869,10923870,10923871,10923872,10923873,10923874,10923875,10923876,10923877,10923878,10923879,10923880,10923881,10923882,10923883,10923884,10923885,10923886,10923887,10923888,10923889,10923890,10923891,10923892,10923893,10923894,10923895,10923896,10923897,10923898,10923899,10923900,10923901,10923902,10923903,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10923913,10923914,10923915,10923916,10923917,10923918,10923919,10923920,10923921,10923922,10923923,10923924,10923925,10923926,10923927,10923928,10923929,10923930,10923931,10923932,10923933,10923934,10923935,10923936,10923937,10923938,10923939,10923940,10923941,10923942,10923943,10923944,10923945,10923946,10923947,10923948,10923949,10923950,10923951,10923952,10923953,10923954,10923955,10923956,10923957,10923958,10923959,10923960,10923961,10923962,10923963,10923964,10923965,10923966,10923967,10923968,10923969,10923970,10923971,10923972,10923973,10923974,10923975,10923976,10923977,10923978,10923979,10923980,10923981,10923982,10923983,10923984,10923985,10923986,10923987,10923988,10923989,10923990,10923991,10923992,10923993,10923994,10923995,10923996,10923997,10923998,10923999,10924000,10924001,10924002,10924003,10924004,10924005,10924006,10924007,10924008,10924009,10924010,10924011,10924012,10924013,10924014,10924015,10924016,10924017,10924018,10924019,10924020,10924021,10924022,10924023,10924024,10924025,10924026,10924027,10924028,10924029,10924030,10924031,10924032,10924033,10924034,10924035,10924036,10924037,10924038,10924039,10924040,10924041,10924042,10924043,10924044,10924045,10924046,10924047,10924048,10924049,10924050,10924051,10924052,10924053,10924054,10924055,10924056,10924057,10924058,10924059,10924060,10924061,10924062,10924063,10924064,10924065,10924066,10924067,10924068,10924069,10924070,10924071,10924072,10924073,10924074,10924075,10924076,10924077,10924078,10924079,10924080,10924081,10924082,10924083,10924084,10924085,10924086,10924087,10924088,10924089,10924090,10924091,10924092,10924093,10924094,10924095,10924096,10924097,10924098,10924099,10924100,10924101,10924102,10924103,10924104,10924105,10924106,10924107,10924108,10924109,10924110,10924111,10924112,10924113,10924114,10924115,10924116,10924117,10924118,10924119,10924120,10924121,10924122,10924123,10924124,10924125,10924126,10924127,10924128,10924129,10924130,10924131,10924132,10924133,10924134,10924135,10924136,10924137,10924138,10924139,10924140,10924141,10924142,10924143,10924144,10924145,10924146,10924147,10924148,10924149,10924150,10924151,10924152,10924153,10924154,10924155,10924156,10924157,10924158,10924159,10924160,10924161,10924162,10924163,10924164,10924165,10924166,10924167,10924168,10924169,10924170,10924171,10924172,10924173,10924174,10924175,10924176,10924177,10924178,10924179,10924180,10924181,10924182,10924183,10924184,10924185,10924186,10924187,10924188,10924189,10924190,10924191,10924192,10924193,10924194,10924195,10924196,10924197,10924198,10924199,10924200,10924201,10924202,10924203,10924204,10924205,10924206,10924207,10924208,10924209,10924210,10924211,10924212,10924213,10924214,10924215,10924216,10924217,10924218,10924219,10924220,10924221,10924222,10924223,10924224,10924225,10924226,10924227,10924228,10924229,10924230,10924231,10924232,10924233,10924234,10924235,10924236,10924237,10924238,10924239,10924240,10924241,10924242,10924243,10924244,10924245,10924246,10924247,10924248,10924249,4974832,4974833,4974834,4974835,4974836,4974837,4974838,4974839,4974840,4974841,4974842,4974843,4974844,4974845,4974846,4974847,4974848,4974849,4974850,4974851,4974852,4974853,4974854,4974855,4974856,4974857,4974858,4974859,4974860,4974861,4974862,4974863,4974864,4974865,4974866,4974867,4974868,4974869,4974870,4974871,4974872,4974873,4974874,4974875,4974876,4974877,4974878,4974879,4974880,4974881,4974882,4974883,4974884,4974885,4974886,4974887,4974888,4974889,4974890,4974891,4974892,4974893,4974894,4974895,4974896,4974897,4974898,4974899,4974900,4974901,4974902,4974903,4974904,4974905,4974906,4974907,4974908,4974909,4974910,4974911,4974912,4974913,4974914,4974915,8563383,6667800,8917912,8917913,8917914,10186425,10186426,10186427,10186428,10186430,10186431,10186432,10186433,10186434,10186435,10186436,10186437,10186438,10186439,10186440,10186441,10186442,10186443,10186444,10186445,10186446,10186447,10186448,10186449,10186450,10186451,10186452,10186453,10186454,10186455,10186456,10186457,10186458,10186459,10186460,10630960,10630961,10630962) 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'