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(11001963,11001964,10940173,10976518,10976519,8575014,8575015,8575016,8575017,8575018,8575019,8583875,10868896,10868897,10868898,10868899,10868900,10951335,10951336,11003459,11003460,11003461,10987966,10929585,8573684,8573859,10972750,10972961,8835863,8835864,8835865,8835866,8835867,8835868,10842087,10842088,10842089,10102513,10102514,10102515,10102516,10985266,10985267,10985268,10985292,10985365,10985366,10985439,10985487,10969506,10969507,10969508,10969509,10969510,10969511,10969512,10969513,10969514,10969515,10969516,10969517,10969518,10969519,10940749,10940750,10940751,8908194,8908195,7069309,7069310,7069311,7069312,7069313,7069314,7069315,7069316,7069317,7069318,8556308,8556309,8556310,8556311,10970058,10970199,10970442,10970443,10970444,10970813,10970814,10970815,10970816,10970817,10971104,10984128,10984129,10984130,10984131,10984132,10984133,10984134,10984135,10984136,10984137,10984138,10984139,10984140,10984141,10984142,10984143,10984144,10984145,10984146,10984147,10984148,10984149,10984150,10984151,10984152,10984153,10984154,10971155,10984155,10984156,10984157,10984158,10984159,10984160,10984161,10984162,10984163,10984164,10984165,10984166,10984167,10984168,10984169,10984170,10984171,10984172,10984173,10984174,10984175,10984176,10984177,10984178,10984179,10984180,10984181,10984182,10984183,10984184,10984185,10984186,10984187,10984188,10984189,10984190,10984191,10984192,10984193,10984194,10984195,10984196,10984197,10984198,10984199,10984200,10984201,10984202,10984203,10984204,10984205,10984206,10984207,10984208,10984209,10984210,10984211,10984212,10984213,10984214,10984215,10984216,10984217,10984218,10984219,10984220,10984221,10984222,10984223,10984224,10984225,10984226,10984227,10984228,10984229,10984230,10984231,10984232,10984233,10984234,10984235,10984236,10984237,10984238,10984239,10984240,10984241,10984242,10984243,10984244,10984245,10984246,10984247,10984248,10984249,10984250,10984251,10984252,10984253,10984254,10984255,10984256,10984257,10984258,10984259,10984260,10984261,10984262,10984263,10984264,10984265,10984266,10984267,10984268,10984269,10984270,10984271,10984272,10984273,10984274,10984275,10984276,10984277,10984278,10984279,10984280,10984281,10984282,10984283,10984284,10984285,10984286,10984287,10984288,10984289,10984290,10984291,10984292,10984293,10984294,10984295,10984296,10984297,10984298,10984299,10984300,10984301,10984302,10984303,10984304,10984305,10984306,10984307,10984308,10984309,10984310,10984311,10984312,10984313,10984314,10984315,10984316,10984317,10984318,10984319,10984320,10984321,10984322,10984323,10984324,10984325,10984326,10984327,10984328,10984329,10984330,10984331,10984332,10984333,10984334,10984335,10984336,8614062,8614063,8614064,8614065,8614066,8614067,8614068,8614069,3924820,3924821,3924822,3924823,3924824,3924825,3924826,3232249,3232250,10622113,10622114,10622115,10622116,10622117,10622118,10622119,10622120,3582091,3582092,3582093,3582094,3582095,3582096,3582097,3582098,9181564,9181565,9181566,9181567,9181568,9181569,9181570,9181571,9181572,9181573,9181574,9181575,9181576,9181577,9181578,9181579,9181580,9181581,9181582,9181583,9181584,9181585,9181586,9181587,9181588,9181589,9181590,9181591,9181592,9181593,9181594,9181595,9181596,9181597,9181598,9181599,9181600,9181601,9181602,9181603,9181604,9181605,9181606,9181607,9181608,9181609,9181610,9181611,9181612,9181613,9181614,9181615,9181616,9181617,9181618,9181619,9181620,9181621,9181622,9181623,9181624,9181625,9181626,9181627,9181628,9181629,9181630,9181631,9181632,9181633,9181634,9181635,9181636,9181637,9181638,9181639,9181640,9181641,9181642,9181643,9181644,9181645,9181646,9181647,9181648,9181649,9181650,9181651,9181652,9181653,9181654,9181655,9181656,9181657,9181658,9181659,9181660,9181661,9181662,9181663,9181664,9181665,9181666,9181667,9181668,9181669,9181670,9181671,9181672,9181673,9181674,9181675,9181676,9181677,9181678,9181679,9181680,9181681,9181682,9181683,9181684,9181685,9181686,9181687,9181688,9181689,9181690,9181691,9181692,9181693,9181694,9181695,9181696,9181697,9181698,9181699,9181700,9181701,9181702,9181703,9181704,9181705,9181706,9181707,9181708,9181709,9181710,8853577,9913763,9913764,9913919,9913920,9913921,9913922,6676693,6676694,6676695,10120762,9914825,8567488,8567499,3654298,3654299,6674909,6675050,7057067,7057068,7057069,7057070,7057071,7057072,7057073,7057074,7057075,7057076,7057077,7057078,7057079,7057080,7057081,6675182,9195245,9195246,9195247,9195248,9195249,9176494,9176575,9176576,4971500,4971567,9183029,8550557,976613,8593570,10164698,10164699,10164700,10164701,10164702,10164703,8594149,8594150,8594151,8594152,8594153,8594154,8594155,8594156,8594157,8594158,8594159,8594160,8594161,8594162,8594163,8594164,10894204,10165295,10165296,10165297,10165298,10894485,10894486,10894487,10894488,10894489,10170643,10170644,10170645,10170646,10170647,10170648,10170649,10170650,10170651,10170652,10170653,10170654,10170655,10170656,10170657,10170658,10170659,10170660,10170661,10165796,10899790,10899791,10899792,10899793,10899794,10899795,10899796,10899797,10899798,10899799,10899800,10899801,10899802,10899803,10899804,10899805,10171049,10896109,10167521,10167522,10167523,10167548,10649278,10649279,10650020,10650021,10524499,10524500,10524501,10524502,10524503,10524504,10524505,10524506,10524507,10524508,10524509,10524510,10524511,10524512,10524513,10524514,10524515,10524516,10524517,10524518,10524519,10524520,10524521,10524522,10524523,10524524,10524525,10524526,10524527,10524528,10524529,10524530,10524531,10524532,10524533,10524534,10524535,10524536,10524537,10524538,10524539,10524540,10524541,10524542,10524543,10524544,10524545,10524546,10524547,10524548,10524549,10524550,10524551,10524552,10524553,10524554,10524555,10524556,10524557,10524558,10524559,10524560,10524561,10524562,10524563,10524564,10524565,10524566,10524567,10524568,10524569,10524570,10524571,10524572,10524573,10524574,10524575,10524576,10524577,10524578,10524579,10524580,10524581,10524582,10524583,10524584,10524585,10524586,10524587,10524588,10524589,10524590,10524591,10524592,10524593,10524594,10524595,10524596,10524597,10524598,10524599,10524600,10524601,10524602,10524603,10524604,10524605,10524606,10524607,10524608,10524609,10524610,10524611,10524612,10524613,10524614,10524615,10524616,10524617,10524618,10524619,10524620,10524621,10524622,10524623,10524624,10524625,10524626,10524627,10421220,10481583,10481584,10481585,10481586,10481587,10481588,10481589,10481590,10481591,10481592,10481593,10481594,10481595,10481596,10481597,10481598,10481599,10481600,10481601,10481602,10481603,10481604,10481605,10481606,10481607,10481608,10481609,10481610,10481611,10481612,10481613,10481614,10481615,10481616,10481617,10481618,10481619,10481620,10481621,10481622,10481623,10481624,10481625,10481626,10481627,10481628,10481629,10481630,10481631,10481632,10481633,10481634,10481635,10481636,10481637,10481638,10478696,10478697) 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'