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(7075993,8574354,8621073,8621074,8574467,7068297,8574474,8574475,7076307,7076308,11002001,11002002,7076323,10448308,10963397,7068807,7068830,7068836,7068850,7068875,10977443,8609602,10977468,10977469,10977470,10977471,8609701,11003579,8619854,8573375,10961928,10961929,10961941,8620156,11001198,10842938,10842981,10843014,10972988,10972989,10972990,10843082,10973029,10843114,10843119,11012237,11012238,11012239,11012338,11012339,11012340,11012341,11012342,11012343,11012344,11012345,8836219,8836248,11038477,11038478,11012494,11012495,10843672,10843707,7073044,11012821,11012871,11012872,11012873,11012874,11012875,8066202,8066209,8066210,10844043,11000103,11000104,11000105,11000106,11000205,11013303,11013304,11013305,11013306,11013307,11013308,11000321,10497702,10497703,10984809,10984810,10984811,10984812,10942823,10102336,10102364,8617170,8617283,10972192,10959215,10959219,10943321,10943322,10102855,10998416,10998417,10998418,10998419,10998449,10998450,10998451,10972459,8617622,8617641,10998493,10998494,8617650,11037525,11037526,11034729,11034730,11034731,8908183,8615088,8615089,11034989,7070090,10941796,10983864,10941804,10983865,10983866,10983867,10941851,10941901,10941906,10941932,10941943,10941944,10941994,10942001,10942010,8073495,7070764,7070767,8073502,7070778,8073517,7070822,7070824,7070857,10928588,10928589,11045765,11045766,11045767,11045768,10928620,11045771,11045772,11045773,11045774,11045775,11045776,11045777,11045778,11045779,10928631,10928632,11045780,11045784,11045788,11045789,11045790,11045804,11045805,11045806,11045816,11045823,11045824,11045825,11045826,11045827,11045828,11045829,11045830,11045835,11045841,11045842,11045844,11045848,11045849,11045862,10618360,10618361,10618371,10618372,10618373,10618374,10618375,8613228,8613243,8613244,8613454,8613474,8613475,8613519,8613620,11033585,11033586,11046647,11046662,11046663,11046729,11046730,11046772,11046807,11046817,11046822,11046823,11046849,11046853,11046862,11046863,11046864,11047004,11047005,8614224,11047119,11047120,11047198,11047284,11047285,11047286,8907812,8907813,10992689,10992690,10622128,10992791,10836860,10617145,10617146,10617159,10992838,8612004,11044870,10992873,10992874,10992875,10622264,10622265,10622266,10622267,10622268,10992930,10992931,10993040,10993041,10922947,10993098,10993227,10993240,10993241,10993268,10993269,10993280,10923394,10993566,10993567,10993568,10993569,10993570,10993571,10425359,10977723,10977724,10977725,10977726,10615077,10977880,10977881,10977906,10977907,10977908,10977909,10977910,10977911,10977912,10977913,10977914,10977915,10977916,10615268,10620296,10991520,10991529,10991533,10991534,10991535,10991536,10991537,10991538,10991539,10991540,10991555,10991570,10615950,10615953,10615955,10978662,10991683,10991684,10978710,10426437,10621146,10952814,10991848,10991851,10426572,10616246,10616247,10616250,10979074,10426766,10426864,10992198,10992199,10992207,10992208,10992209,10992210,10992223,10992224,10992225,10992226,10992227,10992228,10992229,10992230,10992231,10922133,10922134,10992332,10992339,10992340,10992341,10992342,10992343,10992344,10992345,10992353,10992354,10992355,10992356,9181460,9189503,9213596,7059796,9213644,10611339,8864216,8864217,9189711,9213715,10614384,9213733,10611403,9189744,9213755,10611428,9213766,10611432,10611433,10611434,10122096,10122123,10122168,10122190,10611671,9182086,9182087,10122302,10122319,10122341,10122351,9182240,10611909,10611914,10611920,9214258,10611922,10611926,10611936,10611937,10611939,10611941,10119515,10612022,9195377,7057809,7057810,10563546,7058152,7058212,10120264,7058279,10120321,10120328,10557972,9172235,9212348,9212361,9204414,7058666,7058667,10120774,10610312,8863521,10610801,10610869,10517244,10517254,10517255,9185608,10117805,9185626,9185633,9185634,9185635,9185646,9185654,9185687,9185688,9185712,9177720,10117939,9185770,10117970,7055989,7055990,7023513,7023514,7023515,7023516,7023517,9193869,7023546,7023547,7023548,7023549,10515742,9185955,9209955,9185956,9185979,9185988,9185989,9186001,9186009,10513827,9186072,9186097,9178104,9178105,9178106,9186108,9186154,9178192,10514058,9186324,9186325,9178325,10118546,9178379,10118596,9186406,9186430,9186519,9186529,9178546,10514370,9178565,9186632,9186671,9186693,9186694,9186695,9178696,9186699,9186700,9178826,9186843,9171077,9171105,9171106,10515078,10515079,10515080,10515086,9192349,9192350,10416345,10415409,10415410,9192522,9192569,10416507,10416609,10419895,10420053,9169172,10418147,10418150,10420150,10420154,10420155,9193288,9191133,6667150,4972006,9191158,9191159,9191160,6667210,8550496,8550515,8550651,9175510,10462403,10462406,10462407,10462408,10462426,10462427,10462428,10462472,10462473,9184054,10116393,9200278,10883587,10884086,10884087,10884184,10170607,10884651,10170686,10879869,10880214,10632040,10632047,10632048,10632049,10632171,10168703,10627278,10627279,10627292,10883308,10166870,10166962,10166963,10166968,10166969,10166970,10166971,10167040,10172104,10182175,10182176,10182177,10167307,10630854,10167633,10167637,10167707,10167708,10167921,10631455,10631456,10882037,10168093,10168094,10183124,10882288,10882293,10643484,10586481,10586632,10583878,10589890,10589891,10580998,10581012,10581013,10581017,10599250,10599278,10599279,10569287,10569288,10569289,10578334,10578335,10590462,10590471,10590472,10590484,10590485,10590486,10590487,10590488,10590489,10590490,10590491,10569503,10569504,10569505,10569506,10578721,10585536,10585537,10591846,10576956,10576957,10576958,10576959,10576960,10576961,10576962,10586087,10586088,10533128,10533129,10533130,10533131,10533132,10525353,10529433,10529444,10529445,10529446,10529449,10529451,10529455,10529456,10529457,10529458,10529459,10529460,10529461,10529462,10529474,10529475,10531477,10531478,10531479,10531482,10529506,10529507,10529508,10531539,10531540,10531658,10531659,10531804,10531805,10531806,10531807,10531808,10531809,10531810,10531811,10531812,10531813,10531814,10531836,10531837,10531838,10531839,10531840,10531844,10531845,10521875,10529878,10529879,10529899,10529900,10529901,10529902,10529909,10529910,10529911,10529912,10529913,10529914,10529923,10529924,10529925,10529926,10529927,10529928,10529929,10531934,10531935,10531936,10531937,10531938,10531939,10531940,10531941,10531942,10529948,10529949,10529950,10529951,10529952,10529953,10529959,10529985,10530038,10530039,10530040,10530041,10530042,10530043,10530044,10530045,10530046,10532081,10532082,10530089,10532115,10532116,10530120,10530121,10532122,10532123,10532124,10532125,10532126,10532127,10532128,10532129,10532132,10532133,10532134,10532135,10530155,10530156,10532181,10532182,10532183,10532184,10532185,10530195,10530196,10530197,10530198,10530199,10530202,10522248,10522249,10522258,10530264,10530265,10530266,10530267,10530310,10530311,10530312,10530313,10530314,10530315,10530316,10530317,10530402,10530403,10530404,10532413,10532414,10532415,10532416,10530456,10530457,10530458,10530459,10530460,10530461,10530462,10530463,10530464,10522512,10530524,10530525,10530526,10530527,10528541,10528542,10528543,10530560,10530561,10530562,10532565,10532566,10532567,10532568,10532569,10532570,10532571,10530585,10530586,10532605,10532606,10532607,10532608,10530608,10532609,10530609,10532610,10532611,10532612,10532613,10532614,10532615,10532616,10532617,10532618,10532619,10532620,10532621,10532622,10532623,10532624,10532625,10532626,10530634,10530635,10530636,10530637,10530638,10530639,10530640,10530641,10530642,10530643,10532688,10532689,10532690,10532691,10532692,10532693,10532694,10532719,10528736,10530744,10530749,10530784,10530793,10520813,10528819,10528820,10528821,10532840,10530875,10530876,10530877,10530878,10530879,10530880,10530881,10530882,10538891,10522891,10538892,10532897,10538898,10532898,10532904,10532905,10538907,10530922,10530923,10530924,10530925,10530926,10530927,10530928,10530929,10538930,10530930,10530931,10532954,10532966,10530990,10532992,10533014,10533015,10533016,10533017,10533018,10533019,10533020,10533021,10533022,10533023,10533024,10533025,10533026,10533027,10533028,10533029,10533030,10533031,10533032,10533033,10533034,10533035,10533036,10533037,10533038,10533039,10533040,10533041,10533042,10533043,10533044,10533045,10533058,10533059,10533060,10533061,10533062,10533063,10533064,10539065,10533065,10533066,10533067,10533068,10533069,10533070,10533071,10533073,10533074,10533075,10533076,10533077,10533078,10533079,10533080,10533081,10533082,10533093,10533095,10533096,10422380,10422543,10421757,10421758,10421760,10421761,10421762,10422817,10422820,10421971,10421972,10421973,10422003,10422034,10422049,10422096,10422115,10422218,10485967,10479287,10486319,10486332,10479359,10479360,10481535,10479569,10481585,10481592,10481593,10481595,10481609,10481823,10481837,10476457,10478708,10478709,10493714,10493715,10493716,10493717,10493802,10493829,10487852) 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'