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(10943430,11014747,11014748,11014749,11014750,11014751,11014752,7068366,4970700,7068709,7068710,10963400,10963401,10963482,10963483,10963484,10944288,8067473,8067501,8067502,8067503,7074693,7074858,7074859,11013811,11014149,11014150,11014151,11014152,11014153,11014154,11014155,11014156,11014157,11014158,11014159,11014160,11014161,11014162,11014163,11012215,11012271,11012272,8065866,11012786,11012787,11012788,11012789,11012790,11012791,11012792,11012793,11012794,11012795,11012796,11012797,11012798,11012799,11012800,11012801,11012802,11012803,11012804,11026468,11026469,11026470,11026471,11026472,11026473,11026474,11026475,11026476,11026477,11026478,11026479,11026480,11026481,11026482,11026483,11026484,11026485,11026486,11026487,11026488,11026489,11026490,11026491,11026492,11026493,11026494,11026495,11026496,11026497,11026498,11026499,11026500,11026501,11026502,11026503,11026504,11026505,11026506,11026507,11026508,11026509,11026510,11026511,11026512,11026513,11026514,11026515,11026516,11026517,11026518,11026519,11026520,11026521,11026522,11026523,11026524,11026525,11026526,11026527,11026528,11026529,11026530,11026531,11026532,11026533,11026534,11026535,11026536,11026537,11026538,11026539,11026540,11026541,11026542,11026543,11026544,11026545,11026546,11026547,11026548,11026549,11026550,11026551,11026552,11026553,11026554,11026555,11026556,11026557,11026558,11026559,11026560,11026561,11026562,11026563,11026564,11026565,11026566,11026567,11026568,11026569,11026570,11026571,11026572,11026573,11026574,11026575,11026576,11026577,11026578,11023758,11023759,11023760,11023761,10943149,10943251,7071746,7071747,11009525,10997014,10997015,10942031,10942032,10997159,10997160,10997161,10997162,10997163,10997164,8073538,11006641,11006642,11006643,11006644,11006645,11006646,11006647,11006648,11006649,11006650,11006651,11006652,11006653,11006654,11006655,11006656,11006657,11006658,11006659,11006660,11006661,11006662,11006663,11006664,11006665,11006666,11006667,11006668,11006669,11006670,11006671,11006672,11006673,11006674,11006675,11006676,11006677,11006678,11006679,11006680,11006681,11006682,11006683,11006721,11006722,11006723,11006724,11006725,11006726,11006727,11006728,11006729,11006730,11006731,11006732,11006733,11006734,11006735,11006736,11006737,11006738,11006739,11006740,11006741,11006742,11006743,11006744,11006745,11006746,11006747,11006748,11006749,11006750,11006751,11006752,11006753,11006754,11006755,11006756,11006757,11006758,11006759,11006760,11006761,11006762,11006763,11006764,11006765,11006766,11006767,11006768,11006769,11006770,11006771,11006772,11006773,11006774,11006775,11006806,11006807,11006808,11006809,11006810,11006811,11006812,11006813,11006814,11006815,11006816,11006817,11006818,11006819,11006820,11006821,11006822,11006823,11006824,11006825,11006826,11006827,11006828,11006829,11006830,11006831,11006832,11006833,11006834,11006835,11006836,11006837,11006838,10918690,10918691,11006839,10918692,11006840,10918693,11006841,11006842,10918694,11006843,10918695,11006844,11006845,11006846,11006847,11006848,10967871,10967872,10967873,11020094,11020095,11020096,11020097,11020098,11020099,11020100,10919147,10919148,10919149,10919150,10919151,10919152,10919153,10919154,10919155,10919156,10919157,10919158,10919159,10919160,10919161,10919162,10919163,10919164,10919165,10618975,10994638,10994639,10994640,10619124,10619125,10981863,11007924,11007925,11007926,10619354,11008028,11008029,11021317,11021318,11021319,11021320,11021321,11021322,11021323,11021324,11021325,11021326,11021327,11021328,11021329,11021330,11021331,11021332,11021333,11021334,11021335,11021336,11021337,11021338,11021339,11021340,11021341,11021342,11021343,11021344,11021345,11021346,11021347,11021348,11021349,11021350,11021351,11021352,11021353,11021354,11021355,11021356,11021357,11021358,11021359,11021360,11021361,11021362,11021363,11021364,11021365,11021366,11021367,11021368,11021369,11021370,11021371,11021372,11021373,11021374,11021375,10619894,10920456,10920457,10920458,10920459,10920460,10920461,10920462,10920463,10920464,10920465,10920466,10920467,10920468,10920469,10920470,10920471,11005968,11005969,11005970,11005971,11005988,10622397,11006059,10918110,10918111,10918112,10918113,10918114,11006386,11006387,11006388,11006389,11006390,11006391,11006392,10993403,10993404,10993405,10954586,11006606,11006607,11006608,11006609,11006610,10920472,10920473,10920474,10920475,10920476,10920477,10920478,10920479,10920480,10920481,10920482,10920483,10920484,10920485,10920486,10920487,10920488,10920489,10920490,10920491,10920492,10920493,10920494,8570293,10616044,10978796,10978901,10916829,10916830,10916831,10916832,10916833,10916834,10916835,10916836,10916837,10916838,10916839,10916840,10916841,10916842,10916843,10916844,10916845,10916846,10916847,10916848,10916849,10916850,10916851,10916852,10916853,10916854,10916855,10916856,10916857,10916858,10916859,10916860,10916861,10916862,10916863,10916864,10916865,10916866,10916867,10916868,10916869,10916870,10916871,10916872,10916873,10916874,10916875,10916876,10916877,10916878,10916879,10916880,10916881,10916882,10916883,10916884,10916885,10916886,10916887,10916888,10916889,10916890,10916891,10916892,10916893,10916894,10916895,10916896,10916897,10916898,10916899,11005048,10916900,11005049,10916901,11005050,10916902,11005051,10916903,11005052,10916904,11005053,10916905,11005054,10916906,11005055,10916907,11005056,10916908,11005057,10916909,11005058,10916910,11005059,10916911,11005060,10916912,11005061,10916913,11005062,10916914,11005063,10916915,11005064,10916916,10916917,10916918,10916919,10916920,10916921,10916922,11018268,11018269,11018270,11018271,11018272,11018273,11018274,11018275,11018276,11018277,11018278,11018279,11018280,11018281,11018282,11018283,11018284,11018285,11018286,11018287,11018288,11018289,11018290,11018291,11018292,11018293,11018294,11018295,11018296,11018297,11018298,11018299,11018300,11018301,11018302,11018303,11018304,11018305,11018306,11018307,11018308,11018309,11018310,11018311,11018312,11018313,11018314,11018315,11018316,11018317,11018318,11018319,11018320,11018321,11018322,11018323,11018324,11018325,11018326,11018327,11018328,11018329,11018330,11018331,11018332,11018333,11018334,11018335,11018336,11018337,11018338,11018339,11018340,11018341,11018342,11018343,11018344,11018345,11018346,11018347,11018348,11018349,11018350,11018351,11018352,11018353,11018354,11018355,11018356,11018357,11018358,11018359,11018360,11018361,11018362,11018363,11018364,11018365,11018366,11018367,11018368,11018369,11018370,11018371,11018372,11018373,11018374,11018375,11018376,11018377,11018378,11018379,11018380,11018381,11018382,11018383,11018384,11018385,11018386,11018387,11018388,11018389,11018390,11018391,11018392,11018393,11018394,11018395,11018396,11018397,11018398,11018399,11018400,11018401,11018402,11018403,11018404,11018405,11018406,11018407,11018408,11018409,11018410,11018411,11018412,11018413,11018414,11018415,11018416,11018417,11018418,11018419,11018420,11018421,11018422,11018423,11018424,11018425,11018426,11018427,11018428,10616943,10614552,10614553,9173907,9173908,10612500,10609843,10612987,10612988,10612989,9180483,9180698,10613368,8863294,10610469,8863665,10610930,10515116,10513141,4974258,4974259,4974586,4974587,4974588,4974589,4974590,4974591,4974592,9162086,10514886,10514887,10514888,10514889,10516982,9160320,10419462,8864927,8865252,6667205,9175979,10470770,9176234,10629531,10629532,10626995,10167120,10630630,10630635,10630636,10630637,10630644,10167203,10167207,10631327,10574299,10574300,10574301,10574302,10574303,10574304,10574305,10574306,10574307,10574308,10574309,10574310,10574311,10574312,10574313,10574314,10574315,10574316,10574317,10574318,10574319,10574320,10574321,10574322,10574323,10574324,10574325,10574326,10574327,10574328,10574329,10574330,10574331,10574332,10574333,10574334,10574335,10574336,10574337,10574338,10574339,10574340,10574341,10574342,10574343,10574344,10574345,10574346,10574347,10574348,10574349,10574350,10574351,10574352,10574353,10568862,10568863,10568864,10568865,10568866,10568867,10568868,10568869,10568870,10568871,10568872,10568873,10568874,10568875,10568876,10568877,10568878,10568879,10568880,10568881,10575086,10575087,10575088,10575089,10575090,10575091,10575092,10575093,10575094,10575095,10575096,10572184,10572185,10572186,10572187,10572188,10572189,10572190,10572191,10572192,10572193,10572194,10572195,10572196,10572197,10572198,10572199,10572200,10572201,10572202,10572203,10572204,10572205,10572206,10572207,10572208,10572209,10572210,10572211,10572212,10572213,10575763,10575764,10575765,10575766,10576087,10521654,10527835,10527836,10524003,10528118,10522118,10528119,10528120,10528121,10528122,10528123,10528124,10528125,10528126,10528127,10528128,10528129,10528130,10528131,10528132,10528133,10522318,10522323,10522441,10522442,10522443,10522444,10522445,10522446,10522447,10522448,10522449,10522450,10522452,10522453,10522454,10522456,10425087,10478683) 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'