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(11001699,11001700,11001701,7076079,11001814,10988843,7068172,7068189,7068249,7068250,7068292,7068323,7068347,7068361,10976046,7068362,10976047,10976048,10976049,10976050,10976051,10976052,10976053,10940114,4970755,10940185,10940195,10976300,10976301,10976302,7068626,7068639,4970878,7068673,7068674,10940339,4970934,4970953,7068761,10976761,7074128,7074132,7074136,7074138,10976897,10976898,10976899,8067197,7074293,7074342,7074585,8067630,8067631,8067634,10977343,10977344,10977345,10977346,7074671,8067650,7074698,7066722,7074758,7074837,7074888,7074924,11000654,7074972,10961717,11000726,11000727,10987750,10987751,10987752,10961802,10961815,11000826,8068054,8068055,8068056,8068065,11000858,10961860,10961891,10961892,10961893,8068116,11000980,8068232,8068233,11001042,11001060,10975138,10975139,10975140,10975141,10975142,10975143,10975144,10975145,10975146,10975147,10962165,11001279,8068622,7067781,10972757,10972895,7072257,10972965,10972975,10972976,7072304,7064306,7072331,7072337,10973033,10986033,10986034,7072352,7072368,7072369,10986072,10960076,10973105,10973106,7072432,10973142,10973143,10973161,10986216,7072576,7072650,7072653,7072691,7072742,10932212,10932214,7072934,7072935,7072936,7072992,7073029,7073030,7073120,8066285,8066295,8066301,8066302,8066303,8066323,8066324,8066349,8066350,8066351,11000231,11000286,11000287,8066623,10961356,10961357,10961358,10961359,10961360,10974383,10974384,10961412,10961413,7073743,8066744,8066745,8066746,8066747,8066748,8066749,11000521,10961577,11000579,7071083,10942747,10942751,10942752,7071191,7071201,10942832,7071211,10942947,10972016,10943057,10943058,10943059,11049339,7071471,10972163,10985167,10985168,10972184,10972185,10985194,10972255,10972256,10972257,10972258,7071737,7071792,7071793,8970237,10985585,10972594,10972595,10972596,10972597,10969720,10969737,10969738,10969779,10969780,10969781,10969782,10969894,10969895,10969896,10969897,10969898,10969899,10969900,10969904,10940850,10969945,10969947,7069266,7069330,10970072,10970110,7069469,7069471,7069472,7069478,10970174,10970224,10970276,10970277,10970347,10970348,10970349,10970350,10970351,10970451,10970475,3656374,10970538,10970539,10970540,3656456,10970590,10970591,10970592,10970836,10970837,10970896,10970897,10970898,10970941,10970942,10971059,10971061,10971062,10971111,10971112,10971131,7070465,10971171,10942319,10942325,10942342,10942385,8073504,10958470,10997494,10971553,10971616,10971617,10971618,10954629,10918580,10923586,10923610,10923611,10923612,10923634,10923637,10618139,10923698,10923699,10923700,10923701,10923702,10923703,10923704,10923705,10923706,10923707,10623299,10923811,10923812,10923813,10623303,10923814,10923815,10923816,10923818,10923860,10923861,10923862,10923863,10923929,10923930,10923931,10923932,10923933,10923934,10923935,10923936,10923937,10923938,10924021,10924022,10924023,10924024,10924026,10924027,10924102,10924103,10924104,10924105,10924106,10919128,10919129,10919146,10924214,10924215,10924216,10924243,10924244,10924245,10924246,10924263,10924271,10924272,10924273,10924301,10924324,10919426,10919428,10919429,10968622,10968623,10968701,10968882,10968883,10968884,10968885,10968886,10924750,10924751,10924752,10924753,10924754,10924755,10924756,10924757,10924758,10924759,10924760,10924761,10924762,10924763,10924764,10924765,10924766,10924767,10924768,10924769,10919775,10919777,10919778,10919779,10924837,10924838,10924839,10924840,10924841,10924842,10924843,10924844,10924845,10924846,10924847,10924848,10924849,10924850,10919895,10919896,10919897,10924956,10924957,10924958,10924960,10924961,10924962,10924963,10924964,10924967,10924968,10995157,10925078,10925079,10925080,10925081,10925082,10925085,10925086,10925087,10925088,10925089,10925091,10925147,10925168,10925169,10925201,10925202,10925203,10925351,10925353,10925354,10925355,10925356,10925357,10925358,10925359,10925360,10925361,10925362,10925364,10925426,10925427,10925428,10925429,10925430,10969579,10925431,10969581,10969582,10969583,10969584,10969585,10969586,10969587,10969588,10969589,10969590,10922635,10922664,10922665,10922666,10922667,10922696,10922749,10922750,10922751,10922752,10979956,10979957,10979958,10922810,10979959,10922811,10979960,10922849,10922850,10922851,10922852,10922853,10922854,10922855,10922856,10922857,10922858,10922881,10922882,10922883,10922884,10922887,10922982,10622473,10923076,10923077,10923107,10923121,10923122,10923137,10923138,10923139,10923140,10923141,10923142,10923143,10923172,10923173,10923194,10923195,10923206,10928231,10918244,10918245,10918247,10923267,10923385,10622890,10918445,10925517,10920608,10920609,10920612,10920613,10920614,10920615,10920616,10920647,10920648,10920669,8570139,8570140,10615200,10920724,10920833,10920834,10920837,10920838,10920839,10920840,10920841,10920842,8570291,10925872,10620368,8570350,8570353,8570358,10620412,10620413,10620421,10920935,10920938,10920939,10920940,10920941,10920942,10920943,10920944,10921026,10921027,10921028,10926053,10921165,10921166,10921167,10921169,10921170,10921171,10921223,10921224,10921225,10921226,10921230,10921231,10921370,10921372,10921373,10921374,10921451,10921518,10930959,10921555,10978797,10978798,10978799,10978800,10978802,10921663,10921664,10921717,10921841,10921845,10978994,10921846,10978995,10921847,10921848,10921849,10921850,10921952,10921953,10616461,10992305,10621735,10953461,10616832,10917358,7059465,7059466,10610994,7059520,10559275,9165725,10611655,10611656,10611657,10611658,10611659,10611660,10611661,10562984,10562985,10562986,10611969,9171362,9171368,10557241,10557242,10557248,10557249,10557250,10557251,10557252,10557253,10557254,10557255,10557256,10557257,10557258,10557259,10557260,10557266,10557267,10557268,10557269,7057624,10557274,7057648,7058191,7058192,7058201,10563917,10563918,10563919,10563921,10609946,10564110,10564111,10564112,10564113,10564114,10564115,10564116,10564117,10610018,10610041,7058712,10564386,10564387,10564388,10564392,10564393,10564394,10564395,10564396,10564397,10564423,10564424,10564425,8863154,7058820,8863177,7058852,7058865,8863368,8863369,8863398,7059068,7059075,7059078,7059080,7059187,7059322,7059331,7059332,7059361,10610880,7059413,7059455,7059457,10555161,10555162,10555189,10555190,10555191,10555194,10555198,10555201,10555206,7055788,10513477,10513478,10513479,10513526,10513527,10513545,10513546,10555717,10555718,10555719,10555728,10555729,10555730,10555731,10555732,10555733,10555734,10555735,10555736,4974781,4974845,4974846,4974913,4974914,4974915,7056255,7056288,10556192,10556193,10556194,10556195,10556196,10556197,10556198,10556199,10556203,10556209,10556210,10556212,7056688,10556402,10556403,10556404,10556482,10556619,10512800,10512801,10512804,10512805,10512806,10512807,10516976,9171281,9171294,9160348,10417157,8864827,10467105,10467106,10467107,10467108,10467109,10467110,10467111,10467112,10467113,10467114,10467116,10467117,10467118,10467119,10467122,10467124,10467125,10467126,10467127,10467128,10467131,10467132,10467133,10467134,10467135,10467136,10467137,10467139,10467142,10467143,10467144,10467145,10471189,4971466,10471206,10471241,4971518,4971599,4971632,6666930,6666931,10469551,10469586,10469598,10469599,10469608,4972084,4972085,4972086,4972087,4972088,10470038,10470039,8563385,10468118,10468187,10470225,10470258,10470259,10470296,10470298,8917793,10628033,10164732,10164733,10164734,10164735,10164736,10164888,10164980,10164981,10165123,10165124,10165125,10165126,10165127,10165315,10165316,10165317,10165318,10165319,10165398,10165399,10165636,10165639,10165640,10165641,10165642,10165813,10165814,10165815,10629487,10629554,10629555,10629556,10629600,10629645,10629646,10629957,10629958,10629959,10629960,10629961,10626977,10626992,10626994,10627000,10627696,10627697,10627698,10627700,10627702,10627703,10629962,10629989,10629990,10629991,10630237,10630433,10630434,10630435,10630436,10630437,10630438,10630439,10630440,10630441,10630442,10630443,10630444,10630446,10630452,10630453,10630454,10630459,10630481,10630482,10630488,10630583,10630584,10630585,10630586,10630587,10630588,10630589,10630590,10630591,10630643,10630644,10630802,10630804,10630805,10630865,10630866,10630871,10630872,10630873,10630874,10630875,10630876,10630877,10630882,10630939,10630940,10630975,10631015,10631016,10631017,10631035,10631036,10631221,10571602,10574834,10574835,10568837,10568838,10568839,10568840,10568841,10568842,10568843,10568844,10568845,10568846,10568847,10568848,10568849,10568850,10568851,10568852,10568917,10572136,10569256,10569257,10569258,10569259,10569260,10569261,10569262,10569263,10572349,10572350,10570029,10570965,10570966,10523126,10523233,10523234,10523265,10523266,10523447,10523448,10523449,10523450,10523451,10523452,10523459,10523460,10524320,10524321,10524343,10524344,10520408,10520409,10520410,10520413,10520414,10520417,10520418,10520420,10524477) 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'