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(7075904,10962600,10939642,10962638,7076128,7068359,10963046,7068363,10963066,10963067,10940347,10940350,10963386,10963390,10963391,10963392,7068711,7068712,7068715,7068717,7068718,7074092,10976792,7074139,10977003,10977004,10977005,10977006,10977007,10977008,10977009,10977010,10977011,10977012,10977013,10977014,10977015,10977016,10977017,10977018,10977019,10977020,10977021,10977022,10977023,10977024,10977025,10977026,10977027,10977028,10977029,10977030,10977031,10977032,10977033,10977034,10977035,10977036,10977037,10977038,10977039,10977040,10977041,10977042,10977043,10977044,10977045,10977046,10977047,10977048,10977049,10977050,10977051,10977052,10977053,10977054,10977055,10977056,10977057,10977058,10977059,10977060,10977061,10977062,10977063,10977064,10977065,10977066,10977067,10977068,10977069,10977070,10977071,10977072,10977073,10977074,10977075,10977076,10977077,10977078,10977079,10977080,10977081,10977082,10977083,10977084,10977085,10977086,10977087,10977088,10977089,10977090,10977091,10977092,10977093,10977094,10977095,10977096,10977097,10977098,10977099,10977100,10977101,10977102,10977103,10977104,10977105,10977106,10977107,10977108,10977109,10977110,10977111,10977112,10977113,10977114,10977115,10977116,10977117,10977118,10977119,10977120,10977121,10977122,10977123,10977124,10977125,10977126,10977127,10977128,10977129,10977130,10977131,10977132,10977133,10977134,10977135,10977136,10977137,10977138,10977139,10977140,10977141,10977142,10977143,10977144,10977145,10977146,10977147,10977148,10977149,10977150,10977151,10977152,10977153,10977154,10977155,10977156,10977157,10977158,10977159,10977160,10977161,10977162,10977163,10977164,10977165,10977166,10964354,8067911,8067912,10962069,10962083,10962084,10962109,10962110,10962111,10962112,10962457,10962474,6000234,10972738,10972874,10972888,7072246,10972946,10972956,10960044,10973058,10960071,10960072,10973188,7072645,7072686,10999455,10999463,10999474,10999475,10960627,10960665,7065155,10971532,10971544,10971546,7070880,7070885,7070905,7070936,7070954,7070969,10971664,10971665,10971666,7071069,10971753,10984765,10971779,10971780,10984821,10984822,10971841,10984905,10971940,10971941,10971971,10971972,10972008,10972034,10972091,10972092,10972106,10943150,10943151,10972223,7071603,10969532,10969533,10969534,10969535,10969536,10969537,10969538,10969539,10969540,10969541,10969542,10969543,7069229,10969991,10969992,10970037,10970038,10970061,10970062,10970172,10970178,10970424,10970425,10970445,10970704,7070081,10970782,10970783,10970821,10970977,10971106,10971255,10971280,10971281,10971404,10971405,7070723,7070804,10993675,10993722,10993723,10993724,10993725,10993726,10993727,10993728,10993729,10993730,10993731,10993732,10993733,10993734,10993735,10993795,10993881,10993882,10618861,10618862,10981560,10981561,10981566,10968876,10968880,10969071,10969072,10969073,10969074,10969075,10969076,10969077,10969078,10969079,10969080,10969081,10969082,10969083,10969084,10969085,10969086,10969087,10969393,10969394,10969395,10917626,10953678,10992856,10992863,10917852,10917853,10917856,10917857,10617400,10917984,10954195,10954197,10993306,10993307,10993309,10993380,10993381,10993383,10615229,10620426,10926029,10615872,10930850,10916569,10916570,10916571,10916572,10916573,10916574,10921595,10921604,10916641,10916642,10916643,10916644,10916645,10916646,10916647,10916648,10916649,10966034,10966036,10966039,10927198,10966288,10966290,10966291,10917341,10610993,10565194,10614064,10565431,10565432,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565544,10565545,10565546,10565547,10611406,10559594,10559595,10559596,10559597,10559598,10559599,10559600,10559601,10562665,10562669,10562670,10562671,10565673,9166100,9166101,9171466,9171583,9171584,9171585,10609269,7057785,10557466,10557468,10612492,10563833,10612723,10612730,9172222,9172331,9172332,7058546,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10613356,10613357,10613365,10558541,10610468,9172805,9172806,9172815,9172818,9172891,7055697,10513393,10513394,10513395,9161692,9169894,9169901,7056368,7056369,7056370,7056371,7056372,7056373,7056374,7056375,7056376,9170322,9170323,9170324,9170328,9170329,9170330,9170332,9170415,9170416,10556293,10514357,10514358,10514359,10512418,10514498,10514499,10514529,10514694,10514695,10514696,10514697,10514698,10514699,10514700,10514701,10514702,10514703,10514704,10514706,10514707,10514708,10514709,10514710,10514711,10514712,10516713,10514713,10516714,10514714,10516715,10514715,10516716,10516717,10514717,10516718,10514718,10514719,10514720,10514735,10514736,10514737,10514738,10514740,10514741,10518748,10514759,10514760,10514761,10514762,10514763,10514764,10514765,10514766,10514767,10514768,10514770,10514771,10514774,10514775,10514776,10514777,10514778,10514779,10514780,10516783,10516784,10516785,10516786,10516801,10516802,10516803,10516804,10512852,10512969,10517042,10517066,10517067,10517068,10517069,10517070,10517096,9160400,10418687,8864930,4971571,6666954,4971931,10467980,10467999,10468015,10468040,9167536,9167637,10466412,10462449,10462451,10466860,10466863,10466864,10164487,10164638,10164639,10164640,10164704,10164705,10164706,10164707,10164708,10164709,10164710,10164711,10164712,10164713,10164781,10164806,10628531,10165119,10165196,10165197,10165262,10165263,10165264,10165265,10165266,10165301,10165302,10165623,10165753,10165754,10165803,10166251,10166252,10166262,10166323,10166347,10166406,10166439,10166466,10627665,10627929,10627933,10625240,10625372,10626309,10626310,10626315,10626316,10626317,10626318,10631899,10568385,10568386,10568387,10568388,10568389,10568390,10568392,10568395,10568626,10568627,10568628,10568630,10568737,10568811,10568812,10568813,10568814,10568815,10568817,10569745,10569922,10569923,10569924,10569925,10525198,10521269,10521270,10525274,10525275,10525276,10523566,10523567,10523568,10523569,10523570,10523571,10523572,10523573,10523574,10523575,10523576,10523578,10523611,10523612,10523613,10523614,10523615,10523616,10523617,10523618,10523619,10523620,10523621,10525622,10523622,10523623,10523624,10523625,10523626,10523627,10523628,10523629,10523630,10523631,10523632,10523633,10523634,10523635,10523636,10523637,10523638,10523639,10523640,10523641,10523642,10523643,10523644,10523645,10523646,10523647,10523648,10523649,10523650,10525751,10525752,10525756,10525757,10525758,10525759,10525760,10525761,10525762,10525763,10525764,10525765,10525766,10525767,10525768,10525769,10525770,10525771,10525772,10525773,10525774,10525775,10525776,10525777,10525778,10525779,10525780,10525781,10525782,10525783,10525784,10525785,10525786,10525787,10525788,10525789,10525790,10525791,10525792,10525793,10525794,10525795,10525796,10525797,10525798,10525799,10525800,10525801,10525802,10525803,10525804,10525805,10525806,10525807,10525808,10525809,10525810,10525848,10525849,10525850,10525851,10525852,10525853,10525854,10525855,10525856,10525857,10525870,10525871,10525872,10525873,10525874,10525875,10525876,10525877,10525878,10525879,10525880,10525881,10525882,10525883,10525884,10525885,10525886,10525887,10525888,10525889,10522001,10522002,10522003,10526114,10526119,10526120,10526149,10526150,10526151,10526160,10526161,10526162,10526163,10526164,10526165,10526166,10526167,10526168,10526169,10526170,10526171,10526172,10526173,10526174,10526175,10526176,10526177,10526178,10526179,10526180,10526181,10526182,10526183,10526184,10526185,10526186,10526187,10526188,10526189,10526190,10526191,10526218,10526219,10526220,10526221,10526222,10526223,10526224,10526225,10526226,10526227,10526228,10526229,10526230,10526231,10526232,10526233,10526234,10526235,10526236,10526237,10526238,10526239,10526240,10526241,10526242,10526243,10526244,10526245,10526246,10526247,10526248,10526249,10526250,10526251,10526252,10526253,10526254,10526255,10526256,10526257,10526258,10522258,10526264,10526265,10526266,10526267,10526268,10526269,10526272,10526281,10526282,10526283,10526284,10526285,10526291,10526334,10526435,10526439,10526440,10526441,10526443,10526444,10526445,10526446,10526447,10526448,10526450,10526451,10526452,10526453,10526454,10526455,10526456,10526457,10526458,10526459,10526460,10526470,10526481,10526482,10526561,10526572,10526573,10526583,10526584,10526585,10526587,10526588,10526589,10526590,10524832,10525083,10525084,10525091,10525096,10525097,10421498,10422047,10473892) 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'