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(7075955,10939608,11001673,11001674,11001675,4970260,4970261,4970262,4970263,4970264,7076125,11002077,11002083,10989172,10989173,10989174,10989175,10989176,11002312,11002313,11002330,11002331,11002332,4970921,4970922,8569689,11002499,10963510,10963511,11002512,10963512,10963513,10963514,10963515,10963516,8569905,11002666,7074072,7074089,7074138,7074139,11002831,11002836,11002947,11002981,11002982,8067330,11003050,8067345,11003052,11003053,8067348,7074474,7074475,7074476,7074477,7074478,7074479,7074480,7074481,7074482,7074483,7074484,7074485,7074486,7074487,7074488,7074489,7074490,7074491,7074492,7074493,7074494,7074495,11003219,11003220,8067518,11003226,11003227,11003228,11003229,8067575,11003295,11003296,11003297,11003298,11003401,10437585,10437586,10437587,10437588,10990475,10990476,10990477,10990478,10990479,11003520,8067891,10961686,10938625,10961687,10961688,10987902,10987903,10987913,7075289,7075291,10988046,10988047,10988072,10962266,10962267,10962268,10962269,10962270,10962271,10962272,10962273,10939277,10939278,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074706,8074707,8074708,8074709,8074710,8074711,8074712,8074713,8074714,8074715,8074716,8074717,8074718,8074719,8074720,8074721,8074722,8074723,8074724,8074725,8074726,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074748,8074749,8074750,8074751,8074752,8074753,8074754,8074755,8074756,8074757,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8074767,8074768,8074769,8074770,8074771,10972745,10972746,7064255,10972959,10972979,7072307,7072308,7072309,7072310,7072311,7072312,7072313,10960193,8065498,8065499,7072635,7072679,10932052,7072729,7072832,7072833,10999575,7065493,7065494,11000250,11000251,11000252,11000253,11000254,11000255,11000256,11000257,11000258,11000259,11000260,11000261,11000262,11000263,11000264,11000265,11000266,11000267,11000268,11000269,11000270,11000271,11000272,11000273,11000274,11000275,11000276,11000277,11000278,11000279,11000280,11000281,11000282,11000283,11000284,11000285,10933151,10933172,10933173,10961545,10942747,10942748,10942749,7071186,11049099,10959001,10959003,10985280,10985288,10985334,10985335,10985336,5999993,10972409,10972412,7071728,6000069,6000070,10959513,10959514,10959515,10959516,10959517,10959518,10959519,10959520,6000159,6000160,6000161,10969907,10969939,10970050,7069366,10970051,10944893,10944894,10970196,8072359,8072365,8072376,8072380,8072387,8072393,8072396,8072398,8072402,8072408,8072414,8072418,8072424,8072439,3656279,8072444,8072450,8072456,10970435,10970436,10983760,10983761,10983762,10983763,10983764,3656664,3656665,10970789,10970794,8072891,8072892,8072893,8072894,8072895,8072896,10970971,3656911,10971230,10971231,10971232,10971233,10971234,10971235,10971236,10971237,10971238,10971239,10971240,10971241,10971242,10971243,10971244,10971245,10971246,10971247,10971248,10971249,10971250,10971251,10971252,10971253,10971254,10971255,10971256,10971257,10971258,10971259,10971260,10971261,10971262,10971263,10971264,10971265,10971266,10971267,10971268,10971269,10971270,10971271,10971272,10971273,10971274,10971275,10971276,10971277,10971278,10971279,10971280,10971281,10971282,10971283,10971284,10971285,10971286,10971287,10971288,10971289,10971290,10971291,10971292,10971293,10971294,10971295,10971296,10971297,10971298,10971299,10971300,10971301,10971302,10971303,10971304,10971305,10971306,10971307,10971308,10971309,10971310,10971311,7070627,10971312,10971313,10971314,10971315,10971316,10971317,10971318,10971319,10971320,10971321,10971322,10971323,10971324,10971325,10971326,10971327,10971328,10971329,10971330,10971331,10971332,10971333,10971334,10971335,10971336,10971337,10971338,10971339,10971340,10971341,10971342,10971343,10971344,10971345,10971346,10971347,10971348,10971349,10971350,10971351,10971352,10971353,10971354,10971355,10971356,10971357,10971358,10971359,10971360,10971361,10971362,10971363,10971364,10971365,10971366,10971367,10971368,10971369,10971370,10971371,10971372,10971373,10971374,10971375,10971376,10971377,10971378,10971379,10971380,10971381,10971382,10971383,10971384,10971385,10971386,10942326,10971387,10942327,10971388,10942328,10971389,10971390,10971391,10971392,10971393,10971394,10971395,10971396,10971397,10971398,10971399,10971400,10971401,10971402,10971403,10971404,10971405,10971406,10971407,10971408,10971409,10971410,10971411,10971412,10971413,10971414,10971415,10971416,10971417,10971418,10971419,10971420,10971421,10971422,10971423,10971424,10971425,10971426,10971427,10971428,10971429,10971430,10971431,10971432,10971433,10971434,10971435,10971436,10971437,10971438,10971439,10971440,10971441,10971442,10971443,10971444,10971445,10971446,10971447,10971448,10971449,10971450,10971451,10971452,10971453,10971454,10971455,10971456,10971457,10971458,10942414,10942467,10618002,10618028,10918620,10918676,10967845,10623348,10623442,10919038,10919039,10919040,10919041,10919042,10919043,10919048,10919049,10919050,10919051,10919361,10919363,10968619,10919483,10919707,10919708,10919709,10919710,10919711,10919712,8071082,10919927,10969421,10969422,10969423,10969436,10969437,10969438,10969439,10969440,10969441,10969442,10624957,10922477,10922478,10922479,10922480,10922481,10922482,10922483,10922484,10922485,10922486,10922487,10922488,10922489,10922490,10922491,10922492,10922493,10922494,10622095,10617157,10617486,10967152,10967153,10954192,10918066,10918212,10918213,10918214,10918215,10918216,10928301,10918409,10918410,10918411,10918412,10918413,10622905,8570023,10620126,10620127,10920804,10620320,8570288,10920887,8570333,8570381,10926190,10926191,10926192,10926203,10930655,10930656,10921295,10930726,10930727,10615849,10916388,10916389,10916390,10916391,10916392,10930867,10921584,10921585,10921586,10921587,10921588,10921589,10921590,10921591,10921592,10921593,10921594,10921595,10921810,10953180,10953181,10953182,10953183,10953184,10917285,10922361,10559401,10559402,10559403,10559404,10559405,10559406,10559407,10614374,8864399,8864429,8864452,9166079,9166080,9166081,9166082,9166083,7057634,10612223,10612224,10557499,10609367,7057890,7057892,8862266,10557581,10612584,10612641,10612664,10612682,7058202,7058203,7058204,7058205,7058206,7058207,7058208,7058209,7058210,7058211,7058297,10612865,10612874,10609930,10609931,10609932,10609933,10609934,8862805,8862806,7058703,7058704,10561532,4974229,4974527,4974528,9161688,9161689,9161690,9161691,10513741,10513742,10515776,10515777,10515778,10515779,10515780,10515781,10515782,10515783,10515784,10515785,10515786,10515787,10515788,10515789,10515790,10515791,10515792,10555865,10555866,10555867,10555868,10556086,10556087,10556088,10556091,10556092,10517000,10418530,10416556,10419584,4973603,9160912,9160913,7055337,7055338,6666303,6666327,8864930,8864937,8864940,8864984,4971618,6667074,6667135,10463950,10463951,10463952,8563300,8563301,8563302,8563303,8563304,8563305,8563306,8563307,8563308,8563309,10470132,6667776,6667964,6667965,10466773,10466774,10466775,10466776,10466777,10466778,10466779,10466780,10466781,10466782,10466783,10466784,10466785,10466786,10466787,10466788,10466789,8917880,8917881,8917882,8917883,8917884,10627962,10154577,10154578,10154579,10154580,10154581,10154582,10628103,10628188,10628189,10628190,10160698,10160699,10160700,10160701,10629686,10629818,10629819,10632084,10632085,10630082,10630104,10631870,10571142,10571143,10571326,10571327,10574528,10571548,10571549,10574753,10574754,10568760,10568761,10568762,10575005,10575008,10575009,10572021,10572022,10572023,10572024,10572025,10572026,10572036,10572042,10569138,10569139,10569140,10569141,10569142,10569143,10569144,10569145,10569146,10569147,10572336,10572337,10569393,10569394,10569395,10569396,10569397,10569398,10569399,10569611,10569612,10569990,10569991,10569992,10569993,10569994,10569995,10570185,10570186,10567937,10567938,10567939,10567940,10567941,10567942,10567943,10567944,10567945,10567946,10567947,10567948,10567949,10567950,10567951,10567952,10567953,10567954,10567955,10567956,10567957,10567958,10567959,10567960,10567961,10567962,10567963,10567964,10567965,10567966,10567967,10567968,10521319,10523658,10521999,10520092,10520093,10520094,10520918,10420492,10422979,10422980,10421067,10423098,10475210,10475211,10475322,10475323,10475324,10475325,10475326,10475327,10475328,10475329,10475330,10475331,10475332,10475333,10475334,10475335,10475336,10475337,10475338,10475339,10475340,10475341,10475342,10475343,10475344,10475345,10475346,10475347,10475568,10475569,10475570,10477583,10476826,10476827) 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'