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(7067826,7067827,7067848,7067853,7075874,7075880,7075882,8068869,8068872,7067899,7075925,7075944,7075948,7075972,7075993,7067994,7068008,10943519,7068012,7076028,7076029,7068040,7068041,7068056,7068062,7068063,7068065,7076074,10943590,7068103,10943618,7068111,10943624,7068125,10943661,10943662,10943686,7068209,10943732,7068233,4970569,4970570,10943746,4970571,4970572,10943748,4970573,4970574,4970575,4970576,4970577,4970578,7068243,4970579,10943755,4970580,4970581,4970582,4970583,4970584,4970585,4970586,4970587,4970588,4970589,7068253,4970590,4970591,4970592,4970593,4970594,4970595,4970596,4970597,4970598,4970599,4970600,7068264,4970601,4970602,4970603,4970604,10943779,4970605,4970606,7068271,7076272,7068276,7068284,7068287,7068314,7068322,7068328,7068331,7068332,7068340,7068346,7068364,7068367,7068384,10943909,10943932,4970786,4970787,10943970,7068496,7068515,7068516,7068517,7068518,7068520,8569497,7068523,7068531,10944059,10944060,10944061,10944062,10944063,10944064,10944067,7068558,7068564,10944075,10944118,7068640,7068641,7068642,7068643,7068644,7068645,7068646,10944157,7068647,7068648,7068649,7068650,7068651,7068652,7068653,7068654,7068655,7068656,7068657,7068658,7068659,7068660,7068661,7068662,7068663,10944187,7068679,7068697,7068702,7068705,8569686,10944243,10944244,10944245,10944246,10944247,10944248,10944249,10944250,10944251,10944252,7068779,7068783,7068785,8569764,7068789,10944307,10944313,7068813,7068817,4968174,7073841,10933286,7073847,7073851,10933291,7065852,7073853,7065855,7065869,10933320,10933326,7065888,7065889,7065894,7065901,7065918,7073922,7073926,7073940,7073979,7066010,7074028,7074091,7066097,7074099,7066159,7066160,10437168,7074222,7074242,10437227,10437228,10437229,10437230,10437231,10437232,7066334,7066357,7074365,7074377,7074411,7074422,7074423,7074426,7074429,7066430,7074431,7074438,7074439,7074448,7074451,7074464,7074468,7074480,7074516,7074527,7074539,7066541,7066545,7074592,7074597,7066600,7074607,10437566,10437567,7074631,7074649,7066653,7074658,7074661,7074668,10437684,7074748,7066749,7066753,7074754,7066776,7074777,7066794,7066816,7066849,7066852,7074980,7074985,7066986,7074988,7066988,7074989,7066990,7074998,7074999,7075002,7075004,7067008,7067009,7075010,7067010,7067011,7067015,7067027,7067028,7067029,7067030,7067036,7067042,7075052,7075064,7075071,7067077,7075078,7067079,7075087,7075088,7075097,7067105,7067107,7075110,7067133,7067135,7067136,7067138,7067139,7067174,7067186,7075187,7075202,7067214,7075228,4969568,7075234,7067238,7075241,7075264,7067282,7075290,7075291,7067318,7067348,7067424,7067427,7067429,7067432,7067435,7067442,7075443,7067454,7067461,7075465,7067467,7075468,7075471,7075472,7075475,7075477,8068464,8068465,8068466,8068467,8068472,7067494,7067496,7067503,7075505,7067507,8068491,7067509,8068492,7067513,7067515,7067516,7067519,7067526,7075531,7075556,7075588,7075594,7075625,7075635,7067644,7075683,7075706,7075716,7075718,7075727,7075746,7071825,7071842,7071900,7071916,7071919,7071921,10931396,7071960,7071964,7071986,6000272,6000273,6000274,6000275,6000276,6000277,6000278,7071997,7072003,7072004,7072007,7064019,7064022,7072051,7072054,7072060,7072061,7064065,7072066,7064068,10931516,7064080,10931524,7064094,7064104,7064118,7064134,10931574,7064143,7064154,7064155,7064163,7064165,7064181,7064182,7064198,7072200,7064207,7064209,7064216,10931663,7064225,7064227,10931668,10931669,10931670,7064233,10931677,7064238,10931678,10931679,7064243,7064246,7072250,10931697,10931719,10931722,10931737,10931738,10931758,7064322,7064332,7072340,7064343,10931784,7072369,7072380,7072382,7072395,7064407,7064410,7064419,7064420,7072424,10931866,7064487,10931930,7064514,7064519,7072576,7072590,7064594,7072597,7064598,7064601,7072604,7072607,7072608,7064614,7064627,7072628,7072634,7064640,7072642,7072646,7064651,7072653,7064657,7072678,7064682,7064688,7064703,7064712,7072724,7072732,7064736,7064740,7064750,7064753,7064758,7064761,7064776,7064786,7064791,7072796,7064803,7072809,7064814,7072814,7072816,7072817,7064818,7072822,7064824,7072825,7064826,7072834,7064838,7072842,7072847,7072856,7064863,7064883,7072884,7072895,7072896,10932336,7072902,7072905,7072906,7064911,7072912,7072913,7072922,7072931,7072932,7072938,7064950,7064958,7072958,7064972,7072974,7064977,7064979,10932419,7064985,7064986,7064987,7073000,7073004,7073011,7073013,7073014,7073016,7073025,7073027,7073064,7073065,7073066,7073070,10932510,10932512,10932529,7065094,7073098,7073100,7073102,7073104,7073105,10932546,7065108,7073114,7073117,7073119,10932563,7073127,7065134,7073135,7065168,7065195,7065203,7065224,7065231,7065244,7065259,7065265,7065290,7065301,7065308,10932758,7065320,7065337,10932785,10932789,10932802,7073373,7065383,7065386,7073388,7065417,7073420,7065420,7065424,7065431,7065458,7065463,7065466,7073474,7065492,10932932,7073496,7073497,10932940,7065511,7073533,7073535,7073564,7065564,7065565,7065573,7073581,7073582,7065587,4967942,4967943,7065628,7065633,7065665,7073671,7065672,7065685,7065702,7065704,7065712,7065715,7073716,7073718,7065719,10933173,7073738,7065746,7073749,10933199,7065766,7065802,10933242,10933244,10933251,7065816,8860728,7070858,7070872,7070896,7070905,7070910,7070915,7070920,7070921,7070931,7070936,7070938,7070939,7070965,7070967,7070970,7070974,7070977,7070983,7070988,7071002,7071006,7071008,7071010,7071011,7071028,7071062,10942777,8860980,7071099,7071102,7071112,7071113,7071122,7071254,7071285,7071290,7071316,7071317,7071320,7071322,7071328,7071329,7071342,7071411,7071415,7071425,7071430,7071437,7071472,7071473,7071475,7071514,7071523,7071524,7071602,7071603,7071610,7071613,7071620,7071634,7071639,7071640,7071669,7071671,7071694,7071695,7071700,8970196,8970197,8970203,7071723,8970213,8970214,7071750,7071757,7071758,7071761,7071762,10931207,10944367,10944368,7068891,7068949,7068951,7068952,10944465,7068958,7068959,10944473,7068977,7068978,7068979,7068980,7068983,7068985,10944506,10944511,7069010,7069028,10944586,7069079,7069177,7069182,7069269,7069270,7069271,7069272,7069273,7069274,7069275,7069297,10941064,7069410,7069426,7069431,10944965,10944979,7069471,7069498,7069501,7069518,10945033,7069525,10945049,7069565,7069617,7069642,7069660,7069665,7069668,7069744,7069746,7069764,7069765,7069797,7069798,7069800,7069808,7069809,7069816,7069825,7069862,7069869,7069886,7069944,7069969,7070028,7070030,7070033,7070064,7070220,7070225,7070228,7070246,7070276,7070285,7070327,7070333,7070334,7070335,7070363,7070372,7070374,7070380,7070389,7070401,7070405,7070409,7070422,7070428,7070429,10942147,7070443,7070455,7070458,7070500,7070502,7070511,7070514,7070516,7070518,7070525,7070528,7070546,7070549,7070559,8860470,8860471,7070592,7070609,7070610,7070613,8860536,8860537,7070658,7070665,7070668,7070678,7070681,7070686,7070687,7070688,7070691,7070693,7070696,7070699,7070700,7070712,7070716,8860629,7070728,8860724,10623104,10623105,10623106,10623107,10623108,10623109,10623110,10623111,10623200,10623396,10623476,10623497,10618857,10619169,10619832,10619894,10619995,10926781,10921962,10921963,10922258,10922450,10922451,10614568,10614819,10612013,10612271,10612575,10612790,10612791,10612792,10612794,10613116,10558452,10564990,10513398,10513400,10517575,10517576,10517577,10517578,10517579,10517580,10517581,10517582,10517583,10517584,10517585,10517586,10517587,10517588,10517589,10517590,10517591,10517598,10517913,10517914,10517915,10517916,10517917,10517918,10517919,10517920,10517921,10517922,10517923,10517924,10517925,10517926,10517927,10517928,10517929,10517930,10517931,10517932,10517933,10517934,10517935,10517936,10517937,10517938,10517939,10517940,10517941,10517942,10517943,10517944,10517945,10517946,10517947,10517948,10517949,10513981,10513993,10518026,10518027,10518028,10518029,10518030,10518031,10518032,10518033,10518034,10518035,10518036,10518037,10518038,10518039,10518040,10518041,10518042,10518043,10518044,10518045,10512123,10512124,10512125,10512126,10512127,10512128,10512129,10512130,10512131,10512132,10512133,10512134,10512135,10512137,10512138,10512139,10512140,10512179,10419253,10419993,10467048,10467049,10467050,10467051,10467052,10467053,10467054,10467055,10467056,10467057,10467058,10467059,10467060,10467061,10471565,10465913,10465914,10465915,10464116,10466304,10466459,10470733,10470734) 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'