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(4970165,4970166,4970167,4970168,4970169,4970170,4970171,4970172,4970173,4970188,4970189,4970190,4970191,4970192,4970262,4970263,4970264,4970426,4970427,4970428,4970485,4970650,4970676,4970711,4970719,4970720,4970721,4970722,4970723,4970729,4970736,4970738,4970766,4970770,4970782,4970804,4970805,4970806,4970807,4970808,4970809,4970810,4970836,4970837,4970838,4970839,4970840,4970852,4970895,4970903,4970904,4970925,4970992,4970993,4970994,4970996,4970997,4970998,4971006,4971015,4971024,4971025,4971054,4971063,4971064,4971065,4971081,4971100,4971104,4971105,4971106,4968154,4968155,4968187,4968189,4968197,4968198,4968199,4968200,4968211,4968212,4968216,4968224,4968232,4968233,4968234,4968254,4968268,4968296,4968297,4968299,4968301,4968304,4968305,4968312,4968313,4968314,4968320,4968328,4968334,4968335,4968352,4968353,4968354,4968355,4968356,4968361,4968362,4968363,4968364,4968365,4968369,4968377,4968378,4968379,4968380,4968381,4968382,4968383,4968384,4968385,4968386,4968387,4968388,4968389,4968390,4968391,4968392,4968393,4968394,4968395,4968396,4968397,4968398,4968399,4968400,4968401,4968402,4968403,4968404,4968411,4968414,4968415,4968416,4968417,4968418,4968419,4968420,4968421,4968422,4968433,4968434,4968435,4968436,4968437,4968447,4968460,4968472,4968473,4968477,4968478,4968479,4968480,4968481,4968482,4968483,4968484,4968485,4968486,4968487,4968488,4968489,4968490,4968491,4968492,4968493,4968494,4968495,4968496,4968497,4968498,4968499,4968500,4968501,4968502,4968503,4968504,4968505,4968506,4968507,4968508,4968509,4968510,4968511,4968512,4968513,4968514,4968515,4968516,4968517,4968518,4968519,4968520,4968521,4968522,4968523,4968524,4968525,4968526,4968527,4968528,4968529,4968530,4968531,4968532,4968533,4968534,4968535,4968536,4968537,4968538,4968539,4968540,4968541,4968542,4968543,4968544,4968545,4968546,4968547,4968548,4968549,4968550,4968551,4968552,4968553,4968554,4968555,4968556,4968557,4968558,4968559,4968560,4968561,4968562,4968563,4968564,4968571,4968572,4968573,4968574,4968597,4968598,4968599,4968600,4968606,4968608,4968616,4968619,4968620,4968621,4968626,4968627,4968633,4968634,4968636,4968637,4968638,4968639,4968640,4968641,4968642,4968643,4968650,4968651,4968655,4968656,4968657,4968658,4968659,4968660,4968670,4968671,4968676,4968681,4968682,4968683,4968684,4968685,4968686,4968687,4968688,4968689,4968690,4968691,4968723,4968750,4968772,4968776,4968779,4968780,4968781,4968782,4968783,4968786,4968791,4968792,4968793,4968794,4968795,4968796,4968797,4968798,4968799,4968800,4968802,4968808,4968815,4968821,4968823,4968824,4968825,4968826,4968836,4968839,4968840,4968841,4968842,4968849,4968850,4968868,4968870,4968871,4968872,4968873,4968874,4968876,4968887,4968888,4968889,4968890,4968891,4968892,4968893,4968894,4968895,4968896,4968897,4968898,4968899,4968900,4968901,4968902,4968903,4968904,4968905,4968906,4968907,4968908,4968909,4968910,4968911,4968912,4968913,4968914,4968915,4968916,4968917,4968918,4968919,4968920,4968921,4968922,4968923,4968924,4968925,4968926,4968927,4968928,4968929,4968930,4968931,4968932,4968933,4968934,4968935,4968936,4968937,4968938,4968939,4968940,4968941,4968942,4968943,4968944,4968945,4968946,4968947,4968950,4968963,4968970,4968971,4968972,4968973,4968974,4968975,4968976,4968977,4968989,4968990,4968991,4968992,4968993,4968994,4968995,4968996,4968997,4968998,4968999,4969000,4969001,4969002,4969003,4969004,4969005,4969006,4969013,4969014,4969015,4969028,4969029,4969046,4969057,4969060,4969075,4969076,4969077,4969078,4969079,4969080,4969081,4969082,4969083,4969084,4969085,4969086,4969087,4969088,4969089,4969090,4969091,4969092,4969093,4969094,4969095,4969096,4969097,4969098,4969099,4969100,4969101,4969114,4969125,4969130,4969131,4969140,4969152,4969153,4969154,4969155,4969156,4969157,4969158,4969159,4969160,4969161,4969175,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969184,4969185,4969186,4969187,4969188,4969189,4969207,4969208,4969209,4969211,4969216,4969218,4969219,4969220,4969221,4969222,4969223,4969224,4969225,4969237,4969238,4969240,4969251,4969285,4969286,4969287,4969288,4969289,4969290,4969291,4969292,4969293,4969313,4969317,4969331,4969349,4969350,4969351,4969364,4969434,4969435,4969436,4969437,4969438,4969439,4969440,4969441,4969442,4969443,4969444,4969445,4969446,4969447,4969448,4969513,4969514,4969515,4969516,4969525,4969526,4969527,4969528,4969529,4969530,4969531,4969533,4969541,4969550,4969551,4969552,4969553,4969570,4969607,4969613,4969614,4969624,4969979,4969980,4969981,4969982,4969983,4969984,4969985,4969986,4969987,4969988,4969989,4969990,4969991,4969992,4969993,4969994,4969995,4969996,4969997,4969998,4969999,4970000,4970001,4970002,4970050,4970051,4970066,4970067,4970068,4970069,4970070,4970071,4970072,4970103,4970120,4970121,4970122,4970123,4970124,4970125,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074706,8074707,8074708,8074709,8074710,8074711,8074712,8074713,8074714,8074715,8074716,8074717,8074718,8074719,8074720,8074721,8074722,8074723,8074724,8074725,8074726,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074748,8074749,8074750,8074751,8074752,8074753,8074754,8074755,8074756,8074757,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8074767,8074768,8074769,8074770,8074771,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074792,8074793,8074794,8074795,8074796,8074797,8074798,8074799,8074800,8074801,8074802,8074803,8074804,8074805,8074806,8074807,8074808,8074809,8074810,8074811,8074812,8074813,8074814,8074815,8074816,8074817,8074818,8074819,8074820,8074821,8074822,8074823,8074824,8074825,8074826,8074827,8074828,8074829,8074830,8074831,8074832,8074833,8074834,8074835,8074836,8074837,8074838,8074839,8074840,8074841,8074842,8074843,8074844,8074845,8074846,8074847,8074848,8074849,8074850,8074851,8074852,8074853,8074854,8074855,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074877,8074878,8074879,8074880,8074881,8074882,8074883,8074884,8074885,8074886,8074887,8074888,8074889,8074890,8074891,8074892,8074893,8074894,8074895,8074896,8074897,8074898,8074899,8074900,8074901,8074902,8074903,8074904,8074905,8074906,8074907,8074908,8074909,8074910,8074911,8074912,8074913,8074914,8074915,8074916,8074917,8074918,8074919,8074920,8074921,8074922,8074923,8074924,8074925,8074926,8074927,8074928,8074929,8074930,8074931,8074932,8074933,8074934,8074935,8074936,8074937,8074938,8074939,8074940,8074941,8074942,8074943,8074944,8074945,8074946,8074947,8074948,8074949,8074950,8074951,8074952,8074953,8074954,8074955,8074956,8074957,8074958,8074959,8074960,8074961,8074962,8074963,8074964,8074965,8074966,8074967,8074968,8074969,8074970,8074971,8074972,8074973,8074974,8074975,8074976,8074977,8074978,8074979,8074980,8074981,8074982,8074983,8074984,8074985,8074986,8074987,8074988,8074989,8074990,8074991,8074992,8074993,8074994,8074995,8074996,8074997,8074998,8074999,8075000,8075001,8075002,8075003,8075004,8075005,8075006,8075007,8075008,8075009,8075010,8075011,8075012,8075013,8075014,8075015,8075016,8075017,8075018,8075019,8075020,8075021,8075022,8075023,8075024,8075025,8075026,8075027,8075028,8075029,8075030,8075031,8075032,8075033,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075058,8075059,8075060,8075061,8075062,8075063,8075064,8075065,8075066,8075067,8075068,8075069) 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'