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(8630673,8630684,8630737,8631032,10448383,8631276,8631298,8631299,8631300,8631301,8631302,8631303,8631346,8631347,8631473,8631480,8631481,8631482,8631487,8631490,8631491,8631492,8631496,8631497,8631498,8631502,8631506,8631507,8631508,10950639,10849385,8575567,3229962,10951339,8632438,8632442,8632445,8632446,8632450,8632453,8632456,8632459,8632464,8632466,8632468,8632470,8632471,8632472,8632474,8632475,8632476,8632478,8632480,8632481,8632483,8632485,8632487,8632489,8632490,8632493,8632497,8632537,8632538,8629760,8630418,8630421,8630435,8630442,8630443,8630445,8630446,8630449,8630451,8630452,8630453,8627585,8627590,8627592,8627596,8627604,8627605,10866325,7201381,8627807,8627832,8627868,7201468,11011910,11011911,8559172,8559173,8559174,7201514,7072286,10866620,10866621,10866622,10866623,10866624,10866625,10866626,10866627,10866628,10866629,10866630,10866631,10866632,10866633,10866634,10866635,10866636,10866637,10866638,10866639,10866640,10866641,10866642,10866643,10866644,10866645,10866646,10866647,10866648,10866649,10999062,10866669,8559379,8559380,8559381,8559382,8559383,8559384,8559385,8559386,8595114,8595117,8628170,8628247,10103845,8628493,8836431,7202211,7202212,7202213,7202214,8628618,8628619,8628782,8628823,8628826,8628832,8628835,8628837,8628839,8628841,8628843,8628844,8628849,8628850,8628855,8628856,8628865,8628866,8628871,8628872,8628876,8628879,8628882,8628885,8628888,8628890,8628892,8628894,8628895,8628898,8628901,8628904,8628907,8628910,8628913,8628916,8628919,8628922,8628925,8628928,8628931,8628934,8628937,8628942,8628945,8628948,8628953,8628954,8628960,8628961,8628966,8628967,8628972,8628973,8628978,8628979,8628984,8628985,8628990,8628991,8629232,8629310,8629311,3227094,8629447,8626895,8910449,8910450,8910574,10857828,10857833,8835196,8627378,11011425,11011426,11011427,6000119,8627499,6000194,6000195,6000196,6000197,6000198,6000199,8624581,8624790,10863581,7198733,8625151,7198751,7198770,8625615,10840910,10864515,10864533,10864550,10864582,10864599,8626039,8626148,8626154,8626161,8626167,8626172,8626175,8626243,8626244,8626245,8626403,10984537,10984538,10984539,10984540,8557803,10984560,10984561,10984562,10984563,10984564,10984565,10984566,10984567,10984568,10984569,10984570,10984571,10984572,10984573,10984574,10984575,10984576,10984603,10984604,10984605,10984606,10984607,3233403,3233404,3233408,3233416,3233423,3233424,3233425,3233429,7196261,11045716,10853640,3234102,10838501,10838519,10838531,3234358,3234359,3234360,8555154,3234736,8614229,3234964,3234971,8907624,8907699,7197907,7197913,3232418,3232419,8634682,8634683,8634684,8611889,8541593,8541594,8634936,10852649,10617457,10617458,11045522,11045523,11045524,10617955,10617957,10850427,10850428,8632828,8632832,8632835,8632836,8632839,8632842,8632843,10425577,8632893,8632919,8632962,8632967,8633011,8633012,8633013,8633014,8633093,8633094,8633095,8633096,8633098,10425911,8633204,8633270,10965320,10965372,10965373,10930728,10930729,10930730,3582191,10426197,8904226,8904282,3231700,8904354,3232020,3232021,3232022,3232023,3232024,3232025,3232026,3232047,3232048,3232049,3232050,3232051,3232067,3232068,3232069,3232074,3232075,3232076,8541212,3232159,10852106,3232249,11044555,10852158,11044556,8634517,11044557,8634518,11044558,11044559,11044560,11044561,11044562,11044563,11044564,8853169,8853170,8853172,8853173,8853174,8853175,8853176,8853177,8853178,8853179,8853180,8853207,8853208,8853209,8853210,8853211,8853212,8853213,8853214,8853215,8853217,8853218,8853219,8853220,8853221,8853222,8853223,8853224,8853225,8853226,8853228,8853229,8853230,8853231,8853232,8853233,8853234,8853235,8853236,8853237,8853238,8853239,8853240,8853241,8853242,9915684,9915700,10614500,9181892,9181893,9181894,9181895,9181896,9181900,9213993,9213998,9211558,9211563,10612295,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10609942,10609943,10609944,10609945,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,7058533,7058534,10610064,7058620,9188641,9172859,9172860,8852772,8852773,8852774,8849316,8849320,8849321,8849322,8849323,8849330,8849332,9911863,7015320,7015321,7015322,7015323,7015324,7015325,7015326,7015327,7015328,7015329,7015330,7015331,7015332,7015333,7015334,7015335,7015336,7015337,7015338,7015339,9169942,6674261,6674284,10516142,10118679,9912816,9211213,9211215,9211216,9211217,9211218,9211219,9211222,8848124,8848127,8848141,8848150,8848178,8848187,8848193,8848195,8848203,8848205,9168394,6672784,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,6672808,10419538,9168669,9168818,8848715,8848718,8848719,8848729,10417826,8848730,8848735,8848736,8848741,8848744,10417845,8848757,8848758,8848762,9168940,10417862,8848767,8848771,8848772,8848791,10417897,8848804,8848810,8848811,8848815,10417915,8848822,8848845,8848856,8848877,8848886,9169064,6673271,8848909,8848911,8848914,8848916,8848919,8848920,9193118,9193119,9193120,9193121,10417109,9190818,8847268,8847274,8847288,8847310,10123846,10123847,8847476,10123848,8847478,8847480,8847487,8847493,8847496,8847500,8847523,8847558,8550898,8847573,8847584,8847613,9175790,9175796,8847996,8847998,8848002,8848003,8848018,8848021,8848025,8848028,8848033,8848034,8848037,8848060,8848062,8848080,8848081,8848087,8848095,10908624,10908625,10883625,10908626,10883629,10884041,8594166,8594167,8594168,8594169,8594170,8594171,8594172,8594173,10889718,10899853,10875001,10890007,10890008,10890137,10890138,10632056,10153863,10882987,10882988,10882989,10882990,10886497,10886498,10631789,10631790,10631791,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568126,10568127,10568128,10568129,10568130,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10602171,10602176,10602183,10602189,10602192,10643548,10602696,10602697,10602710,10602711,10598866,10602727,10602729,10602730,10602731,10590276,10590278,10590297,10647702,10603687,10603688,10603697,10603698,10606801,10606919,10604146,10567621,10567622,10567623,10567624,10567625,10601691,10601693,10591921,10568110,10568111,10522455,10547031,10425030,10409663,10407787,10407788,10496936,10478011,10478029,10478030,10497039,10412414,10412422,10493251,10493252,10493253,10493254,10493255,10493296,10493297,10493298,10493299,10493300,10493301,10493302,10408756,10408780,10406991,10409076) 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'