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(10939573,10939580,10939653,10939809,10940005,10940006,10940007,10940008,10940154,10940159,10940180,10940187,10940188,10940189,4971140,4971148,8066892,8066893,8066894,8066895,8066896,8066897,8066898,8066899,8066900,8066901,8066902,8066903,8066904,8066905,8066906,8066907,8066908,8066909,8066910,8066911,8066912,8066913,8066914,8066915,8066916,8066917,8066918,8066919,8066920,8066937,8067242,8067303,4968615,4968648,4968649,8067394,8067395,8067396,4968848,10939381,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075058,8075059,8075060,8075061,8075062,8075063,8075064,8075065,8075066,8075067,8075068,8075069,8075070,8075071,8075072,8075073,8075074,8075075,8075076,8075077,8075078,8075079,8075080,8075081,8075082,8075083,8075084,8075085,8075086,8075087,8075088,8075089,8075090,8075091,8075092,8075093,8075094,8075095,8075096,8075097,8075098,8075099,8075100,8075101,8075102,8075103,8075104,8075105,8075106,8075107,8075108,8075109,8075110,8075111,8075112,8075113,8075114,8075115,8075116,8075117,8075118,8075119,8075120,8075121,8075122,8075123,8075124,8075125,8075126,8075127,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075149,8075150,8075151,8075152,8075153,8075154,8075155,8075156,8075157,8075158,8075159,8075160,8075161,8075162,8075163,8075164,8075165,8075166,8075167,8075168,8075169,8075170,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,8075191,8075192,8075193,8075194,8075195,8075196,8075197,8075198,8075199,8075200,8075201,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8075209,8075210,8075211,8075212,8075213,8075223,8075224,8065978,8066128,3655562,3655605,3655609,3655613,3655721,3655722,3655723,3655731,3655732,3655733,3655734,3655735,3655736,3655737,3655738,3655739,3655740,3655741,3655742,3655743,3655744,3655800,8072315,8072385,8072428,8072511,3656418,8072778,8072779,8072780,8072781,8072782,3656655,3656666,3656675,3656676,8072935,8072936,8072937,8072938,8072939,8072940,8072941,8072942,8072943,8072944,8072945,8072946,8072947,8072948,8072949,8072996,3656837,3656838,3656839,8073036,8073037,3656896,3656897,3656903,3656908,3656914,3656915,8073088,3656934,10918581,10918582,10918649,10918650,10918687,10918688,10918689,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623377,10623465,10623494,10919130,10919131,10919132,10623788,10920418,10920419,10920420,10920421,10920422,10920423,10920424,10920425,10920426,10920427,10920428,10920429,10920430,10920431,10920432,10920433,10920434,10920435,10920436,10920437,10920438,10920439,10920440,10920441,10917643,10917644,10917645,10917646,10917647,10917648,10917649,10917650,10917651,10917652,10917876,10917877,10917878,10917879,10622409,10917986,10917987,10622518,10622519,10622520,10622521,10622542,10918249,10918250,10620085,10620342,10620419,10620420,10620421,10620422,10620423,10620424,10620425,10620862,10620863,10620864,10916726,10916727,10916728,10916729,10916730,10916731,10916732,10916733,10916734,10916735,10916736,10916737,10916738,10916739,10916740,10916741,10916742,10916743,10916744,10916745,10916746,10916747,10916748,10916749,10916750,10916751,10916752,10916753,10916754,10916755,10916756,10916757,10916758,10916759,10916760,10916761,10916762,10916763,10916764,10916765,10916766,10916767,10916768,10916769,10916770,10916771,10916772,10916773,10621745,10621746,10621747,10621748,10621749,10621750,10917352,10917353,10917354,10917355,10917356,10917357,10917358,10565152,10611038,10611039,10611160,10611176,10611232,10611752,10611753,10611872,10611879,10609264,10609265,10609266,10609267,10609268,10609269,10609305,10609310,10609392,10563556,10563557,10563558,10609982,10610306,10610307,10610364,10610390,10610440,10610441,10564632,10564633,10610502,10564672,10564831,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,10517636,10555637,10517637,10555638,10517638,10555639,10517639,10555640,10517640,10555641,10517641,10555642,10517642,10555643,10517643,10555644,10517644,10555645,10517645,10555646,10517646,10555647,10517647,10555648,10517648,10555649,10517649,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,10419418,10419480,10419481,10419482,10419483,10419484,10419684,10419723,10419740,10419811,10420012,10471245,10469945,10470093,10470433,10470434,10470560,10470561,10470575,10470576,10470577,10470578,10470579,10470580,10470581,10470582,10470583,10470584,10470585,10470586,10470587,10470588,10470589,10470590,10470591,10470592,10470593,10470594,10470595,10470596,10470597,10470598,10470599,10470600,10470601,10470602,10470603,10470604,10470605,10470606,10470607,10470608,10470609,10470610,10470611,10470612,10470613,10470614,10470615,10470616,10470617,10470618,10470619,10470620) 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'