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(10930099,3228439,3228440,3228453,3228488,3228537,3228573,3228735,4970667,4970668,3228750,9215041,9215093,3228986,8583119,8583169,10950326,8583358,8583369,8631597,9215647,9215653,9215670,10849379,7066147,7066148,7066164,10849559,10849849,8573046,8573097,8629602,3227407,8629668,8629670,3227498,3227501,3227502,3227503,3227508,3227509,3227510,3227568,3227573,8573340,10938928,10938929,10939023,10939041,8573636,8573637,8573638,8573639,8573640,10939385,3238544,3238545,3238546,8595039,8595076,8595114,8595117,8595214,8595298,8065798,7201975,8572094,8572170,8572171,7202349,10844098,8572835,8572889,8572893,7200341,7200431,7200432,7200435,7200436,7200467,7200473,8626907,8626908,8626909,8626910,8626916,8626917,8626918,8626919,10102663,10102758,7198078,8624550,7198179,7198437,7198449,10839982,10100403,10100409,10941035,10941036,7198599,7198600,7198601,7198602,7198677,7198679,7198680,7198703,8908523,7198713,7198752,7069777,7069778,10100954,10941575,10941576,10941577,10101031,7199352,7070108,7199377,7199466,7199477,10101455,10101467,10101500,10101618,3923225,8905975,8905978,8905979,10837737,10837741,10837742,3923391,10837760,10837764,10837861,10837862,10837863,10837864,10837865,10837866,7196399,3923550,3923594,7196480,3923647,8554288,8906510,8906513,7196733,8906585,8906604,8906625,8906785,8906831,8906832,8906836,7197104,7197147,8070776,7197194,10838757,10838761,10838795,7197328,10838909,7197484,3234854,7197942,11047452,8578002,10616975,10616976,10616977,10616981,10616982,8578017,8904912,8904952,8904968,8904991,3232353,8904992,8905028,8905030,10617124,8905043,8905056,10617169,10617170,10622188,10622197,10617207,10617221,10617222,8905151,8905161,10617343,10617346,10837003,10837010,10837012,8905338,8634957,8905391,8905392,8905547,8905611,8905621,8905622,8905626,8905628,8905633,8905733,8905751,8905771,8905778,3233175,10615095,10615098,8609791,10615143,10615148,10615182,10615232,10615234,10615242,10615268,9216853,10615391,10615405,10615406,10615415,10615432,10615433,10615916,10615967,10616005,10616017,10426243,10426253,10616044,10616072,10426338,10616136,10426378,10616208,10616224,10616359,10616361,10616362,8904311,8904323,10616418,10616427,10616497,10616609,8904537,10616666,10616667,10616668,10616731,10616748,10616787,10616873,10613999,10614012,10614024,9915572,10611058,10611108,10614171,10614279,6669826,10714114,10611305,10611322,6669892,6669893,6669894,6669902,6669913,10614438,8853784,10611633,8853797,8853798,10614731,9214116,10611786,10614870,10614890,10614893,10614894,10614895,10614896,10614904,10614905,10614910,9190256,10614933,10614940,10614941,10614942,10614946,10609073,10612086,10609213,10612306,10609350,10609352,10609360,10609365,10609368,10612381,10609383,10609402,10609405,10612407,10609410,10609424,10609439,10609454,10609500,10609501,10609510,10609511,10609512,10609513,10609514,10609515,10609518,10609522,10612556,10609564,10609581,10609596,10609600,10609619,10609629,8862497,10609658,8862523,10609693,10609704,8851886,8851891,10609743,10612757,10609768,10612824,10609835,10609848,8852012,8852013,10609859,10609860,10609861,10609862,10609863,10609864,10609865,10609866,10609867,10609868,10609869,10609876,10609877,10609879,10609888,10609892,10609895,10609900,10609901,10609976,10612982,10612983,10612991,10610046,8852277,8852279,10610124,10610187,8852395,10610319,10610335,10613351,10610390,9164764,8852730,9164940,10610684,10610685,10610691,10613886,10613896,10613917,8853095,10613959,10613960,10613961,10117500,10117501,10117502,10117504,10117529,9169353,9911631,9911633,9911634,9911635,9911636,9911637,9911638,10117640,9169449,9911659,9911660,9911677,9911680,9169495,9911703,9169504,8849336,9911720,9911748,8849367,8849374,8849375,9911778,9169576,9911802,9911813,9911814,9911821,6673821,6673831,6673835,9169629,6673839,6673842,6673845,6673847,6673848,6673855,10117874,6673893,8849523,10117976,9169795,9912009,9912031,10118030,8849700,10118075,9912107,10118097,9169928,8849775,10118147,10118173,10118178,6674229,9912236,8551341,990437,990438,8849890,8849910,10118286,990596,990597,8551508,8850044,8850050,8850051,8850066,10118465,10118466,8850102,8551576,9912487,10118479,10118489,9912537,8850171,9912653,9912658,10118663,8551768,8551769,8551770,8551771,8551778,9912687,990890,990900,8551828,990919,990932,2809285,9912893,9912896,8552001,8552012,8552058,991157,991167,8552100,8552140,8552142,8552173,8552188,8552205,8552441,9160342,10416337,10415343,10415344,6672652,6672659,10416381,10416382,9168533,10419470,10416471,10419507,10419512,6672801,10419518,10419536,10419537,9168629,9160643,9160650,10419572,9160656,6672862,9160733,10415656,10416656,10416661,10416662,6672994,6672995,10419761,9160874,6673128,6673129,6673190,6673191,9169008,9169034,9169035,10417968,6673261,6673290,10416042,9169122,10117338,6673372,9169182,10117431,6673442,10117449,10117457,10117461,10117482,10117484,10117490,8549530,10471072,10469097,9166533,10471157,10471158,10471160,9166611,8865237,9166750,8549931,8549942,8549943,8549958,8549983,10467508,8550126,8550127,10467566,10467571,8550174,10467608,10467640,10469657,8550248,8550261,10467739,10467740,10467741,10467750,10467771,10469859,10469860,10469866,10469903,9167332,9167333,9167345,10467948,10467949,10467950,10469958,8847268,8847273,8847274,8847290,10468161,10470162,9167640,9167662,8847489,9167682,9167726,10468311,10468346,9167799,9167804,9167805,9167829,9167831,9167832,9167851,9168141,9168171,8848027,8848029,10946304,10946305,10883561,10888563,10946431,10883657,10946470,10946471,10946475,10946476,10888671,10888687,10888695,10888702,10883731,10888749,10888814,10628311,10946799,10884091,10884100,10946915,10884131,10889139,10889156,10889159,10889160,10884170,10889172,10889185,10889186,10889190,10889192,10889194,10884195,10889205,10889211,10889227,10889239,10947171,10947228,10947229,10947230,10947231,10947232,10947234,10947235,10947236,10947237,10628917,10947238,10884591,10884599,10947460,10947481,10884748,10884784,10889867,10947712,10884914,10889970,10875033,10875038,10875039,10875042,10875043,10875044,10875045,10875046,10875048,10875060,10890084,10890164,10885195,10885290,10885470,10882480,10882485,10882490,10882491,10882492,10882493,10887504,10882515,10882516,10882521,10882522,10882529,10882553,10887564,10882576,10882588,10887597,10882600,10882617,10887627,10887633,10882634,10882648,10882649,10882656,10882657,10882662,10887666,10945485,10882686,10882687,10882733,10882736,10882737,10882738,10882739,10882744,10882747,10882748,10882796,10887801,10887807,10887822,10887823,10887839,10887841,10887846,10882899,10882906,10882908,10882909,10882910,10882914,10882923,10882926,10882932,10882938,10882939,10882942,10882958,10882965,10882974,10882994,10882995,10883008,10945824,10883013,10883031,10883033,10883035,10883036,10883037,10883039,10883040,10883041,10883046,10883047,10883048,10883149,10883155,10883196,10883220,10888272,10888275,10888278,10888386,10888399,10946221,10888418,10946239,10946248,10888440,10888443,10946272,10885503,10948403,10885648,10161689,10625206,10885750,10161776,10161781,10161796,10161799,10161800,10161806,10161811,10161831,10161832,10885956,10161981,10161994,10948852,10948857,10162074,10886068,10162089,10162097,10886088,10886097,10162126,10162134,10886137,10886140,10886144,10625642,10625658,10948985,10886197,10886202,10886223,10881243,10886252,10886258,10886289,10886292,10886298,10886313,10886314,10881343,10886353,10886379,10886380,10886381,10886382,10886430,10886442,10886456,10886482,10886484,10886487,10886557,10886561,10886563,10886564,10886595,10886606,10886619,10886643,10886648,10886672,10886675,10886683,10626212,10886741,10876749,10949565,10886781,10886782,10886783,10886784,10886785,10886807,10886808,10876831,10886976,10886977,10886987,10886988,10886989,10886999,10887003,10626497,10887012,10877060,10882060,10877064,10882073,10882079,10882138,10877223,10877349,10877358,10877361,10877368,10887383,10887384,10887385,10945203,10882396,10882400,10882401,10882405,10626912,10887427,10882445,10882446,10882456,10882458,10882460,10602172,10602205,10602234,10602273,10602751,10647297,10647302,10647316,10647317,10647349,10647541,10647548,10647554,10647560,10647567,10647569,10647573,10647576,10601711,10545356,10545357,10545358,10545371,10545372,10545373,10508489,10508533,10411328,10411342,10407356,10407357,10411391,10411470,10409607,10409608,10409644,10409645,10409646,10409696,10409731,10409732,10409733,10409734,10409735,10409736,10409764,10409806,10409807,10407821,10409826,10407838,10409852,10409853,10409908,10409971,10409987,10408036,10410083,10410101,10410106,10410107,10410111,10410114,10410115,10410117,10410134,10410140,10410153,10410154,10410584,10410919,10410920,10406985,10409101,10407145) 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'