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(8068875,7075933,7068167,7068168,7068179,7068180,10939956,7068244,7068290,7068345,7068353,7068355,10940102,10940103,10940104,10940105,10940168,4970872,4970904,7068621,7068622,4970960,7068635,7068636,7068668,8569754,10976576,10976603,10976604,7074105,7074117,8067210,7074162,8067507,8067609,8067610,8067611,8067612,8067613,8067683,8067684,8067700,7066715,7074748,7074859,7074863,7074891,7066929,10987976,11001151,11001152,7071865,10972724,10972812,10972813,10972814,10972915,10972916,10972934,7072349,7072359,7072360,7072377,10986064,7072386,10986083,7064399,10973116,10973117,10973118,10973119,10973192,10973193,10960260,7072614,7072715,8065817,10986440,10932205,10932209,7072909,7072910,7072971,7073018,7073050,7073054,7073111,8066198,8066200,8066207,8066208,8066213,8066215,7070955,7070956,7070957,8861078,10942891,7071180,7071181,8861086,10942901,10942906,8861103,10942946,10943004,10943005,10943007,10943087,8861295,7071465,10972175,10972177,10972178,7071653,7071655,7071656,7071657,7071658,7071660,7071661,7071662,10972437,10972447,10972448,3655568,3655569,3655570,3655589,7068984,7068985,10969710,10969733,10969734,10969735,10969771,10969772,10969773,10940831,10969933,10969934,10970007,7069467,7069474,3656235,3656236,10970249,10970250,10970251,10970252,10970253,10970320,10970321,10970322,10970323,10970396,3656467,10970525,10970526,10970527,10970583,10970584,10970585,10970586,10970636,10970637,10970735,10970736,10970737,10970738,10970890,10942069,10971038,10971039,10971040,10971041,10971087,10971088,10971089,10942151,10971128,10971165,10971166,10971167,10971168,10971169,10971170,10971172,8073506,8073520,8860628,10997434,10997435,10997436,10997437,10997438,10942481,10942487,11006526,10617998,10618106,10918729,10923759,10923760,10923761,10967789,10923840,10923841,10923842,10923899,10923900,10923901,10923902,10923903,10918921,10924070,10924160,10924161,10924162,10924163,10924164,10924165,10924166,10924167,10924168,10924169,10924170,10924171,10924172,10924231,10924232,10924233,10924234,10924320,10924321,10924322,10919621,10919622,10919623,10919624,10924669,10924670,10924671,10924672,10924673,10924674,10924675,10924676,10924677,10924678,10924679,10924680,10968803,10968804,10968805,10968806,10968807,10968808,10968809,10968810,10994827,10924804,10924805,10919853,10924900,10924901,10924902,10924903,10924904,10924905,10924906,10924907,10924908,10924909,10924910,10924911,10924912,10924913,10924914,10982009,10982010,10925012,10925013,10925014,10925015,10925016,10925017,10925018,10925019,10925020,10925021,10925022,10925101,10925102,10925103,10925108,10925111,10925112,10925129,10925155,10925156,10925157,10925158,10925159,10969191,10969192,10969193,10969194,10969195,10969196,10969197,10969198,10969199,10969200,10969201,10969202,10969203,10925277,10925278,10925279,10925280,10925281,10925282,10925283,10925284,10925285,10925286,10925287,10922692,10922739,10922740,10922741,10922742,10922771,10922791,10922792,10922793,10922794,10922795,10922796,10922797,10922798,10922871,10922872,10922873,10922993,10922994,10923038,10923039,10923040,10923068,10918168,10918169,10918170,10918171,10918172,10928234,10923290,10923291,10923292,10923293,10923294,10923346,10918354,10918355,10923430,10925485,10925486,10925491,10925492,8569838,8569839,8569840,8569841,10920567,10920585,10615166,10920697,10925867,10920881,10620375,10620389,10620405,8570283,10920995,10920996,10921092,10921093,10921094,10620654,10620655,10620661,10620662,10921212,10921213,10921214,10921215,10615834,10921423,10921504,10921505,10921506,10921507,10921508,10921509,10921523,10978580,10621127,10621151,10621286,10921901,10992306,10992307,10611511,10611512,10611513,10611514,10611515,10611516,10562947,10562948,10562949,10562950,9171306,7057642,7057643,10557351,10557488,10557489,10557567,7058184,9172029,9172030,7058205,7058225,7058292,7058309,10609948,10609949,8863127,8863170,7058874,7058916,10561584,10561602,10561603,10561611,10561613,10561614,10561615,10561625,10561626,10561627,10561632,10561633,10561634,10561646,10561647,10561653,10561654,10561655,10561665,10561675,10561676,10561677,10561702,10561703,10561706,9172905,10561726,10561727,10561728,10561729,10561738,10561743,10561744,10561746,7059162,7059165,7059166,7059194,7059195,7059196,7059288,7059306,7059365,9177302,9177303,9177304,9177309,9177314,9177316,10517243,9161592,9161593,7055801,9169645,10513504,10513505,10513506,10513507,10513508,10513509,10513510,10513511,10513512,10513532,10513533,10513534,10513535,10555535,10513536,10555536,10513537,10555537,10555538,7055902,4974773,4974799,4974800,4974841,4974889,4974923,4974924,7056286,7056287,7056291,7056292,10513951,10514104,10514105,10514106,10514218,10514219,10514220,10514221,10514222,10514223,10514224,10514225,10514226,10514227,10514228,10514229,10514230,10514231,10514232,10514233,10514234,10514235,10556323,10556324,10556325,10556326,10556327,10556328,10556329,10556330,10556331,10556332,10556333,10556334,10556335,10556336,10556337,10556338,10556462,10556463,10556464,10556465,10556564,10556565,10556566,10556567,10556744,10556745,10556746,10556747,10556748,10556749,10556750,7057154,9171256,9160470,9176514,9176530,9176666,9176714,9168726,9176736,9168796,9168828,9168829,9176906,9176943,9176974,9177156,9177158,9169173,9177178,9177187,9177208,9177212,9177213,9177219,9177262,9177297,8864828,10471195,10471210,10471211,10471215,10471218,10471224,10471225,10471234,4971535,4971553,4971554,4971596,4971625,4971626,4971637,10471488,6666928,6666932,4972002,10463741,4972018,10463742,10463743,10463744,10463745,10463746,10463747,10463748,10463749,4972025,10463750,10463751,10463752,10463753,10463754,10463755,10463756,10463757,10463758,10463759,10463760,10463761,10463762,10463763,10463764,10463765,10463766,10463767,10467947,8563383,10470094,10470113,10468116,8917190,10468366,10470388,6667859,10470497,10470596,10164543,10164544,10628079,10164785,10164879,10164986,10165065,10165066,10165067,10165224,10170289,10170293,10170294,10170295,10170296,10165393,10165394,10165562,10165563,10165564,10165565,10165566,10170604,10170626,10170687,10170688,10170692,10165705,10165706,10165707,10165892,10165893,10165915,10165961,10165962,10165963,10171078,10166086,10166087,10166088,10629838,10629839,10629929,10629930,10626981,10627679,10627683,10627684,10627685,10627686,10627687,10627688,10627691,10164248,10166589,10166670,10166844,10630365,10630366,10166898,10166909,10630389,10630390,10630391,10630392,10630393,10630394,10166959,10630489,10167034,10630529,10630530,10630531,10630532,10167093,10630624,10630625,10630626,10630666,10630667,10162192,10630672,10630729,10167269,10167283,10167325,10167346,10630848,10167428,10167432,10630910,10630911,10630912,10630913,10630914,10630915,10630916,10631027,10631028,10167554,10162562,10167650,10167651,10167671,10167672,10167673,10167686,10631209,10167738,10167739,10167740,10167741,10167742,10167743,10167744,10167745,10167746,10162768,10167814,10167815,10167816,10167817,10167818,10167927,10167928,10167949,10167991,10167992,10168052,10168060,10168069,10168114,10168115,10168116,10168117,10168118,10168153,10168154,10168155,10168156,10168157,10168192,10168201,10168202,10168203,10577222,10577223,10577224,10577498,10577499,10577500,10577501,10577502,10577503,10577504,10577505,10577506,10577507,10577508,10577509,10577510,10577511,10577512,10577513,10577514,10577515,10577516,10577517,10577518,10577519,10577520,10577521,10577522,10577523,10577524,10577525,10577526,10577527,10577528,10577529,10568675,10568676,10580719,10571882,10571883,10571884,10571885,10571886,10571887,10571888,10571889,10571890,10571891,10571892,10571893,10568907,10577913,10577914,10577915,10577916,10577917,10577918,10568926,10568927,10568928,10568929,10568930,10580973,10578091,10575185,10575186,10575187,10575188,10575189,10575190,10578217,10578314,10578315,10578316,10578317,10578318,10578319,10578352,10578353,10578354,10578371,10578397,10575453,10575454,10578455,10575566,10575567,10575568,10575569,10575570,10575571,10578618,10575690,10578841,10578842,10579101,10579102,10579264,10579560,10579561,10579562,10576749,10576750,10576751,10576752,10576753,10576754,10576755,10576756,10576757,10576758,10576982,10576983,10576984,10576985,10576986,10576987,10525112,10523113,10523194,10523195,10523206,10523441,10523442,10523443,10523444,10523445,10523453,10523454,10523455,10523456,10525583,10525584,10523686,10523708,10524237,10524317,10524318,10524751,10522839,10523098,10423600,10423813,10422980,10422988,10477204,10479382,10479383,10479384,10479385,10479386,10479387,10479388,10479389,10479390,10479391,10479392,10479393,10479394,10479395,10479488,10479489,10479490,10479491,10479492,10479493,10479494,10479551,10479573,10478167,10478168,10478526,10478527,10478530,10478540,10478541,10478712,10478713,10478714,10478715,10478716,10478717,10478718,10478726,10478728,10478729,10478750,10478751) 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'