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(10962593,10962598,10962695,10962696,10962697,10962698,10962699,10962700,10962701,7068251,7068252,10963066,10963067,10963070,10963071,10963073,4970742,8569617,7068681,7068682,7068761,7068775,7068776,7068777,7068778,7068779,7068780,7068781,10940514,8569778,8569779,10940518,7068806,7068808,7068810,7068814,8066889,8066894,8066895,8066896,8066897,8066908,8066909,8066910,10963783,7066174,7074300,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,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,10939103,10962081,10962089,10962094,10962095,10962096,8068399,8068400,8068401,8068402,8068403,8068404,8068405,8068406,8068524,8068525,8068526,8068527,8068528,8068529,8068603,8068604,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,10939367,8068680,8068681,8068682,8068683,8068684,8068685,8068686,8068697,8068698,8068699,8068700,8068701,8068702,8068703,10939436,8068715,8068716,8068717,8068746,8068747,8068761,8068762,8068763,8068764,8068765,8068766,6000289,10931629,7072300,7064332,8065797,10960469,10932265,7072897,7072898,10960658,10960659,10960660,10960693,8066214,8066216,8066224,8066225,8066226,8066227,8066228,8066229,8066230,8066231,8066232,10932603,8066272,8066273,8066292,8066293,8066308,8066328,8066329,8066330,8066331,8066332,8066333,8066334,8066335,8066336,8066337,8066338,8066354,8066355,8066356,8066357,8066358,8066369,8066370,8066371,8066372,8066373,8066374,8066375,8066376,8066377,8066378,8066379,7065342,8066421,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066508,8066509,8066510,8066564,8066565,8066566,8066567,8066568,8066569,8066570,8066571,8066572,8066573,8066574,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066636,8066637,8066638,8066639,8066640,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066654,8066655,8066656,8066657,8066658,7073632,8066756,8066757,8066758,8066759,8066760,8066761,8066762,8066763,8066764,8066765,8066766,8066767,8066768,8066818,8066819,8066820,8066821,8066822,8066823,8066824,8066825,8066826,8066827,8066828,8066829,8066830,8066831,8066832,8066833,8066834,8066881,8066884,8861105,7071298,10943062,10959104,7071558,7071702,7068816,7068833,7068837,7068839,7068848,7068908,7068909,7068910,7068911,7068912,7068913,7068914,7068916,7068941,7068961,7068970,7069026,7069029,7069032,7069034,7069036,7069037,7069039,7069041,7069053,7069073,10940845,10940848,7069308,7069462,10942096,10958283,10942466,10942497,10621977,10617124,10622360,10622361,10622362,10622363,10622364,10622365,10954281,8569792,8569797,8569802,8569807,8569811,8569812,8569817,10615266,10620372,10620373,10620374,10620375,10620376,10620377,10620378,8570491,10930751,10930766,10930767,10930768,10930769,10930770,10930771,10930772,10930773,10621120,10621151,10621152,10616228,10616230,10621230,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,10616381,10621386,10621387,10621388,10621428,10621429,10621445,10621446,10621447,10621448,10621449,10616450,10621450,10621451,10621452,10621500,10621501,10621529,10621530,10621531,10621532,10621533,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,10953442,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,10611568,10559727,10559748,10559749,10559750,10559751,10562798,10562799,10562800,10562801,10562802,10614746,10565931,10565932,10565956,10566014,10612099,10557618,10612530,10609715,10609716,10612769,10613176,10610271,8863309,8863310,8863311,8863312,8863313,8863331,8863340,8863341,8863342,8863343,8863344,8863345,8863346,8863377,8863378,8863379,8863380,8863381,8863382,8863383,8863401,8863402,8863403,8863404,8863405,10610791,10610850,10610878,10513133,10513152,10513217,10513218,10513224,10511228,10511229,10511230,10511231,10511232,10513249,10513261,10513262,10515264,10515265,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,10555829,10555830,10513985,10514075,10512085,10512086,10512087,10512088,10514091,10514092,10514112,10514113,10516122,10514131,10514132,10514133,10514134,10514135,10514136,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,10516676,10512770,10512771,10514795,10514796,10514797,10514798,10514799,10514808,10514809,10514819,10514839,10514840,10514841,10514842,10514843,10514844,10516962,10514976,10514980,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10515003,10515004,10515005,10519082,10519083,10519084,10515084,10519085,10519086,10519087,10519088,10513090,10515092,10513109,10513110,10513111,10419304,10419305,10417342,10417394,10417395,10417396,10417397,10418651,10418652,10415813,10416919,10420157,10420158,10417172,10420175,10420192,10420204,10463002,10463003,10463006,10463027,10463031,10463034,10463044,10467094,10467095,10467105,10467108,10467110,10467111,10467112,10467125,10467127,10467128,10467145,10467148,10467149,10467152,10463315,10463316,10463360,10463361,10463362,10463396,10463398,10467428,10463429,10463430,10463432,10467437,10467438,10467458,10467459,10467628,10467629,10463654,10463728,10463731,10463732,10463748,10463749,10463750,10463751,10463752,10463753,10463757,10463758,10463759,10465761,10463763,10465777,10465778,10465779,10463780,10463782,10463783,10465783,10463784,10463785,10463786,10465786,10463787,10465787,10463788,10463789,10465799,10465800,10465805,10465806,10465807,10465808,10465809,10465810,10465811,10465867,10465868,10465869,10465870,10465871,10465872,10465873,10465874,10465875,10465876,10463883,10463884,10463885,10463886,10465887,10463887,10463888,10463889,10463890,10463891,10463892,10463893,10465894,10463894,10465895,10465896,10465909,10465911,10465913,10463919,10463920,10467986,10468002,10468020,10464041,10464042,10468046,10468111,10466305,10466318,10466320,10466321,10466322,10466323,10466325,10466328,10466345,10466357,10466358,10466359,10466360,10466361,10466362,10468393,10468394,10468395,10468396,10468397,10468398,10466401,10462401,10462409,10462410,10462411,10462412,10466413,10462413,10466414,10466415,10466416,10466417,10466418,10466419,10466420,10466421,10466422,10466423,10468424,10462427,10466432,10466433,10468435,10462436,10462437,10462438,10466439,10462439,10466440,10466444,10462458,10462462,10462463,10462485,10462486,10462487,10462488,10462489,10462490,10462491,10462492,10462493,10462494,10462495,10462496,10462497,10462498,10462499,10462500,10462501,10462502,10462503,10462504,10462505,10462518,10462587,10462588,10462589,10462590,10462591,10462592,10462593,10462594,10462595,10462596,10462597,10462724,10462725,10462756,10466845,10466851,10466855) 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'