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(10939607,11014682,4970230,4970231,4970232,4970233,4970234,4970235,4970236,4970237,4970238,4970239,4970240,4970241,4970242,4970243,4970244,4970245,4970246,4970247,4970248,4970249,4970250,4970251,4970252,4970253,4970254,7076066,11015235,7068676,7068677,7068678,7068679,7068680,7068681,7068682,7068683,7068684,7068685,7068686,7068687,7068688,7068689,7068690,7068691,7068692,7068693,7068694,7068695,7068696,7068697,7068698,7068699,4970916,7068700,7068701,7068702,4970919,7068703,7068704,7068705,7068706,10940342,10944174,10944175,8569766,8569767,8569768,10950578,10976927,10976928,10976929,10976930,10976931,10976932,10976933,10976934,10976935,10976936,10976937,10976938,10976939,10976940,10976941,10976942,10976943,10976944,10976945,10976946,10976947,10976948,10976949,10976950,10976951,10976952,10976953,10976954,10976955,10976956,10976957,10976958,10976959,10976960,10976963,10976964,10976965,10976966,10976967,10950932,7074462,7074463,7074464,7074465,7074466,7074467,7074468,7074469,7074470,7074471,7074472,7074473,7074554,8067574,10951235,10951236,7066743,11042504,11042505,11042506,7066925,7066980,7066981,7066982,8067888,8067889,8067890,10961877,10961878,10962258,10962259,10962260,10962261,10962262,10962263,10962264,10962265,7067619,10962303,10962304,10962305,10962306,10939271,10939272,10939273,10939274,10939275,10939276,8068816,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8835439,8835440,8835441,8835442,8065481,8065482,8065483,8065484,8065485,8065486,8065487,8065488,8065489,8065490,8065491,8065492,8065493,10932201,10999567,10999568,10999570,11025757,8836585,8836586,10932597,7065341,11013123,11013124,7065490,7065491,10932863,11000233,11000234,11000235,11000236,11000237,11000238,11000239,11000240,11000241,11000242,11000243,11000244,11000245,11000246,11000247,11000248,11000249,10933124,10933125,10933150,10933166,10933167,10933168,10933169,10933170,10933171,10997777,8834667,8834668,8834669,8834670,11049097,11049098,10984903,11036944,10972180,10972182,10972184,10972185,10972187,10943287,11037370,11037371,11037429,11037430,11037431,11037432,11037433,11037434,11037435,11037436,11037501,10959506,10959507,10959508,10959509,10959510,10959511,10959512,8074596,8074597,8074598,8074599,8074600,8074601,8074602,8074603,8074604,8074605,8074606,8074607,8074608,8074609,8074610,8074611,8074612,8074613,8074614,8074615,8074616,8074617,8074618,8074619,8074620,8074621,8074622,8074623,8074624,8074625,8074626,8074627,8074628,8074629,8074630,8074631,8074632,8074633,8074634,8074635,8074636,8074637,8074638,8074639,8074640,8074641,8074642,8074643,8074644,8074645,8074646,8074647,8074648,8074649,8074650,8074651,8074652,8074653,8074654,8074655,8074656,8074657,8074658,8074659,8074660,8074661,8074662,8074663,8074664,8074665,8074666,8074667,8074668,8074669,11009407,11009408,11009409,11009410,8564515,8564516,8564517,8564518,8072885,8072886,8072887,8072888,8072889,8072890,8565272,8565273,8565274,10942288,10942325,11048686,11048687,10997575,10997576,10997577,11049768,11036613,11036614,11032759,11032760,11032761,11032780,11032781,11045937,11045938,11006957,11006958,10623346,10623440,10919045,10994205,10994206,11007215,11007238,11007239,10618959,10618960,10618961,10618962,10618963,10618964,10618965,8070768,10619106,8070848,8070849,8070850,8070851,10994951,10994952,10994955,10994956,10994957,10994958,10919926,10922585,11006040,10923084,11006312,11032603,11042656,8570345,10926081,11043246,11043247,11043248,11043249,11030253,11030254,10926149,10965317,11004387,10916344,10916345,10916346,10916347,10916348,10916349,10916350,10916351,10930868,11017635,11017636,11017637,11017638,11017639,11017640,10621077,10621078,10927076,10992315,10992316,9189331,10559332,10559333,9205736,8864428,10559788,9166043,9166044,9166045,9166046,9166047,10566080,10566081,10566082,9171370,9171371,9171372,9171380,9187466,7057733,8862247,8862248,8862249,8862250,8862251,8862252,8862253,8862254,8862255,8862256,8862257,8862258,8862259,8862260,8862261,10612596,7058108,10612622,10612685,7058194,7058195,7058196,7058197,7058198,7058199,7058200,7058201,7058495,10564469,10564470,9172779,10610466,9164817,9196842,9204925,10610684,10610685,9189087,10613770,10613771,9189203,9185355,4974225,9169422,9161683,9177745,9177746,9177747,9177748,9177749,9177750,9177751,9201751,9201752,9177752,9177753,9177754,9177755,9177756,9177757,9177758,9177759,9177760,9177761,9177762,9177763,9177764,9177765,9177766,9177767,9177768,9177769,9177770,9177771,9177772,9177773,9177774,9177775,9177776,9177777,9177778,9177779,9177780,9177781,9177782,9177783,9177784,9177785,9177786,9177787,9177788,9177789,9177790,9177791,9177792,9177793,9177794,9169864,10513732,10515768,10515769,10515770,10515771,10515772,10515773,10515774,10515775,10513822,7056362,7056363,7056364,7056365,7056366,9186364,2809253,2809254,2809255,2809256,10512838,9171212,9187283,9176366,9192576,4973550,4973573,9176835,9168872,9168914,7055335,10419208,9166477,9166478,9166479,9166480,9166481,9166482,9166483,9166484,9166485,6666495,9190608,10471279,9174711,9174713,10469294,6666953,9175052,8563368,8563374,8917166,8917167,8917168,8917169,8917170,8917171,8917172,8917173,8917174,9167641,8563560,9191898,9191899,9191900,9191901,9191902,9191903,9191947,6667959,6667960,6667961,6667962,6667963,10466748,10466749,10466750,10466751,10466752,10466753,10466754,10466755,10466756,10466757,10466758,10466759,10466760,10466761,10466762,10466763,10466764,9200239,9200240,9200241,10184547,10184548,10179548,10184549,10184550,10184551,10628183,10628184,10179711,10179712,10159901,10159902,10159903,10159904,10159905,10159906,10174975,10174976,10185313,10185314,10185420,10185421,10185422,10160670,10160671,10160672,10160673,10160674,10160675,10160676,10160677,10160678,10160679,10160680,10160681,10160682,10160683,10160684,10160685,10160686,10160687,10166482,10166483,10173545,10173546,10632098,10178644,10178645,10178646,10178647,10627308,10173850,10173973,10173974,10173975,10173976,10173977,10173978,10173979,10173980,10173981,10627681,10174233,10627776,10627961,10630080,10630104,10162207,10172438,10167615,10167616,10167617,10167618,10167619,10167620,10631559,10173205,10173206,10173207,10173208,10173209,10173210,10173211,10173212,10173213,10173214,10173215,10173216,10173217,10173218,10173219,10631708,10163300,10163301,10631848,10586279,10586891,10586892,10586893,10586894,10569136,10566367,10566368,10566673,10572736,10572737,10572738,10572739,10572740,10572741,10572742,10585164,10585165,10585166,10585167,10585168,10585169,10585170,10585171,10585172,10585173,10585174,10585175,10585176,10585177,10585178,10585179,10585180,10570181,10570182,10570183,10570184,10570786,10579906,10579907,10521295,10521296,10521297,10521298,10521299,10521300,10521301,10521302,10521303,10521304,10521305,10521306,10527334,10527335,10527336,10523461,10523462,10523463,10523464,10523465,10523466,10523467,10523468,10523469,10523470,10523471,10523472,10523473,10523474,10523475,10523476,10523477,10523478,10523479,10523480,10523481,10523482,10523483,10523484,10523485,10523486,10523487,10523488,10523489,10523490,10523491,10523492,10523493,10523494,10523495,10523496,10523497,10523498,10523499,10523500,10523501,10523502,10523503,10523504,10523505,10523506,10523507,10523508,10523509,10523510,10523511,10523512,10523513,10523514,10523515,10523516,10523517,10523518,10523519,10523520,10523521,10523522,10523523,10523524,10523525,10523526,10523527,10523528,10523529,10523530,10523531,10523532,10523533,10523534,10523535,10523536,10523537,10523538,10523539,10523540,10523541,10523542,10523543,10523544,10523545,10523546,10523547,10523548,10523549,10523550,10523551,10523552,10523553,10523554,10523555,10523556,10523557,10523558,10424345,10424520,10423778,10423779,10420850,10423058,10421065,10474974,10474975,10474976,10475075,10479108,10479109,10479110,10479111,10479112,10479113,10479114,10479115,10479116,10479117,10479118,10479119,10479120,10479121,10479122,10479123,10479124,10479125,10479126,10479127,10479128,10479129,10479130,10479131,10479132,10479133,10475205,10475206,10475207,10475208,10475209,10473275,10473276,10473277,10473278,10473279,10473280,10473281,10475294,10475295,10475296,10475297,10475298,10475299,10475300,10475301,10475302,10475303,10475304,10475305,10475306,10475307,10475308,10475309,10475310,10475311,10475312,10475313,10475314,10475315,10475316,10475317,10475318,10475319,10475320,10475321,10475564,10475565,10475566,10475567,10475616,10475617,10475618,10475619,10477977,10481999,10474065,10474068,10474069,10474070,10474280,10474281,10480460,10480472,10480473,10474685,10474686,10474687,10474688,10474689,10474725,10474753) 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'