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(8630715,8630716,8630717,8630777,8630778,8630812,8630936,8630970,10870719,8631080,8631143,8631254,8631521,8631522,8631560,8631561,8631562,8631563,8631564,8631565,8631566,8631568,8631569,8631570,8631571,8631572,8631573,8631574,8631575,8631576,8631578,8631580,8631582,10868230,8631657,8631704,8621913,8631777,8631778,8631858,10871555,10871557,10871836,10871838,10871839,10871842,8632202,8632203,10871845,10871846,10871847,10871849,8632388,8632507,8632508,8632509,8632510,8632511,8632512,8632513,8632514,8632521,8629749,8629750,8629810,8629811,8629812,8629816,8629817,8629818,8629819,8629820,8629821,8629822,8629823,8629824,10872470,10872471,8629831,8629832,8629849,8629850,8629851,8629852,8629853,8629854,8629855,8629856,8629857,8629858,8629859,8629860,8629861,8629862,8629863,8629914,8629915,8629924,8629925,8629935,8629936,8629941,8629950,8629951,8629952,8629953,8629954,8629956,8629957,8620361,8630177,8630224,8630235,8630240,8630263,8630264,8620481,10869947,10869948,8630403,8630437,8630438,8630439,8630440,8630441,8630456,7067824,9214482,8630510,7201253,7201257,7201258,7201259,7201260,7201261,7201262,7201263,7201264,7201265,7201266,7201293,7201294,7072073,10842887,7201422,10842935,8627867,8627868,8627870,8627871,8559176,8627945,8627948,8627951,7201605,7201607,7201629,7201631,8628171,8628201,8628353,8628354,8628355,8628356,8628360,8628361,8628362,8628363,8628364,8628365,8628366,8628367,8628368,8628369,8628573,8628574,10859238,8628624,8628625,8628643,10986740,10867391,8629096,10104591,10104613,9794592,10961233,10867991,8629422,8629423,8629424,8629464,8629467,10868149,10868150,10868151,10868152,10868153,10868154,10868155,10868156,10868157,10868158,10868159,10868160,10868161,10868162,10868163,10868164,10868165,10868166,10868167,10868168,8629555,8626613,8626614,8626615,8626616,8626617,8626618,8626619,8626620,8626623,8626624,8626627,8626628,8626630,8626631,8626632,8626633,8626634,8626635,8626636,8626637,8626638,8626639,8626640,8626641,8626642,8626643,8626644,8626645,8626646,8626647,8626648,8626649,8626650,8626651,8626652,8626653,8626654,8626655,8626656,8626657,8626658,8626659,8626660,8626661,8626662,8626663,8626664,8626665,8626666,8626667,8626668,8626669,8626670,8626671,8626672,8626673,8626674,8626675,8626676,8626679,8626680,8626681,8626691,8626692,8626693,8626694,8626696,8626697,8626698,8626701,8626702,8626703,8626704,8626705,8626706,8626707,8626708,8626709,8626710,8626711,8626712,8626713,8626714,8626715,8626719,8626720,8626721,8626722,8626723,8626724,8626725,8626726,8626727,8626728,8626729,8626730,8626731,8626732,8626733,8626734,8626735,8626736,8626737,8626738,8626739,8626740,8626749,8626750,8626751,8626752,8626753,8626754,8626755,8626756,8626757,8626758,8626759,8626760,8626761,8626762,8626763,8626764,8626765,8626766,8626767,8626768,8626769,8626770,8626771,7200382,8626803,8626804,8626805,8626806,8626807,8626808,8626809,8626810,8626811,8626812,8626813,8626814,8626815,8626816,8626817,8626818,8626819,8626820,8626821,8626822,8626823,8626824,8626825,8626826,8626827,8626828,8626829,3927619,8626934,8626935,8626936,8626937,8626939,8626940,8626941,8626943,8626944,8626945,8626946,8626947,8626948,8626949,8626950,8626951,8626952,8626955,8626957,8626961,8626962,8626963,8627004,8627053,8627059,8627060,8627061,8627119,7200821,7200868,8627370,8627372,8627375,8627376,8627430,8627431,8627432,8627433,8627434,8627435,8627441,8627442,8627443,8627444,8627447,8835397,8624678,8624771,8624776,8624779,10839994,8625169,8625186,8625210,8625211,8625212,8625213,8625214,10941262,7198890,8908714,8625320,8625321,8625322,8625333,8908760,8625352,8625353,8625354,8625355,8625356,8625357,8625358,8625361,8625362,8625369,8625373,8625419,8625420,8625421,8625422,8625423,3926406,8564730,8625696,8625697,8625698,8625699,8625700,8625701,8625702,8625703,8625704,8625705,8625706,8625707,8625708,8625709,8625710,8625711,8625712,8625713,8625714,8625715,8625716,8625717,8625718,8625719,8625720,8625721,8625722,8625723,8625724,8625725,8625726,8625727,8625728,8625729,8625730,8625731,8625732,8625733,8625734,8625735,8625736,8625737,8625738,8625739,8625740,8625741,8625742,8625743,8625744,8625745,8625746,8625747,8625748,8625749,8625750,8625751,8625752,8625753,8625754,8625755,8625756,8625757,8625758,8625759,8625760,8625761,8625762,8625763,8625764,8625765,8625766,8625767,8625768,8625769,8625770,8625771,8625772,8625773,10840912,8626082,8626083,8626084,8626085,8626086,7199775,8626209,8626229,8626230,8626231,8626232,8626233,8626234,8626235,8626253,3233390,8612968,10618183,10967929,10967930,10967931,10967932,10967933,10967934,10967935,10967936,10967937,10967938,10967939,10967940,10967941,3923803,3923804,3923808,10839429,8624411,8624426,8624427,8624428,8624474,8624475,8624476,8624477,8624478,8624481,8624482,8624483,8624484,8624485,8624486,8624487,8624488,10619905,10619906,8624547,10427308,8541475,8541476,8634670,8634671,8634672,8634673,8634674,8634675,8634676,8634776,8634777,10622235,8634896,8634948,8634950,8634963,8634964,8634965,8612193,11045209,11045210,8542202,8632614,8632615,8632616,8632617,8632618,8632619,8632620,8632621,8632622,8632623,8632624,8632625,8632626,8632627,8632628,8632629,8632630,8632631,8632632,10951642,8632706,8632720,8632766,8570097,8632767,8570098,8632768,8632769,8632770,8632771,8570102,8570103,8632772,8632773,8632774,8570106,8632775,8632776,8632777,8570109,8632778,8570110,8632779,8570111,8632780,8632781,8570113,8632782,8632783,8632784,8632785,8632786,8570118,8632787,8570119,8632788,8632789,8632790,8570125,8632908,8632909,8632910,10848115,10848117,8633055,8633056,8633057,10848176,8633069,8633070,8633071,8633072,8633073,8633074,8633075,8633076,8633077,8633078,8633079,8633080,8633081,8633082,8633083,8633084,8633085,8633086,8633087,8633088,8633089,8633090,8633091,8633092,8633093,8633094,8633095,8633096,8633126,8633128,8633129,8633139,8633145,8633146,8633147,8633148,8633245,10615710,8633402,8633404,8633405,8633406,8633407,8633408,8540599,8633982,8633983,8633984,8633985,8633986,8541011,8634288,8634290,8634408,8634416,8634423,8634424,8634428,8634429,8634579,10559426,8568245,8853604,10613017,8852948,8852971,8853002,8853073,8853074,8853075,10517143,10517144,10117664,10513407,8849739,6674694,6674695,6674696,6674697,6674698,6674699,9186752,10516865,9211207,9211208,4973258,4973259,4973260,4973261,4973262,4973263,4973264,4973265,4973266,4973267,4973268,4973765,4973766,4973767,10420181,6666613,6666683,6666684,6666687,9206708,8854752,8854753,9198936,9198937,9198938,8854916,9207302,9207303,6667322,10465918,10465919,10465920,10465921,6667783,9176125,9192199,9192200,10159551,10159554,10159562,10908603,10893767,10893768,10893769,10893770,10893771,10893772,10893773,10893774,7001145,10164085,10627630,10908313,10900901,10900902,10172563,10631885,10603510,10528578,10528579,10528580,10528581,10528582,10528583,10522594,10522595,10522599,10522600,10522612,10522613,10522614,10522615,10522617,10508215,10508216,10422354,10423583,10423584,10420643,10420753,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10420768,10420769,10420831,10424883,10424884,10424885,10424886,10424887,10424888,10424889,10421889,10421890,10424890,10424997,10424998,10423022,10423024,10413706,10483408,10476457,10476458,10476459,10476460,10476461,10476462,10476463,10476464) 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'