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(8574000,7076144,7076145,7076146,7076147,7076148,7076149,7076150,7076151,7076152,7076153,7076154,7076155,7076156,7076157,7076158,7076159,7076160,7076161,7076162,8839040,8583086,8583087,8583088,8583089,8583090,8583091,8583092,8583093,8583094,8583095,8583096,8583097,8583098,8575139,8575140,8575141,8575142,8575143,8575144,8575145,8575146,8575147,8575148,8575149,8575150,8575151,8575152,8575153,8575154,8575155,8575156,8575157,8575158,8575159,8575160,8609592,8609593,8609594,8609595,8594652,8594653,8594654,8594655,7201689,7202223,7202224,7202225,7202226,7202227,5654660,10100097,8564676,10101564,10101565,10101566,8906129,8906130,8906131,8906132,8906133,8906134,8906135,8906136,8906137,8906138,8906139,8906140,8906141,8906142,8906143,8906144,8906145,8906146,8906147,8906148,8906149,8906150,8906151,8906152,8906153,8906154,8906155,8906156,8906157,8906158,8906159,8906160,8906161,8906162,8906163,8906164,8906165,8906166,8906167,8906168,8906169,8906170,8906171,8906172,8906173,8906174,8906175,8906176,8906177,8906178,8906179,8906180,8906181,8906182,8906183,8906184,8906185,8906186,8906187,8906188,8906189,8906190,8906191,8906192,8906193,8906194,8906195,8906196,8906197,8906198,8906199,8906200,8906201,8906202,8906203,8906204,8906205,8906206,8906207,8906208,8906209,8906210,8906211,8906212,8906213,8906214,8906215,8906216,8906217,8906218,8906219,8906220,8906221,8906222,8906223,8906224,8906225,8906226,8906227,8906228,8906229,8906230,8906231,8906232,8906233,8906234,8906235,8906236,8906237,8906238,8906239,8906240,8906241,8906242,8906243,8906244,8906245,8906246,8906247,8906248,8906249,8906250,8906251,8906252,8906253,8906254,8906255,8906256,8906257,8906258,8906259,8906260,8906261,8906262,8906263,8906264,8906265,8906266,8906267,8906268,8906269,8906270,8906271,8906272,8906273,8906274,8906275,8906276,8906277,8906278,8906279,8906280,8906281,8906282,8906283,8906284,8906285,8906286,8906287,8906288,8906289,8906290,8906291,8906292,8906293,8906294,8906295,8906296,8906297,8906298,8906299,8906300,8906301,7157676,7157677,7157678,7157679,7157680,7157681,7157682,7157683,7157684,7157685,7157686,7157687,7157688,7157689,7157690,7157691,7157692,7157693,7157694,7157695,7157696,7157697,7157698,7157699,7157700,7157701,7157702,7157703,7157704,7157705,7157706,7157707,7157708,7157709,7157710,7157711,7157712,7157713,7157714,7157715,7157716,7157717,7157718,7157719,7157720,7157721,7157722,7157723,7157724,7157725,7157726,7157727,7157728,7157729,7157730,7157731,7157732,7157733,7157734,7157735,7157736,7157737,7157738,7157739,7157740,7157741,7157742,7157743,7157744,7157745,7157746,7157747,7157748,7157749,7157750,7157751,7157752,7157753,7157754,7157755,7157756,7157757,7157758,7157759,7157760,7157761,7157762,7157763,7157764,7157765,7157766,7157767,7157768,7157769,7157770,7157771,7157772,7157773,7157774,7157775,7157776,7157777,7157778,7157779,7157780,7157781,7157782,7157783,7157784,7157785,7157786,7157787,7157788,7157789,7157790,7157791,7157792,7157793,7157794,7157795,7157796,7157797,7157798,7157799,7157800,7157801,7157802,7157803,7157804,7157805,7157806,7157807,7157808,7157809,7157810,7157811,7157812,7157813,7157814,7157815,7157816,7157817,7157818,7157819,7157820,7157821,7157822,7157823,7157824,7157825,7157826,7157827,7157828,7157829,7157830,7157831,7157832,7157833,7157834,7157835,7157836,7157837,7157838,7157839,7157840,7157841,7157842,7157843,7157844,7157845,7157846,7157847,7157848,7157849,7157850,7157851,7157852,7157853,7157854,7157855,7157856,7157857,7157858,7157859,7157860,7157861,7157862,7157863,7157864,7157865,7157866,7157867,7157868,7157869,7157870,7157871,7157872,7157873,7157874,7157875,7157876,7157877,7157878,7157879,7157880,7157881,7157882,7157883,7157884,7157885,7157886,7157887,7157888,11006431,10615237,10620306,10925842,10925843,10615353,10615354,10615435,7154413,7154414,7154415,7154416,7154417,7154418,7154419,7154420,7154421,8904265,8904266,8904267,8904268,8904269,8904270,8904271,8904272,8904273,8904274,8904275,8904276,8904277,8904278,8904279,8904280,8904281,8904282,8904283,8904284,8904285,8904286,8904287,8904288,8904289,8904290,8904291,8904292,8904293,8904294,8904295,8904296,8904297,8904298,8904299,8904300,8904301,8904302,8904303,8904304,8904305,8904306,8904307,8904308,10921966,10921967,10714020,6669917,6669918,6669919,6669920,6669921,6669922,6669923,6669924,6669925,6669926,6669927,6669928,6669929,6669930,6669931,6669932,6669933,6669934,6669935,6669936,6669937,6669938,6669939,6669940,6669941,6669942,6669943,6669944,6669945,10614530,3962364,3962365,10611842,10611991,10611992,10611993,10610040,10613060,10613061,10613062,10613078,10610093,10610323,10610702,10610703,10610930,10610946,10610947,10610948,10610949,10610950,10610951,10610952,6673997,6674033,6674034,6674037,6674042,6674044,6674045,6674049,6674052,6674053,6674054,6674055,6674057,6674062,6674063,6674072,10118440,10118441,10118442,10118443,10118444,10118445,10118446,10118447,9160308,9160309,9160310,9160311,9160312,9160313,9160314,9160315,9160316,9160317,9160318,9160319,9160320,9160321,9160322,9160323,9160324,9160325,9160326,9160327,9160328,9160329,9160330,9160331,9160332,9160333,9160334,9160335,6672763,6672764,6672765,6672766,6672767,6672768,6672769,6672770,6672771,6672772,6672773,6672774,6672775,6672776,6672777,6672778,6672779,6672878,6672879,6672885,6672886,6672887,9207239,9207291,9207292,9207293,10115560,10115561,10115562,10115563,10115564,10115565,10115566,10115567,10115568,10115569,10115570,10115571,10115572,10115573,10115574,10115575,10115576,10115577,10115578,10115579,10115580,10115581,10115582,10115583,10115584,10115585,10115586,10115587,10115588,10115589,10115590,10115591,10115592,10115593,10115594,10115595,10115596,10115597,10115598,10115599,10115600,10115601,10115602,10115603,10115604,10115605,10115606,10115607,10115608,10115609,10115610,10883572,10883573,10883574,10883575,10883576,10883577,10883578,10883579,10883580,10883581,10883582,10883583,10883584,10883585,10883586,10883587,10883588,10883589,10883590,10883591,10883592,10883593,10883594,10883595,10883596,10883597,10883598,10883599,10883600,10883601,10883602,10883603,10883700,10883701,10883702,10883703,10883704,10883705,10883706,10883707,10883708,10883709,10883710,10884021,10884022,10884023,10884024,10884025,10884026,10884027,10884028,10884029,10884030,10884031,10884032,10884033,10884034,10884035,10884036,10884037,10884038,10884039,10884040,10884041,10884042,10884043,10884044,10884045,10884046,10884047,10884048,10884049,10884050,10884051,10884052,10884053,10884054,10884055,10884056,10884057,10884058,10875001,10153863,10888070,10888071,10888072,10888073,10888074,10888075,10888076,10888077,10888078,10888079,10888080,10888081,10888082,10888083,10888084,10888085,10888086,10888087,10888088,10888089,10888090,10888091,10888092,10888093,10888094,10888095,10888096,10888097,10888098,10888099,10888100,10888101,10888102,10888103,10888104,10888105,10888106,10888107,10888108,10888109,10888110,10888111,10888112,10888113,10888114,10888115,10888116,10888117,10888118,10888119,10888120,10888121,10888122,10888123,10888124,10888125,10888126,10888127,10888128,10888129,10888130,10888131,10888132,10888133,10888134,10888135,10888136,10888137,10888138,10888139,10888140,10888141,10888142,10888143,10888144,10167097,10167118,10887238,10643471,10647423,10496955,10496956,10496957,10496958,10496959,10496960,10496961,10496962,10496963,10496964,10496965,10496966,10496967,10496968,10496969,10496970,10496971,10496972,10496973,10496974,10496975,10496976,10496977,10496978,10496979,10496980,10496981,10496982,10496983,10496984,10496985,10496986,10496987,10496988,10496989,10496990,10496991,10496992,10496993,10496994,10496995,10496996,10496997,10496998,10496999,10497000,10497001,10497225,10497226,10497227,10497228,10497229,10497230,10497231,10497232,10497233,10497234,10497235,10497236,10497237,10497238,10497239,10497240,10497241,10497242,10497243,10497244,10497245,10497246,10497247,10497248,10497249,10497250,10497251,10497252,10497253,10497254,10497255,10497256,10497257,10497258,10497259,10497260,10497261,10497262,10497263,10497264,10497265,10497266,10497267,10497268,10497269,10497270,10497271,10497272,10497273,10497274,10497275,10497276,10497277,10497278,10497279,10497280,10497281,10497282,10497283,10497284,10497285,10497286,10497287,10497288,10497289,10497290,10497291,10497292,10497293,10497294,10497295,10497296,10497297,10497298,10497299,10497300,10497301,10497302,10497303,10497304,10497305,10497306) 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'