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(8630766,8630767,8630768,8630769,8630770,8630771,8630779,8630780,8630787,8630788,8630789,8630790,10870457,8630913,8630914,8630937,8630998,8631119,8631120,8631121,8631123,8631124,8631185,8631186,8631187,8631194,8631195,8631196,8631197,8631198,8631199,8631200,8631201,8631202,8631203,8631204,8631211,8631212,8631213,8631214,8631215,8631216,8631217,8631218,8631219,8631220,8631221,8631222,8631223,8631224,8631225,8631226,8631227,8631228,8631229,8631230,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631238,8631239,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,8631248,3229207,8631485,8631486,8631488,8631489,8631494,8631495,8631500,8631501,8631504,8631505,8631566,8631659,8631660,8631661,8631662,7066180,8631862,9216085,9216086,9216087,9216089,9216090,8632188,8632189,7066646,8632391,8632404,7066766,8632411,7066767,8632415,8632416,8632419,8632421,8632422,8632423,8632463,8632464,8632465,8632466,8632467,8632468,8632469,8632470,8632471,8632472,8632473,8632474,8632475,8632476,8632477,8632478,8632479,8632480,8632481,7066836,8632482,8632483,8632484,8632485,8632486,8632487,8632488,8632489,8632521,8632526,8632531,8632533,8632534,8632535,8632536,8632537,8632538,8632575,8629581,8629582,8629583,8629584,7075043,8629716,8629717,8629742,8629811,8629812,8629836,8629900,8629901,8629916,8629917,11001090,11001091,10962235,8630224,8630225,8630226,8630227,8630228,8630229,8630240,8630247,8630248,8630265,8630269,8630282,8630301,8630429,8630444,8630447,8630448,8630450,8630454,8630455,9214464,8627803,8627804,8627805,8627806,8627807,8627826,8627833,7201460,7201462,7201463,7201470,7201476,7201496,7201624,7201641,8628126,8628127,7201741,7201742,7201761,7201762,8628335,10960475,8628490,8628491,8628492,8628493,7202118,7202129,7202137,7202162,7202163,8628576,8628598,7202201,7202202,7202203,7202312,7202316,7202317,7202320,7202321,7202322,7202323,7202327,7202328,7202348,10843867,7202364,7202365,8628804,8628805,8628812,8628813,8628814,8628815,8628816,8628817,8628821,8628825,8628830,8628834,8628842,8628847,8628848,8628853,8628854,8628859,8628860,8628863,8628864,8628869,8628870,8628875,8628878,8628881,8628884,8628887,8628889,8628891,8628893,8628897,8628900,8628903,8628906,8628909,8628912,8628915,8628918,8628921,8628924,8628927,8628930,8628933,8628936,8628939,8628941,8628944,8628947,8628951,8628952,8628958,8628959,8628964,8628965,8628970,8628971,8628976,8628977,7202577,7202578,7202579,7202580,8628982,8628983,8628988,8628989,7065421,7065422,10844228,10104608,10104610,8629223,8629224,8629225,8629226,8629245,8629250,8629251,8629252,8629253,8629254,8629255,8629256,8629257,8629258,8629259,8629260,8629333,8629354,8629483,8629484,8629485,8629578,8629579,8629580,11036621,11036622,7200460,3927619,8626968,8626969,7200632,8627051,8627053,7071413,8627076,8627079,8627081,8627111,8627113,8627114,8627116,8627373,11011438,11011439,7201001,8627402,8627403,8627404,8627409,8627410,8627411,8627414,8627415,8627420,8627422,8624600,8624602,10995679,10839824,3925510,8625062,8625063,8625064,8625065,8625066,8625067,8625068,8625069,8625070,8625071,8625086,8625087,8625088,8625155,11009285,8625252,8625253,8625254,8625257,8625258,8625276,8625280,8625305,8625351,8615572,10840556,3236231,8625526,3236301,3236302,3236304,3926313,3926314,8625627,8625695,8625737,8625761,8625762,8625771,8625773,8625774,8625775,8625776,8625780,8625783,8625784,8625786,8625787,8625788,8625789,8625790,7199414,8625866,8625868,8625876,8625877,8625878,8625889,8625893,8625897,8625967,8625999,8626071,8626072,8626073,8626074,8626075,8626076,8626093,8626094,8626095,8626096,8626097,8626098,8626099,8626104,8626113,8626114,8626121,8626122,8626123,8626124,8626193,8626198,8626228,10101713,10101714,8626250,8626365,8626528,8626529,8626531,8626532,8626534,8626548,8626549,8626550,8626551,8626552,8626553,8626554,8626555,8626556,8626557,8626558,8626559,8626560,8626561,8626562,8626563,8626564,8626565,7196276,7196278,7196280,7196282,7196283,7196316,7196317,7196512,7196520,7196527,7196537,3234573,8555316,7197730,7197732,7197733,7197734,7197735,7197738,7197740,7197743,7197744,8624254,8624255,8624258,8624377,10619863,8624496,8624497,8624502,8624503,8624504,8624505,8624507,8624508,8624509,8624512,8624524,8624525,8624526,8624527,8614761,8541604,8541605,8634874,8634875,8634876,8634877,8634878,8634879,8634880,8634881,8634882,8634883,8634884,8541936,8541939,8542018,8542019,8542020,8542021,8578989,8542377,7196129,8632590,8632591,8632592,8632593,8632594,8632595,8632597,8632598,8632599,8632600,8632601,8632633,8632635,8632703,8632704,8632706,8632730,8632731,8632732,8632733,10925638,8632775,8632781,8570168,8632845,8632911,8632912,8632913,8632914,8632915,8632916,8632917,8632918,8632919,8632920,8632921,8632922,8632923,8632924,8632925,8632926,8632927,8632928,8632929,8632930,8632931,8632932,8632933,8632934,8632935,8632936,8632937,8632938,8632939,8632940,8632941,8632942,8632943,8632944,8632945,8632946,8632947,8632948,8632949,8632950,8632951,8632952,8632953,8632954,8632955,8632956,8632957,8632958,8632959,8632960,8632961,8632962,8632963,8632964,8632965,8632966,8632967,8632968,8632969,8632970,8632971,8632972,8632973,8632974,8632975,8632976,8632977,8632978,8632979,8632980,8632981,8632982,8632983,8632984,8632985,8632986,8632987,8632988,8632989,8632990,8632991,8632992,8632993,8632994,8632995,8632996,8632997,8632998,8632999,8633000,8633001,8633002,8633003,8633004,8633005,8633006,8633007,8633008,8633009,8633010,8633011,8633012,8633013,8633014,8633015,8633016,8633017,8633018,8633019,8633020,8633021,8633022,8633023,8633024,8633025,8633055,8633056,8633057,8633058,8633059,8633060,8633061,8633062,8633063,8633064,8633065,8633066,8633067,8633068,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,10615477,8633137,8633160,10615552,8633184,10991312,8633297,8633298,8633299,8633414,8633415,8633416,8633417,9217428,9217429,9217430,9217431,8633607,8633608,8633609,8633610,8633611,9217800,8540756,8633958,8633959,8633963,8634160,8634166,8634170,8634279,8634280,8634281,8634282,8634283,8634284,8634285,8634286,8634287,8634289,8634312,8634316,8634317,8634318,8634319,8634335,8634336,8634337,8634341,8634342,8634343,8634344,8634345,8634346,8634347,8634348,8634349,8634350,8634351,8634352,8634353,8634359,8634360,8634361,8634362,8634422,8634423,8634424,8634426,8634479,8634481,8634483,8634485,8634486,8634491,8634493,8634494,8634495,8634498,8634499,8634505,8634506,8634507,8634511,8634512,8634513,8634515,8634516,8634520,8634521,8634526,8634527,8634530,8634531,8634534,8634535,8634537,8634538,8634540,8634571,8634572,8634580,8853827,8853828,8853829,6670232,6670233,7057913,7058146,7058149,10609714,6676463,10558317,10558318,10558319,10558320,8852348,8852349,8852350,8852351,8852352,8852363,8852364,8852365,8852366,8852367,8852368,8852369,8852370,8852371,6677017,10121045,10613547,6677405,6677406,8849917,8850174,8850175,6674568,8850426,8850427,10124629,10124635,10124647,10124662,10124671,7054861,6680970,6681031,9182422,6666662,6666844,6666845,9207304,6668137,6668138,6668139,6668147,10185626,10185628,10185935,10185969,10185971,10185978,10185980,10186010,10186021,10186028,10186029,10186043,10186045,10186054,10186078,10186095,10186104,10186106,10186107,10186115,10186116,10186118,10186119,10186123,10627775,10627803,10627816,10627817,10627818,10627819,10627820,10627851,10627852,10627853,10627854,10627855,10630117,10630118,10630238,10630239,10626292,10626293,10631794,10631795,10580113,10583131,10583145,10583146,10583147,10607002,10604031,10582608,10582609,10582610,10582611,10582612,10582613,10582615,10582630,10582631,10582632,10582633,10582634,10583031,10583044,10583045,10540084,10542098,10542099,10550444,10424875,10508819,10508820,10508821,10508825,10422167) 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'