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(10939592,10939593,3228940,4971034,4971035,4971036,8631900,10950898,10950899,10950900,10950901,10950902,10950903,10950904,10950905,10950906,10950907,10950908,10950909,10950910,7074370,8622293,10951128,3230210,3230233,8629841,8629843,7067773,10962481,10962482,10962483,10962484,10962485,10962486,10962487,10962488,10962489,10962490,10962491,10962492,10962493,10962494,10962495,10962496,10962497,10962498,10962499,10962500,10962501,10962502,10962503,10962504,10962505,8627657,8627658,8627659,8627660,8627661,8627662,8627663,8627664,8627665,8627666,8627667,8627668,8627669,8627670,8627671,8627672,8627673,8627674,8627675,8627676,8627677,8627678,8627679,8627680,8627681,8627682,8627683,8627684,8627685,8627686,8627687,8627688,8627689,8627690,8627691,8627692,8627693,8627738,8627739,8627740,8627741,8627742,8627743,8627744,8627745,8627746,8627747,8627748,8627749,8627750,8627751,8627752,8627753,8627754,8627755,8627756,8627757,8627758,8627759,8627760,8627761,8627762,8627763,8627764,8627765,8627766,8627767,8627768,8627769,8627770,8627771,8627772,8627773,8627774,8627775,8627776,8627777,8627778,8627779,8627780,8627781,8627782,8627783,8627784,8627865,8627866,10931611,10931612,10931613,10931614,10931615,10931616,10931617,10931618,8627983,8627984,8627985,8627986,8627987,8627988,8627989,8627990,10104136,3899592,5654577,5654578,5654579,5654580,7073488,9794575,9794576,10942994,8834891,8834892,8834893,8834894,8627211,8627212,8627213,8627214,8627215,8627216,8627217,8627218,8627219,8627220,7198670,8625106,11035972,11035973,11048373,11048374,11048375,11048376,11048377,11048378,10101734,10101735,11048534,11046055,11007121,11007122,11007123,11007124,3234716,7197605,7197606,7197607,7197608,7197609,7197610,7197611,7197612,7197613,7197614,7197615,7197616,7197617,7197618,7197619,7197620,7197621,7197622,7197623,7197624,7197625,7197626,7197627,7197628,7197629,7197630,7197631,7197632,7197633,7197634,7197635,7197636,7197637,7197638,7197639,7197640,7197641,7197642,7197643,7197644,7197645,7197646,7197647,7197648,7197649,7197650,7197651,7197652,7197653,7197654,7197655,7197656,7197657,7197658,7197659,7197660,7197661,7197662,7197663,7197664,7197665,7197666,7197667,7197668,7197669,7197670,7197671,7197672,7197673,7197674,7197675,7197676,7197677,7197678,7197679,7197680,7197681,7197682,7197683,7197684,7197685,7197686,7197687,7197688,7197689,7197690,7197691,7197692,7197693,7197694,7197695,7197696,7197697,7197698,7197699,7197700,7197701,7197702,7197703,7197704,7197705,7197706,7197707,7197708,7197709,7197710,7197711,7197712,7197713,7197714,7197715,7197716,7197717,7197718,7197719,7197720,7197721,7197722,7197723,7197724,7197725,7197726,7197727,7197728,7197729,7197730,7197731,7197732,7197733,7197734,7197735,7197736,7197737,7197738,7197739,7197740,7197741,7197742,7197743,7197744,7197745,7197746,7197747,10839685,10839686,10839687,8905072,8905073,8611941,8611942,8611943,8905204,8905205,8905206,8905207,8905208,8905209,8905210,8905211,8905212,8905213,8905214,8905215,8905216,8905217,8905218,8905219,8905220,11045270,11045271,11045272,11045273,11045274,11045275,10848198,10848199,10848200,10848586,8540792,8540875,8540876,8540877,7059799,9166150,10563392,10609387,9211975,9211976,9211977,9211978,9211979,9172266,9172267,9172268,9172269,9172270,9172271,9172272,9172273,9172274,9172275,9172276,9172277,9172278,9172279,9172280,9172281,9172282,9172283,9172284,9172285,9172286,9172287,9172288,9172289,9172290,8566845,9212468,9212469,10610164,10610165,10610166,10610167,10610168,10610169,10613307,9204790,9204791,10515144,10515145,10515146,10515147,10515148,10515149,10515150,10515151,10515152,10515153,10515154,10515155,10515156,10515157,10515158,10515159,10117544,10515160,10515161,10515162,10515163,10515164,10515165,10515166,10515167,10515168,10515169,10515170,10515171,10515172,10515173,10515174,10515175,10515176,10515177,10515178,10515179,10515180,10515181,10515182,10515183,10515184,10515185,10515186,10515187,10515188,10515189,10515190,10515191,10515192,10515193,10515194,10515195,10515196,10515197,10515198,10515199,10515200,10515201,10515202,10515203,10515204,10515205,10515206,10515207,10515208,10515209,10515210,10515211,10515212,10515213,10515214,10515215,10515216,10515217,10515218,10515219,10515220,10515221,10515222,10515223,10515224,10515225,10515226,10515227,10117611,10515228,10117612,10515229,10117613,10117614,10515230,10117615,10515231,10117616,10515232,10515233,10515234,10515235,10515236,10515237,10515238,10515239,10515240,10515241,10515242,10515243,10515244,10515245,10515246,10117754,7055840,7055841,7055842,7055843,7055844,9169715,7056178,10517994,10517995,4975248,10119077,6680532,6672667,6672668,8918227,6681221,10420216,10420217,10420218,10420219,10420220,10469127,6666559,6666560,6666561,6666562,6666563,6666564,6666565,6666566,6666567,6666568,6666569,6666570,6666571,6666572,6666573,6666574,6666575,6666576,6666577,6666578,6666579,6666580,6666581,6666582,6666583,6666584,6666585,6666586,6666587,6666588,6666589,6666590,6666591,6666592,6666593,6666594,6666595,6666596,6666597,6666598,8549958,8549959,8549960,8549961,6679030,9166827,10467776,8916897,10467952,10467953,10467954,10467955,10467956,10467957,10467958,10467959,10467960,10467961,10467962,10467963,10467964,10467965,10467966,10467967,10467968,10467969,10467970,10467971,10467972,10467973,10467974,10467975,10467976,10467977,10467978,10467979,10467980,10467981,10467982,10467983,10467984,10467985,10467986,10467987,10467988,10467989,10467990,10467991,10467992,10467993,10467994,10467995,10467996,10467997,10467998,10467999,10468000,10468001,10468002,10468003,10468004,10468005,10468006,10468007,10468008,10468009,10468010,10468011,10468012,10468013,10468014,10468015,10468016,10468017,10468018,10468019,10468020,10468021,10468022,10468023,10468024,10468025,10468026,10468027,10468028,10468029,10468030,10468031,10468032,10468033,10468034,10468035,10468036,10468037,10468038,10468039,10468040,10468041,10468042,10468043,10468044,10468045,10468046,10468047,10468048,10468049,10468050,10468051,10468052,10468053,10468054,10468055,10468056,10468057,10468058,10468059,10468060,10468061,10468062,10468063,10468064,10468065,10468066,10468067,10468068,10468069,10468070,10468071,10468072,10468073,10468074,10468075,10468076,10468077,10468078,10468079,10468080,10468081,10468082,10468083,10468084,10468085,10468086,10468087,10468088,10468089,10468090,10468091,10468092,10468093,10468094,10468095,10468096,10468097,10468098,10468099,10468100,10468101,10468102,10468103,10468104,10468105,10468106,10468107,10468108,10468109,10468110,10468111,10468112,10468113,10468114,10468115,10468116,10468117,10468118,10468119,10468120,9167913,9167914,9167915,9167916,6680165,6680181,6680187,6680189,6680203,6680206,6680226,6680258,6680267,6680270,6680287,6680293,6680369,6680370,6680466,10174572,10174576,10174589,10174590,10174603,10174606,10174625,10174639,10883691,10899934,10899935,10899936,10899937,10879976,10887511,10632190,10883241,10883242,10883243,10883244,10949057,10630821,10630823,10630843,10891357,10891358,10891359,10891360,10891361,10891362,10630853,10630856,10630865,10630866,10162925,10162926,10162942,10162944,10162945,10162956,10162957,10162961,10163066,10163067,10163068,10163069,10163070,10163071,10163072,10163073,10163074,10163075,10626563,10631924,10601255,10601256,10601257,10647369,10648028,10648029,10648030,10648031,10648032,10591012,10420221,10507802,10425089,10425090,10425091,10425092,10425093,10508045,10422182,10422183,10422184,10422185,10422186,10422187,10411037,10411038,10411039,10411040,10411041,10411042,10411043,10411044,10411045,10411046,10411047,10411048,10411049,10411050,10411051,10411052,10411053,10411054,10411055,10411056,10411057,10411058,10411059,10411060,10411061,10411062,10411063,10411064,10411065,10411066,10411067,10411068,10411069,10411070,10411071,10411072,10411073,10411074,10411075,10411076,10411077,10411078,10411079,10411080,10411081,10411082,10411083,10411084,10411085,10411086,10411087,10411088,10411089,10411090,10411091,10411092,10411093,10411094,10411095,10411096,10411097,10411098,10411099,10411100,10411101,10411102,10411103,10411104,10411105,10411106,10411107,10411108,10411109,10411110,10411111,10407111,10411112,10411113,10411114,10411115,10411116,10411117,10411118,10411119,10411120,10411121,10411122,10407122,10411123,10411124,10411125,10411126,10411127,10411128,10411129,10411130,10411131,10411132,10411133,10411134,10411135,10411136,10411137,10411138,10411139,10411140,10411141,10411142,10411143,10411144,10411145,10411146,10411147,10411148,10411149,10411150,10411151,10411152,10411153,10411154,10411155,10411156,10411157,10411158,10411159,10411160,10411161) 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'