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(10939561,8068868,10943425,7068242,7076246,7076247,7076250,7068251,7068252,7068293,7068294,7076307,7076308,7076309,7076310,7076311,7076312,7076313,7076314,7076315,7076317,7076318,7076319,7076321,7076323,7076324,7076325,7076326,7068336,7076352,10939983,4970750,4970916,4970936,4970937,4970939,4970976,7065943,8066938,10963676,10963677,7073999,7074103,7074143,7074144,7074327,7066345,8067504,8067691,8067696,8067712,7074866,7066928,7074935,7066937,10961732,10961733,10961734,10961735,8067952,8067953,8067954,8067955,7075140,7075142,7075143,10961852,10961906,10961916,10961917,10961967,10962074,10962075,10962076,10962077,10962078,10962079,10962080,10962081,10962082,10962090,10962113,10962114,8068449,8068478,8068487,8068509,8068510,8068511,8068512,8068513,8068514,8068605,7067735,8068659,8068680,7067794,8068689,8068720,8068730,8068731,8068732,8068733,8068748,8068761,8068762,7064042,10972790,7072154,7072155,7072156,7072285,7072287,7072333,7072334,7072383,7072388,7072411,7072441,10973188,7072565,7072571,7072587,7072590,7072662,7072665,7072699,7072748,7072752,7072792,4967032,7072945,7072946,7073105,8066218,8066483,10961211,10961212,10961213,8066507,10961221,8066558,8066565,10961276,10961277,8066575,8066630,8066661,8066662,10961384,8066692,8066713,8066714,10961460,10961461,8066758,8066774,8066775,8066789,8066790,8066800,8066838,8066850,8066851,8066852,8066853,10961605,10961606,10961612,10961613,10961614,10961615,10961616,8066911,10942785,10942798,10942799,10942800,10942801,10942827,11049126,10942889,10942913,10942963,10942964,10942966,10942967,10942981,10942982,10942988,10942989,10942990,10943010,10943050,10943051,10943060,11049345,10943076,10943192,10943196,10943197,10943366,7071749,7071762,7071763,10943413,10943414,10943418,7071802,7071866,7071878,7071879,3655506,3655507,7069054,10969876,10969877,10969878,10969879,10969880,10969881,10969882,10969883,10969884,10969885,10969886,10969887,10969888,10969889,10969890,10969891,10969892,10944747,3656209,3656212,3656218,3656219,7069692,3656270,3656331,10970580,10970581,3656592,10941805,10941848,10970919,10970920,10970921,10941864,10941884,10941891,10941909,10941927,10941930,10941936,10941937,10957999,10941940,10971011,10941955,10941965,10941969,10941974,10941978,10941980,10941982,10941986,10941994,10942063,10971151,10971191,10971192,10971193,10971194,7070622,7070737,7070738,10942415,7070796,7070816,7070817,7070818,7070819,7070820,7070822,7070824,7070850,7070857,10918485,10923531,10923532,10923541,10923558,10923615,10923623,10923624,10618127,10923638,10618128,10923639,10923640,10923641,10923642,10923643,10923644,10918651,10918652,10618154,10918697,10918698,10923708,10923709,10923710,10923711,10923712,10923713,10923714,10923715,10923716,10923717,10923718,10923719,10923720,10918763,10928794,10923944,10923945,10923946,10923947,10923948,10923949,10923950,10923951,10923952,10923953,10924031,10924032,10924033,10924034,10924035,10924118,10924119,10924120,10924121,10924122,10924123,10924124,10924125,10924126,10919201,10919202,10919203,10919204,10919205,10919206,10924219,10924251,10924252,10924280,10924281,10924340,10924341,10924342,10924343,10924344,10924345,10924346,10924347,10924348,10924349,10924350,10924351,10924352,10924353,10924354,10924355,10924356,10924357,10924358,10924359,10924360,10924361,10924362,10924363,10924364,10924365,10924366,10924367,10924368,10924369,10924370,10924371,10924372,10924373,10924374,10924375,10924376,10924377,10924378,10924379,10924380,10924381,10924382,10924383,10924384,10924385,10924386,10924387,10924388,10968643,10624056,10624057,10924577,10924578,10924579,8070858,10924852,10924853,10924854,10924855,10924969,10924970,10924971,10924972,10919973,10924973,10919974,10924974,10924975,10919975,10924976,10919976,10919977,10919978,10919979,8071199,8071200,10925125,10925126,10925127,10925141,10925148,10925149,10925178,10925179,10925180,10925181,10925182,10925215,10925216,10925378,10925434,10621985,10622011,10622014,10617042,10622055,10622060,10622071,10617072,10617109,10622115,10922640,10922641,10922642,10617180,10617181,10617182,10617189,10617190,10617191,10617192,10922705,10922706,10922707,10922708,10922717,10922723,10966873,10922861,10922919,10917999,10918000,10923019,10923025,10923026,10928060,10923088,10923108,10923109,10923115,10923116,10918118,10923123,10923144,10923174,10923175,10923190,10923191,10923208,10923225,10923226,10923227,10923228,10923268,10923273,10918282,10918283,10923341,10923396,8570013,8570014,8570084,8570085,10920745,10620307,10925863,10620381,10620382,10615391,10615393,10920961,10920962,10920963,10620491,10965365,10930740,10965480,10921339,10921340,10921341,10921342,10921343,10930766,10921382,10921392,10921393,10921394,10921395,10615897,10615898,10615947,10921472,10921473,10921474,10921475,10930963,10616062,10921609,10921636,10921667,10616211,10616212,10616213,10616214,10616215,10926755,10621323,10921883,10921884,10921885,10921886,10921887,10921888,10921889,10921890,10921891,10621381,10621382,10621422,10621428,10621429,10621445,10621446,10621447,10621456,10621529,10927072,10927073,10927083,10621615,10621649,10621668,10621675,10621732,10611073,10611074,10611077,10611078,10611135,10611141,10614247,10614248,10614254,10565445,10565446,10565447,10565448,10565449,7059845,10614345,10614350,10614351,7059865,8864429,10562905,10562906,10562907,10562908,10562909,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,6666255,6666256,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611936,8864809,7057485,7057488,7057489,7057495,7057496,7057501,7057502,7057504,7057505,7057506,7057507,7057513,7057514,7057515,7057516,7057517,7057530,10609141,10557315,10557316,10557317,10557318,10557319,10557446,10557447,10557540,8862527,7058214,8862674,10609984,8863102,7058843,7058855,7058856,10610372,7058884,7058885,7058909,10613479,10610486,10610488,7059097,7059112,10613612,7059119,10613662,8863528,8863529,7059235,7059236,8863593,8863594,8863601,8863610,10610811,7059363,7059375,7059376,7059377,7059414,7059425,7059426,7059427,10511199,4974288,4974289,4974290,10555261,10511263,10511264,10511291,10555327,10555328,10555329,10555330,10555331,10555332,10555333,10555334,10555335,7055689,10555336,10555337,10555338,10555339,10555340,10555341,10555342,10555343,7055749,7055754,7055907,7055908,10515595,10515596,10517634,10517635,10515675,10513712,10513713,4974809,4974825,4974826,4974827,4974828,4974829,4974830,4974832,4974833,10555799,10555800,10555801,10555802,10555803,10555804,7056158,10555805,10555806,10555807,4974848,4974865,10513887,10513888,10513889,10555947,10513962,10513963,10513964,10512118,10512119,10512120,10512142,10516188,4975278,4975279,4975280,2809391,2809392,7057274,10516956,10516957,10516958,10516959,10516960,10516961,10516963,10556991,10556992,10556993,10556994,10556995,10556996,10556997,10556998,10556999,10557000,10557001,10557002,10557003,10557004,10557005,10557006,10557007,10557008,10557009,10557010,10557011,10557012,10557013,10557014,10557015,10557016,10557017,10513071,10513072,10513073,10513074,10519089,10419242,10419271,10418317,10418319,10418322,10418329,10416334,4973266,10415339,10415340,10417351,10416399,10416417,10417433,10417434,10415515,10417529,10419543,10419556,10419562,10419563,10417634,10415674,10417712,10417713,10416797,10415845,10415846,10415923,10419005,10417092,10420102,4974126,4974148,8864834,10469245,4971590,10471482,10471483,8916871,8916896,10469911,10469920,4972208,10467965,4972255,8917063,10468038,8563393,8563394,10468082,4972468,10468210,10468211,10470212,10468212,10470213,10468352,10462396,10462397,10462398,10470487,10470666,8917845,10464803,10464804,10629560,10629750,10629807,10629901,10629902,10629903,10626967,10632040,10632041,10632042,10632043,10632044,10632045,10632046,10632188,10153866,10153867,10153868,10153869,10627693,10627756,10627774,10627790,10627821,10627822,10627823,10627824,10627825,10627826,10627827,10627828,10627829,10627830,10629971,10629972,10629973,10629974,10630050,10630101,10625239,10625240,10630317,10630341,10630342,10630343,10630344,10630345,10630359,10630503,10630599,10630600,10630601,10630605,10630655,10630665,10630685,10630686,10630687,10630954,10626192,10626195,10626269,10626270,10626271,10626272,10626273,10626274,10626439,10626723,10626742,10626959,10568557,10568569,10568570,10568571,10568572,10568573,10568944,10568945,10568946,10568947,10568988,10568989,10520826,10520827,10520828,10520829,10520830,10520831,10520832,10520833,10520834,10520849,10520850,10520851,10520852,10520853,10520854,10520855,10420305,10420306,10420307,10420409,10420410,10420413,10420517,10420518,10420526,10420530,10420531,10421109,10421123,10421134,10421143) 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'