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(8628040,8628097,8628098,8628099,8628100,8628106,8628107,8628108,8628109,8628110,8628111,8628112,8628113,8628114,8628115,8628116,8628117,8628406,8628407,8628408,8628409,8628410,8628411,8628412,8628413,8628414,8628415,8628416,8628418,8628419,8628420,8628423,8628425,8628426,8628427,8628428,8628429,8628430,8628431,8628432,8628433,8628434,8628435,8628436,8628437,8628438,8628440,8628441,8628442,8628443,8628444,8628445,8628446,8628447,8628448,8628449,8628450,8628451,8628453,8628454,8628455,8628456,8628457,8628458,8628459,8628460,8628461,8628462,8628463,8628464,8628465,8628466,8628468,8628469,8628470,8628471,8628472,8628473,8628474,8628475,8628476,8628477,8628478,8628479,8628480,8628481,8628482,8628483,8628484,8628485,8628753,8628754,8628755,8628756,8628757,8628758,8628759,8628760,8628761,8628762,8628763,8628764,8628765,8628766,8628767,8628768,8628769,8628770,8629281,8629351,8629352,8629353,8629354,8629429,8629430,8629472,8629478,8629479,8629480,8629481,8629482,8629544,8629545,8629546,8629547,8629548,8629549,8629550,8629551,8629552,8629555,8629556,8629590,8629593,8629597,8629598,8629600,8629604,8629605,8629606,8629614,8629617,8629618,8629619,8629620,8629621,8629622,8629636,8629643,8629644,8629651,8629653,8629656,8629658,8629660,8629664,8629665,8629666,8629667,8629668,8629669,8629671,8629683,8629684,8629685,8629686,8629688,8629689,8629694,8629695,8629696,8629697,8629698,8629699,8629700,8629701,8629702,8629703,8629704,8629710,8629711,8629712,8629713,8629766,8629767,8629768,7201404,8624990,8624991,8624992,8624993,8624994,8624995,8624996,8624997,8624998,8624999,8625000,8625001,8625002,8625003,8625004,8625005,8625006,8625007,8625008,8625009,8625010,8625011,8625012,8625013,8625014,8625015,8625016,8625017,8625018,8625019,8625020,8625021,8625022,8625023,8625024,8625026,8625027,8625028,8625029,8625030,8625031,8625032,8625033,8625034,8625035,8625036,8625037,8625038,8625039,8625040,8625043,8625044,8625046,8625047,8625048,8625049,8625050,8625051,8625052,8625053,8625054,8625241,8625242,8625243,8625244,8625245,8625246,8625247,8625248,8625249,8625374,8625375,8625376,8625377,8625378,8625379,8625380,8625381,8625444,8625445,8625446,8625447,8625448,8625449,8625450,8625451,8625452,8625453,8625454,8625455,8626262,8626263,8626264,8626265,8626266,8626267,8626268,8626269,8626270,8626271,8626272,8626273,8626274,8626275,8626276,8626277,8626278,8626279,8626280,8626281,8626282,8626283,8626284,8626285,8626286,8626287,8626288,8626289,8626290,8626291,8626292,8626293,8626294,8626295,8626296,8626297,8626298,8626299,8626300,8626301,8626303,8626304,8626305,8626306,8626307,8626309,8626310,8626311,8626312,8626313,8626314,8626315,8626316,8626317,8626318,8626319,8626320,8626321,8626322,8626323,8626324,8626325,8626326,8626327,8626328,8626329,8626330,8626331,8626332,8626333,8626334,8626335,8626336,8626337,8626338,8626339,8626340,8626341,8626342,8626343,8626344,8626345,8626346,8626347,8626348,8626349,8626406,8626407,8626408,8626409,8626410,8626411,8626412,8626413,8626414,8626415,8626416,8626417,8626418,8626419,8626421,8626422,8626423,8626424,8626425,8626426,8626427,8626428,8626429,8626430,8626431,8626432,8626433,8626434,8626435,8626436,8626437,8626438,8626439,8626440,8626441,8626442,8626443,3237346,8626835,8626836,8626837,8626838,8626839,8626847,8626848,8626849,8626850,8626851,8626852,8626853,8626854,8626855,8626856,8626857,8626858,8626859,8626860,8626861,8626862,8626863,8626864,8626865,8626866,8626867,8626868,8626869,8626870,8626871,8626872,8626873,8626874,8626875,8626876,8626877,8626878,8626879,8626880,8626881,8626882,8626883,8626884,8626885,8626886,8626887,8626888,8626889,8626890,8626891,8624261,8624262,8624263,8624264,8624265,8624266,8624267,8624268,8624269,8624270,8624271,8624272,8624273,8624274,8624275,8624276,8624277,8624278,8624279,8624280,8624281,8624282,8624283,8624284,8624285,8624286,8624287,8624288,8624289,8624290,8624291,8624292,8624293,8624294,8624295,8624296,8624297,8624298,8624299,8624300,8624301,8624302,8624303,8624304,8624305,8624306,8624307,8624308,8624309,8624310,8624311,8624312,8624313,8624314,8624315,8624316,8624317,8624318,8624319,8624320,8624321,8624322,8624323,8624324,8624325,8624459,8624528,8624529,8624530,8624531,8624532,8624533,8624534,8624535,8624536,8624537,8624538,8624539,8624540,8624541,8624542,8624543,8624544,8624545,8624696,8624697,8624698,8624708,8624709,8624710,8624711,8624712,8624713,8624714,8624715,8624716,8624717,8624718,8624719,8624720,8624721,8624722,8624723,8624724,8624725,8624727,8624728,8624729,8624730,8624731,8624732,8624733,8624734,8624735,8624736,8624737,8624738,8624739,8624740,8624741,8624742,8624743,8624744,8624745,8624746,8624747,8624748,8624749,8624750,8624752,8624753,8624754,8624755,8624756,8624757,8624758,8624759,8624760,8624761,8624762,8624763,8624764,8624765,8624817,8624818,8624819,8624820,8624821,8624822,8624823,8624824,8624825,8624826,8624827,8624828,8624829,8624830,8624831,8624832,8624833,8624834,8624835,8624836,8624837,8624838,8624839,8624840,8624841,8624842,8624843,8624844,8624845,8624846,8624847,8624848,8624849,8624850,8624851,8624852,8624853,8624854,8624855,8624856,8624857,8624858,8624859,8624860,8624861,8624862,8624863,8624864,8624865,8624866,8624867,8624868,8624869,8624870,8624871,8624872,8624873,8624874,8624875,8624876,8624877,8624878,8624879,8624880,8624881,8624882,8624883,8624884,8624885,8624886,8624887,8624888,8624889,8624890,8624891,8624892,8624893,8624894,8624895,8624896,8624897,8624898,8624899,8624900,8624901,8624902,8624903,8624904,8624905,8624906,8624907,8624908,8624909,8624910,8624911,8624912,8624913,8624914,8624915,8624916,8624917,8624918,8624919,8624920,8624921,8624922,8624928,8624929,8624930,8624931,8624933,8624936,8624937,8624938,8624939,8624940,8624941,8624942,8624943,8624946,8624947,8624948,8624949,8624950,8624951,8624952,8624953,8624954,8624955,8624956,8624957,8624958,8624959,8624962,8624963,8624964,8624965,8624966,8624967,8624968,8624969,8624970,8624971,8624972,8624974,8624975,8624976,8624977,8624979,8624980,8624981,8624982,8624983,8624984,8624986,8624987,8624988,8624989,3232801,3232879,7197270,7197275,7197279,7197281,3234503,8633345,8633346,8633347,8633388,8634100,8634102,8634359,8634360,8634361,8634362,8634442,8634443,8634444,8634445,8634446,8634447,8634573,8634574,8634575,8634580,8634586,8634587,8634588,8634589,8634590,8634591,8634592,8634593,8634594,8634595,8634596,8634597,8634598,8634599,8634600,8634601,8634602,8634603,8634604,8634605,8634885,8634886,8634887,8634888,8634889,8634890,8634891,8634892,8634905,8634906,8634907,8634908,8634909,8634910,8634911,8634912,8634913,8634914,8634915,8634916,8634917,8634919,8634920,8634921,8634922,8634923,8634924,8634925,8634926,8634927,8634930,8634931,8634932,8634933,8634934,8634935,8634939,8634940,8634941,8634942,8631990,8631991,8631992,8631993,8631994,8631996,8631997,8631998,8631999,8632000,8632001,8632002,8632003,8632004,8632005,8632006,8632007,8632008,8632009,8632010,8632011,8632012,8632013,8632014,8632015,8632016,8632017,8632018,8632019,8632020,8632021,8632022,8632023,8632024,8632025,8632026,8632027,8632028,8632029,8632030,8632031,8632032,8632033,8632034,8632035,8632036,8632037,8632038,8632039,8632040,8632041,8632042,8632043,8632044,8632045,8632046,8632047,8632048,8632049,8632050,8632051,8632052,8632053,8632054,8632055,8632056,8632057,8632058,8632059,8632060,8632061,8632062,8632063,8632064,8632065,8632066,8632067,8632068,8632069,8632070,8632071,8632072,8632073,8632074,8632075,8632076,8632077,8632078,8632079,8632080,8632081,8632082,8632083,8632084,8632085,8632086,8632087,8632088,8632089,8632090,8632091,8632092,8632093,8632094,8632095,8632096,8632097,8632098,8632099,8632100,8632101,8632102,8632103,8632104,8632105,8632106,8632107,8632108,8632109,8632110,8632111,8632112,8632113,8632114,8632115,8632116,8632117,8632118,8632119,8632120,8632121,8632122,8632123,8632124,8632125,8632126,8632127,8632128,8632129,8632130,8632131,8632132,10615568,10615569,10615570,7017415,7017416,10117655,9169551,10118051,6674254,10118419,10118550,10118551,9168795,9168796,9168797,9168283,10887864,10888443,10885527) 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'