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(4970230,4970231,4970232,4970233,4970234,4970235,4970236,4970237,4970238,4970239,4970240,4970241,4970242,4970243,4970244,4970245,4970246,4970247,4970248,4970249,4970250,4970251,4970252,4970253,4970254,4970255,4970256,4970258,4970260,4970261,4970263,4970265,4970266,4970267,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970314,4970315,4970316,4970317,4970318,4970323,4970324,4970331,4970332,4970335,4970336,4970337,4970338,4970357,4970361,4970362,4970363,4970366,4970367,4970368,4970369,4970383,4970384,4970385,4970386,4970405,4970406,4970407,4970408,4970429,4970430,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970450,4970508,4970509,4970510,4970511,4970512,4970513,4970612,4970613,4970614,4970615,4970616,4970617,4970618,4970619,4970620,4970621,4970622,4970623,4970624,4970625,4970626,4970646,4970647,4970648,4970649,4970659,4970660,4970661,4970662,4970663,4970664,4970665,4970666,4970667,4970668,4970669,4970672,4970684,4970687,4970688,4970701,4970702,4970711,4970716,4970724,4970725,4970726,4970727,4970728,4970729,4970732,4970733,4970734,4970739,4970744,4970745,4970753,4970783,4970798,4970807,4970808,4970809,4970811,4970812,4970853,4970854,4970855,4970856,4970857,4970875,4970876,4970877,4970886,4970887,4970888,4970889,4970908,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970951,4970964,4970973,4971019,4971020,4971021,4971031,4971043,4971044,4971045,4971060,4971061,4971062,4971103,4971108,4971143,4968169,4968170,4968171,4968208,4968227,4968230,4968317,4968323,4968326,4968333,4968334,4968410,4968411,4968412,4968413,4968414,4968415,4968416,4968417,4968418,4968419,4968420,4968421,4968422,4968423,4968424,4968425,4968426,4968427,4968607,4968608,4968609,4968610,4968611,4968612,4968613,4968614,4968616,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968630,4968632,4968635,4968636,4968637,4968645,4968646,4968647,4968655,4968656,4968657,4968658,4968659,4968660,4968664,4968665,4968666,4968667,4968668,4968669,4968678,4968679,4968680,4968691,4968692,4968693,4968694,4968695,4968696,4968697,4968702,4968703,4968789,4968790,4968861,4968862,4969102,4969132,4969133,4969162,4969178,4969179,4969247,4969248,4969260,4969270,4969282,4969283,4969284,4969320,4969321,4969397,4969398,4969399,4969400,4969401,4969402,4969403,4969404,4969405,4969406,4969407,4969408,4969409,4969410,4969411,4969412,4969413,4969414,4969421,4969422,4969423,4969424,4969425,4969443,4969444,4969445,4969447,4969448,4969547,4969549,4969554,4969555,4969556,4969557,4969558,4969559,4969560,4969561,4969562,4969564,4969565,4969566,4969567,4969568,4969570,4969571,4969572,4969573,4969586,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,4969637,4969638,4969642,4969643,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969912,4969913,4970034,4970035,4970036,4970037,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074814,8074815,8074816,8074817,8074818,8074819,8074820,8074821,8074822,8074823,8074824,8074825,8074826,8074827,8074828,8074829,8074830,8074831,8074832,8074833,8075218,8075219,8075220,8075221,8075222,8075225,8075288,8075316,8075317,8075318,8075319,8075321,8075485,8075490,8075539,8075542,4967035,4967046,4967047,4967068,4967103,4967109,4967110,4967111,4967144,4967145,4967146,4967187,4967348,4967355,4967356,4967357,4967371,4967372,4967373,4967374,4967377,4967378,4967379,4967380,4967381,4967382,4967383,4967384,4967385,4967386,4967387,4967401,4967402,4967403,4967404,4967405,4967406,4967407,4967413,4967414,4967415,4967416,4967437,4967438,4967439,4967440,4967441,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967451,4967452,4967453,4967454,4967455,4967456,4967457,4967458,4967459,4967460,4967461,4967462,4967463,4967464,4967465,4967466,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967474,4967475,4967476,4967477,4967478,4967479,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967497,4967498,4967499,4967500,4967501,4967502,4967503,4967504,4967505,4967506,4967507,4967508,4967509,4967510,4967511,4967512,4967513,4967514,4967515,4967523,4967634,4967635,4967636,4967637,4967638,4967639,4967756,4967757,4967758,4967759,4967760,4967761,4967788,4967795,4967796,4967797,4967799,4967800,4967805,4967806,4967808,4967809,4967810,4967841,4967844,4967869,4967909,4967910,4967911,4967915,4967924,4967980,4967982,4967993,4967994,4967995,4968021,4968022,4968023,4968024,4968025,4968026,4968081,4968082,4968083,4968084,4968085,4968086,4968087,4968088,4968089,4968090,4968091,4968092,4968093,4968094,4968095,4968096,4968097,4968098,4968099,4968100,4968101,4968102,4968103,4968104,4968105,4968106,4968107,4968108,4968109,4968110,4968111,4968112,4968116,4968120,8073855,8073856,8073857,8073858,8073859,8073860,8073861,8073862,8073863,8073864,8073865,8073866,8073867,8073868,8073869,8073870,8073871,8073872,8073873,8073874,8073875,8073876,8073900,8073901,8073902,8073903,8073904,8073905,8073906,8073907,8073908,8073909,8073910,8073911,8073912,8073913,8073914,8073915,8073916,8073917,8073918,8073919,8073920,8073921,8074212,8074213,8074214,8074215,8074216,8074217,8074218,8074219,8074220,8074221,8074222,8074223,8074224,8074225,8074226,8074227,8074228,8074229,8074230,8074231,8074232,8074233,8074234,8074235,8074236,8074237,8074238,8074239,8074240,8074241,8074242,8074243,8074244,8074245,8074246,8074247,8074248,8074249,8074250,8074251,8074252,8074253,8074254,8074255,8074256,8074257,8074258,8074259,8074260,8074261,8074262,8074263,8074264,8074265,8074266,8074267,8074268,8074269,8074270,8074271,8074272,8074273,8074274,8074275,8074276,8074277,8074278,8074279,8074280,8074281,8074282,8074283,8074284,8074285,8074286,8074287,8074288,8074289,8074290,8074291,8074292,8074293,8074294,8074295,8074296,8074297,8074298,8074299,8074300,8074301,8074302,8074303,8074304,8074305,8074306,8074499,8074500,8074501,8074502,8074503,8074504,8074505,8074506,8074507,8074508,8074509,8074510,8074511,8074512,8074513,8074514,8074515,8074516,8074517,8074518,8074519,8074520,8074521,8074522,8074523,8074524,8074525,8074526,8074527,8074528,8074529,8074530,8074531,8074532,8074533,8074534,8074535,8074536,8074537,8074538,8074539,8074540,8074541,8074542,8074543,8074544,8074545,8074546,8074547,8074548,8074549,8074550,8074551,8074552,8074553,8074554,8074555,8074556,8074557,8074558,8074559,8074560,8074561,8074562,8074563,8074564,8074565,8074566,8074567,8074568,8074569,8074570,8074571,8074572,8074573,8074574,8074575,8074576,8074577,8074578,8074579,8074580,8074581,8074582,8074583,8074584,8074585,8074586,8074587,8074588,8074589,8074590,8074591,8074592,8074593,8074594,8074595,8074596,8074597,8074598,8074599,8074600,8074601,8074602,8074603,8074604,8074605,8074606,8074607,8074608,8074609,8074610,8074611,8074612,8074613,8074614,8074615,8074616,8074617,8074618,8074619,8074620,8074621,8074622,8074623,8074624,8074625,8074626,8074627,8074628,8074629,8074630,8074631,8074632,8074633,8074634,8074635,8074636,8074637,8074638,8074639,8074640,8074641,8074642,8074643,8074644,8074645,8074646,8074647,8074648,8074649,8074650,8074651,8074652,8074653,8074654,8074655,8074656,8074657,8074658,8074659,8074660,8074661,8074662,8074663,8074664,8074665,8074666,8074667,8074668,8074669,8072033,8072034,8072035,8072036) 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'