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(7075856,11014741,11001815,11001816,11001817,11001921,11001922,11001923,11001924,11001925,11001926,11001927,11001928,11001929,7076246,11001930,7076247,7076250,11001941,11001942,11001943,11001944,11002112,11002113,10940180,11002384,11002385,11015407,11015408,11015409,11015410,11015411,11015412,11015413,11015414,8569733,10944272,11002547,10963631,10963632,11002697,11002698,11002699,11002700,7074091,7074096,11002862,11002863,11002864,11002966,7066368,7066386,11003074,11003273,10961718,10961719,10987960,10987961,10939381,10985538,10985539,7071862,10972758,7072518,7072577,7072578,7072579,7072580,7072581,7072582,7072583,7072584,7072586,7072655,7072692,7072783,7072849,7072850,7072851,7072873,10999590,10999591,10999592,10999593,10999594,10999595,10999596,10999597,10999598,10999599,10999600,7072939,7072945,7072946,7072947,7072948,7072949,7072950,7072951,7072953,7072954,7072955,7072956,7072957,7072958,7072959,7072960,7072961,7072962,7072963,7072964,7072965,7072966,7072967,7072968,7072969,7072970,7072971,7072972,7072973,7072974,7072975,7072976,7072977,7072978,7072979,7072980,7072981,7072982,7072983,7072984,7072985,7072986,7072987,7072988,7072989,7072990,7072991,7072992,7072993,7072994,10960699,7070836,10943155,10943321,10972416,7071795,10969604,10969605,10969606,10969607,10969608,10970074,10996633,10996634,10941825,10941832,10941841,10941871,10970845,10970846,10970847,10970848,10970849,10941939,10941950,10941952,10970981,10997031,8860480,10942432,10942453,10942472,7070803,10997497,10618035,10918581,10918582,10918688,10918689,10919130,10623788,10968624,10994631,10994632,10994633,10994634,10994635,10994777,10994778,10994864,10994865,10994866,10994945,10994946,10994947,10994948,10920433,10920434,10920435,10920436,10992628,10992629,10992630,10992631,10992632,10992633,10992634,10992635,10992665,10992666,10992667,10992668,10917644,10917645,10917646,10917647,10917648,10917649,10992720,10992725,10992823,10992824,10992825,10992826,10992827,10992828,10992829,10992830,10992831,10992832,10992833,10992834,10992835,10992836,10917877,10917878,10917879,10992960,10992961,10993032,10993033,10617503,10617523,10993155,10993156,10918249,10918250,10928306,10928307,10617798,10928308,10928309,10617800,10928310,10928311,10928312,10928313,10928314,10920739,10990817,10990818,10620342,8570488,10921172,10921173,10921174,10921316,10921331,10921332,10921333,10921334,10921335,10921336,10921337,10921338,10921339,10921340,10921341,10921342,10921343,10921344,10921345,10921346,10921347,10921348,10921349,10921350,10921351,10921352,10921353,10921354,10921355,10921356,10921357,10921358,10921359,10921360,10921361,10921362,10921363,10921364,10921365,10921366,10921367,10921368,10921369,10921370,10921371,10921372,10921373,10921374,10921375,10921376,10921377,10921378,10921379,10921380,10921381,10921452,10921453,10921454,10991528,10991532,10991547,10991548,10991549,10921545,10921546,10616050,10616052,10991757,10991758,10991826,10991827,10952914,10952915,10952916,10952917,10952918,10921925,10921926,10992045,10992275,10992276,10992277,10917353,10917354,10917355,10917356,10917357,10611160,10614862,10611879,7057774,10557600,10557601,10557602,10557603,10557604,10557605,10557606,10557607,10557608,10557609,10612907,10612912,10612913,10612914,10610306,10610307,10610390,10610750,10610954,10555209,10555210,10555211,10555212,10555213,10555262,10555263,10555264,10555265,10555266,10555267,10555268,10555269,10555270,10555271,10555272,10555273,10555274,10555275,10555276,10555277,10555278,10555279,10555280,10555281,10555282,10555283,10555284,10555285,10555286,10555287,10555288,10555289,10555290,10555291,10555292,10555293,10555294,10555295,10555296,10555297,10555298,10555299,10555300,10555301,10555302,10555303,10555304,10555305,10555306,10555307,10555308,10555309,10555310,10555311,10555312,10555313,10555314,10555315,10555316,10555317,10555318,10555319,10555320,10555321,10555322,10555323,10555324,10555325,10555326,10555327,10555328,10555329,10555330,10555331,10555332,10555333,10555334,10555335,10555336,10555337,10555338,10555339,10555340,10555341,10555342,10555343,10555344,10555345,10555346,10555347,10555348,10555349,10555350,10555351,10555352,10555353,10555354,10555355,10555356,10555357,10555358,10555359,10555360,10555361,10555362,10555363,10555364,10555365,10555366,10555367,10555368,10555369,10555370,10555371,10555372,10555373,10555374,10555375,10555376,10555377,10555378,10555379,10555380,10555381,10555382,10555383,10555384,10555385,10555386,10555387,10555388,10555389,10555390,10555391,10555392,10555393,10555394,10555395,10555396,10555397,10555398,10555399,10555400,10555401,10555402,10555403,10555404,10555405,10555406,10555407,10555408,10555409,10555410,10555411,10555412,10555413,10555414,10555415,10555416,10555417,10555418,10555419,10555420,10555421,10555422,10555423,10555424,10555425,10555426,10555427,10555428,10555429,10555430,10555431,10555432,10555433,10555434,10555435,10555436,10555437,10555438,10555439,10555440,10555441,10555442,10555443,10555444,10555445,10555446,10555447,10555448,10555449,10555450,10555451,10555452,10555453,10555454,10555455,10555456,10555457,10555458,10555459,10555460,10555461,10555462,10555463,10555464,10555465,10555466,10555467,10555468,10555469,10555470,10555471,10555472,10555473,10555474,10555475,10555476,10555477,10555478,10555479,10555480,10555481,10555482,10555483,10555484,10555485,10555486,10555487,10555488,10555489,10555490,10555491,10555492,10555493,10555494,10555495,10555496,10555497,10555498,10555499,10555500,10555501,10555502,10555503,10555504,10555505,10555506,10555507,10555508,10555509,10555510,10555511,10555512,10555513,10555514,10555515,10555516,10555517,10555518,10555519,10555520,10555521,10555522,10555523,10555524,10555525,10555526,10555527,10555528,10555529,10555530,10555531,10555532,10555533,10555534,10555535,10555536,10555537,10555538,10555539,10555540,10555541,10555542,10555543,10555544,10555545,10555546,10555547,10555548,10555549,10555550,10555551,10555552,10555553,10555554,10555555,10555556,10555557,10555558,10555559,10555560,10555561,10555562,10555563,10555564,10555565,10555566,10555567,10555568,10555569,10555570,10555571,10555572,10555573,10555574,10555575,10555576,10555577,10555578,10555579,10555580,10555581,10555582,10555583,10555584,10555585,10555586,10555587,10555588,10555589,10555590,10555591,10555592,10555593,10555594,10555595,10555596,10555597,10555598,10555599,10555600,10555601,10555602,10555603,10555604,10555605,10555606,10555607,10555608,10555609,10555610,10555611,10555612,10555613,10555614,10555615,10555616,10555617,10555618,10555619,10555620,10555621,10555622,10555623,10555624,10555625,10555626,10555627,10555628,10555629,10555630,10555631,10555632,10555633,10555634,10555635,10555636,10555637,10555638,10555639,10555640,10555641,10555642,10555643,10555644,10555645,10555646,10555647,10555648,10555649,10555650,10555651,10555652,10555653,10555654,10555655,10555656,10555657,10555658,10555659,10555660,10555661,10555662,10555663,10555664,10555665,10555666,10555667,10555668,10555669,10555670,10555671,10555672,10555673,10555674,10555675,10555676,10555677,10555678,10555679,10555680,10555681,10555682,10555683,10555684,10555685,10555686,10555687,10555688,10555689,10555690,10555691,10555692,10555693,10555694,10555695,10555696,10555697,10555698,10555699,10555700,10555701,10555702,10555703,10555704,10555705,10555706,10555707,10555708,10555709,10555710,10555711,10555712,10555713,10555714,10555715,10555716,10555717,10555718,10555719,10555720,10555721,10555722,10555723,10555724,10555725,10555726,10555727,10555728,10555729,10555730,10555731,10555732,10555733,10555734,10555735,10555736,10555737,10555738,10555739,10555740,10555741,10555742,10555743,10555744,10555745,10555746,10555747,10555748,10555749,10555750,10555751,10555752,10555753,10555754,10555755,10555756,10555757,10555758,10555759,10555760,10555761,10555762,10555763,10555764,10555765,10555766,10555767,10555768,10555769,10555770,10555771,10555772,10555773,10555774,10555775,10555776,10555777,10555778,10555779,10555780,10555781,10555782,10555783,10555784,10555785,10555786,10555787,10555918,10555919,10555920,10555921,10555922,7057193,10516977,10516978,10516979,10516980,10516981,10418793,10420012,10417188,10417196,10417204,6666314,6666404,6666805,8916832,8916896,10470433,10470560,10164737,10164738,10164739,10628361,10628383,10165321,10165322,10629516,10166218,10166219,10166220,10629830,10629831,10154004,10154005,10154006,10154007,10629963,10630189,10162275,10162299,10162300,10162301,10630857,10630858,10626267,10626268,10631880,10577165,10571185,10571186,10571347,10571348,10571604,10577735,10568853,10568919,10575071,10575072,10572159,10572160,10572357,10575624,10575732,10575733,10572852,10570377,10570378,10576917,10576918,10576919,10570950,10570951,10521255,10521256,10521257,10521259,10520919,10526958,10523032,10523033,10523034,10523035,10422012,10422025,10422091,10422092,10422156,10477395,10477992,10478150,10478151) 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'