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(10222494,7074300,10196687,10196688,10196689,10196723,7074635,8067961,8067962,8067963,8067964,8067965,8067966,8067967,7066989,8068026,8068027,8068028,8068029,8068030,8068031,8068075,8068076,8068077,8068078,8068079,8068080,8068081,8068082,8068083,8068084,8068085,8068143,8068144,8068145,8068146,8068147,8068148,8068149,8068150,8068151,8068152,8068153,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068161,8068162,8068163,8068164,8068165,8068166,8068167,8068168,8068169,8068170,8068171,8068172,7072300,7064332,10198081,10198086,10198091,10198092,10198093,10074490,7072897,7072898,10074840,7065342,7073632,7066174,10196484,8968562,8968926,8968955,10194169,8861105,7071298,8969536,7071558,7071702,10195014,6000289,10073864,7069308,7069462,8068256,8068257,8068258,8068259,8068260,8068261,8068262,8068263,8068264,8068265,8068301,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8068318,8068319,8068320,8068321,8068322,8068323,8068324,8068325,8068326,8068327,8068328,8068329,8068330,8068331,8068332,8068333,8068334,8068399,8068400,8068401,8068402,8068403,8068404,8068405,8068406,8965549,8068524,8068525,8068526,8068527,8068528,8068529,8068603,8068604,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068680,8068681,8068682,8068683,8068684,8068685,8068686,8068697,8068698,8068699,8068700,8068701,8068702,8068703,8068715,8068716,8068717,8965814,8068746,8068747,8068761,8068762,8068763,8068764,8068765,8068766,8965885,7068251,7068252,7068681,7068682,7068761,7068775,7068776,7068777,7068778,7068779,7068780,7068781,7068806,7068808,7068810,7068814,7068816,7068833,7068837,7068839,7068848,7068908,8966974,7068909,8966975,7068910,7068911,7068912,7068913,8966979,7068914,7068916,7068941,7068961,7068970,7069026,7069029,7069032,7069034,7069036,7069037,7069039,7069041,7069053,7069073,8967309,8967312,10189205,10190187,10621977,10617124,8570491,10622360,10622361,10622362,10622363,10622364,10622365,8579470,8579472,8579487,8579488,8579489,8579490,8579491,8579492,8579493,8579494,10198695,10198700,10615266,10198803,10198804,10198805,10198806,10198807,10198808,10198809,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10212034,10212035,10212036,10212037,10212038,10199150,10199151,10199154,10199155,10199157,10212554,10212555,10212556,10212557,10212558,10212559,10212560,10212561,10621120,10621151,10621152,10616228,10621230,10616230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621267,10621268,10621281,10621292,10621293,10621305,10621306,10621307,10616307,10621308,10621309,10616310,10616311,10616317,10616318,10616319,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,8569617,10616381,10621386,10621387,10621388,10199923,10621428,10621429,10621445,10621446,10621447,10621448,10621449,10616450,10621450,10621451,10621452,10621500,10621501,8569778,8569779,8569792,10621529,10621530,8569797,10621531,10621532,10621533,8569802,8569807,8569811,8569812,8569817,10621567,10621568,10621573,10621574,10621621,10621622,10621623,10621624,10621625,10621634,10621635,10621636,10621646,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621692,10621693,10621694,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10565145,10559400,10559401,10559402,10614252,10559403,10559404,10559405,10559406,10559407,10614271,10614317,10562654,10562655,10562656,10562657,10562658,10562659,10562660,10562661,10562662,10562663,10562664,10562665,10562666,10562667,10562668,10562669,10562670,10562671,10562672,10562673,10562674,10562675,10562676,10562677,10562678,10562679,10562680,10562681,10559727,10559748,10559749,10559750,10559751,10562798,10562799,10562800,10562801,10562802,10614746,10565931,10565932,10565956,10566014,10612099,10557618,10612530,10612769,10613176,10513133,10513152,10513217,10513218,10513224,10511228,10511229,10511230,10511231,10511232,10513249,10513261,10513262,10515264,10515265,6667793,10513287,10513294,10513299,10511299,10513300,10513301,10513302,10513303,10511307,10513313,10513314,10513315,10515317,10515318,10515319,10515335,10515336,10515352,10511374,10511375,10511376,10515395,10515396,10515397,10515398,10511476,10511604,10511709,10513735,10513985,10514075,10512085,10512086,10512087,10512088,10514091,10514092,10514112,10514113,10516122,10514131,10514132,10514133,10514134,10514135,10514136,4973538,4973539,4973540,10514160,10516171,10516172,10514174,10514175,10514176,10514177,10512203,10512204,10514213,10514214,10514221,10514242,10514264,10514284,10512294,10512295,10512296,10512297,10512298,10514304,10514317,10514331,10514332,10514360,10514361,10512420,10512421,10512450,10512451,10512452,10512453,10514533,10514534,10514535,10514536,10514537,10514538,10514539,10514540,10514547,10514548,10512559,10514564,10514565,10514644,9161184,9161185,9161186,9161187,9161188,9161189,9161190,9161191,9161192,9161193,9161194,9161195,9161196,9161197,9161198,9161199,10516676,10512770,10512771,10514795,10514796,10514797,10514798,10514799,10514808,10514809,10514819,7055530,10514839,10514840,10514841,10514842,10514843,10514844,10516962,10514976,10514980,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10515003,10515004,10515005,10519082,10519083,10515084,10519084,10519085,10519086,10519087,10519088,10513090,10515092,10513109,10513110,10513111,10419304,10419305,4971612,4971613,10417342,10417394,10417395,10417396,10417397,8916598,6666975,6666977,6666978,6666979,6666984,6666987,6666991,10418651,10418652,4971933,4971942,4971943,4971944,4971945,4971946,4971947,4971950,4971954,4971961,4971962,4971976,4971981,4971982,4971997,4972014,4972015,4972016,8916811,4972017,8916812,4972018,4972019,4972020,4972046,4972047,4972048,4972049,4972050,4972051,4972052,4972053,4972054,4972055,4972056,4972057,4972134,4972161,4972162,4972163,4972164,10416919,4972196,4972197,4972198,4972199,4972202,4972203,4972204,4972217,4972218,4972219,4972220,4972221,4972222,4972223,4972229,4972232,4972233,4972234,4972235,4972245,4972246,4972247,4972255,4972256,4972257,4972258,4972259,8917185,8917186,8917187,8917188,8917193,8917194,8917195,8917196,8917197,8917203,8917204,8917205,8917206,10420157,8917225,10420158,10417172,10420175,10420192,10420204,8863309,8863310,8863311,8863312,8863313,8863331,8863340,8863341,8863342,8863343,8863344,8863345,8863346,8863377,8863378,8863379,8863380,10467094,8863381,10467095,8863382,8863383,10467105,10467108,10467110,10467111,10467112,8863401,8863402,8863403,8863404,8863405,10467125,10467127,10467128,8863425,8863426,8863427,8863428,8863429,8863430,8863431,10467145,8863432,10467148,10467149,10467152,8863444,8863532,8863533,8863534,8863535,8863536,8863537,8863538,8863539,8863540,8863541,8863598,8863599,8863600,8863601,8863602,8863603,8863604,8863605,7059326,7059328,7059339,10467428,10467437,10467438,10467458,10467459,10467628,10467629,10465761,10465777,10465778,10465779,10465783,10465786,10465787,10465799,10465800,10465805,10465806,10465807,10465808,10465809,10465810,10465811,10465867,10465868,10465869,10465870,10465871,10465872,10465873,10465874,10465875,10465876,10463883,10463884,10463885,10463886,10463887,10465887,10463888,10463889,10463890,10463891,10463892,10463893,10463894,10465894,10465895,10465896,10465909,10465911,10465913,10463919,10463920,10467986,10468002,10468020,10464041,10464042,10468046,10468111,4970742,10466305,10466318,10466320,10466321,10466322,10466323,10466325,10466328,10466345,10466357,10466358,10466359,10466360,10466361,10466362,10468393,10468394,10468395,10468396,10468397,10468398,10466401,10466413,10466414,10466415,10466416,10466417,10466418,10466419,10466420,10466421,10466422,10466423,10468424,10466432,10466433,10468435,10466439,10466440,10466444,10466845,10466851,10466855,10154729,10628311,10159922,10159923,10155428,10156205,10632312,10627680,10631019,10631020,10631021,10631022,10631023,10631024,10631025,10631026,10631027,10631028,10631030,10631031,10631032,10631033,10631034,10631036,10631037,10631795,10571412,10571413,10574615,10568621,10568622,10568623,10568624,10568625,10571805,10568898,10566368,10566369,10566370,10573002,10567394,10567405,10570551,10567627,10567632,10573643,10573644,10573645,10573646,10573647,10573648,10573649,10573650,10523247,10523477,10523478,10523479,10523480,10523565,10523659,10523676,10523681,10523685,10522498,10522654,10522840,10522991,10523042,10420222,10420223,10420238,10420427,10420489,10420520,10421072,10421075,10421076,10421078,10421133,10421134) 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'