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(8630627,8630628,8630629,8630630,8630631,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,8630720,8630743,8630746,10861432,10861434,10861437,10861438,8630854,3229130,3229131,3229171,3229285,8631598,8631716,10862682,10862683,10862684,10862911,8632515,8632518,8632519,8632542,8632543,8632545,8632546,8632559,8632560,8632573,8632574,8629596,10860242,10860244,10860245,10860246,10860247,10860248,10860249,10860250,8067943,8629765,10860413,10860414,10860438,10860518,8630363,8630365,8630369,8630376,10861074,8627596,7201309,7201366,7201367,8627795,8627796,8627797,8627821,7201444,7201454,10866549,10866550,10866551,10866552,10866553,10866554,10866555,10866556,10866557,10866558,10866559,7201727,8628258,8628259,8628261,7201862,8628263,7201959,7201974,7201975,10960474,7202102,7202129,7202130,7202137,7202139,7202140,7202162,7202200,7202208,8628627,8628634,7202265,7202266,8628814,10859576,7202585,5654676,5654677,9794588,8629164,8629165,8629166,8629167,8629168,8629169,7202769,8629170,8629171,8629172,8629173,8629174,8629176,8629177,8629178,8629179,8629180,8629181,8629184,8629185,8629187,8629188,8629258,10859918,10859919,10859920,10859921,10859922,10859923,10859924,10859925,10859926,10859927,10859928,10859929,10859930,10859931,10859932,10859933,10859934,10859935,10859936,10859937,10859938,10859939,10859940,10859941,10859942,10859943,10859944,10859945,10859946,10859947,10859948,10859949,10859950,10859951,10859952,10859953,10859954,10859955,10859956,10859957,10859958,10859959,10859960,10859961,10859962,10859963,10859964,10859965,10859966,10859967,10859968,10859969,10859970,10859971,10859972,10859973,10859974,10859975,10859976,10859977,10859978,10859979,10859980,10859981,10859982,10859983,10859984,10859985,10859986,10859987,10859988,10859989,10859990,10859991,8626723,8626724,8626725,8626726,7200456,7200458,10857503,10857504,7200469,10857556,10857557,10857559,10857560,10857561,10857562,10857563,10857564,7200527,7200528,7200529,7200543,7200572,7200573,7200576,7200577,7200578,7200639,7200640,7200641,7200642,7200643,10959088,8627150,8627151,8627163,8627164,8627176,8627177,8627188,8627189,8627206,8627207,8627253,8627404,8627408,8627411,8627413,8627415,8627419,8627430,8627431,8627432,8627433,8627434,8627435,8627441,8627442,8627443,8627444,10866115,8627530,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627567,8627568,8627569,8627570,8627571,8627572,8627573,8624944,8624945,8624961,8624985,8625025,8625055,8625058,8625059,7198736,7198737,7198738,7198739,7198740,7198742,7198743,7198746,7198747,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198759,7198762,7198784,7198785,8625209,10863911,10863973,10863988,8625467,8625468,8625469,8625470,8625471,8625473,8625475,8625476,8625478,8625479,8625480,8625481,8625482,10864306,7199540,7199541,7199542,7199545,7199775,11048454,10865157,10865158,10865159,10853296,10853297,3923468,3923593,3923638,10854077,8906901,7197805,7197807,8624401,8624409,8624441,8624472,3232382,8634673,8634674,8634675,8634676,8541549,10617107,10617138,10617151,10617159,10617171,8541668,10617436,10617437,10617438,10617439,10617440,10617441,10617442,10617443,10617444,10617445,10617461,3232910,8542165,8632622,8632627,8632629,10425350,8632633,8632634,8632635,8632636,10425358,8632716,8632717,8632718,10425484,10425573,10425574,10425586,10615352,10615356,10615389,10850749,8633159,10425910,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,8633215,10425934,8633216,10615598,8633217,8633218,10425939,10425942,10425944,8633276,8633277,10426008,10426009,10426010,10426017,10615709,10615721,10615722,10615726,10615727,10615728,10615780,10615820,10615822,10426197,10615896,10615939,10616002,10616005,10616044,10616045,8540631,8634043,8634045,8634047,8634049,8634050,8634051,8634052,8634053,8634055,8634056,8634057,8634058,8634059,8634061,8634062,8634063,8634064,8634065,8634067,8634069,8634070,8634071,8634072,8634073,8634074,8634075,8634076,8634077,8634078,8634079,8634080,8634081,8634082,8634083,8634084,8634085,8634086,8634087,8634088,8634089,8634090,8904796,8634401,8904857,10616874,10616875,10616888,8853380,10614220,10614376,10611444,10611676,10612268,10609845,8852017,10612916,10613079,10613089,10613093,10613096,10613097,10613098,10613099,10613106,10613108,10613109,10613112,10613117,10613192,8852376,10613235,8852480,10613513,10613514,10610901,10610935,6673506,6673538,6673542,10117679,9169638,6674152,9169954,9169955,6674280,6674285,6674309,6674310,6674330,10118678,8552227,6672521,6672592,10415373,10415374,10416481,6672802,10417633,6673067,6673122,6673124,6673125,9169233,7055445,10471173,10471174,8550018,8550155,9168102,10470721,10889019,10889020,10889021,10889756,10884764,10890157,10890158,10890159,10890160,10885316,10631994,10887546,10882916,10888437,10888457,10161705,10886057,10886058,10886059,10886060,10886062,10886063,10167934,10168029,10882061,10887072,10608607,10608654,10608712,10608715,10608790,10608793,10608798,10608800,10608804,10647649,10647650,10582561,10508407,10507721,10414016,10414314,10414315,10414316,10414317,10414318,10414319,10414320,10414321,10414322,10414323,10414324,10414325,10414326,10414327,10414328,10414329,10414330,10414331,10414332,10414333,10414334,10414335,10414336,10414337,10414338,10414339,10414340,10414341,10414342,10414343,10414344,10414345,10414346,10414347,10414348,10414349,10414350,10414351,10414352,10414353,10414354,10414355,10414356,10414357,10414358,10414359,10414360,10414361,10414362,10414363,10414364,10414365,10414366,10414367,10414368,10414369,10414370,10414371,10414372,10414373,10414374,10414375,10414376,10414377,10414378,10414379,10414380,10414381,10414382,10414383,10414384,10414385,10414386,10414387,10414392,10487111) 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'