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(10962565,4970255,4970256,4970257,4970258,4970259,7075935,10962652,10943532,10943533,10943534,10943535,10943536,10943537,10943538,10943539,10943540,10943541,10943542,10962741,8569402,8569403,4970920,10963308,10940343,10940344,10940345,10940346,10940347,10940348,10940349,10940350,10940351,10940352,10940353,10944176,10963383,7068707,7068708,7068709,7068710,7068711,7068712,7068713,7068714,7068715,7068716,7068717,7068718,7068719,8067182,10976968,10976969,10976970,10976971,10976972,10976973,10976974,10976975,10976976,10976977,10976978,10976979,10976982,4968635,10976983,10976984,10976985,10976986,10976987,10976988,10976989,10976990,10976991,10976992,10976993,10976994,10976995,10976996,10976997,10976998,10976999,10977000,10977001,10977002,10977003,10977004,10977005,10977006,10977007,10977008,10977009,10977010,10977011,10977012,10977013,10977014,10977015,10977016,4968668,4968669,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,8067846,8067847,8067848,8067849,10938609,10938610,10938611,10938612,10938613,10938614,10938615,10938616,10938617,10938618,10938619,10938620,10938621,10938622,10938623,10938624,10961879,7075214,7075269,7075514,7075541,7075543,7067620,7075728,7067731,7067732,7067747,6000157,6000158,7064241,7064242,7064243,7064244,7064245,7064246,7064247,7064248,7064249,7064250,7064251,7064252,7064253,7064254,7064305,10960023,8065494,8065495,8065496,8065497,10931926,10931927,10931928,10931929,10931930,10931931,10931932,10931933,10931934,10931935,10931936,10931937,10931938,10931939,10931940,10931941,10931942,10931943,10931944,10931945,10931946,10960192,10931947,10931948,10931949,10931950,10931951,10931952,10931953,10931954,10931955,10931956,10931957,10931958,10931959,10931960,10960507,10960513,10932282,10932283,10932284,10932289,4967461,4967462,4967463,4967464,4967465,4967466,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967474,4967475,4967476,4967477,4967478,4967479,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967497,4967498,4967499,4967500,4967501,4967502,4967503,4967504,4967505,4967506,4967507,4967508,4967509,10932877,10932878,10932879,10932880,10932881,10932882,10932883,10932884,10932885,10932886,10932887,10932888,10932889,10932890,10932891,10932892,10932893,10932894,10932895,10932896,10932897,10932898,10932899,10932900,10932901,10932902,10932903,7065492,7070854,8064299,8064300,8064301,8064302,8064303,8064304,8064305,8064306,8064307,8064308,8064309,8064310,8064311,8064312,8064313,8064314,8064315,8861150,8064316,8064317,8064318,8064319,8064320,8064321,8064322,8064323,8064324,8064325,8064326,8064327,8064328,8064329,8064330,8064331,8064332,10958987,10958988,10958989,10943150,10943151,10943156,6000065,6000066,6000067,6000068,3655719,3655720,10944648,10944649,10944650,10944651,10944652,10944653,10944654,10944655,10944656,8072434,8072436,8072447,8072459,8859524,8859525,8072527,3656624,3656641,3656645,3656646,3656662,3656663,3656669,3656670,3656680,10941851,8073029,8073030,8073031,8073032,8073033,8073034,8073035,10957996,10957998,8860296,10942306,8969928,8860521,8860615,7070730,8860651,7070770,10942521,10942522,10623347,10623441,10919046,10919047,10618848,10618966,10618967,8070852,8070853,10619220,8070948,8070949,8070950,8070951,8070952,8070953,8070954,8070955,8070956,8070957,8070958,8070959,10624467,10624468,10920288,10920289,10927501,10927502,10927503,10927577,10927578,10923085,10923086,10923087,10620079,10620082,10926158,10926163,10926164,10926165,10926166,10926169,10926202,10926206,10916367,10916368,10916369,10916370,10916371,10916372,10916373,10916374,10916375,10916376,10916377,10916378,10916379,10916380,10916381,10916382,10916383,10916384,10916385,10916386,10916387,10615926,10921560,10921561,10921562,10921563,10921564,10921565,10921566,10921567,10921568,10921569,10921570,10921571,10921572,10921573,10921574,10921575,10921576,10921577,10921578,10921579,10921580,10921581,10921582,10921583,10930948,10926891,10926892,10926893,10927064,10927070,10953157,10953158,10953159,10953160,10953161,10953162,10953163,10953164,10953165,10953166,10953167,10953168,10953169,10953170,10953171,10953172,10953173,10953174,10953175,10953176,10953177,10953178,10953179,10917284,10922334,10922335,10922336,10922337,10922338,10922339,10922340,10922341,10922342,10922343,10922344,10922369,10922370,10922371,10922372,10922373,10922374,10922375,10922376,10922377,10922378,10922379,10922380,10922381,10922382,10922383,10922384,10922385,10922386,10922387,10922388,10922389,10922390,10922391,10922392,10922393,10922394,10922395,10922396,10922397,10922398,10922399,10922400,10922401,10922402,10922403,10922404,10922405,10922406,10922407,10922408,10922409,10922410,10922411,10922412,10922413,10922414,10922415,10922416,10922417,10922418,10922419,10922420,10922421,10922422,10922423,10922424,10922425,10922426,10922427,10922428,10922429,10614238,10559718,10559719,10559720,10559721,10559745,8864476,8864477,8864478,10559789,8861969,10560393,10560394,10560395,10560396,10560397,10560398,10560399,10560400,10560401,10560402,10560403,10560404,10560405,10560406,10560407,10560408,10560409,10560410,10560411,10560412,10560413,10560414,10560415,10560416,10560417,10560418,10560419,10560420,10560421,10560422,10560423,10560424,10560425,10560426,10560427,10560428,10560429,10560430,10560431,10560432,10612283,10560433,10560434,10560435,10560436,10560437,10560438,10560439,10560440,10560441,10560442,10560443,10560444,10560445,10560446,10560447,10560448,10560449,10560450,10560451,10560452,10560453,10560454,10560455,10560456,10560457,10560458,10560459,10560460,10560461,10560462,10560463,10560464,10560465,10560466,10560467,10560468,10563468,10563469,10560469,10563470,10560470,10563471,10560471,10563472,10560472,10560473,10560474,10560475,10560476,10560477,10560478,10560479,10560480,10560481,10560482,10560483,10560484,10560485,10560486,8862262,8862263,8862264,8862265,10612486,10612637,10612660,10612666,10612667,10612668,10612673,10612704,10612707,10612740,10612862,10612868,10612869,8862867,10561597,10561599,10561600,10561601,10561606,10561648,10561649,10561656,10561657,10561668,10561707,10561708,10561709,10610832,10610833,4975113,4975114,4975117,10516183,2809112,2809113,2809114,2809257,10516655,10516656,10516657,10516658,10516659,10516660,10516661,10516662,10512839,10512840,8861660,8861661,8861662,8861663,8861664,8861665,8861666,8861667,8861668,8861669,8861670,8861671,8861672,8861673,8861674,8861675,8861676,8861677,8861678,8861679,8861680,8861681,8861682,8861683,4973243,4973421,4973422,10418529,4973636,4973729,4973818,4973819,10419019,10462948,10462949,10462950,10462951,10462952,10462953,10462954,10462955,10462956,10462957,10462958,10462959,10462960,10462961,10462962,10462963,10462964,10462965,10462966,10462967,10462968,10462969,10462970,10462971,10462972,10462973,10462974,10462975,10462976,10462977,10462978,10462979,10462980,10462981,10462982,10462983,10462984,10462985,10462986,10462987,10462988,10462989,10462990,10462991,10462992,10462993,4971387,4971388,4971931,10469763,10470071,10466765,10466766,10466767,10466768,10466769,10466770,10466771,10466772,10628185,10628186,10628187,10628830,10629816,10629817,10627562,10627563,10627719,10626102,10626103,10626104,10626822,10568768,10566369,10566370,10567660,10567661,10567919,10567920,10567921,10567922,10567923,10567924,10567925,10567926,10567927,10567928,10567929,10567930,10567931,10567932,10567933,10567934,10567935,10567936,10421066,10472885,10472886,10472887,10472911,10472912,10473067,10473068,10473069,10473070,10473071,10473072,10473073,10472756,10472757,10472758,10472759,10472760) 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'