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(10493344,10493345,10493346,10493347,10493384,10493385,10493386,10493387,10493388,10493389,10872390,10872391,10872392,10872393,10872394,10697698,10697699,10697700,10697701,10697702,10697703,10697704,10697705,10697706,10697707,10697708,10697709,10697710,10697711,10697712,10697713,10697714,10697715,10697716,10697717,10697718,10697719,10697720,10697721,10697722,10697723,10697724,10697725,10697726,10697727,10697728,10697729,10697730,10697731,10697732,10697733,10697734,10697735,10697736,10697737,10697738,10697739,10697740,10697741,10697742,10697743,10697744,10697745,10697746,10697747,10697748,10697749,10697750,10697751,10697752,10697753,10697754,10697755,10697756,10697757,10697758,10697759,10697760,10697761,10697762,10697763,10697764,10697765,10697766,10697767,10697768,10697769,10697770,10697771,10697772,10697773,10697774,10697775,10697776,10697777,10697778,10697779,10697780,10697781,10697782,10697783,10697784,10697785,10697786,10697787,10697788,10697789,10697790,10698025,10845764,10845765,10845766,10845767,10845768,10845769,10845770,10845771,10845772,10845773,10845774,10845775,10845776,10845777,10845778,10845779,10845780,10845781,10845782,10845783,10845784,10845785,10845786,10845787,10845788,10845789,10845790,10845791,10845792,10845793,10845794,10845795,10845796,10845797,10845798,10845799,10845800,10845801,10845802,10845803,10845804,10845805,10493176,10493177,10493178,10493179,10493245,10493246,10493247,10493256,10493257,10493258,10493259,10493260,10845890,10493261,10493262,10493263,10493264,10493265,10493266,10493267,10493268,10493269,10493270,10493271,10493272,10493273,10493274,10493275,10493276,10493277,10493278,10493279,10493280,10493281,10493282,10493283,10493284,10493285,10493286,10493287,10493288,10493289,10493290,10493291,10493292,10493293,10493294,10493295,10493336,10493337,10493338,10493339,10493340,10493341,10493342,10493343,10568109,10568131,10568132,10568133,10568134,10568135,10568136,10568137,10568138,10568139,10568140,10568141,10568142,10568143,10568144,10568145,10568146,10568147,10568148,10568149,10568150,10568151,10568152,10568153,10568154,10568155,10568156,10568157,10568158,10568159,10568160,10568161,10568162,10568163,10568164,10568165,10568166,10568167,10568168,10568169,10568170,10568171,10568172,10568173,10568174,10568175,10568176,10568177,10568178,10568179,10568180,10568181,10568182,10568183,10568184,10568185,10568186,10568187,10568188,10568189,10568190,10568191,10568192,10568193,10568194,10568195,10568196,10568197,10568198,10568199,10568200,10568201,10568202,10568203,10568204,10568205,10568206,10568207,10568208,10568209,10568210,10568211,10568212,10568213,10568214,10568215,10568216,10568217,10568218,10568219,10568220,10568221,10568222,10568223,10568224,10568225,10568226,10568227,10568228,10568229,10568230,10568231,10568232,10568233,10568234,10568235,10568236,10568237,10568238,10568239,10568240,10568241,10568242,10568243,10568244,10568245,10568246,10568247,10568248,10568249,10568250,10568251,10568252,10568253,10568254,10568255,10568256,10568257,10568258,10568259,10568260,10568261,10568262,10568263,10568264,10568265,10568266,10568267,10568268,10568269,10568270,10568271,10568272,10568273,10568274,10568275,10568276,10568277,10568278,10568279,10568280,10568281,10568282,10568283,10568284,10568285,10568286,10568287,10568288,10568289,10568290,10568291,10568292,10568293,10568454,10568455,10568456,10568473,10568474,10568475,10568476,10568522,10568523,10568524,10568525,10568526,10629455,10629456,10629457,10629458,10629459,10629460,10629461,10629462,10629463,10629464,10629465,10629466,10629467,10629468,10629469,10629470,10652807,10652808,10652809,10652810,10652811,10652812,10652813,10652814,10652815,10652816,10652817,10652818,10652819,10652820,10652821,10652822,10652823,10652824,10652825,8864653,8864654,8864655,8864656,8864657,8864658,8864659,8864660,8864661,8864662,8864663,8864664,8864665,8864666,8864667,8864668,8864669,8864670,10629263,10629264,10629265,10629266,10629267,10629268,10629269,10629270,10629271,10629272,10629273,10629274,10629275,10629276,10629277,10629278,10629279,10629280,10629281,10629282,10629283,10629284,10629285,10629286,10629287,10629288,10629289,10629290,10629291,10629292,10629293,10629294,10629295,10629296,10629297,10629298,10629299,10629300,10629301,10629302,10629303,10629304,10629305,10629306,10629307,10629308,10629309,10629310,10629311,10629312,10629313,10629314,10629315,10629316,10629317,10629318,10629319,10629320,10629321,10629322,10629323,10629324,10629325,10629326,10715146,8854921,8854922,8854923,10427335,10427336,10427337,10427338,10427339,10427340,10427341,10427342,10427343,8552487,8552488,8552489,8552490,8559225,8559311,8559312,8559317,8559328,8559329,8559330,8559331,8559332,8559333,8559334,8559335,8559336,8559337,8559338,8559339,8559340,8559341,8559342,8559343,8559344,8559345,8559346,8559347,8559348,8559349,8559350,8559351,8559352,8559353,8559354,8559355,8559356,8559357,8559358,8559359,8559360,8559361,8559362,8559363,8559364,8559365,8559366,8559367,8559368,8559369,8559370,8559371,8559372,8559373,8559374,8559375,8559376,8559377,8559423,8559424,8559460,8559461,8559462,10176985,10176986,10176987,10176988,10176989,10176990,10176991,10176992,10176993,10176994,10176995,10176996,10176997,10176998,10176999,10177000,10177001,10177002,10177003,10177004,10177005,10177006,10177007,10177008,10177009,10177010,10177011,10177012,10177013,10177014,10177015,10177016,10177017,10177018,10177019,10177020,10177021,10177022,10177023,10177024,10177025,10177026,10177027,10177028,10177029,10177030,10177031,10177032,10177033,10177034,10177035,10177036,10177037,10177038,7058606,7058607,7058608,7058609,7058610,7058611,7058612,7058613,7058614,7058615,7058616,7058617,7058618,7058619,7058653,7058654,7058655,10433173,10433174,10433175,10423526,10423527,10423528,10423529,10423530,10423531,10423532,10423533,10423534,10423535,10423536,10423537,10423538,10423539,10423540,10423541,10423542,10423543,10428381,10428382,10428383,10428384,10251435,10251436,10251437,10251438,10251439,10251440,10251441,10251442,10251443,10251444,10251445,10251446,10251447,10251448,10251449,10251450,10251451,10251452,10251453,10251454,10251455,10251456,10251587,10251588,10251589,10251590,8969163,8969164,8969165,9199627,9199628,9199629,9199630,9199631,9199632,9199633,9199634,9199635,9199636,9199637,9199638,9199639,9199640,9199641,9199642,9199643,9199644,9199645,9199646,9199647,9199648,9199649,9199650,9199651,9199652,9199653,9199654,9199655,9199656,9199657,9199658,9199659,9199660,9199661,9199662,9199663,9199664,9199665,9199666,9199667,9199668,9199669,9199670,9199671,9199672,9199673,9199674,9199675,9199676,9199677,9199678,9199679,9199680,9199681,9199682,9199683,9199684,9199685,9199686,9199687,9199688,9199689,9199690,9199691,9199692,9199693,9199694,9199695,9199696,9199697,9199698,9199699,9199700,9199701,9199702,9199703,9199704,9199705,9199706,9199707,9199708,9199709,9199710,9199711,9199712,9199713,9199714,9199715,9199716,9199717,9199718,9199719,9199720,9199721,9199722,8910839,8910840,9217690,9217691,10103899,10103900,9915704,9915705,9915709,9915710,9915711,9915712,9915713,9915714,9915715,9915717,9915718,9915719,10099175,10099176,10099177,10099178,10099179,8584031,8570266,8565212,8592986,8592987,8592988,8837020,8837021,8837022,8568765,8568770,8568771,8568772,8568773,8568774,8568775,8568776,8568777,8568778,8568779,8576476,8576477,8576478,8576479,8576480,8576481,8576482,8576483,8576505,8576506,8576507,8576524,8619088,8619090,8619091,8619133,8563164,8563165,7073725,7073824,7150924,7150925,7150926,7073851,7073852,7073853,7073854,7073855,7073856,7073857,7073858,7073859,7073860,7073861,7073862,7073863,7073864,7073865,7073866,8067449,8067450,7156554,7156555,7156556,6679350,6679351,6679352,6679353,7001262,7001263,7001264,7001265,7001266,7001267,7001268,3656111,3656112,3656113,3656114,3656115,3656116,3656117,3656118,3656119,3656120,3656121,3656122,976325,6000200,6000201,6000202,6000203,6000204,6000205,6000206,6000207,6000208,6000209,6000210,6000211,6000212,6000213,6000248,6000249,6000250,6000251,6000258,6000259,6000272,6000273,6000274,6000275,6000276,6000277,6000278,4974049,4974050,4974051,4974052,4974053,4974054,4974055,4974056,4974057,4974058,4974059,4974060,4974061,4974062,4974063,4974064,4974065,4974066,4974067,4974068,4974069,4974070,4974071,4974072,4974073,4974074,4974075,4974076,4974077,4974078,4974079,4974080,4974081,4974082,4974083,4974084,4974085,4974086,4974087,4974088,4974089,4974090,4974091,4974092,4974093,4974094,4974095,4974096,4974097,4974098,4974099,4974100,3926932,3926933,3926934,3926935,3926936,3926937,3926938,3926939,3926940,3926941,3926942,3926943,3926957) 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'