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(10939578,10939579,4970290,10939725,4970340,10943574,4970383,10939811,10943622,10939877,10939878,4970500,4970501,4970502,4970552,4970560,4970580,4970636,4970637,4970638,10940100,4970743,4970750,4970753,4970754,4970755,4970756,10944076,10944079,10944083,10940289,10940290,10944106,10944132,10944140,10944166,10940374,10944191,10940399,10940400,4970994,10940401,10940402,10944200,10944225,4971024,4971025,10944261,10940497,10940502,10944354,8066934,8067027,10437195,4968565,8067374,10437291,10437292,10437293,10437294,10437306,8067435,8067446,8067467,8067468,8067518,10437499,8067692,10938605,8067911,8067912,4969261,4969262,4969263,4969264,10938722,10938755,8068171,8068200,4969611,4969612,4969613,4969614,10939253,8068532,8068581,8068597,4969938,10939374,8068668,10939424,8065081,8065087,8065088,8065089,8065091,8065094,8065184,8065185,8065208,8065209,8065210,8065211,8065212,8065213,8065214,8065215,8065216,8065217,8065218,8065219,8065220,8065221,10931812,8075321,8065618,8065653,8065691,8065728,8065765,8065766,8065781,10932163,8065938,10932328,10932329,8066048,8066189,10932661,10932662,10932683,10932684,4967553,10932685,10932686,10932687,10932688,10932689,10932690,4967560,10932691,10932692,10932693,10932694,10932695,4967577,8066347,10932773,10932774,8066432,4967703,8066468,8066474,4967743,4967744,4967745,4967746,4967747,4967752,4967753,4967767,4967768,4967769,10932906,4967819,4967820,4967821,4967822,4967823,4967824,4967825,4967826,8066589,8066590,8066626,10933039,10933040,8066672,10933044,10933047,10933048,8066678,10933049,10933051,10933052,10933063,10933064,10933065,10933089,10933108,10933109,10933110,8066740,4967983,4967984,10933176,8066820,8066838,8066850,8066861,11049796,10942585,10942647,10942650,10942658,10942710,10942723,10942734,10942735,10942736,10942737,8064364,8064374,8064394,8064478,8064479,8064480,8064481,8064482,10943160,10943161,8064520,8064521,8064522,8064525,10940599,3655610,3655611,10940673,10940696,10940697,10940759,10940762,10940764,3655793,3655810,3655811,3655812,3655813,3655971,3655972,3655973,3656015,3656100,3656111,10941173,3656122,10941176,3656156,3656173,3656285,10941440,10941441,10941442,10941443,10941444,10941502,8072644,8072659,8072664,8072679,8072684,8072689,8072699,8072714,8072719,8072734,8072739,8072744,8072754,8072759,8072764,8072769,10941659,8072779,8072784,8072789,8072797,3656634,8072805,3656645,3656646,3656647,3656648,3656649,8072813,3656650,3656651,3656652,8072821,8072829,8072837,3656678,8072849,3656686,8072857,8072869,8072877,8072887,8072893,8072905,10941799,8072913,3656753,3656754,8072921,8072928,8072939,8072946,8072954,8072962,8072970,8072978,10942024,10942029,10942030,11049749,11049750,11049751,10923655,10923674,10923675,10923697,10923744,10923745,10923758,10918764,10923809,10918832,10923840,10918846,10923908,10918914,10923938,10923956,10923963,10923969,10923999,10623492,10623493,10924012,10924013,10924014,10924015,10924026,10924057,10919069,10924070,10924075,10623567,10623568,10623569,10924096,10919097,10924114,10924115,10924116,10924124,10924127,10924143,10924151,10924167,10924173,10924181,10924205,10924215,10924222,10924235,10924244,10919279,10623819,10919333,10623846,10623847,10623848,10924366,10919372,10623862,10623863,10919373,10623864,10623865,10623866,10623867,10623891,10623901,10924479,10924499,10919526,10924539,10919560,10624070,10624076,10924587,10924606,10924654,10924713,10924729,10919732,10924779,10919783,10924796,10924868,10924887,10924895,10924911,10924963,10924964,10924971,10924985,10924986,10924988,10924991,10925006,10925015,10925037,10925038,10925079,10925085,10925086,10925087,10925088,10925091,10925203,10925209,10925210,10624705,10925246,10925264,10925265,10925266,10925282,10925283,10925302,10925324,10925327,10925332,10925336,10925362,10922472,10922473,10621967,10621969,10621975,10622011,10622029,10622037,10622038,10622039,10622050,10622051,10622052,10922586,10922587,10922588,10922589,10917591,10917592,10622093,10622094,10922608,10917610,10622176,10917689,10917690,10917818,10622363,10622679,10622941,10622947,10622957,10620000,10620009,10920531,10920532,10920533,10920534,10920535,10920536,10920537,10920538,10920539,10920540,10620033,10620035,10920560,10620065,10920598,10920599,10920600,10920619,10920636,10920657,10920667,10920682,10920684,10920685,10920686,10920687,10920688,10920689,10920690,10920716,10920736,10920737,10920739,10920740,10920741,10920742,10920743,10920744,10920745,10920746,10920747,10920748,10920749,10920750,10920751,10920752,10920753,10920754,10920755,10920756,10920757,10920758,10920759,10920769,10920776,10920784,10915837,10920838,10620329,10920847,10920848,10920849,10920850,10920851,10920852,10920853,10920854,10920855,10920856,10620346,10920857,10920858,10920859,10920860,10920861,10920862,10920863,10920864,10920865,10920866,10920867,10920868,10920869,10920870,10920871,10920872,10920873,10920874,10620390,10620391,10620392,10620395,10620396,10620397,10620411,10620415,10620417,10620418,10915957,10916200,10620760,10916276,10620857,10916440,10916441,10916445,10916446,10916447,10916448,10916454,10916455,10916471,10916472,10916473,10916474,10916479,10916480,10916488,10916489,10916490,10916491,10916492,10916493,10916494,10916518,10916519,10916524,10916525,10916526,10916527,10916528,10916529,10916532,10916539,10916540,10916541,10916542,10916543,10916549,10916550,10916551,10916552,10916557,10916558,10916559,10916560,10916561,10916565,10621109,10621110,10621111,10621112,10621113,10621114,10621115,10621116,10621144,10621163,10621164,10621165,10621264,10621359,10621421,10621428,10621429,10917004,10621510,10621516,10621517,10621535,10621536,10621541,10621543,10621567,10621568,10621749,10917277,10621775,10621777,10621778,10621779,10917291,10917318,10917323,10917324,10917325,10917326,10621817,10917332,10917334,10621875,10610995,10610996,10565171,10565176,10565221,10565222,10611162,10611203,10611361,10611377,10611378,10611425,10611426,10611522,10611581,10611682,10611699,10611702,10611705,10611706,10611707,10609095,10609107,10609108,10563450,10609306,10609307,10609356,10609357,10609376,10609378,10563541,10563542,10563543,10563584,10563585,10609447,10609618,10609674,10563924,10563925,10609784,10563936,10563937,10563945,10563946,10563955,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563975,10563976,10609835,10609836,10610036,10610041,10610049,10610301,10610308,10564460,10610462,10564645,10564646,10564647,10564648,10564649,10564650,10564651,10564652,10564653,10564654,10564655,10564656,10564657,10564658,10564735,10564736,10564737,10564738,10564739,10564740,10564741,10564742,10564743,10564744,10564745,10564746,10564747,10564748,10564749,10564750,10564751,10564752,10564753,10564754,10564755,10564756,10564757,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,10564766,10564767,10564768,10564769,10564770,10564771,10564772,10564773,10564774,10564775,10564776,10564777,10564778,10564779,10564780,10564781,10564782,10564783,10564784,10564785,10564786,10564787,10564788,10564806,10564807,10564808,10564809,10564810,10564811,10564812,10564813,10564814,10564815,10564816,10564817,10564818,10564819,10564820,10564821,10564822,10564823,10564824,10564825,10564826,10610676,10564827,10564828,10610683,10610842,10610937,10610938,10610952,10517276,10517515,10517516,10517517,10517518,10517519,10517520,10517521,10517522,10517523,10517524,10517525,10517526,10517527,10556517,10518617,10556743,10556990,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,10557018,10557019,10557020,10557021,10557022,10557023,10557024,10557025,10557026,10557027,10557028,10557029,10557030,10557031,10557032,10557033,10557034,10557035,10557036,10557037,10557038,10557039,10557040,10557041,10557042,10557043,10557044,10557045,10557046,10557047,10557048,10557049,10557050,10557051,10557052,10557053,10557054,10557055,10557056,10557057,10557058,10557059,10557060,10557061,10415392,10415419,10415429,10419448,10419449,10415604,10419637,10419638,10419639,10419640,10415676,10415678,10415846,10416196,10462926,10470967,10462970,10463023,10463025,10463026,10463027,10463035,10463045,10463046,10463050,10463051,10463052,10463054,10471067,10463075,10463099,10463116,10463158,10463162,10463184,10463185,10463187,10463188,10463189,10463192,10463199,10463200,10463221,10471228,10471229,10463308,10463309,10463310,10463487,10463575,10463576,10463577,10463578,10463579,10463580,10463680,10463735,10463739,10469894,10469895,10469896,10469918,10469919,10469920,10469921,10469922,10469923,10469946,8563297,8563337,8563339,10470087,8563490,10462407,10462421,10470447,10470448,10470449,10470450,10470451,10462452,10470452,10470642,10470663,10470848) 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'