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(8630632,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630649,8630650,8630651,8630652,8630653,8630654,8630657,8630720,8630743,8630746,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630779,8630780,8630781,8630782,8630783,10861432,10861434,10861437,10861438,8630854,8630855,8630856,8630902,8630903,8631133,8631141,8631142,8631147,3229130,3229131,3229285,8631594,8631596,8631597,8631598,8631599,8631606,8631607,8631608,8631609,8631610,8631611,8631622,8631623,8631624,8631625,8631635,8631702,8631705,8631712,8631716,10862911,8632392,8632424,8632425,8632426,8632427,8632428,8632429,8632498,8632499,8632500,8632514,8632515,8632518,8632519,8632521,8632545,8632546,8632559,8632560,8632561,8632562,8632563,8632564,8632565,8632571,8632573,8632574,8629596,10860331,10860332,10860341,10860342,10860347,8629707,8629709,10860364,10860373,10860374,8629734,8629735,10860383,8629745,8629765,10860413,8629790,10860518,8630286,8630287,8630318,8630324,8630325,8630326,8630331,8630333,8630340,8630349,8630351,8630357,8630359,8630360,8630361,8630362,8630363,8630364,8630365,8630366,8630367,8630368,8630369,8630370,8630371,8630372,8630373,8630374,8630375,8630376,8630377,8630378,8630379,8630380,8630381,8630382,8630383,8630384,8630385,8630386,8630459,8630528,8630529,8630530,8630531,8630532,8630533,8630534,7201335,8627795,8627796,8627797,8627821,8627822,7201727,8628183,8628187,8628258,8628259,8628261,8628263,8628265,7201901,8628343,7201959,7201974,7201975,10960474,8628490,8628491,8628492,8628493,10859259,10859260,8628626,8628627,8628633,8628634,7202257,7202285,8628812,8628813,8628814,8628815,8628816,8628817,10859576,5654676,5654677,8628995,8628996,8628997,8628998,7202643,8629109,8629110,8629111,8629112,8629113,8629116,8629137,8629138,8629139,9794588,7202769,8629203,8629205,8629206,8629251,8629253,8629255,8629256,8629257,8629258,8629261,8629262,8629263,8629265,8629266,10859918,10859919,10859920,10859921,10859922,10859923,10859924,10859925,10859926,10859927,10859928,10859929,10859930,10859931,10859932,10859933,10859934,10859935,10859936,10859937,10859938,10859939,10859940,10859941,10859942,10859943,10859944,10859945,10859946,10859947,10859948,10859949,10859950,10859951,10859952,10859953,10859954,10859955,10859956,10859957,8629411,8629414,8629416,8629417,8629463,8629472,8626813,8626814,8626815,8626825,7200527,7200528,7200529,8626939,7200578,8626995,10959088,8627068,8627087,8627149,8627150,8627151,8627162,8627163,8627164,8627175,8627176,8627177,7200779,8627187,8627188,8627189,8627205,8627206,8627207,8627221,8627223,8627224,8627225,8627227,8627228,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627239,8627240,8627241,8627242,8627243,8627244,8627246,8627247,8627248,8627249,8627250,8627251,8627252,8627253,8627254,8627255,8627256,8627257,8627258,8627259,8627260,8627261,8627262,8627263,8627264,8627266,8627267,8627268,8627269,8627270,8627272,8627273,8627275,8627277,8627279,8627280,8627282,8627283,8627284,8627285,8627286,8627287,8627288,8627289,8627290,8627291,8627292,8627293,8627310,8627312,8627313,8627395,8627405,8627406,8627407,8627412,8627416,8627417,8627418,8627502,8627510,8627515,8627516,8627517,8627530,8624583,8624584,8624585,8624586,8624587,8624588,8624589,8624646,8624647,8624648,8624649,8624650,8624651,8624652,8624653,8624654,8624655,8624656,8624657,8624658,8624659,8624660,8624726,8624751,8624932,8624934,8624935,8624944,8624945,8624960,8624961,8624973,8624978,8624985,8625022,8625025,8625041,8625042,8625045,8625055,8625056,8625057,8625058,8625059,7198682,7198694,7198736,7198737,7198738,7198739,7198742,7198746,7198749,7198750,7198751,7198752,7198756,7198757,8625157,7198759,7198762,7198784,7198785,8625209,8625241,8625242,8625251,8625256,8625265,8625268,8625269,8625270,8625271,8625272,8625285,8625286,8625287,8625288,8625289,8625290,8625291,8625298,8625299,8625300,8625301,8625303,8625304,8625305,8625306,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,8625323,8625324,8625325,8625326,8625327,8625328,8625329,8625331,8625334,8625335,8625336,8625337,8625338,8625339,8625340,8625342,8625343,8625344,8625352,8625353,8625354,8625355,8625356,8625357,8625358,8625359,8625360,8625363,8625365,8625367,8625370,8625385,7199211,7199392,7199480,7199508,10101491,8626085,8626086,8626149,8626159,8626166,8626171,8626174,8626261,8626379,3923441,3923467,3923468,3923471,3923593,3923632,8554335,8554358,7197239,7197437,3234662,3234729,7197805,7197807,8624358,8624381,8624400,8624401,8624402,8624418,8624441,8624449,8624472,10619872,10619874,3232382,8541521,8634673,8634674,8634675,8634676,8541549,10617107,8634728,10617123,10617126,10617138,10617139,10617140,10617151,10617157,10617158,10617159,10617171,8542165,8632620,8632621,8632622,8632625,8632629,8632630,10425350,8632631,10425358,8632684,8632685,8632686,8632687,8632688,8632689,8632690,8632691,8632716,8632717,8632718,10425484,10620195,10620196,10620197,10620198,10620199,10620201,10620202,10425573,10425574,10425586,10615352,10615363,10615389,10615439,8633186,8633187,8633188,8633189,8633190,10425910,8633191,8633192,8633193,8633194,8633195,8633196,8633197,8633198,8633199,8633200,8633201,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,10425934,8633215,8633216,8633217,8633218,10425939,10425942,10425944,8633261,8633275,8633276,8633277,10426010,10426017,10615710,10615711,10615726,10615727,10615728,10615780,8633402,10615820,10615822,10615823,10615896,10615950,10615953,10615956,10616005,10616044,10616045,10426448,10426449,10426450,10426451,10426452,8540612,8540613,8540631,8633951,8633952,8634011,8634015,8634019,8634023,8634027,8634031,8634042,8634043,8634044,8634045,8634046,8634047,8634048,8634049,8634050,8634051,8634052,8634053,8634054,8634055,8634056,8634057,8634058,8634059,8634060,8634061,8634062,8634063,8634064,8634065,8634066,8634067,8634068,8634069,8634070,8634071,8634072,8634073,8634074,8634075,8634076,8634077,8634078,8634079,8634080,8634081,8634082,8634083,8634084,8634085,8634086,8634087,8634088,8634089,8634090,8634155,8634156,8634157,8634158,8634159,8634162,8634168,8634169,8634401,8634440,8634441,8634445,10616873,10616874,10616876,10616888,10614085,10614086,8853380,10611338,10611339,10611341,10614376,10614593,10611812,10612095,10609285,7058247,7058248,7058249,7058250,8566596,8566597,8566612,8566617,8566618,10609845,8852017,10612916,10612931,10613079,10613089,10613093,10610233,10613235,10613421,10613431,10613432,10613524,10613525,10613732,10613733,6673538,6673542,6673563,7055541,7055546,6673686,6673688,6673697,6673698,6673699,9169586,10117784,10117785,9169638,9169695,9169748,6674165,6674175,6674186,9912226,6674236,6674249,6674256,6674276,6674278,6674280,6674281,6674285,6674308,6674309,6674310,6674311,6674312,6674313,10417222,10417223,10417224,10417225,6672521,6672592,10415373,10415374,10417394,10417395,10417396,10417397,10416481,10417531,10417532,10417533,10417534,10418543,10418544,10418545,10418546,6672896,6672897,6672898,6672899,6672900,6672901,6672903,6672904,10417633,6673089,6673122,6673124,6673125,6673140,6673141,6673317,10418109,10418110,10418142,10417212,10417213,10417215,10417216,10417218,10417220,10471122,8550155,9167779,10888565,10888566,10888704,10946563,10946564,10946565,10888840,10889019,10889020,10889021,10889231,10884423,10889756,10885313,10883067,10883143,10888437,10883458,10883459,10885867,10886057,10886058,10886059,10886060,10886062,10886063,10886850,10882284,10882353,10545356,10545357,10545358,10545371,10545372,10545373,10507920,10507921,10413714,10413715,10413716,10407925,10414016,10414314,10414315,10414316,10414317,10414318,10414319,10414320,10414321,10414322,10414323,10414324,10414325,10414326,10414327,10414328,10414329,10414330,10414331,10414332,10414333,10414334,10414335,10414336,10414337,10414338,10414339,10414340,10414341,10414342,10414343,10414344,10414345,10414346,10414347,10414348,10414349,10414350,10414351,10414352,10414353,10414354,10414355,10414356,10414357,10414358,10414359,10414360,10414361,10414362,10414363,10414364,10414365,10414366,10414367,10414369,10414371,10414381,10414383,10414394,10414664,10414669,10414670,10414673,10414682,10410756,10410757,10410758,10410759,10410760,10410764,10410765,10410766,10410767,10410771,10410783,10410784,10410787,10410793) 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'