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(4970159,4970160,4970161,4970162,4970163,4970164,4970450,4970467,4970468,4970485,4970486,4970528,4970529,4970530,4970533,4970534,4970636,4970637,4970638,4970643,4970644,4970672,4970695,4970697,4970704,4970840,4970848,4970849,4970850,4970851,4970858,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971007,4971008,4971009,4971051,4971052,4971053,4971058,4971066,4971067,4971068,4971069,4971081,4971088,4971089,4971098,4971099,4971100,4971104,4971105,4971106,4971127,4971136,4971144,4968335,4968472,4968473,4968478,4968479,4968480,4968508,4968509,4968510,4968511,4968512,4968513,4968650,4968655,4968657,4968658,4968659,4968660,4968670,4968671,4968872,4968972,4968973,4968974,4968975,4969130,4969131,4969177,4969207,4969208,4969252,4969253,4969254,4969255,4969256,4969258,4969259,4969260,4969263,4969264,4969265,4969266,4969267,4969268,4969269,4969270,4969271,4969272,4969273,4969274,4969275,4969276,4969277,4969278,4969279,4969280,4969281,4969328,4969329,4969347,4969381,4969403,4969404,4969405,4969406,4969407,4969429,4969430,4969456,4969457,4969458,4969459,4969460,4969477,4969493,4969498,4969499,4969516,4969523,4969547,4969559,4969560,4969561,4969562,4969822,4969823,4969824,4969825,4969826,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969834,4969835,4969836,4969837,4969838,4969839,4969874,4969875,4969876,4969877,4970154,4970155,4970156,4970157,4970158,8074694,8074695,8074696,8074697,8074698,8074737,8074738,8074739,8074740,8074741,8074782,8074783,8074784,8074785,8074786,8074824,8074825,8074826,8074827,8074828,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074877,8074878,8074879,8074880,8074881,8074882,8074883,8074884,8074885,8074886,8074887,8074888,8074889,8074890,8074891,8074892,8074893,8074894,8074895,8074896,8074897,8074898,8074899,8074900,8074901,8074912,8074913,8074914,8074915,8074916,8074956,8074957,8074958,8074959,8074960,8075000,8075001,8075002,8075003,8075004,8075046,8075047,8075048,8075049,8075050,8075092,8075093,8075094,8075095,8075096,8075097,8075138,8075139,8075140,8075141,8075142,8075181,8075182,8075183,8075184,8075185,8075218,8075219,8075225,8075235,8075236,8075247,8075248,8075250,8075258,8075276,8075281,8075283,8075302,8075305,8075312,8075358,8075521,8075523,8075533,4967077,4967078,4967079,4967080,4967081,4967099,4967100,4967101,4967102,4967156,4967157,4967158,4967308,4967309,4967310,4967311,4967312,4967416,4967435,4967436,4967713,4967714,4967777,4967778,4967779,4967780,4967781,4967906,4967907,4967908,4967913,4967914,4968018,4968069,4968070,4968074,4968154,4968155,8073713,8073714,8073715,8073716,8073717,8073718,8073719,8073767,8073768,8073769,8073770,8073771,8073772,8073773,8073816,8073817,8073818,8073819,8073820,8073821,8073822,8073865,8073866,8073867,8073868,8073869,8073870,8073910,8073911,8073912,8073913,8073914,8073915,8073957,8073958,8073959,8073960,8073961,8074002,8074003,8074004,8074005,8074006,8074007,8074048,8074049,8074050,8074051,8074052,8074091,8074092,8074093,8074094,8074095,8074133,8074134,8074135,8074136,8074137,8074177,8074178,8074179,8074180,8074181,8074212,8074213,8074214,8074215,8074216,8074217,8074218,8074219,8074220,8074221,8074222,8074223,8074224,8074225,8074226,8074227,8074228,8074229,8074230,8074231,8074232,8074233,8074234,8074235,8074236,8074237,8074238,8074239,8074240,8074241,8074242,8074243,8074244,8074245,8074246,8074247,8074248,8074249,8074250,8074251,8074252,8074253,8074254,8074255,8074256,8074257,8074258,8074259,8074260,8074261,8074262,8074263,8074264,8074265,8074266,8074267,8074268,8074269,8074270,8074271,8074272,8074273,8074274,8074275,8074276,8074277,8074278,8074279,8074280,8074281,8074282,8074283,8074284,8074285,8074286,8074287,8074288,8074289,8074290,8074291,8074292,8074293,8074294,8074295,8074296,8074297,8074298,8074299,8074300,8074301,8074302,8074303,8074304,8074305,8074306,8074307,8074308,8074309,8074310,8074311,8074312,8074313,8074314,8074315,8074316,8074317,8074318,8074319,8074320,8074321,8074322,8074323,8074324,8074325,8074326,8074327,8074328,8074329,8074330,8074331,8074332,8074333,8074334,8074335,8074336,8074337,8074338,8074339,8074340,8074341,8074342,8074343,8074344,8074345,8074346,8074347,8074348,8074349,8074350,8074351,8074352,8074353,8074354,8074355,8074356,8074357,8074358,8074359,8074360,8074361,8074362,8074363,8074364,8074365,8074366,8074367,8074368,8074369,8074370,8074371,8074372,8074373,8074374,8074375,8074376,8074377,8074378,8074379,8074380,8074381,8074382,8074383,8074384,8074385,8074386,8074387,8074388,8074389,8074390,8074391,8074392,8074393,8074394,8074395,8074396,8074397,8074398,8074399,8074400,8074401,8074402,8074403,8074404,8074405,8074406,8074407,8074408,8074409,8074410,8074411,8074412,8074413,8074414,8074415,8074416,8074417,8074418,8074419,8074420,8074421,8074422,8074423,8074424,8074425,8074426,8074427,8074428,8074429,8074430,8074431,8074432,8074433,8074434,8074435,8074436,8074437,8074438,8074439,8074440,8074441,8074442,8074443,8074444,8074445,8074446,8074447,8074448,8074449,8074450,8074451,8074452,8074453,8074454,8074455,8074456,8074457,8074458,8074459,8074460,8074461,8074462,8074463,8074464,8074465,8074466,8074467,8074468,8074469,8074470,8074471,8074472,8074473,8074474,8074475,8074476,8074477,8074478,8074479,8074480,8074481,8074482,8074483,8074484,8074485,8074486,8074487,8074488,8074489,8074490,8074491,8074492,8074493,8074494,8074495,8074496,8074497,8074498,8074511,8074512,8074513,8074514,8074515,8074516,8074559,8074560,8074561,8074562,8074563,8074564,8074606,8074607,8074608,8074609,8074610,8074650,8074651,8074652,8074653,8074654,8071680,8071685,8071689,8071693,8071696,8071697,8071698,8071699,8071700,8071701,8071710,8071715,8071720,8071724,8071728,8071731,8071734,8071735,8071736,8071737,8071738,8071745,8071750,8071754,8071758,8071761,8071762,8071763,8071764,8071765,8071766,8071775,8071780,8071785,8071789,8071793,8071796,8071799,8071800,8071801,8071802,8071803,8071810,8071815,8071819,8071824,8071826,8071827,8071828,8071829,8071830,8071831,8071840,8071845,8071850,8071854,8071858,8071861,8071864,8071865,8071866,8071867,8071868,8071875,8071880,8071884,8071888,8071891,8071892,8071893,8071894,8071895,8071896,8071905,8071910,8071915,8071919,8071923,8071926,8071929,8071930,8071931,8071932,8071933,8071940,8071945,8071949,8071953,8071956,8071957,8071958,8071959,8071960,8071961,8071970,8071975,8071980,8071984,8071988,8071991,8071994,8071995,8071996,8071997,8071998,8072005,8072010,8072014,8072018,8072021,8072022,8072023,8072024,8072025,8072026,8072035,8072040,8072045,8072049,8072053,8072056,8072059,8072060,8072061,8072062,8072063,8072070,8072075,8072079,8072083,8072086,8072087,8072088,8072089,8072090,8072091,8072100,8072105,8072110,8072114,8072118,8072121,8072124,8072125,8072126,8072127,8072128,8072135,8072140,8072144,8072148,8072151,8072152,8072153,8072154,8072155,8072156,8072165,8072170,8072175,8072179,8072183,8072186,8072189,8072190,8072191,8072192,8072193,8072200,8072205,8072209,8072213,8072216,8072217,8072218,8072219,8072220,8072221,8072230,8072235,8072240,8072244,8072248,8072251,8072254,8072255,8072256,8072257,8072258,8072265,8072270,8072274,8072278,8072281,8072282,8072283,8072284,8072285,8072286,8072306,8072311,8072554,8072555,8072586,8072587,8072592,8072597,8072602,8072607,8072612,8072618,8072658,8072659,8072660,8072661,8072662,8072713,8072714,8072715,8072716,8072717,8072753,8072754,8072755,8072756,8072757,8072758,8072759,8072760,8072761,8072762,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8072817,8072818,8072819,8072820,8072821,8072822,8072823,8072824,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,8072843,8072844,8072853,8072854,8072855,8072856,8072857,8072858,8072859) 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'