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(10930140,10845632,10845633,10870223,10870493,3229073,3229074,3229075,8631620,7074308,10950982,8622485,10990355,10990356,10871966,10871967,10871968,10871969,10871970,10871971,10871972,7066713,7066750,7066751,10964472,10844688,10872229,7066952,10844710,10844711,10872326,10844945,10844961,9214339,8620534,8620535,8561673,6000128,11011576,11011577,11011578,11011579,11011580,11011581,11011582,11011583,11011584,11011585,11011586,11011587,11011588,11011589,11011590,8617927,8617989,8559175,8559176,3238795,10103591,8618359,8618360,8618361,8618362,8618363,8618364,8618365,10103767,10103852,10867331,8618992,5654562,7073436,7073445,7073718,3227185,3227191,10942532,10942663,10958959,8861182,8861183,10958981,3927722,7200614,7071382,7071394,10842198,10972151,10972152,10972153,5999940,5999948,5999950,5999952,5999955,5999956,5999957,5999958,8558632,5999973,8558654,8558655,8558656,8558657,8558658,8558659,8558660,8558661,8558662,8558663,8558664,8558665,8558666,8558667,8558668,8558669,8558670,8558671,8558672,8558673,8970230,11011437,10866063,10866064,10866065,3235234,3235235,3235236,3235237,3235238,3235239,3235240,3235241,3235242,3235243,3235244,3235245,3235246,3235247,3235248,10839631,10839632,3655781,3655782,3925507,10100255,3235598,3235599,3235600,3235601,3235602,3235603,7069369,10996201,10996202,11009238,11009239,11009240,11009241,11009242,11009243,11009244,7199404,3926597,3926603,3926604,3926605,8073079,8073080,8073081,3926653,10941975,3926654,3926655,3926656,3926660,3926661,7156444,10967771,10967963,3923839,8907055,11007686,11007687,11007688,11007730,11007731,11007732,11007733,10968763,11008220,11008221,10982441,8614598,3235233,8611864,8611865,8611866,8611867,8611868,8611869,8611870,8611871,10427409,3232850,3232851,3232852,11045495,11045496,10615185,10615201,10615203,10615204,3230584,3230585,10952098,10952221,3582178,8904788,10616955,8863828,8863829,8567844,8567845,9189553,9197683,9197684,9197685,9197686,9197687,9197688,9197689,9197690,9197691,9197692,9197693,9197694,9197695,9197696,9197697,9197698,9197699,9197700,9197701,9197702,9197703,9197704,9197705,9197706,9205754,9197757,8864325,8864498,8864499,8864500,8864501,8864502,8864507,8864508,8864567,8864568,9174254,9174255,8542642,8542644,10612207,10612208,10612209,9211680,6676009,9171962,9171963,9171964,9212091,7058540,9188396,7058787,9196819,10121037,10121041,10121043,10121044,9196974,10561805,10561806,10561807,10561808,10561809,10561810,10561811,10561812,10561813,10561814,10561815,10561816,10561817,10561818,10561819,10561820,10561821,10561822,10561823,10561824,10561825,10561826,10561827,10561828,10561829,10561830,10561831,10561832,10561833,10561834,10561835,10561836,10561837,10561838,10561839,10561840,10561841,10561842,10561843,10561844,10561845,10561846,10561847,10561848,10561849,10561850,10561851,10561852,10561853,10561854,10561855,10561856,10561857,10561858,10561859,10561860,10561861,10561862,10561863,10561864,10561865,10561866,10561867,10561868,10561869,10561870,10561871,10561872,10561873,10561874,10561875,10561876,10561877,10561878,10561879,10561880,10561881,10561882,10561883,10561884,10561885,10561886,10561887,10561888,10561889,10561890,10561891,10561892,10561893,10561894,10561895,10561896,10561897,10561898,10561899,10561900,10561901,10561902,10561903,10561904,10561905,10561906,10561907,10561908,10561909,10561910,10561911,10561912,10561913,10561914,10561915,10561916,10561917,10561918,10561919,10561920,10561921,10561922,10561923,10561924,10561925,10561926,10561927,10561928,10561929,10561930,10561931,10561932,10561933,10561934,10561935,10561936,10561937,10561938,10561939,10561940,10561941,10561942,10561943,10561944,10561945,10561946,10561947,10561948,10561949,10561950,10561951,10561952,10561953,10561954,10561955,10561956,10561957,10561958,10561959,10561960,10561961,10561962,10561963,10561964,10561965,10561966,10561967,10561968,10561969,10561970,10561971,10561972,10561973,10561974,10561975,10561976,10561977,10561978,10561979,10561980,10561981,10561982,10561983,10561984,10561985,10561986,10561987,10561988,10561989,10561990,10561991,10561992,10561993,10561994,10561995,10561996,10561997,10561998,10561999,10562000,10562001,10562002,10562003,10562004,10562005,10562006,10562007,10562008,10562009,10562010,10562011,10562012,10562013,10562014,10562015,10562016,10562017,10562018,10562019,10562020,10562021,10562022,10562023,10562024,10562025,9161363,10513448,10513449,10513450,10513451,10117892,9161751,9194443,10118988,10118989,10419555,10428303,10428304,10428305,10428306,10428307,10428308,10428309,4973896,10420138,10419207,10419208,10419209,6666530,6666531,6666533,8854916,8916884,9167307,9167308,9167309,9167310,10123642,10123643,10123644,10123645,10123646,10123647,8917501,9176080,10628515,10628516,10628517,10628518,10175041,10628519,10175042,10628520,10175043,10628521,10628522,10628523,10628524,10628525,10628526,10628527,10628528,10175143,10175144,10175145,10175147,10894297,10894298,10628964,10628965,10884483,10171207,10171208,10176628,10176629,10905637,10905638,10900696,10900697,10910848,10910849,10910850,10910851,10910852,10910853,10910885,10910892,10910893,10891200,10891201,10891202,10891203,10891204,10891233,10172279,10881537,10881538,10876650,10912008,10912084,10912085,10912128,10912129,10912130,10912131,10950056,10583515,10652674,10608540,10647876,10591131,10604146,10567664,10604663,10527880,10531896,10531897,10531898,10531899,10531900,10531901,10531902,10531903,10531904,10531905,10531906,10527979,10527980,10527981,10527982,10527983,10527984,10527985,10527986,10527987,10527988,10527989,10527990,10527991,10527992,10527993,10527994,10527995,10527996,10527997,10527998,10527999,10528000,10528001,10528002,10528003,10528004,10528005,10528006,10528007,10528008,10528009,10528010,10528011,10528012,10528013,10528014,10528015,10528016,10528017,10528018,10528019,10532052,10532053,10528054,10528055,10528056,10528062,10540883,10539096,10539097,10539098,10539099,10510142,10510143,10510144,10423406,10510349,10423472,10498377,10510412,10510413,10509497,10509498,10509499,10509500,10509501,10509502,10509518,10509519,10509520,10509521,10509522,10509526,10509539,10507597,10509604,10509605,10509608,10509644,10509653,10509799,10509800,10509841,10509842,10509843,10509866,10509867,10509868,10509873,10509899,10422189,10484040,10484048,8562942,8562983,10482559) 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'