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(8068812,8068813,11001516,11001517,11001518,11001519,11001520,8068824,8068828,8068830,8068832,8068833,8068834,8068835,8068836,8068837,8068838,8068839,8068840,8068841,8068843,8068844,8068845,8068846,8068847,8068849,8068850,11014611,11014612,11001657,7076010,11027715,11027716,11027717,11027718,11027719,11027720,11027721,11027722,11027723,11027724,11001725,11027725,11027726,11027727,11027728,11027729,11027730,11027731,11027732,11027733,11027734,7076069,7076080,7076090,11014799,7068139,7068140,7068141,7068142,7068143,7068144,7068145,11001839,11001840,10943686,10943687,10943688,10943689,10943690,11001908,7068356,7068357,7068358,7068359,7068360,7068361,7068362,7068363,11002056,11002057,11002058,11002059,10940193,10940194,8569460,8569461,11002264,11002265,4970920,4970926,10976291,10976292,10976293,10976294,10976295,10976296,10976297,10976298,10976299,10976300,10976301,10976302,10976303,10976304,10976305,10976306,10976307,10976308,10976309,10976349,10976350,10976351,10976352,10944263,8569750,8569751,11002480,11002481,11002482,7065901,11002632,7074034,7074069,7074094,11002816,11002817,11002818,11002819,11002820,11002821,11002822,7074163,11002931,8067319,8067320,8067341,10437256,10437259,11003031,11003032,11003033,11003185,7074591,7066617,7066620,7074626,7074628,7066633,7074653,7066691,11003378,11003379,7074702,7066730,7074739,7074790,7074791,10437747,7074808,7074830,10961519,10961520,10961521,10961522,10961523,10961524,7066921,11013636,7074955,7074956,7074957,7075001,10961812,10961813,10961814,10961824,10961825,10961826,10961827,10961828,10961829,11013836,11013837,11013838,11013839,11013840,10961845,10961846,10961847,10961888,10961889,10961890,11014009,11014010,11014011,11014012,11014013,11014242,11014243,11014244,11014245,11014246,11014247,11014248,11014249,11014250,11001363,11014370,11014371,11014407,7071952,7071953,7071954,7072293,7072297,7072505,11012196,7072529,7072554,7072555,7072574,7072575,10932038,10932039,10932040,7072617,10932085,10973348,10973349,10973350,10973351,10973352,10999353,10973353,10999354,10973354,10999355,10973355,10999356,10973356,10999357,10973357,10999358,10973358,10999359,10973359,10999360,10973360,7064677,10999361,10973361,7064678,10999362,10973362,7064679,10999363,10973363,7064680,10973364,7064681,10973365,7064682,4967031,10999384,10999385,10999386,10999387,7072720,10999405,10999406,10999407,10999408,7072766,10986495,7072819,11012577,7072915,7072916,7072978,10999714,7073125,7073230,10961021,7073464,10974160,10974161,10974162,10974167,10961316,10961317,10961318,10961319,10961320,10961321,11013353,11013354,10987363,10961400,10961401,10961432,10961433,10961434,10961453,7070832,7071088,10997788,8861032,7071153,7071215,10984903,10998098,10998099,10998100,10998101,10998102,10998103,10998104,10998105,10998106,10998107,10998108,10998109,10998110,10998111,10998112,10998113,10998114,10998115,10998116,10998117,10998118,10998119,10998120,10998121,10998122,10998123,10998124,10998125,10998126,10998127,10998128,10998129,10998130,10998131,10998132,10998133,10998134,10998135,10998136,10998137,10998138,10998139,10998140,10998141,10998142,10998143,10998144,10998145,10998146,10998147,10998148,10998149,10998150,10998151,10998152,10998153,10998154,10998155,10998156,10998157,10998158,10998159,10998160,10998161,10998162,10998163,7071501,7071502,7071503,7071533,8071674,8071675,8071676,8071739,8071740,8071741,3655588,8071804,8071805,8071806,8071869,8071870,8071871,8071934,8071935,8071936,8071999,8072000,8072001,8072064,8072065,8072066,10944748,10944749,8072129,8072130,8072131,8072194,8072195,8072196,7069393,7069394,8072259,8072260,8072261,8072364,8072370,3656237,3656273,8072463,3656332,3656370,3656371,3656372,3656373,8072598,8072608,8072631,8072641,10996612,8072987,8072988,8072989,8072991,10997090,10997091,10997092,10997093,10997094,10997095,10942230,10942231,10942232,10942233,10942234,10942235,10942236,10942237,10942238,10942239,10942240,10942241,10942242,10942243,10942244,10942245,10942246,10942247,10942248,10997220,10997221,10942259,8860481,10997316,10997317,10997378,10997448,10997449,10622976,10622978,10617996,10617997,10918515,10993593,10928586,10928587,10928623,10928624,10618117,10618126,11006828,10955119,11007603,10919590,10994829,10994830,10994831,8071034,8071035,8071036,8071037,8071038,8071039,8071040,8071041,8071042,8071043,8071044,8071045,8071046,8071047,8071048,8071049,8071050,8071051,8071052,8071053,8071054,8071055,8071056,8071057,8071058,8071059,8071060,8071061,8071062,8071063,8071064,8071065,8071066,8071067,8071068,8071069,8071070,8071071,8071072,8071073,8071074,10994922,10994923,10994924,10994925,8071188,8071292,8071304,8071391,8071392,8071419,8071420,8071446,8071447,8071469,8071470,10995370,8071541,8071542,8071543,8071609,8071610,8071611,11005583,11005726,10992752,10992753,10992754,10992896,10992897,10992898,10992899,10992900,10953900,10953901,10992901,10992902,10992903,10953906,10953907,10953908,10953909,10917958,11006054,11006055,11006107,11006108,11006109,10954145,10993363,10918340,10622946,10622947,11003503,11003504,10619998,11003603,10920735,10920760,10920878,11004196,10921262,11004350,11004351,11004352,10930697,10930705,10930706,10921412,11004479,11004480,10616003,10616004,11004559,11004560,10616050,10921623,10921669,11004875,11004876,11004877,11004878,11004879,10921897,11005074,11005306,11005307,11005308,11005309,11005310,10611162,7059739,7059740,10614338,8864231,6665848,8864373,6665849,6665850,9166031,10611696,6666143,9171330,9171355,9171376,8861921,8861922,8861923,8861924,8861925,10557341,10557342,9171538,9171603,10557456,9171649,10557510,7057878,7057879,7057880,7057881,7057882,7057883,7057884,7057885,10557550,10557551,10557552,10557553,10557554,10557555,10557556,10557557,10557558,10557559,10557560,10557561,9171765,9171766,9171769,9171823,9172075,9172076,7058418,10613166,7058761,9173093,9173094,9173096,9177300,9177301,10513134,4974205,10513165,4974206,7055535,10513234,10513238,10513242,10513285,10555436,10555437,10555438,10555439,10555440,10555441,10555442,10555443,10555444,10555445,9161632,10555446,10555447,10555448,10555449,10555450,10555451,4974491,10555452,10555453,7055946,10517669,9169904,10555832,9170024,7056288,10555971,10555972,10555973,10555974,10555975,10555976,10555977,10555978,10555979,10555980,10555981,10555982,10555983,10555984,9162423,9162424,9162425,9162426,9162427,9162428,9162429,9162430,9162431,9162432,9162433,10512810,10512811,9171155,9171156,9171157,9171235,9171236,9171287,9160327,9160493,8918242,8918244,4973474,4973475,4973476,4973477,4973478,4973479,4973480,4973481,4973482,4973483,4973484,4973485,4973486,4973487,4973488,4973489,4973490,4973491,4973492,10420068,10417113,10417114,10471177,10471190,10471194,10471195,10471197,10471202,10471205,10471206,10471209,10471218,10471220,10471221,10471224,9174648,10471225,9174649,10471227,10471228,10471232,10471234,10471236,10471240,10471242,10471244,8916437,9166810,6667026,9175142,9175143,9175165,9175173,8916861,8917009,6667454,9167607,8563550,8917339,8917343,8917368,8917427,8917524,10470508,10470509,9176141,8917847,10464803,10464804,10464805,10464806,10628070,10629835,10629874,10629875,10629876,10629877,10632116,10632117,10627182,10627183,10627184,10627185,10627186,10627187,10627188,10627189,10627190,10627191,10627192,10627193,10627194,10627195,10627196,10627197,10627198,10627199,10627527,10627571,10627574,10627950,10630210,10161861,10161862,10162191,10162254,10167412,10167413,10167414,10167415,10167446,10167447,10162560,10162593,10626291,10577216,10571431,10577445,10577446,10577447,10577448,10577449,10577450,10577451,10568642,10568643,10568644,10568645,10571837,10571838,10571839,10571840,10577876,10577877,10577878,10574900,10574901,10574902,10568950,10568951,10578069,10578070,10575169,10578202,10578254,10578255,10569300,10569301,10569302,10572307,10572364,10572365,10572366,10575432,10572538,10572539,10572540,10572541,10572542,10572543,10572544,10572545,10572546,10575554,10575555,10575556,10575557,10575558,10578645,10578692,10578693,10578694,10578977,10579097,10576133,10576134,10576135,10576136,10576137,10576138,10576139,10576140,10576141,10576142,10576143,10576144,10576145,10576146,10576147,10576148,10576149,10576150,10576151,10576152,10576153,10579242,10579243,10579244,10579245,10579246,10573254,10573255,10570567,10570568,10576712,10576713,10576714,10525118,10525130,10525131,10525133,10525134,10525135,10525136,10527174,10528262,10528263,10522519,10522520,10526966,10526969,10526970,10526975,10526976,10526980,10526982,10526983,10526988,10526989,10422661,10421974,10421975,10425004,10423063,10422073,10477111,10481803,10481806,10478520,10478521,10478523,10478740,10478741,10478742,10478743,10478744,10478745,10478746,10478747) 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'