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(11014746,7076079,10988843,10988844,10988845,10988846,10988850,10988851,10988852,10988853,7068172,7068189,7068190,7068249,7068250,7068292,7068323,7068347,7068361,7068362,10976046,10976047,10976048,10976049,10976050,10976051,10976052,10976053,10940195,10976300,10976301,10976302,7068626,7068627,7068639,10940339,10940341,7068761,11015521,10976582,7074046,10976760,10976761,11028811,11028812,11028813,11028814,11028815,11028816,11028817,11028818,11028819,11028820,11028821,11028822,11028823,10976897,10976898,10976899,7074292,7074293,8067631,7074671,7074674,7074698,7074758,10437623,7074837,7074879,10987654,7074972,8067908,7075021,10961717,10987750,10987751,10987752,10987753,10987754,10987755,10987756,10987757,10987758,10987759,10987760,10987761,10987762,10987763,11000811,10961815,11013824,11000826,11000827,7075145,8068056,8068065,10961891,10961892,10961893,10987985,11014128,11014129,11014130,10975138,10975139,10975140,10975141,10975142,10975143,10975144,10975145,10975146,10975147,11001279,11014312,11014366,10972895,7072257,10986032,10986033,10986034,7072375,10960076,10973161,10986216,10999369,7072848,7072936,7073091,7065157,8066295,8066303,8066350,8066351,11026310,11026311,11026312,11026313,11026314,11026315,11026316,11026317,11026318,11026319,11026320,11026321,11026322,11026323,11026324,11026325,11026326,11026327,11026328,11026329,11026330,11026331,10974383,10974384,10961412,10961413,8066747,8066748,8066749,7071201,7071202,7071211,10972016,10943029,11024100,11049339,10943102,10985167,10985168,10972185,7071738,10972445,7071793,7071794,8970237,10985537,10985585,10969779,10969780,10969781,10969782,10969894,10969895,10969896,10969897,10969898,10969899,10969900,10969901,10969902,10969903,10969904,10940844,10940850,10940851,10940866,10969946,7069330,10970070,10970071,10970110,10970111,10970112,7069469,7069471,7069472,7069478,11022296,11022297,11022298,11022299,11022300,11022301,11022302,11022303,3656252,10941351,3656382,10996532,10970538,10970539,10970540,10970590,10970591,10970592,11022711,11022712,11022713,11022714,11022832,11022833,11022834,11022835,10970892,10970893,10970894,10970895,10970896,10970897,10970898,11023004,11023005,11023006,10971110,10971131,7070465,10971171,11023211,11023212,11023374,11023375,11023376,11023395,10942362,8073527,10997489,10997490,10997491,10997492,10997493,10997494,10997495,10997496,10971553,10971616,10971617,10971618,10954629,10918580,10923610,10923611,10923612,10923637,10923700,10623296,10623297,10623298,10623299,10923817,10954987,10923863,10923933,10923934,10924021,10968180,10919146,10924245,10924290,10924301,10919423,10919424,10919425,10919430,10968623,10968634,10968882,10968883,10968884,10924750,10924751,10924755,10924756,10924757,10924761,10924766,10924767,10919773,10919774,10919775,10919776,10919780,10919781,10919789,10919790,10924837,10924838,10924839,10924840,10924841,10924842,10924843,10924844,10924845,10924846,10924847,10924848,10924849,10924850,10919895,10919896,10919897,10919937,10924956,10924957,10924958,10924959,10924960,10924961,10924962,10924963,10924964,10924965,10924966,10925078,10925079,10925080,10925081,10925082,10925083,10925084,10925085,10925086,10925087,10925088,10925089,10925090,10925091,10925092,10925093,10925094,10925095,10925096,10925097,11021254,11021255,11021256,11021257,11021258,11021259,11021260,11021261,11021262,11021263,11021264,11021265,11021266,11021267,11021268,11021269,11021270,11021271,11021272,11021273,11021274,11021275,11021276,11021277,11021278,11021279,10925202,10925429,10925430,10925431,10969581,10969586,10969587,10920451,10922633,10922634,10922635,10922636,10922665,10922666,10922667,10922684,10922699,10922749,10922750,10922751,10922752,10922810,10979958,10922811,10979959,10922812,10979960,10922849,10922850,10922851,10922852,10922853,10922854,10922855,10922858,10922884,10922885,10922887,10922937,10922981,10922983,10918097,10923112,10923120,10923121,10923122,10923137,10923138,10923139,10923140,10923141,10923142,10923143,11019301,10923172,10923173,10923194,10923195,10923206,10923223,10918245,10918248,10923267,10923329,10923330,10923331,10923332,10923385,10923392,10622890,10622912,10918445,10923467,10925517,10920647,10920648,8570139,10615200,10920720,10920724,10920725,10920726,10920834,10920842,10925848,10925849,10925871,10925872,8570353,10920943,10921165,10921166,10921167,10921168,10921169,10620660,10615837,10930959,10921664,10916801,10916802,10978995,10921849,11005027,10616460,11018170,11018171,10922027,11018242,11018243,11018244,10992305,11005451,10917358,7059465,7059466,9189676,9189677,10611653,10611656,10611657,10611658,10611659,10611660,10611661,9190211,9190212,9190213,10611969,10557250,10557251,10557252,10557253,10557254,10557256,10557259,10557270,10557271,10557272,10557285,10557286,10557420,9171687,10563788,7058191,7058192,7058210,9188045,9188046,9188047,9188048,9188049,9188091,10563910,10563911,10563912,10563913,10563914,10563915,10563916,10563920,10563921,10563922,10612856,10564118,10564119,10564120,10564121,10564122,10564123,10610041,7058686,10564386,10564387,10564388,10564389,10564390,10564396,10564398,10564399,10564400,10564401,10564402,10564403,10564404,10564405,10564406,10564407,10564408,10564409,10564411,10564423,10564424,10564425,7058852,7058865,10561558,7058928,8863369,8863398,7059067,7059068,7059075,7059078,7059079,7059080,10613605,7059184,7059187,7059241,10610749,7059281,10610919,7059455,7059457,9177300,9177310,9177326,10555161,9177481,10513475,10513476,10513477,10513480,10513481,10513482,9177718,4974583,10513545,9177732,10513546,10513547,7055900,4974781,4974782,9177978,9177979,4974847,7056255,7056288,9178256,10556197,10556205,10556208,10556619,10556620,10556621,10556622,10556623,10556891,9171216,7057410,7057411,7057412,10416241,9160339,9184457,9184458,9176579,9176591,9176592,10417795,9176944,9185093,9177170,10417157,9177275,8864827,9182531,10467108,10467109,10467110,10467111,9182535,10467113,10467114,10467115,10467116,10467117,10467119,10467120,10467123,10467124,10467129,10467130,10467131,10467132,10467133,10467134,10467135,10467136,10467143,10467145,10471206,10471241,4971523,4971631,9174863,9174867,10469614,4972088,9183303,9183304,9183305,8917227,10470334,10470351,10470352,10470366,10470422,10470423,10470425,10470427,10470428,9168293,10174529,10174730,10165315,10170867,10171005,10629513,10629554,10629881,10629957,10629958,10626983,10626993,10168673,10168674,10168675,10168676,10168677,10173994,10174014,10174038,10627701,10166553,10166626,10166643,10166644,10166645,10166674,10166675,10166676,10166677,10166678,10166679,10630237,10166915,10166919,10166920,10630433,10630436,10630438,10630439,10630440,10630441,10630445,10630446,10630447,10630448,10630449,10630450,10630451,10630452,10630453,10630454,10630481,10630482,10630488,10630585,10630586,10630587,10630588,10630589,10630590,10630591,10630592,10167151,10167152,10630643,10630644,10167236,10167267,10167321,10167322,10630803,10630804,10172361,10172379,10172380,10630865,10630866,10630872,10630873,10630874,10630875,10630876,10630877,10630881,10630882,10167430,10167441,10630939,10630940,10167473,10630975,10630976,10631015,10631016,10631017,10167555,10631036,10631221,10162841,10172879,10172880,10168005,10626531,10626532,10168328,10168329,10168330,10168331,10168365,10168366,10168477,10577162,10574290,10574291,10574292,10574293,10574294,10574295,10571599,10571600,10571601,10571602,10580697,10580698,10580715,10580716,10577717,10577718,10568840,10568845,10568849,10568850,10568852,10580956,10580963,10580984,10580985,10580986,10580991,10580997,10581004,10581005,10575066,10575067,10575068,10575069,10575070,10581127,10572136,10572157,10572158,10581162,10581208,10581209,10581210,10581211,10569256,10569257,10569258,10569259,10581260,10569260,10581261,10569261,10581262,10569262,10581263,10569263,10581264,10581265,10578277,10575334,10575335,10575336,10575337,10575338,10575339,10575340,10575341,10575342,10575343,10575344,10581345,10575345,10575346,10572349,10572350,10578363,10572393,10572394,10581395,10572395,10581503,10581504,10575510,10578580,10581588,10581589,10581645,10581654,10581675,10581676,10581677,10581678,10581679,10581680,10581681,10581682,10581683,10578683,10575730,10575731,10581738,10581739,10581747,10581769,10581823,10581824,10581825,10581826,10581827,10581877,10581878,10581879,10581880,10578954,10578955,10578956,10570029,10576096,10576097,10576098,10579197,10579198,10579199,10579200,10579201,10579545,10579546,10579547,10579548,10576914,10576916,10570965,10570966,10577067,10577077,10577080,10577082,10523124,10523125,10523126,10523233,10523234,10523265,10523266,10525315,10527762,10527774,10527809,10524343,10524344,10528738,10528815,10422983,10480928,10481017,10481036,10481037,10479231,10481531,10481547,10481565,10481566,10479777,10479786,10481788,10479869,10479870,10479871,10479872,10478201,10480260,10478263,10478723,10478724,10478725,10478734,10478741,10478742,10478743) 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'