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(8068814,8068816,8068822,7067875,7067876,7067878,7067879,7067880,8068865,7067883,7067884,10943623,7076249,7076250,10943952,10943977,10944002,10944003,10944004,10944005,8569661,8569719,7073823,7073836,7073840,7073841,7073846,7073847,7073849,7073869,7073870,7073872,7073873,7065906,7073923,7073980,10199309,7074150,7074152,7074156,7074158,7074159,7074161,7074162,7074164,7074165,7074167,7074168,7074171,7074176,7066178,7074179,7074180,7074183,7074186,7074209,7074311,7066355,10199617,10199618,10199619,10199620,10199621,10199622,10199623,10199624,10199625,10199626,10199627,10199628,10199629,10199630,10199631,10199632,10199633,10199634,10199635,10199636,10199637,10199638,10199639,10199640,7074549,10199802,10199803,10199804,10199863,7066692,10200014,7066892,7066893,7066894,7066917,7066930,7075284,7075498,7067595,7075672,7075673,7075674,7067709,7067714,7067715,7067719,7067720,7067723,7067725,7067728,7067731,7067732,7067733,7067734,7075759,7075760,7075761,7075762,7075763,7075764,7075768,6000190,6000195,6000197,6000199,6000273,6000281,6000285,6000296,10195454,7072452,7072455,7072456,7064463,7064464,7064465,8075325,10195975,10195976,10195977,7064890,7064965,10196233,10196234,10196235,10196236,10196348,10196349,10196387,7065178,7073182,10932663,7065238,10196487,7065261,7065274,7073524,7073621,4968029,4968033,4968034,4968035,4968036,7073702,7073704,7073715,10197019,10197024,7070845,10207086,10942578,10942579,10942586,10194140,10194141,10194142,10194143,10942645,10942657,10942675,10942703,10942704,10942705,10942707,10942708,10942716,10942754,7071375,8861298,8861299,10943228,7071584,10194910,8970204,6000065,6000067,6000070,6000073,6000081,10944354,10944416,10944417,10944425,10944426,10944430,10944432,10944433,10944435,10944438,10944793,10944844,10944852,10944871,10944872,10944874,10944877,10945035,8072645,8072650,8072655,8072660,8072665,8072670,8072675,8072680,8072685,8072690,8072695,8072700,8072705,8072710,8072715,8072720,8072725,8072730,8072735,8072740,8072745,8072750,8072755,8072760,8072765,8072770,8072775,8072780,8072785,8072790,8072798,8072806,8072814,8072822,8072830,8072838,8072850,8072858,8072870,8072878,8072888,8072894,8072906,8072914,8072922,8072929,8072940,8072947,8072955,8072963,8072971,8072979,10941859,10941916,10941917,10941918,10941960,7070421,8860360,8860389,7070721,10623059,10203177,10203185,10203186,10203187,10928616,10203200,10203201,10203203,10928623,10928624,10618232,10618269,10618278,10618304,10618322,10618667,10618668,10618683,10618684,10618685,10618820,10203954,10203955,10204180,10204181,10204218,10204219,10204220,10204221,10204222,10619129,10619130,10619131,10619132,10619133,10619134,10619135,10619136,10619137,10619138,10619139,10619140,10619141,10619142,10619143,10619144,10619145,10619147,10619148,10619171,10619242,10619243,10619244,10619245,10204344,10204345,10619250,10189192,10617223,10927891,10928121,10928122,10928127,10928160,10189848,10189849,10189850,10189851,10189852,10189853,10189854,10189855,10622885,10622886,10622887,10622888,10622889,10622890,10622906,10622907,10622908,10622909,10622910,10622911,10622912,10622913,10614991,10615037,10620056,10620068,10620069,10620119,10620120,8570032,8570036,10615230,10615351,8570208,8570209,8570261,8570264,8570267,8570268,10926036,8570497,8570503,10930529,10926255,10926256,10930574,10615819,10926338,10930652,10616000,10616001,10616048,10201147,10930925,10921654,10921664,10930974,10921674,10921683,10921696,10921698,10921699,10921703,10921704,10921705,10921706,10931008,10921707,10921713,10921716,10931019,10921726,10921744,10921745,10921769,10921787,10921800,10921823,10921855,10921856,10921862,10921864,10921866,10921883,10921932,10921933,10921934,10921942,10921944,10921947,10921970,10921974,10922073,10922089,10922094,10201685,10616595,10201772,10201773,10201774,10201775,10616716,10201871,10201872,10201873,10927438,10927439,10927440,10927461,10927462,10927463,10927464,10927465,10927466,10927467,10927468,10927469,10927470,10927471,10927472,10927473,10927474,10927475,10927476,10927477,10927478,10565125,10565126,10565185,10559211,10559212,10559213,10559214,10559293,7059669,10559318,10565318,10559319,10559327,10559328,10559329,10559330,10614243,10614245,10614281,10559471,10559472,10559473,10559474,10559475,10559477,10559478,10559481,10559482,10614366,10614367,10614414,10559610,10559611,10559612,10559613,10559615,10614508,10614530,10565710,10565711,10614591,8864557,8864558,8864559,8864566,8864570,8864571,8864574,8864575,8864576,8864581,8864582,8864585,8864587,8864593,8864594,8864595,8864598,8864599,8864601,8864608,8864609,8864611,8864612,8864614,8864618,8864645,8864647,8864648,8864652,8864655,8864657,8864658,8864660,8864664,8864682,8864684,8864685,8864686,8864688,8864692,8864694,8864696,8864711,8864713,8864714,8864715,8864719,8864721,8864723,8864780,6666259,7057572,7057573,7057583,7057590,10612093,10612108,7057679,7057680,8862085,8862145,10563530,7058239,7058523,7058533,7058534,7058537,7058550,7058554,7058605,8862977,8862987,7058632,8862988,7058635,8863000,8863001,8863002,8863007,8863009,8863019,8863020,8863022,8863037,8863038,8863042,8863047,8863051,8863055,8863063,8863067,7058746,8863188,8863629,10515139,10515140,10515141,10515142,10515143,10513339,7055838,10517515,10517516,7055912,4974602,4974608,4974644,4974645,7056076,7056077,10515727,7056095,7056096,7056108,7056109,7056110,7056111,7056112,7056113,7056114,10515820,10517823,10517824,10517825,4975260,4975261,4975262,10512583,10512584,7057200,10512848,10512860,10512861,10517042,10517043,10517044,10517045,10517046,10517047,10517048,10517049,10517050,10517051,10517052,10517053,10517054,10517055,10517056,10517057,10517058,10517059,10517060,10517061,10517062,10517063,10517064,10517065,10517066,10517067,10517068,10517069,10517070,10517071,10517072,10517073,10517074,10517075,10517076,10517077,10517078,10517079,10517080,10517081,10517082,10517083,10517084,10517085,10517086,10517087,10517088,10517089,10517090,10517091,10517092,10517093,10517094,10517095,10517096,10517097,10517098,10517099,10517100,10517101,10517102,10517103,10517104,10419239,10419267,10419268,10416303,10416321,10416322,10416328,4973267,10419398,10419427,8918180,10416449,10416454,10416460,10416468,10416469,10416482,10416483,10419505,10419516,10419528,10419532,10419535,10418542,10417555,10417556,10417557,10419591,10416672,10418683,7054964,10419792,10419798,10417806,10419898,10418914,4973898,10417003,4974000,4974007,4974011,4974012,4974013,4974014,4974016,4974026,4974027,4974042,4974055,4974056,4974057,4974058,4974059,4974060,4974061,4974103,4974104,4974106,4974113,4974114,4974118,4974119,7055447,4971335,4971336,4971337,4971338,4971339,4971340,4971373,4971387,8865129,10467337,10467338,10467339,10467340,10471461,8916876,8917035,8917036,8917044,8917054,8917064,8917069,8917070,8917071,8917076,8917079,8917146,8917623,8917627,8917628,8917691,8917694,8917695,8917696,8917697,8917706,8917712,8917750,8917773,8917789,8917830,8917831,8917832,10628298,10628299,10628431,10628541,10628542,10628543,10628581,10628652,10628835,10628836,10628844,10628889,10628897,10628898,10628901,10629242,10629243,10629244,10629245,10629246,10629247,10629248,10629249,10629250,10629251,10629252,10629253,10629254,10629255,10629256,10629257,10629258,10629259,10629260,10629261,10629262,10629334,10629336,10629410,10629430,10629431,10629508,10629511,10629842,10629850,10629855,10629856,10629857,10629872,10629874,10629875,10629881,10629894,10629926,10629927,10629936,10629938,10629939,10629940,10629941,10629956,10629957,10629958,10631974,10631975,10631992,10632060,10632061,10632062,10632063,10632068,10632082,10632083,10627105,10632163,10632164,10632165,10629963,10629967,10629975,10629976,10629977,10629978,10630023,10630149,10630153,10630154,10631546,10631549,10631706,10626720,10626732,10626734,10626739,10626740,10626741,10626743,10626744,10631893,10568114,10568115,10568121,10568122,10568123,10568124,10568125,10568126,10568302,10568303,10568304,10568310,10568311,10568312,10568389,10568390,10568393,10568394,10568396,10568477,10568482,10568483,10568493,10568506,10568517,10568518,10568519,10568520,10568521,10568532,10568559,10568942,10568952,10568953,10568954,10568961,10568987,10570077,10570090,10570091,10570094,10570101,10570106,10570123,10570124,10570125,10570129,10570134,10570135,10570136,10570138,10570146,10570152,10567481,10567482,10567787,10567788,10567796,10567798,10567799,10567808,10567809,10567810,10567811,10567812,10567813,10567814,10567815,10567816,10567817,10567818,10567819,10567820,10567829,10567830,10567831,10567832,10567833,10567834,10567835,10567836,10567837,10520740,10520741,10520742,10520926,10420382,10420673,10420696,10420697,10420904,10420908) 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'