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(10939559,4970858,4970859,4970860,4970861,4970862,4970863,4970864,4970865,4970866,4970867,4970868,4970869,4970870,4970871,4970872,4970873,4970874,4970875,4970876,4970877,4970878,4970879,4970880,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970891,4970892,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970930,4970931,4970932,4970933,4970934,4970935,4970936,10940343,10940344,4970937,10940345,4970938,4970939,10940346,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970972,4970973,4970974,4970975,4970976,4970977,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,10940531,10940532,10940533,10940534,10940535,8067282,8067283,8067347,4968618,10437265,4968644,10437285,10437286,10437322,10437323,10437324,10437325,10437326,10437327,10437328,10437333,8067556,8067595,8067596,8067597,8067598,8067599,8067600,8067601,8067602,8067603,8067604,8067605,8067606,8067607,8067608,8067609,8067610,8067611,8067612,8067613,8067614,8067615,8067616,8067617,10437495,8067618,8067619,10437496,10437497,8067620,8067621,8067622,8067623,8067624,8067625,8067626,8067627,8067628,8067629,8067630,8067631,8067632,8067633,8067634,8067635,10437583,10437604,10437605,10437606,10437607,10437608,10437609,10437610,10437611,10437612,10437613,10437614,10437615,10437616,10437617,10437618,10437619,8067787,8067788,8067789,8067790,8067791,8067792,8068799,10939558,10931726,10931857,10931858,8075272,10931935,10931975,10931999,10932000,10932001,10932105,10932278,10932279,8066100,10932635,10932648,10932649,10932671,10932672,10932682,10932691,10932695,10932813,10933011,10933034,10933044,10933083,10933084,10933085,10933086,10933087,10933155,10933156,10942599,10942600,8073756,8073757,8073758,8073759,8073760,8064004,8073761,8064005,8073762,8064006,8073763,8073764,8073765,8073766,8073767,8073768,8073769,8073770,8073771,8073772,8073773,8073774,8073775,8073776,8073777,8073778,8073779,8073780,8073781,8073782,8073783,8073784,8073785,8073786,8073787,8073788,8073789,8073790,8073791,8073792,8073793,8073794,8073795,8073796,8073797,8073798,8073799,8073800,8073801,8073802,8073803,8073804,8073805,8073806,8073807,8073808,8073809,8073810,8073811,8073812,8073813,8073814,8073815,8073816,8073817,8073818,8073819,8073820,8073821,8073822,8073823,8073824,8073825,8073826,8073827,8073828,8073829,8073830,8073831,8073832,8073833,8073834,8073835,8073836,8073837,8073838,8073839,8073840,8073841,8073842,8073843,8073844,8073845,8073846,8073847,8073848,8073849,8073850,8073851,8073852,8073853,8073854,8073855,8073856,8073857,8073858,8073859,8073860,8073861,8073862,8073863,8073864,8073865,8073866,8073867,8073868,8073869,8073870,8073871,8073872,8073873,8073874,8073875,8073876,8073877,8073878,8073879,8073880,8073881,8073882,8073883,8073884,8073885,8073886,8073887,8073888,8073889,8073890,8073891,8073892,8073893,8073894,10942783,8073895,8073896,8073897,8073898,8073899,8073900,8073901,8073902,8073903,8073904,8073905,8073906,8073907,8073908,10942798,8073909,10942799,8073910,10942800,8073911,10942801,8073912,10942802,8073913,10942803,8073914,10942804,8073915,10942805,8073916,8073917,10942806,10942807,8073918,10942808,8073919,10942809,8073920,8073921,10942810,8073922,10942811,10942812,8073923,10942813,8073924,8073925,10942814,10942815,8073926,10942816,8073927,8073928,10942817,8073929,10942818,8073930,8073931,8073932,8073933,8073934,8073935,8073936,8073937,8073938,8073939,8073940,8073941,8073942,8073943,8073944,8073945,8073946,8073947,8073948,8073949,8073950,8073951,8073952,8073953,8073954,8073955,8073956,8073957,8073958,8073959,8073960,8073961,8073962,8073963,8073964,8073965,8073966,8073967,8073968,8073969,8073970,8073971,8073972,8073973,8073974,8073975,8073976,8073977,8073978,8073979,8073980,8073981,8073982,8073983,8073984,8073985,8073986,8073987,8073988,8073989,8073990,8073991,8073992,8073993,8073994,8073995,8073996,8073997,8073998,8073999,8074000,8074001,8074002,8074003,8074004,8074005,8074006,8074007,8074008,8074009,8074010,8074011,8074012,8074013,8074014,8074015,8074016,8074017,8074018,8074019,8074020,8074021,8074022,8074023,8074024,8074025,8074026,8074027,8074028,8074029,8074030,8074031,8074032,8074033,8074034,8074035,8074036,10943264,3656405,3656406,3656424,3656425,3656426,3656427,3656428,3656429,3656430,3656431,3656432,3656433,3656434,3656435,3656436,3656437,3656457,3656458,3656459,3656460,3656461,8072688,8072689,8072690,8072691,8072692,3656597,8073095,10942258,8073537,8073538,8073539,8073540,8073541,8073550,8073551,10918594,10918595,10918596,10918597,10623321,10918869,10623415,10919908,10920113,10920114,10920115,10922530,10922531,10922532,10922533,10922546,10922547,10922548,10922549,10922616,10922725,10922726,10922727,10922728,10922729,10922730,10922731,10922732,10922733,10922734,10922735,10922736,10922737,10922738,10922739,10922740,10922741,10922742,10922743,10922744,10922745,10922746,10922747,10922748,10922749,10922750,10922751,10922752,10922753,10922754,10922755,10922756,10922757,10922758,10922759,10922760,10922761,10922762,10922763,10922764,10922765,10922766,10922767,10922768,10922769,10922770,10922771,10922772,10922773,10922774,10922775,10922776,10922777,10922778,10922779,10922780,10922781,10922782,10922783,10922784,10922785,10922786,10922787,10922788,10922789,10922790,10922791,10922792,10922793,10922794,10922795,10922796,10922797,10922798,10922799,10922800,10922801,10922802,10922803,10922804,10922805,10922806,10922807,10922808,10922809,10922810,10922811,10922812,10922813,10922814,10922815,10922816,10922817,10922818,10922819,10922820,10922821,10922822,10922823,10922824,10922825,10922826,10922827,10922828,10922829,10922830,10922831,10922832,10922833,10922834,10922835,10922836,10922837,10922838,10922839,10922840,10922841,10922842,10922843,10922844,10922845,10922846,10922847,10922848,10922849,10922850,10922851,10922852,10922853,10922854,10922855,10922856,10922857,10922858,10922859,10922860,10922861,10922862,10922863,10922864,10922865,10922866,10922867,10922868,10922869,10922870,10922871,10922872,10922873,10922874,10922875,10922876,10922877,10922878,10922879,10922880,10922881,10922882,10922883,10922884,10922885,10917935,10917936,10917937,10917938,10917939,10620189,10620190,10620191,10620192,10620193,10620194,10915711,10620202,10915712,10620203,10915713,10620204,10915714,10620205,10915715,10620206,10915716,10915717,10915718,10915719,10915720,10915721,10915722,10915723,10915724,10915725,10915726,10915727,10921866,10921867,10921868,10921869,10621493,10621494,10621495,10621496,10621497,10621498,10621499,10621500,10621501,10621502,10621503,10621504,10621505,10621506,10621507,10621508,10621509,10922043,10917078,10922304,10922305,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565445,10565446,10565447,10565448,10565449,10614635,10611650,10611651,10611835,10611981,10612195,10612196,10612197,10612198,10609265,10613214,10613215,10610359,10564614,10564615,10564616,10564617,10564618,10564619,10564620,10564621,10564622,10564623,10564624,10564625,10564626,10564636,10564656,10564684,10564685,10564686,10564687,10564688,10564689,10564690,10564691,10564692,10564693,10564694,10564695,10564696,10564697,10564698,10564776,10564777,10564778,10564828,10565046,10565091,10512789,10512790,10512791,10512792,10512793,10512794,10512795,10512796,10512797,10512798,10512799,10512800,10512801,10512802,10512803,10512804,10512805,10512806,10512807,10512808,10512809,10512810,10512811,10512812,10519000,10419582,10420063,10420064,10420065,10420066,10420067,10420068,10420069,10420070,10420071,10420072,10420073,10420074,10471482,10471483,10471484,10471485,10471486,10471487,10471488,10471489,10471490,10471491,10471492,10471493,10471494,10471495,10471496,10471497,10471498,10471499,10471500,10471501,10471502,10471503,10471504,10471505,8563230,8563231,8563232,8563233,8563234,8563235,8563236,8563237,8563238,8563239,8563240,8563241,8563242,8563243,8563244,8563245,8563246,8563247,8563248,8563365,8563366,8563367,8563371,8563378,8563379,10462711,10462712,10462713,10462714) 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'