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(10962565,10962566,8574513,4970675,4970721,4970722,4970723,8569474,8583434,8583518,10950674,8583522,8583523,8583524,8583525,7066105,7066106,7066107,7066108,7066109,7066110,7066111,7066265,8575733,8575734,8575735,8067927,8067941,8067942,8067943,8573267,8573268,8573269,8573270,8837615,8573316,10962455,8065841,8065842,10960474,10960475,8910056,8834762,8834763,10959088,8910599,10944447,11009405,11009407,11009408,11009409,11009410,11009411,10101518,10101528,10101534,10101535,10101536,10958379,10618183,10618274,10618320,8906885,8906892,8906900,8906901,8907461,8907462,8907463,8907464,8907465,10619864,10619865,10619866,10619895,10619896,10617126,10617138,10617139,10617140,8905149,8905151,10617322,10617323,10617324,10617332,8905248,8905249,8905250,8905251,8905252,8905253,8905254,10617343,8905255,8905256,10617346,8905257,8905260,10617356,10617357,10617358,10617359,10617360,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617370,10617371,10617373,10617374,10617377,10617379,10617382,10617399,10617427,10617448,10617452,10617457,8905383,8905385,10993173,8905663,8905686,10954313,8905711,8905717,8905718,8905720,8905721,8905765,8905766,8905767,8905768,8905769,8905770,8905771,8905772,8905773,8905774,8905775,8905776,8905777,8905778,8905779,8905780,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620208,10615229,10620301,10615334,10615338,10615343,10615344,10615363,10615710,10615711,10615891,10615895,10615896,10616005,10616044,10616045,10616332,10616417,10616426,10616476,10616479,10616644,10616905,10613962,10613963,10613964,10613965,10613966,10613967,10613968,10613969,10613970,10613971,10613972,10613973,10613974,10613975,10613976,10613977,10613978,10613979,10613980,10613981,10613982,10613983,10613984,10610984,10610985,10613985,10613986,10610987,10613987,10610988,10613988,10610989,10613989,10613990,10613991,10613992,10613993,10613994,10613995,10613996,10613997,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,10614006,10614007,10614008,10614009,10614010,10614011,10614012,10614013,10614014,10614015,10614016,10614017,10614018,10614019,10614020,7059524,10614021,10614022,10614023,10614024,10614025,10614026,10614027,10614028,10614029,10614030,10614031,10614032,10614033,10614034,10614035,10614036,10611037,10614037,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10614047,10614048,10614049,10614050,10614051,10614052,10614053,10614054,10614055,10614056,10614057,10614064,10614376,10611378,10611423,10611441,10611443,10614495,10614497,10614498,10614499,10614501,10614502,10614503,10614504,10614505,10614552,10614553,10614554,10614593,10611603,9166136,10611856,8549450,10612060,10612106,10612107,10609155,10609285,10612294,10612381,9211941,9211942,9211943,9211944,10609706,7058247,7058248,7058249,7058250,7058251,10609845,7017858,7017859,7017874,7017875,7017888,7017889,10612916,10612936,10612937,10612938,10612939,10612940,10612941,10612942,10612943,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,10609971,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,10609988,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10610097,10613127,9172538,10610233,10613350,10613369,10613393,10613421,10610429,10613431,10613432,10610434,10610435,10610449,10610479,10610480,10610481,10613524,10613525,9204938,10613729,10613732,10613733,10613740,10613811,10613812,10613813,10613814,10613815,10613816,10613817,10613818,10613819,10613820,10613821,10613822,10613823,10613824,10613825,10613826,10613827,10613828,10613829,10613830,10613831,10613832,10613833,10613834,10613835,10613836,10613837,10613838,10613839,10613840,10613841,10613842,10613843,10613844,10613845,10613846,10613847,10613848,10613849,10613850,10613851,10613852,10613853,10613854,10613855,10613856,10613857,10613858,10613859,10613860,10613861,10613862,10613863,10613864,10613865,10613866,10613867,10613868,10613869,10613870,10613871,10613872,10613873,10613874,10613875,10613876,10613877,10613878,10613879,10613880,10613881,10613882,10613883,10613884,10613885,10613886,10613887,10613888,10613889,10613890,10613891,10613892,10613893,10613894,10613895,10613896,10613897,10613898,10613899,10613900,10613901,10613902,10613903,10613904,10613905,10613906,10613907,10613908,10613909,10613910,10613911,10613912,10613913,10613914,10613915,10613916,10613917,10613918,10613919,10613920,10613921,10613922,10613923,10613924,10613925,10613926,10613927,10613928,10613929,10613930,10613931,10613932,10613933,10613934,10613935,10613936,10613937,10613938,10613939,10613940,10613941,10613942,10613943,10613944,10613945,10613946,10613947,10613948,10613949,10613950,10613951,10613952,10613953,10610954,10613954,10613955,10613956,10613957,10613958,10613959,10613960,10613961,7055541,7055546,9169428,7055723,9169586,7015280,7015281,7015282,7015283,7015284,7015285,7015286,7015287,7015288,7015289,7015290,7015291,7015292,9169638,7015293,7015294,7015295,7015296,7015297,7015298,7015299,7015300,7015301,7015302,7015303,7015304,7015305,7015306,7015307,7015308,7015309,7015310,7015311,7055836,9169695,9169748,9169822,9169938,9169939,9169940,9169942,9169943,9168394,9168403,10416348,10416349,10416350,10416351,10416352,10416353,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10415373,10415374,9168453,10419470,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10416481,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419493,10419497,10419498,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419511,10419512,10419513,10419514,10419516,10419517,10419518,10419519,10419520,10419524,10419525,10419526,10419527,10419536,10419537,10418543,10418544,10418545,10418546,9168709,10417633,9168817,10418807,10418808,10418809,10418810,10419810,10418812,10418813,10418814,10418817,10418820,10418821,10418822,10418823,10418824,10418825,10418827,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418856,10418859,10418860,10418861,10418863,9169034,9169035,9169036,9169037,9169038,9169039,9169040,9169041,9169042,9169043,9169044,9169045,9169046,9169047,9169048,9169049,9169050,9169051,9169052,9169053,9169054,9169055,9169056,9169057,9169058,9169059,9169060,9169061,9169062,9169063,9169064,9169065,9169066,9169067,9169068,9169069,9169070,9169071,9169072,9169073,9169074,9169075,9169076,9169077,9169078,9169079,9169080,9169081,9169082,9169083,9169084,9169085,9169086,10418048,10418109,10418110,10471171,10471173,10469277,10469278,10469337,10469338,10469339,10469340,10469341,10469342,10469343,10469344,10469345,10469346,10469347,10469348,10469349,10469350,10469351,10469352,10469353,10469354,10469355,10469356,10469357,10469358,10469359,10469360,10469361,10469362,10469363,10469364,10469365,10469366,10469367,10469368,10469369,10469370,10469371,10469372,10469373,10469374,10469375,10469376,10469377,10469378,10469379,10469380,10469381,10469382,10469383,10469384,10467558,10469573,10467865,10467866,10467867,10467874,6667407,6667412,10468235,10468236,10468237,9167682,9167770,9167779,9167782,9167792,9167988,9168100,9168101,10946563,10946564,10946565,10632106,10632107,10632109,10632110,10627319,10627775,10162083,10162084,10162085,10162086,10162087,10162088,10162089,10162090,10162091,10162092,10162093,10162094,10162095,10162096,10162097,10162201,10162249,10162279,10626143,10626144,10626145,10631412,10631413,10631414,10631415,10631416,10631417,10631418,10631419,10631420,10631421,10631422,10631423,10631424,10631425,10631426,10631427,10631428,10631429,10631430,10631431,10631432,10631433,10631434,10631435,10631436,10631437,10631438,10631439,10631440,10631441,10631442,10631443,10631444,10631445,10631446,10631447,10631448,10631449,10631450,10631451,10631452,10631453,10631454,10167992,10626724,10626725,10631794,10631795,10590270,10590277,10498250,10498251,10498252,10421543,10420858,10420859,10420860,10420861,10420862,10420863,10420864,10420865,10420866,10420867,10420868,10420869,10420870,10420871,10420872,10420873,10420874,10420875,10420876,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10420884,10420885,10420886,10420887) 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'