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,10939646,10939647,10943623,7076249,7076250,10943952,10943977,10944002,10944003,10944004,10944005,10963247,8569661,8569719,7073823,7073836,7073840,7073841,10963526,10963527,10963528,10963529,10963530,7073846,7073847,10963531,10963532,7073849,10963533,10963534,10963535,10963536,10963537,10963538,10963539,10963540,10963541,10963542,10963543,10963544,10963545,10963546,10963547,10963548,10963549,7073869,7073870,7073872,7073873,7065906,7073923,8067004,7073980,10963669,10963670,10963671,10963735,7074150,7074152,7074156,7074158,7074159,7074161,7074162,7074164,7074165,7074167,7074168,7074171,8067243,7074176,7066178,7074179,7074180,7074183,7074186,7074209,10976969,10976970,7074311,8067407,7066355,8067454,8067464,7074549,7066692,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,10959553,6000190,6000195,6000197,6000199,6000273,6000281,6000285,6000296,10960080,10960081,10960082,8065508,7072452,7072455,7072456,7064463,7064464,7064465,8075325,10960261,10960262,10960263,10960264,10960355,10960356,10960472,7064890,7064965,8066090,8066097,8066102,8066103,8066104,8066107,8066108,8066109,8066111,7065178,7073182,10932663,7065238,7065261,7065274,10960982,10960986,7073524,7073621,4968029,4968033,4968034,4968035,4968036,7073702,7073704,7073715,7070845,10942578,10942579,10942586,10942645,10942657,10942675,10942703,10942704,10942705,10942707,10942708,10942716,10942754,10959001,7071375,8861298,8861299,10943228,7071584,8970204,6000065,6000067,6000070,6000073,6000081,10944354,10944416,10944417,10944425,10944426,10944430,10944432,10944433,10944435,10944438,3655809,3655814,10944793,3655991,3655992,3655993,10944844,10944852,10944871,10944872,10944874,10944877,3656123,3656188,3656189,10945035,3656280,3656298,3656299,3656300,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,10970617,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,10958256,10958257,7070721,10623059,10928616,10928623,10928624,10618232,10967773,10967774,10618269,10967808,10967809,10967810,10967811,10967812,10618278,10618304,10618322,10618667,10618668,10618683,10618684,10618685,10618820,10619129,10619130,10619131,10619132,10619133,10619134,10619135,10619136,10619137,10619138,10619139,10619140,10619141,10619142,10619143,10619144,10619145,10619147,10619148,10619171,10619242,10619243,10619244,10619245,10619250,10927472,10927473,10927474,10927475,10927476,10927477,10927478,10617223,10966852,10966860,10966861,10966862,10966874,10966875,10927891,10953952,10953953,10953954,10953955,10953956,10953957,10928121,10928122,10928127,10928160,10622885,10622886,10622887,10622888,10622889,10622890,10622906,10622907,10622908,10622909,10622910,10622911,10622912,10622913,10614991,10615037,10620056,10620068,10620069,10620119,10620120,8570032,8570036,10615230,10964888,10615351,8570208,8570209,8570261,8570264,8570267,8570268,10926036,8570497,8570503,10930529,10926255,10926256,10930574,10615819,10926338,10965368,10930652,10965452,10965453,10965454,10965455,10616000,10965539,10616001,10965540,10965541,10616048,10930925,10921654,10921664,10930974,10921674,10921683,10921696,10921698,10921699,10921703,10921704,10921705,10921706,10921707,10931008,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,10616595,10616716,10927438,10927439,10927440,10927461,10927462,10927463,10927464,10927465,10927466,10927467,10927468,10927469,10927470,10927471,10565125,10565126,10565185,10559211,10559212,10559213,10559214,10559293,10611151,10611152,10611153,10611154,10611155,10611156,10611158,10611161,10611162,10611163,7059669,10559318,10565318,10559319,10611175,10559327,10559328,10559329,10559330,10611193,10611194,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,10611696,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,10611864,8864780,6666259,10611944,7057572,7057573,7057583,7057590,10612093,10612108,7057679,7057680,8862085,8862145,10563530,7058239,10610011,10610012,10610013,7058523,7058533,7058534,7058537,7058550,7058554,7058605,10610111,8862977,8862987,7058632,8862988,7058635,8863000,8863001,8863002,8863007,8863009,8863019,8863020,8863022,10610169,8863037,8863038,8863042,8863047,8863051,8863055,8863063,8863067,7058746,10610270,10610271,10610282,10610323,10610327,8863188,10610341,10610342,10610346,10610374,8863629,10610836,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,10415312,10415313,10416321,10416322,10416328,4973267,10415387,10419398,10419427,10416449,10416454,8918180,10416460,10416468,10416469,10415472,10416482,10416483,10419505,10419516,10419528,10419532,10419535,10418542,10417555,10417556,10417557,10419591,10416672,10418683,7054964,10419792,10419798,10417806,10415873,10415887,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,10416182,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,8563486,8563593,8563594,10462306,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,10627105,10626720,10626732,10626734,10626739,10626740,10626741,10626743,10626744,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,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'