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(7067911,10943427,10943428,10943429,10943430,10943431,10943432,10943436,10943437,7068140,7068147,7068148,7068161,7068261,7068297,7068298,7068326,7068348,7068349,7068351,7068352,7068605,7068606,7068724,7068726,7068735,7068740,7068750,7068759,7068765,7068768,7068769,7068770,7068775,7068791,7068807,7068808,7068809,7068812,7065900,7065950,10437200,10437402,10437606,7066699,7066821,8067832,7066912,7066913,8067903,8067906,8067952,8067953,8067954,8067955,8067956,8067957,8067958,8067959,8067960,7066994,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068025,8068026,8068027,8068040,8068057,7067084,8068067,8068068,8068069,8068070,8068071,8068072,8068073,8068074,8068075,8068076,8068097,8068098,8068099,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,8068139,8068140,8068141,8068142,8068143,8068144,8068145,8068146,8068147,8068190,8068191,8068192,8068193,8068194,8068242,8068243,7067270,8068253,8068254,7067271,8068255,8068272,8068273,8068297,8068298,8068299,8068306,8068307,8068308,8068309,8068310,8068311,8068312,8068313,8068314,8068349,8068398,8068399,8068420,8068421,8068422,8068449,8068450,8068451,8068464,8068472,8068493,8068494,8068495,8068496,8068497,8068498,8068499,8068500,8068501,8068502,8068503,8068504,8068505,8068506,8068507,8068508,8068524,8068525,8068526,8068527,8068540,8068541,8068542,8068543,8068544,8068545,8068546,8068624,8068635,8068636,8068637,8068638,8068639,8068645,8068694,8068709,8068710,8068711,8068727,7067751,7067789,6000114,6000214,7064045,7064046,7064047,7064048,7064049,7064050,7064051,7064052,7064053,7064054,10931538,10931539,10931558,10931570,10932096,4967031,4967034,4967035,4967036,4967037,4967038,4967039,4967040,4967041,4967042,4967043,4967044,4967045,4967046,4967047,4967048,4967049,4967050,4967051,4967052,4967053,4967054,7064725,4967063,4967064,4967065,4967066,4967067,10932185,10932186,10932187,10932188,10932189,10932190,10932201,10932216,10932217,4968121,8860896,10942709,8860908,8860909,8860910,8860923,10942747,10942763,10942788,8860986,10942821,10942823,10942825,10942826,8861181,8861278,8861301,8861329,10943185,10943192,10943193,10943197,10943285,8861545,10943366,10943380,10943399,10943422,8970215,8970216,10944385,10944405,10944413,10944450,10940719,10940720,10940749,10940826,10944862,10941095,10941352,10941710,10941796,10941804,10941807,10941808,10941818,10941824,10941843,10941850,10941851,10941852,10941853,10941896,10941901,10941902,10941904,10941906,10941910,10941931,10941932,10941943,10941944,10941945,10941947,10941954,10941989,10941994,10941996,10941999,10942001,10942007,10942009,10942010,10942013,10942014,10942015,10942017,10942018,10942019,10942024,10942058,8860262,8860267,8860268,10942141,10942196,8860418,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,8073517,8073518,8073519,8073520,10942416,8860613,10923476,10923477,10923478,10923479,10923533,10928558,10923562,10923563,10923564,10928575,10928580,10928588,10928589,10923591,10923592,10928599,10928615,10923618,10923625,10923626,10923627,10923635,10923645,10923646,10923647,10923648,10923649,10923650,10928673,10928677,10923721,10923722,10923819,10923820,10923821,10623312,10923873,10923874,10924043,10924044,10924045,10623658,10924291,10624203,10924773,10924774,10924775,10924776,10924777,10924778,10924779,10924780,10924781,10924856,10924857,10924977,10924978,10924979,10924980,10924981,10924982,10925220,10925221,10925222,10925223,10925379,10925380,10925381,10925382,10925435,10925436,10925437,10925438,10925459,10925460,10925461,10925462,10925463,10621990,10621991,10621992,10622012,10622013,10622104,10622105,10922643,10622190,10922709,10622264,10622265,10622266,10622267,10622268,10622269,10922817,10922818,10922819,10927889,10922901,10922902,10922904,10922905,10922911,10922920,10922921,10922943,10922944,10922947,10922949,10922957,10922958,10922965,10927978,10922986,10927993,10622524,10923085,10923086,10923087,10923100,10923101,10923102,10923124,10923145,10622656,10622662,10928210,10923212,10923229,10923230,10923231,10923232,10923233,10928253,10928254,10923278,10923279,10923280,10923342,10923360,10622881,10622882,10923394,10622885,10923401,10923402,10622892,10923403,10622893,10923404,10923405,10923447,10923448,10923449,10923450,10923451,10920594,10920595,10920596,10920597,10620143,10620210,10920740,10920741,10920742,10920743,10920744,10920745,10920746,10920747,10920748,10920749,10920750,10920751,10920752,10920753,10920754,10920755,10920756,10920757,10920758,10920759,10920760,10920761,10920762,10920763,10920764,10920765,10920766,10920767,10920768,10920769,10920770,10920771,10920772,10920773,10920774,10920775,10920776,10920777,10920778,10920779,10920780,10920781,10920782,10920783,10920784,10920785,10920786,10920787,10920788,10920789,10920790,10920791,10920792,10920793,10920794,10920795,10920796,10920797,10920798,10920799,10920800,10920801,10920802,10920803,10920804,10920805,10920806,10920807,10920808,10920809,10920810,10620300,10920811,10620301,10920812,10920813,10620303,10920814,10920815,10920816,10920817,10920818,10920819,10920820,10920821,10920822,10920823,10920824,10920825,10920826,10920827,10920828,10920829,10920830,10920831,10920832,10920833,10920834,10920835,10920836,10920837,10920838,10920839,10920840,10920841,10920842,10920843,10920844,10920845,10920846,10925854,10920860,10620350,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620370,10620408,10620409,10620410,10620426,10926008,10926009,10926010,10926011,10926012,10926013,10926014,10926015,10620528,10921056,10926154,10926155,10926156,10926157,10926158,10926159,10926160,10926161,10926162,10926163,10926164,10926165,10926166,10926167,10926168,10926169,10620669,10921200,10921201,10921202,10921203,10921248,10921330,10921344,10921345,10921398,10921476,10921477,10921478,10921497,10921556,10921584,10921585,10921587,10921588,10921589,10621116,10621117,10621119,10621120,10621132,10621146,10621147,10621148,10621150,10621155,10621160,10621161,10621162,10926730,10621239,10621240,10621241,10621242,10621265,10926776,10621266,10621273,10621274,10621279,10621284,10621288,10621289,10621290,10621291,10621292,10621293,10621301,10621305,10621306,10621320,10621323,10621324,10621375,10621376,10621377,10621378,10621379,10621380,10927060,10927061,10927062,10927063,10927071,10621587,10927109,10621645,10621651,10621684,10621688,10621689,10621692,10621693,10621695,10621698,10621705,10927445,10565186,10565189,10565196,10614067,10614190,10614198,10614236,10559476,10614384,10614385,10614403,10559622,10614507,10614508,10614530,10559701,10565707,10565708,10614726,10614820,10614857,10566044,10566046,10566057,10566058,10612022,10612034,10612086,10612131,10612189,10612284,10612285,10563504,10563505,10563506,10563507,10557519,10563519,10557520,10563520,10557521,10557522,10563534,10563546,10612407,10563567,10563572,10612424,10557619,10557620,10612486,10612496,10612501,10612502,10612503,10557665,10612519,10612553,10612586,10612611,10612637,10557819,10612687,10612688,10612707,10612714,10612715,10612833,10612834,10612841,10612842,10612846,10612860,10612864,10612867,10612868,10613006,10613011,10613057,10613084,10613086,10613453,10558624,10558625,10613548,10613741,10613745,10613764,10613765,10513233,10517247,10517248,10517249,10517250,10517251,10517252,10517253,10517254,10517255,10517287,10517288,10517300,10517301,10517302,10517303,10517304,10517305,10513400,10517557,10517605,10513627,10517659,10517809,10517818,10513823,10513824,10513827,10513834,10513835,10513836,10513837,10513838,10513839,10513840,10513849,10513850,10513851,10513852,10513853,10513854,10513858,10513859,10513860,10513861,10513862,10513863,10513864,10513904,10513951,10513976,10513996,10514043,10514114,10514115,10514368,10514369,10514370,10514371,10514372,10514373,10514374,10514615,10514639,10512903,10416231,10416239,10419243,10416345,10416364,10416365,10416366,10419459,10419568,10416593,10416629,10416630,10416631,10416632,10416633,10416634,10416635,10416636,10419891,10419895,10419899,10419901,10419904,10419905,10419907,10419921,10419923,10419925,10416925,10419936,10419937,10419942,10419944,10416978,10416980,10416982,10419994,10420036,10420053,10417053,10417054,10420055,10417055,10420056,10417096,10417097,10417098,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10471128,10471129,10471176,10471177,10471193,10465682,10465683,10465684,10465685,10465759,10465760,10465770,10465796,10465797,10465798,10465799,10465800,10465857,10465858,10465859,10465860,10463876,10463877,10470116,10470117,10470370,10470372,10470471,10470473,10470586,10470644) 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'