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(10962643,10962682,10962683,7076319,7068344,7068359,7068360,7068363,10963066,10963067,10976293,10976295,10976296,10976297,10976298,10976299,10976303,10976304,10976305,10976306,10976307,10976308,10976309,4970898,4970912,10963390,7068711,7068712,7068715,7068717,7068718,10940347,10940350,7068734,7068735,7068773,10963464,8569796,10963550,10963551,10963552,7068907,8569899,8569900,8066938,10963647,10963648,8067152,7074192,8067183,8067184,8067196,7074253,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,8067324,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,8067423,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,10977330,10977331,10964354,7066680,7066712,7074776,10977492,10977493,10977494,10977495,10977496,10977497,7066917,8067911,8067912,10961956,7075281,7075282,10962069,10962157,7067541,7067542,10962457,10962467,10962476,10962569,7075893,10962600,6000234,10972737,10972738,10972751,7072084,10972831,10972874,10972887,10972888,7072246,10972941,10972946,10973079,10973154,10973171,10973172,10973173,10973188,7072550,7072604,10932192,10960632,10960633,10960634,10960635,10960636,10960637,10960638,10960640,10960641,10960642,10960648,10960649,10960653,10960654,10960658,10960659,10960660,10960661,10960664,10960693,10960695,7073014,7065155,7073169,8066510,7065591,10932971,4967996,7073882,7065930,7070936,7070944,7070945,7070947,7070954,7070966,7070969,10971664,10971665,10971666,10971667,7071024,7071030,7071037,7071040,7071041,7071045,7071046,11048952,7071053,7071054,7071055,7071057,7071058,7071059,10971753,7071071,10942773,10971841,7071171,10971940,10971941,10971971,10971972,7071363,7071364,10972091,10972110,10972159,10972196,10943142,10943150,10943151,10972221,10972222,10972223,10972224,10972243,10972244,10972245,10972284,10972285,10972286,7071612,7071613,7071647,7071648,7071649,7071650,7071652,7071685,7071688,10972442,10972472,7071866,10972579,10972580,10972582,10972584,6000213,10969716,10940709,10940712,10940713,10940715,7069228,7069229,7069231,7069244,10969931,7069248,10969932,7069252,7069302,7069304,7069305,10969991,10969992,10970037,10970038,10970061,7069377,10970062,10970172,10970178,10970189,10970190,10970214,10970247,10970333,10970343,10970344,10970345,10970346,10970424,10970425,10970445,10970632,10970645,7069975,10970702,10941708,10970782,10970783,7070105,10942139,10942140,7070584,7070657,7070744,7070745,8073505,10942437,7070879,7070880,7070885,7070889,7070893,7070898,7070902,7070903,7070905,7070909,7070915,7070925,7070929,7070934,10918567,10618288,10619131,10619132,10619135,10619136,10619137,10619138,10619139,10619141,10619142,10619143,10619146,10619147,10619148,10919883,10919884,10919913,10917483,10917484,10917485,10622014,10953676,10953677,10953678,10953679,10953680,10617101,10622106,10622107,10622108,10617108,10622109,10617109,10622110,10917626,10622131,10917715,10917716,10917717,10917730,10917817,10917852,10917853,10917856,10917857,10917858,10917859,10917860,10917861,10917898,10917899,10917900,10917901,10917902,10917903,10917904,10617400,10917910,10917911,10617401,10917912,10917913,10917918,10617408,10622409,10917919,10917920,10917921,10917922,10927923,10917923,10927924,10917924,10917925,10917926,10917927,10620006,8570019,10920600,10920604,10920605,10915614,10915615,10920631,10920632,10915663,10915664,10915665,10915666,10920683,10915724,10920755,10615245,10920792,10920830,10920883,10920934,10620426,10920978,10921005,10926028,10926029,10926193,10926194,10926195,10926196,10926197,10926240,10930829,10921410,10930850,10921536,10921537,10916569,10916570,10916571,10916573,10916574,10621124,10621126,10916641,10916642,10916643,10916644,10916645,10916646,10916647,10916648,10916649,10926710,10917001,10922188,10922189,10927198,10565195,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,10614355,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,10611386,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565544,10565545,10565546,10565547,10611405,10611406,10611407,10611408,10611452,10614463,10611468,10611469,10559622,10562654,10562655,10562656,10562657,10562658,10562659,10562660,10562661,10562662,10562663,10562664,10562665,10562666,10562667,10562668,10562669,10562670,10562671,10562672,10562673,10562674,10562675,10562676,10562677,10562678,10611531,10614572,10611750,8864674,10611949,8861980,10612197,10609269,10557455,10557465,10557466,10557467,10557476,10557477,10557478,10612492,10563830,10563831,10563832,10563833,10563983,10612885,8862848,8862884,10610046,10613111,10613293,10613294,10613296,10613297,10613298,10613299,8863159,10613300,10613301,10613302,10613303,10613304,10613356,10613357,10613365,10610468,10517149,10517150,10513344,10513345,10513346,10513347,10513348,10513349,10513350,10513351,10513352,10513353,10555354,10513354,10513355,10513356,10513357,10513358,10513408,10513409,10513410,10513411,10513420,10513421,10513422,10513423,10555424,10513430,10513431,10513432,10513433,10517557,10517558,10517559,10517592,4974650,10555825,10555831,10512118,10512119,10512120,4975227,10516188,10556291,10556292,10556293,10556294,10556308,10556314,10514354,10514355,10556360,10556383,10556393,10556406,10556477,10514488,10514489,10514490,10514491,10556503,10514505,10514506,10556507,10514507,10556508,10514510,10514516,10514522,10556531,10556532,10556533,10556534,10514537,10514538,10514539,10514540,10514546,10514548,10514646,10516664,10514676,10514694,10514695,10514696,10514697,10514698,10514699,10514700,10514701,10514702,10514703,10514704,10514706,10514707,10514708,10514709,10514710,10514711,10514712,10514713,10514714,10514715,10514717,10514718,10514719,10514720,10514735,10514736,10514737,10514738,10514740,10514741,10514759,10514760,10514761,10514762,10514763,10514764,10514765,10514766,10514767,10514768,10514770,10514771,10514772,10514774,10514775,10514776,10514777,10514778,10514779,10514780,10517043,10517046,10517050,10517051,10517052,10517053,10517054,10517060,10517061,10517062,10517066,10517069,10517071,10517072,10517073,10517074,10517075,10517076,10517077,10517081,10517084,10517089,10517093,10517096,10517098,10517104,10517105,10517106,4973179,4973180,4973181,4973182,4973183,4973184,4973186,4973188,4973290,4973291,10419379,10419382,10416594,10419669,10419670,4973601,4973602,10419675,10419683,10419684,10419688,10417742,10416847,10420015,10417083,10417084,10417110,10418147,4971470,10471203,10471204,4971510,4971571,10469415,10469528,10469538,4971931,4971994,4972008,4972009,10465865,10465866,10463881,10463882,4972450,4972467,4972468,4972469,10470221,10470223,10470247,10470256,10462406,10466412,10462432,10462433,10462434,10462435,10462484,10462585,10462586,10470622,10466747,10464800,10466848,10466851,10466855,10466860,10628489,10628531,10629346,10629347,10629505,10629692,10627013,10627014,10627022,10627023,10625239,10625240,10625241,10625372,10626303,10626304,10626305,10626306,10626307,10626308,10626309,10626310,10626315,10626316,10626317,10626318,10626840,10568385,10568386,10568387,10568388,10568626,10568627,10568628,10568630,10568737,10568811,10568812,10568813,10568814,10568815,10568817,10569045,10569046,10569056,10569059,10569060,10569061,10567575,10567576,10567577,10520759,10421205) 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'