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(10962711,10962712,10962713,10962714,10962715,10962716,10962717,10962718,10939662,7076110,7076111,7076394,7076395,8569510,7068596,7068604,7068605,7068606,10963307,8569616,10989344,10989345,10989346,10989347,10989348,4970893,4970894,10963365,10940324,10940325,10940326,10940327,10940328,10940329,10940330,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970971,4970978,4970979,4970980,4970981,10963450,4970982,10963451,4970983,10963452,4970984,10963453,4970985,4970986,10963454,4970987,10963455,4970988,4970989,4970990,4970991,10963550,10963551,10963552,4971098,4971099,7073967,10976745,10976746,10976747,10976748,10976753,10976754,10976755,10976756,10976757,10976758,10976759,10976760,10976761,10976762,10976763,10976764,10976765,10976766,10976767,10976768,10976769,10976770,10976771,10976772,10976773,10976774,10976775,10976778,10963883,10963884,10963885,10963886,10963937,10963938,10964024,10964025,10964026,10964027,10964028,10964029,10437210,10437221,10437222,10964059,10964060,10964061,10964062,10964063,10964064,10964065,10964066,10964067,10964068,10964069,10437258,10964088,10964089,10964090,10964091,10964092,10964093,10964094,10437265,10964095,10964096,10964097,10964098,10964099,10964100,10964101,10964102,10964103,10964104,10964105,10964106,10964107,10964108,10964109,10964110,10964111,10964112,10964113,10964114,10964115,10964116,10964117,10964118,10964119,10964120,10964121,10964122,10964123,10964124,10964125,10964126,10964127,10964128,10990297,10437491,8067691,8067692,8067693,8067743,8067744,8067745,7066772,10437738,7067024,7067039,7067040,7067046,7067047,7067048,7067049,10962215,11001269,11001270,11001271,11001277,11001278,11001448,11001449,11001450,11001451,7067805,8068727,8068728,7075847,10939558,6000277,10998685,10998693,10998694,7072160,10931684,10931685,10931686,10931693,10931694,10931695,10931697,10999098,10999099,10999100,10931773,10931774,7072450,7072451,7072453,10932185,10999569,4967161,10932325,10932341,7073165,10932583,10932584,7065336,7065337,7065338,7073496,7073497,7073508,7073509,7073510,10961421,10961422,10961423,10961424,10961425,10961426,10961427,10961428,10961429,10961430,10961431,10961432,10961433,10961434,10961435,10961436,10961437,10961438,10961439,10961440,10961441,10961442,10961443,10961444,10961445,10961446,10961447,10961448,10961449,10961450,10961451,10961452,10961602,11049210,10943050,10943051,10943052,10943053,10943054,10943055,10943056,10943057,10943058,10943059,10943060,11049404,11049405,11049406,10943328,10998515,7071880,10944366,3655525,3655526,3655799,3656200,10983757,10983758,8072865,8072866,8072867,8072868,8072869,8072870,8072871,8072872,10941761,10957997,10958290,10958292,11048518,10958337,10958338,10958339,10958340,10958341,10958342,10958343,10958344,10958345,10958346,10958347,10958348,11048565,10958349,10958350,11048581,10942404,10618037,10618038,10618039,10980698,10618040,10618041,10980699,10618042,10980700,10980701,10618043,10618044,10980702,10980703,10618045,10618046,10980704,10980705,10618047,10618048,10980706,10618049,10980707,10618050,10980708,10980709,10618051,10618052,10980710,10618053,10980711,10618054,10980712,10980713,10618055,10618056,10980714,10618057,10618058,10618059,10618060,10618061,10618080,10623335,10623429,10618844,10618845,10618846,10618847,10618921,10618922,10618923,10618924,10618925,8070842,8070843,8070844,8070845,10619181,10925125,10925126,10925127,10920226,10920227,10920228,10922474,10617155,10617156,10992846,10992847,10992848,10992849,10992850,10992851,10992852,10992853,10992854,10992855,10917990,10928058,10928274,10990815,10990816,10615222,10615490,10991171,10930514,10916128,10916129,10916130,10916131,10916132,10916133,10916134,10916135,10916136,10916137,10930663,10621070,10952939,10952940,10952941,10952942,10952943,10952944,10952945,10952946,10991946,10952947,10991980,10927068,10927219,10927220,10927221,10927222,10917229,10917230,9173329,9173382,9173383,9173410,9173411,9173412,9173413,9173414,9173415,9173416,9173417,9173418,9173427,9173428,9173429,9173430,9173431,9173432,9173433,9173434,9173435,9173436,9165449,9165450,9165451,9165452,9165453,9165454,6665955,6665956,10614765,8864733,8864744,10612189,10563342,10563343,10563344,10563345,10563346,10563347,10563348,10563349,10563350,10563351,10563352,10563353,10563354,10563355,9171652,9171653,10560487,10557502,10557503,10612412,10557619,10557620,10557665,10612597,10612626,10612661,10612663,10612714,10612724,7058238,7058239,7058357,9172198,9172229,9172230,9172231,9172232,9172245,7058420,7058567,10558410,10558411,10558412,10558413,10558414,10561572,10561573,9172843,9172844,9172845,9172846,9172847,9172848,9172849,9172850,9172851,9172879,9172880,9172881,9172882,9172883,9172927,9172928,9172929,9172930,9173124,9173125,9173126,9173127,9173128,9173129,9173277,9173278,9173279,10517225,9169421,10513306,7055697,7055784,10515433,4974500,4974501,10511482,10511523,10511524,10511525,10511526,10511527,7055936,7055937,7055938,10511634,10517694,10517695,10517696,10517697,10517698,10517699,10517700,10517701,10517702,10517703,10517704,10517705,10517706,10511732,10511733,4974823,4974824,7056149,10517822,9162158,9162159,9162160,9162161,7056350,7056351,7056352,7056353,7056354,10518083,10518084,10518085,10518086,10518087,10518088,10518089,7056452,7056453,9170328,10518148,10514151,9170343,10518156,10518157,10518158,10518159,10518160,10518161,10518162,10518163,10518164,10518165,10518166,10518167,10518168,10518169,10518170,10518171,10518172,10518173,10518174,10518175,10518176,10518177,10518178,10518179,10518180,10518181,10518182,10518183,10518184,10518185,10518186,10518187,10518188,10518189,10518190,10514191,10518191,10518192,10518193,10518194,10518195,10518196,10518197,10518198,10518199,10518200,10518201,10518202,10518203,10518204,10518205,10518206,10518207,10518208,10518209,10518210,10518211,10518212,10518213,10518214,10518215,10518216,9170404,10518217,10518218,10518219,10518220,10518221,10518222,10518223,10518224,10518225,10514226,10518226,10518227,10518228,10518229,4975273,4975274,4975275,4975276,4975277,4975281,10514267,10514268,10514269,10514311,10514335,9170660,9170666,9170691,10514558,10514636,10512756,10512792,10512793,10512794,10514795,10512795,10514796,10512796,10514797,10512797,10514798,10512798,10514799,10512799,10514800,10512800,10514801,10512801,10514802,10512802,10514803,10514804,9170996,9170997,10512810,9170998,10512811,9170999,10512812,10514814,10514867,10514868,10514869,10514897,10514898,10516929,10516930,10516931,10516932,10516933,10516934,10516935,10514982,10514983,10515014,10515015,10515016,9171204,10515017,10515018,10515019,10515020,10515021,10515022,9171248,9171249,9171250,9171251,9171252,9171253,9171254,9171255,9171256,9171257,9171258,10515071,9171259,10515072,9171260,10515073,9171261,10515074,9171262,10515075,9171263,9171264,9171265,9171266,9171267,9171268,9171269,9171270,9171271,9171272,9171273,9171274,9171275,9171276,9171277,9171278,9171279,9171280,9171281,9171283,10513098,10517105,10517106,10517107,10517108,10418283,10416397,10416398,9160505,9160506,9160507,9160508,9160509,9160510,9160511,9160512,9160513,10416479,4973547,10419676,10418682,10418683,10418684,10415916,10415917,10420067,10420068,7055364,4971360,4971361,6666726,6666727,10471365,10471493,10471494,10471495,10469836,8916926,8916937,8916938,8916950,8916951,8563465,8917524,8917784,10462763,10462764,10462765,10462766,10462767,10462768,10462769,10462770,10462771,6668235,10159546,10628163,10628164,10628165,10628166,10628167,10628168,10628169,10628170,10628171,10159865,10628727,10628792,10628793,10628802,10628803,10628804,10629463,10629464,10629465,10626975,10626976,10632133,10632134,10632135,10632136,10627718,10627784,10627785,10630067,10630103,10630287,10161902,10161903,10162273,10162552,10626239,10631273,10631734,10163280,10163326,10163327,10163328,10163345,10163346,10163388,10163389,10163392,10163399,10631960,10631961,10567673,10567908,10567909,10521155,10523354,10523355,10523356,10523357,10523358,10523359,10523360,10523361,10523362,10523363,10523364,10523365,10523366,10523367,10523368,10523369,10523370,10523371,10523372,10523373,10523374,10523375,10523376,10523377,10523378,10523379,10523380,10523381,10523382,10523383,10523384,10523385,10523386,10523387,10523388,10523389,10523390,10523391,10523392,10523393,10523394,10523395,10523396,10523397,10523398,10523399,10523400,10523401,10523402,10523403,10420497,10420498,10420499,10420689,10421056,10421057,10421058,10472978,10477447,10477448,10474066,10474067,10476378,10472614,10472615,10474675,10474676,10474677,10474678,10474679,10474680,10474723,10474724) 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'