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(10939590,10939721,8838592,8838593,10939729,7068180,11040881,10962885,11040908,10939881,7068308,11001998,7068315,7068316,7068323,7068376,11041117,11002136,4970677,10940185,10989259,10963261,8569617,8569647,7068761,8569792,7068832,7068908,7068914,7068916,10950652,10989724,7074061,10950774,8067197,7066281,10977021,7074342,10977061,10977064,10977118,10977289,10977333,10977334,10977335,10977336,10977341,10977342,10977343,10977344,10977345,10977346,10977407,10977418,10977423,10977424,10977426,10977428,10977515,10977516,10964615,7067003,7075046,10961802,10961860,11039869,10961891,10961892,10961893,8837701,8837708,8837709,7067266,7075268,7075279,11039986,10975192,11001201,11001204,11001205,11001279,10975351,10975370,10975382,10988441,7075906,10931472,7072300,7064306,10986173,11038213,11038214,10986216,11038223,11038262,10960306,10960308,11038353,10960433,11038441,11038494,11038495,10932194,10960658,10960659,10960660,10999673,10999674,10999676,10999677,10999680,7065054,10960830,10960834,10960835,7065154,7065342,10932779,11000193,11000196,11000207,11000212,11000213,11000214,11039255,11039256,11039257,11039258,11039297,11039298,4967843,11039348,11039349,10961356,10961357,10961358,10961359,10961360,11039389,10974401,10974402,10974403,10974404,10974405,10974406,10974407,10974408,10974409,10974410,10974411,10974413,10974414,10974415,10974416,10974417,10974418,10974419,10974420,10974421,10974422,10974423,10974424,10974425,10974426,10974427,10974429,11039523,11039524,11039534,10961577,10971912,10971913,7071277,10958988,10998023,10998038,10943057,7071558,10998308,10998413,10998414,10998420,10998421,10998422,10998423,10998424,10998425,10998426,10998427,10998452,10998453,10998454,10998455,10998456,10998457,10998458,7071774,10998459,10998460,10998461,10998462,10998463,10998464,10998477,10998478,10998479,10998500,10998505,10998506,10998507,11008750,11008800,10982837,10969888,10969892,10940841,7069305,10983391,10983417,3656456,10996734,10996735,10996736,10983786,10983787,10983788,3656736,10983964,11036005,11036006,11036007,11036008,10942319,10958470,11036533,10971550,10971551,7070905,10954629,11006667,11006670,10918580,10923607,10923610,10923611,10923612,10923634,10923698,10923699,10923700,10923701,10923702,10923703,10923704,10923705,10923706,10923707,11032884,11032904,11032908,11032912,11032913,11032914,11032915,11032916,11032917,11032918,11032919,11032920,11032921,10618299,10618300,10923811,10618301,10923812,10923813,11032966,10923860,10968009,10923861,10923862,11033065,10923929,10923930,10923931,10923932,10923933,10923934,10923935,10924021,10924022,10924102,10924103,10924104,10924105,10924106,10994303,11033308,10994352,10924243,10924244,10924245,11033475,10924750,10919895,10919896,10919897,10995157,10995477,10995486,10619894,11005708,10617120,11005988,11006023,10622473,10622525,10622526,11006211,11006213,11006214,10617581,11006292,11006572,10614987,10925517,10977738,10977739,10977740,10977745,10977747,10977753,10977754,10977755,10920608,10977756,10920609,10920611,10920612,10920613,10977761,10920614,10977762,10920615,10977763,10920616,10977764,10977765,10977766,10977773,10977774,10977775,10977776,10920647,10920648,10920653,10920654,10920655,10920669,10990864,10990865,10925756,10620385,10991101,10991102,10920982,10921026,10978414,10978415,10978416,10926321,10921396,10921410,10965570,10978602,10616055,10991758,10991776,10621124,10978787,10978788,10978795,10921662,10921663,10991814,10991884,10921841,10921842,10926933,10616471,10992305,10953461,10953462,10979485,10979502,10966526,10562288,10565316,10565317,10565320,10559338,10559406,10559407,9189656,9189657,8864219,9197746,9189748,10562655,10559750,10559751,10559759,10562798,10562799,10562800,10562801,10562802,9190166,7057672,8862049,7057751,9171593,9171600,10557455,10557476,10557477,10557479,10557480,10557483,10557484,10557618,10560622,10560639,10560651,10560653,10560658,10560662,10560669,10560677,10560685,10560696,10560719,10560724,10560736,10560737,10560740,10560741,10560746,10560748,9187952,9187955,10560769,9187958,9187959,10560773,10560778,10563790,9171978,10560822,10560824,10560825,10560827,10560828,10560838,10560839,10560847,10560848,10560849,10560878,10560884,10563971,9172169,9172250,8862838,10610018,10564179,10564180,9188399,10613110,10613225,7058820,9172678,7058865,9196851,7059115,10564772,9181008,9189016,9189021,9169334,10511177,7055534,9193370,10511222,10511228,10511229,10511230,10511231,10511232,10513275,10513276,10513277,10513278,10513279,10513280,10513281,10513282,10513283,10513284,10513285,10513286,10511292,10511293,10511294,10511295,10511296,10511297,10511298,10511299,10511305,10511306,10511307,10515318,10515319,9169506,10555351,10555352,10511374,10511375,10511376,10515395,10513411,10555424,10555428,10513429,10513431,7055788,10517565,10517566,10517567,10517568,10517573,10511582,7055962,4974650,4974651,4974652,9169835,9177850,9177855,10513736,9177977,9177978,9177979,4974855,9178022,9178023,9178035,9170048,9170051,9170052,9170053,9170054,9170055,9178056,9170056,9170057,9170058,9162062,9178066,9178067,9178068,9170068,7056250,7056255,10513952,10555952,10555953,9178215,9178217,9178218,9178220,10514034,9178221,10512057,7056412,9170246,9170250,9170251,9170301,10514117,10514133,10514134,10514160,10514168,10514169,10514174,10514175,10514176,10514177,9170370,4975227,10516188,10512192,10512200,10514213,10514214,9170421,10514239,10514240,9178431,10514260,10514261,10514280,10556294,9178624,9178625,9178627,9170688,10514508,10514509,10514533,10514534,10514535,10514536,10556537,10514547,10512559,10514560,10514564,10514565,9178822,10514692,10514693,10514739,10512800,10518863,10518865,10512926,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10519082,10519084,10519090,10519094,9160310,9160321,9192352,9192353,9192357,9192363,9192371,9168376,9192378,9192419,9192420,9192421,9192426,9192475,9192553,9192571,9192572,9192573,9184609,9193103,9193104,9185124,9185125,9185126,9185128,9185130,9185131,9177139,9177171,9177179,9177180,10420143,10420147,10417157,9177289,8864885,4971270,10467105,10467108,10467110,10467111,10467112,9182538,10467125,10467127,10467128,10467132,10467145,10463332,10463396,10463398,10463429,10463430,10463432,9183001,9175043,9167054,4971946,10463675,4971962,9191124,9191125,9191139,9191140,9191141,9191142,9191144,9183145,9191168,9191169,9191170,9191171,9191176,9191257,9191260,10467859,9167320,10463931,9175448,9175450,9175455,9175460,8917172,9191557,9191558,9191559,9191560,9191561,9191562,9191563,9191564,9191565,9191566,9191567,9191568,9191569,10466243,9167669,9167899,9192010,9192013,9192015,9192016,9192018,9192019,9168106,9192121,9168157,9192193,9192214,8917912,8917913,10466852,10628274,10628357,10628358,10174902,10174987,10628990,10628993,10629356,10629581,10629600,10629609,10629645,10629646,10629661,10629662,10156253,10171431,10627019,10173644,10627680,10159330,10161629,10176672,10630270,10176933,10177118,10167187,10167206,10167207,10167209,10167347,10167348,10167350,10630866,10162746,10626309,10177926,10173360,10580267,10580270,10577434,10583752,10583854,10583865,10583897,10583910,10583942,10583943,10583944,10583951,10580956,10583961,10583962,10583966,10583967,10583968,10583969,10583992,10584034,10584035,10584036,10584037,10584038,10578051,10584107,10584108,10584109,10584110,10581718,10578722,10578723,10578775,10578776,10584867,10584868,10584870,10584890,10582029,10582034,10576230,10576232,10576240,10576284,10576287,10576296,10576297,10582321,10582327,10582328,10576329,10576344,10576346,10576347,10576348,10576349,10576350,10576351,10576374,10576375,10576379,10576381,10576384,10567401,10576438,10576439,10576451,10576452,10576453,10576454,10582457,10576484,10576531,10576532,10576533,10576534,10576535,10576536,10576544,10576566,10576591,10585657,10576698,10585753,10585754,10585865,10527295,10527296,10527309,10525317,10529337,10529338,10529339,10529340,10529343,10529345,10529350,10523568,10523623,10523631,10523635,10523675,10523685,10523686,10523687,10523688,10523689,10523690,10523691,10530124,10530138,10530142,10530145,10530156,10530166,10530167,10530172,10530173,10528178,10530188,10530201,10530202,10530203,10530204,10530205,10530206,10530207,10530208,10530209,10530210,10530211,10530224,10530231,10522327,10524487,10524676,10524721,10524725,10522726,10522727,10520764,10520765,10520796,10520868,10520906,10528945,10528946,10528949,10528950,10528951,10528952,10528953,10528970,10521029,10523042,10523068,10523069,10523070,10523071,10523072,10523103,10422281,10422347,10420375,10423383,10422526,10420576,10420578,10420584,10420593,10420597,10420638,10420639,10422657,10422658,10423752,10423753,10423798,10423887,10423888,10420939,10423970,10423977,10420986,10423996,10424002,10423031,10421077,10425080,10423081,10421117,10423180,10479231,10479232,10477256,10479269,10479270,10476584) 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'