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(8630751,8630755,8569558,3229175,3229176,8575082,7065983,8583479,8583480,8583481,8583482,8583483,7066166,7066167,7066168,8067938,8067939,8595091,8595263,8595264,8595265,8595266,8628814,8628815,8628816,8628817,7202586,7199247,7199248,7199249,7199250,7199251,7199252,7199253,7199254,7199255,7199256,7199257,7199258,7199259,7199260,7199261,7199262,7199263,7199264,7199265,7199266,10101484,10101494,8860427,8905873,3923473,3923474,3923475,3923476,3923477,3923478,10838802,10838803,8907461,8907462,8907463,8907464,8907465,7197897,7197898,8614616,8905066,10617211,10425936,10616201,10616202,10616203,10616204,10616205,10616206,10616207,10616208,10616209,10616210,10616211,10616212,10616213,10616214,10616215,10616216,10426435,10616217,10426436,10616218,10616219,10426437,10426438,10616220,10616221,10616222,10616223,10616224,10616225,10616226,10616227,10616228,10616229,10616230,10616231,10616232,10616233,10616234,10616235,10616236,10616237,10616238,10616239,10616240,10616241,10616242,10616243,10616244,10616245,10616246,10616247,10616248,10616249,10616250,10616251,10616252,10616253,10616254,10616255,10616256,10616257,10616258,10616259,10616260,10616261,10616262,10616263,10616264,10616265,10616266,10616267,10616268,10616269,10616270,10616271,10616272,10616273,10616274,10616275,10616276,10616277,10616278,10616279,10616280,10616281,10616282,10616283,10616284,10616285,10616286,10616287,10616288,10616289,10616290,10616291,10616292,10616293,10616294,10616295,10616296,10616297,10616298,10616299,10616300,10616301,10616302,10616303,10616304,10616305,10616306,10616307,10616308,10616309,10616310,10616311,10616312,10616313,10616314,10616315,10616316,10616317,10616318,10616319,10616320,10616321,10616322,10616323,10616324,10616325,10616326,10616327,10616328,10616329,10616330,10616331,10616332,10616333,10616334,10616335,10616336,10616337,10616338,10616339,10616340,10616341,10616342,10616343,10616344,10616345,10616346,10616347,10616348,10616349,10616350,10616351,10616352,10616353,10616354,10616355,10616356,10616357,10616358,10616359,10616360,10616361,10616362,10616363,10616364,10616365,10616366,10616367,10616368,10616369,10616370,10616371,10616372,10616373,10616374,10616375,10616376,10616377,10616378,10616379,10616380,10616381,10616382,10616383,10616384,10616385,10616386,10616387,10616388,10616389,10616390,10616391,10616392,10616393,10616394,10616395,10616396,10616397,10616398,10616399,10616400,10616401,10616402,10616403,10616404,10616405,10616406,10616407,10616408,10616409,10616410,10616411,10616412,10616413,10616414,10616415,10616416,10616417,10616418,10616419,10616420,10616421,10616422,10616423,10616424,10616425,10616426,10616427,10616428,10616429,10616430,10616431,10616432,10616433,10616434,10616435,10616436,10616437,10616438,10616439,10616440,10616441,10616442,10616443,10616444,10616445,10616446,10616447,10616448,10616449,10616450,10616451,10616452,10616453,10616454,10616455,10616456,10616457,10616458,10616459,10616460,10616461,8611330,8853356,10611373,10611374,10611375,10611376,10611377,10611378,10611379,10611380,10611381,10611382,10611383,10611384,10611385,10611386,10611387,10611388,10611389,10611390,10611391,10611392,10611393,10611394,10611395,10611396,10611397,10611398,10611399,10611400,10611401,10611402,10611403,10611404,10611405,10611406,10611407,10611408,10611409,10611410,10611411,10611412,10611413,10611414,10611415,10611416,10611417,10611418,10611419,10611420,10611421,10611422,10611423,10611424,10611425,10611426,10611427,10611428,10611429,10611430,10611431,10611432,10611433,10611434,10611435,10611436,10611437,10611438,10611439,10611440,10611441,10611442,10611443,10611444,10611445,10611446,10611447,10611448,10611449,10611450,10611451,10611452,10611453,10611454,10611455,10611456,10611457,10611458,10611459,10611460,10611461,10611462,10611463,10611464,10611465,10611466,10611467,10611468,10611469,10611470,10611471,10611472,10611473,10611474,10611475,10611476,10611477,10611478,10611479,10611480,10611481,10611482,10611483,10611484,10611485,10611486,10611487,10611488,10611489,10611490,10611491,10611492,10611493,10611494,10611495,10611496,10611497,10611498,10611499,10611500,10611501,10611502,10611503,10611504,10611505,10611506,10611507,10611508,10611509,10611510,10611511,10611512,10611513,10611514,10611515,10611516,10611517,10611518,10611519,10611520,10611521,10611522,10611523,10611524,10611525,10611526,10611527,10611528,10611529,10611530,10611531,10611532,10611533,10611534,10611535,10611536,10611537,10611538,10611539,10611540,10611541,10611542,10611543,10611544,10611545,10611546,10611547,10611548,10611549,10611550,10611551,10611552,10611553,10611554,10611555,10611556,10611557,10611558,10611559,10611560,10611561,10611562,10611563,10611564,10611565,10611566,10611567,10611568,10611569,10611570,10611571,10611572,10611573,10611574,10611575,10611576,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611591,10611592,10611593,10611594,10611595,10611596,10611597,10611598,10611599,10611600,10611601,10611602,10611603,10611604,10611605,10611606,10611607,10611608,10611609,10611610,10611611,10611612,10611613,10611614,10611615,10611616,10611617,10611618,10611619,10611620,10611621,10611622,10611623,10611624,10611625,10611626,10611627,10611628,10611629,10611630,10611631,10611632,10611633,10611634,10611635,10611636,10611637,10611638,10611639,10611640,10611641,10611642,10611643,10611644,10611645,10611646,10611647,10611648,10611649,10611650,10611651,10611652,10611653,10611654,10611655,10611656,10611657,10611658,10611659,10611660,10611661,10611662,10611663,10611664,10611665,10611666,10611667,10611668,10611669,10611670,10611671,10611672,10611673,10611674,10611675,10611676,10611677,10611678,10611679,10611680,10611681,10611682,10611683,10611684,10611685,10611686,10611687,10611688,10611689,10611690,10614849,10614850,8851124,8851125,8851126,8851127,8851128,8851129,8851130,8851131,8851132,8851133,8851134,8851135,8851136,8851137,8851138,8851139,8851140,8851141,8851142,8851143,8851144,8851145,8851146,8851147,8851148,8851149,8851150,8851151,8851152,8851153,8851154,8851155,8851156,8851157,8851158,8851159,8851160,8851161,8851162,8851163,8851164,8851165,8851166,8851167,8851168,8851169,8851170,8851171,8851172,8851173,8851174,8851175,8851176,8851177,8851178,8851179,8851180,8851181,8851182,8851183,8851184,8851185,8851186,8851187,8851188,8851189,8851190,8851191,8851192,8851193,8851194,8851195,8851196,8851197,8851198,8851199,8851200,8851201,8851202,8851203,8851204,8851205,8851206,8851207,8851208,8851209,8851210,8851211,8851212,8851213,8851214,8851215,8851216,8851217,8851218,8851219,8851220,8851221,8851222,8851223,8851224,8851225,8851226,8851227,8851228,8851229,8851230,8851231,8851232,8851233,8851234,8851235,8851236,8851237,8851238,8851239,8851240,8851241,8851242,8851243,8851244,8851245,8851246,8851247,8851248,8851249,8851250,8851251,8851252,8851253,8851254,8851255,8851256,8851257,8851258,8851259,8851260,8851261,8851262,8851263,8851264,8851265,8851266,8851267,8851268,8851269,8851270,8851271,8851272,8851273,8851274,8851275,8851276,8851277,8851278,8851279,8851280,8851281,8851282,8851283,8851284,8851285,8851286,8851287,8851288,8851289,8851290,8851291,8851292,8851293,8851294,8851295,8851296,8851297,8851298,8851299,8851300,8851301,8851302,8851303,8851304,8851305,8851306,8851307,8851308,8851309,8851310,8851311,8851312,8851313,8851314,8851315,8851316,8851317,8851318,8851319,8851320,8851321,8851322,8851323,8851324,8851325,8851326,8851327,8851328,8851329,8851330,8851331,8851332,8851333,8851334,8851335,8851336,8851337,8851338,8851339,8851340,8851341,8851342,8851343,8851344,8851345,8851346,8851347,8851348,8851349,8851350,8851351,8851352,8851353,8851354,8851355,8851356,10613743,10613744,10117806,10117807,10117808,10117809,10117810,10117811,9169749,10117970,10126077,10118552,8552179,9168348,9168509,7014226,7014227,7014228,7014229,9168668,6672910,10418795,10419796,10418796,10419797,10418797,10418798,10418799,10418800,10418801,10418802,10418803,10418804,10418805,6673092,6673093,6673094,6673095,6673096,6673097,6673098,6673099,10416043,10416044,10416045,8550007,8550008,8550010,8550083,8916773,10468332,10468333,10468334,10468335,9168274,9168275,9168276,9168277,9168278,10883838,10884012,10889320,10884490,10884491,10884492,10884493,10884494,10884495,10884496,10884497,10884498,10884499,10884500,10884501,10884508,10885461,10887524,10887562,10632107,10632108,10887775,10183898,10183899,10883092,10883093,10883094,10883095,10888300,10888301,10161947,10161965,10647460,10647461,10647462,10647463,10647464,10647465,10647466,10647467,10647468,10507931,10507932,10507933,10507934,10507935,10507936,10494354,10494355,10494356,10494357) 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'