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(8630664,8630665,8630693,8630699,8630706,8630711,8630717,8630721,8630725,8630730,8630745,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630798,8630799,8630859,8630955,8574490,8631031,8631037,8631059,8631073,8631074,8631075,8631139,8631175,8631178,8631182,8631194,8631195,10989240,10989241,8631240,8631241,8631242,8631243,8631382,8631383,8631529,8631560,8631561,8631562,8631563,8631564,8631565,8631568,8631569,8631570,8631571,8631572,8631573,8631574,8631575,8631576,8631578,8631579,8631580,8631582,7065998,8583479,8631655,8583490,8631721,8631727,8631728,8631729,8631750,8631753,8631756,8631758,8631850,8631851,8631852,8631853,8631855,8583746,8575744,8632226,8632251,8632252,8632294,8632295,8632296,8632297,8632462,8629585,7075018,8629665,8629667,8629689,8629695,8629702,8629705,8629707,8629723,8629724,8629772,8629773,8629784,8629790,8629906,8629961,8629964,8629971,8629976,8629979,8629980,8629983,8629984,8629985,8630000,8630004,8630005,8630010,8630011,8630015,8630016,8630020,8630025,8630026,8630037,8630038,8630039,8630040,8630041,8630042,8630044,8630045,8630046,8630047,8630048,8630066,8630068,8630069,8630071,8630074,8630075,8630076,8630077,8630078,8630079,8630080,8630081,8630098,8630099,8630100,8630101,8630102,8630114,8630115,8630119,8630120,8630124,8630125,8630132,8630134,8630138,8630147,8630152,8630164,8630165,8630191,8630239,8630240,8630309,8630310,8630398,8630399,8630442,7201187,8627719,8627720,8627745,8627763,8627786,8627788,8627837,8627842,8627853,8627858,8627865,8627866,8627886,8627889,8627890,8627893,8627894,8627895,8627896,8627897,8627898,8627899,8627900,8627901,8627905,8627912,8627913,8627914,8627915,8627916,8627918,8627921,8627925,8627926,8627927,8627928,8627929,7072286,8627932,8627939,8627941,8627959,8627965,8627972,8627977,8627982,8627997,8627998,8628005,8628006,8628007,8628021,8628022,8628023,8628032,8628120,8628121,8628123,8628148,8628155,8628156,8628157,8628158,8628166,8628194,7201961,8628365,8628366,7201984,7201989,7202009,7202011,8628420,8628421,8628461,7202088,7202089,8628500,8628539,8628540,8628541,8628562,8628563,8628564,8628576,8628623,8628744,8628867,8628868,8628869,8628870,8628871,8628872,8628893,8628894,8628895,8629093,8629095,8629096,8629098,8629099,8629105,8629106,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629228,8629282,8629283,8629284,8629407,8629420,8629421,8629544,8629545,8629554,8626595,8626696,8626709,8626710,8626711,8626712,8626713,8626751,8626752,8626756,8626868,8626869,8626870,8626871,8626872,8626873,8626874,8626875,8626876,8626877,8626878,8626879,8626880,8626881,8626882,8626883,8626920,8626921,8626922,8626963,8627005,10959115,10959116,7200725,7200730,7200733,7200738,7200740,7200744,7200748,8627221,8627244,8627261,8627264,8627276,8627277,8627304,8627308,8627327,8627344,8627354,8627358,8627359,8627377,8627378,8627379,8627380,8627381,8627382,8624582,7198201,7198202,7198203,7198204,7198205,8624641,8624684,8624693,8624694,8624708,8624709,8624714,8624718,8624719,8624724,7198706,7198707,7198709,8625171,8625177,8625178,8625220,8625228,8625282,8625283,8625284,8625285,8625286,8625287,8625288,8625289,8625290,8625291,8625292,8625293,8625294,8625295,8625296,8625297,8625298,8625299,8625300,8625301,8625302,8625303,8625304,8625305,8625306,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,8625318,8625319,8625320,8625321,8625322,8625323,8625324,8625325,8625326,8625327,8625328,8625329,8625330,8625331,8625332,8625333,8625334,8625335,8625336,8625337,8625338,8625339,8625340,8625341,8625349,8625350,8625351,8625352,8625353,8625354,8625355,8625356,8625357,8625358,8625359,8625360,8625361,8625362,8625363,8625364,8625365,8625366,8625367,8625368,8625369,8625370,8625371,8625372,8625382,8625383,8625384,8625386,8625387,8625388,8625389,8625390,8625391,8625392,8625393,8625394,8625395,8625396,8625397,8625398,8625399,8625400,8625401,8625402,8625403,8625404,8625405,8625406,8625407,8625408,8625413,8625414,8625415,8625416,8625417,8625418,8625424,8625487,8625489,8625490,8625498,7199392,8626026,8626027,7199745,8626148,8626153,8626154,8626160,8626161,8626167,8626172,8626175,8626340,8626341,8626342,8626343,8626344,8626345,8626371,8626376,8626449,8626450,8626451,8626452,8626453,3923631,8906524,8906581,7196930,7197007,7197017,7197018,8906871,8906872,10838794,10838903,7197651,7197787,7197864,8624335,8907806,8624423,8624424,8624426,8624441,10619865,8624557,8624573,8624574,8624575,8624580,8905017,8611931,8634753,8634787,8634851,8634852,8634858,8634859,8634864,8634865,8905282,8905283,8634871,8634872,8905284,8634876,8634895,8634996,8634997,8634998,8634999,8635000,8635001,8635002,8635003,8635004,8635005,8635006,8635007,8635008,8635009,10622405,8635057,8635058,8905474,8905475,8905509,10954196,10954197,8905967,3233337,8632608,10614993,8632617,8632642,8632643,10425387,10425390,10425394,8632744,8632745,8632749,8632752,10425471,8632753,8632754,8632757,8632762,8632764,10425554,10425555,8632850,10425575,11042900,10425581,11042901,11042902,11042903,10425589,10425590,8632894,8632895,8632896,8632897,8632898,8632899,8632902,8632959,8632960,8632961,8632962,8632963,8632964,8632965,8632966,8632967,8632968,8632969,8632970,8632971,8632972,10615389,8633036,8633037,8633038,8633039,8633077,8633078,8633079,8633080,8633099,10615482,10620487,8633186,8633190,8633191,8633195,8633199,8633210,8633224,8633237,8633250,3231053,8633292,10615703,8633331,3231150,8633391,8633400,8633409,10426151,10615822,8633510,8633514,8633517,8633519,8633530,8633534,8633537,10616044,10616045,10616048,8633668,10616049,8633669,8633670,8633671,8633672,8633673,8633674,8633675,10616060,8633799,8633800,10616291,10616292,10616296,10616888,10714024,10714139,10614421,10611465,10559766,10611894,10611960,10609085,10612093,10609093,10609095,10612189,10609285,10609287,10609411,10609420,10609446,10609447,10612458,10612606,10612607,10609621,10609669,10612675,10609676,8862556,8862557,10609835,10612892,10612893,10612894,9220284,10610054,10613157,10613166,10613187,10613192,10610233,10610271,10613318,10610677,10613741,9169438,6673650,10117654,9169465,6673683,6673712,6673713,6673714,6673715,6673716,6673717,6673770,9169588,9169595,9169612,9169632,7015524,7015525,10126077,7015538,7015539,6674185,10118226,6674245,10118277,10118289,10118293,10118298,10118497,10118665,10118666,10415224,10418232,10418233,10418234,10416261,10416275,6672584,10418389,10418390,10418391,10418392,10419427,10419429,10419431,10419434,10419435,10419438,10419439,6672746,6672747,10419465,6672767,10416487,6672804,10418552,10419564,10419565,9168699,10415705,10415711,10415718,10416757,10416758,10419807,10415822,9168926,10415877,10415886,6673173,10416951,10418022,10417031,10418035,10418036,10417044,10417049,10417062,10417063,10417064,10417065,10417066,10418118,10418119,6673474,10117475,8549580,9166510,3963322,10469933,10463995,10463996,10470161,10470174,10470345,10470346,10470347,10470348,10470349,10470350,10470351,10470352,10470353,10470354,10470355,10468386,9167816,9167817,10470420,10470421,9167852,10116207,10116208,10116209,10116210,10116211,10116213,10116214,10116215,10116216,10116217,10116218,10116219,10116220,10116221,10116222,10116223,10470647,10470648,10468682,10468683,10883570,10883571,10883629,10888755,10888756,10888759,10888773,10888891,10888930,10888933,10889012,10889161,10889163,10889179,10889180,10889217,10889229,10884379,10899507,10899515,10884689,10889706,10889798,10889938,10890046,10890047,10890048,10890091,10890098,10890117,10890118,10885219,10885220,10885221,10885222,10885223,10885224,10890230,10890231,10890237,10890240,10890241,10890244,10890245,10631994,10632011,10887660,10887758,10882892,10883033,10888264,10888265,10888266,10888269,10888270,10888271,10885580,10161998,10886020,10162152,10626143,10626144,10167977,10167992,10882077,10897123,10897128,10887129,10887192,10887193,10887194,10887195,10882406,10882407,10882412,10882413,10887459,10580666,10521186,10547998,10505548,10505549,10505550,10507622,10507708,10507709,10507710,10507716,10507717,10507786,10507905,10507906,10507938,10508009,10508010,10508011,10508012,10508025,10508034,10508043,10508044,10409434,10409435,10409762,10409981,10408048,10408049,10408677,10482594,10482595,10406941,10406942,10411063,10407143,10407144,10407145,10411154,10411216) 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'