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(4970873,4970874,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970921,4970922,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970971,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971042,4971066,4971067,4971068,4971069,4971125,4971127,4971144,4968232,4968481,4968556,4968670,4968671,4969300,4969301,4969302,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,4969312,4969313,4969314,4969315,4969316,4969317,4969318,4969319,4969320,4969321,4969322,4969323,4969324,4969325,4969326,4969327,4969328,4969329,4969330,4969331,4969332,4969333,4969334,4969335,4969336,4969337,4969338,4969339,4969340,4969341,4969342,4969343,4969344,4969345,4969346,4969347,4969348,4969349,4969350,4969351,4969352,4969353,4969354,4969355,4969356,4969357,4969358,4969359,4969360,4969361,4969362,4969363,4969364,4969365,4969366,4969367,4969368,4969369,4969370,4969371,4969372,4969373,4969374,4969375,4969376,4969377,4969378,4969379,4969380,4969381,4969382,4969383,4969384,4969385,4969386,4969387,4969388,4969389,4969390,4969391,4969392,4969393,4969394,4969395,4969396,4969397,4969398,4969399,4969400,4969401,4969402,4969403,4969404,4969405,4969406,4969407,4969408,4969409,4969410,4969411,4969412,4969413,4969414,4969415,4969416,4969417,4969418,4969419,4969420,4969421,4969422,4969423,4969424,4969425,4969426,4969427,4969428,4969429,4969430,4969431,4969432,4969433,4969434,4969435,4969436,4969437,4969438,4969439,4969440,4969441,4969442,4969443,4969444,4969445,4969446,4969447,4969448,4969449,4969450,4969451,4969452,4969453,4969454,4969455,4969456,4969457,4969458,4969459,4969460,4969461,4969462,4969463,4969464,4969465,4969466,4969467,4969468,4969469,4969470,4969471,4969472,4969473,4969474,4969475,4969476,4969477,4969478,4969479,4969480,4969481,4969482,4969483,4969484,4969485,4969486,4969487,4969488,4969489,4969490,4969491,4969492,4969525,4969526,4969527,4969528,4969529,4969530,4969531,4969532,4969533,4969534,4969535,4969536,4969537,4969538,4969539,4969540,4969541,4969542,4969543,4969544,4969545,4969546,4969570,8075218,8075219,8075298,8075299,8075300,8075301,8075302,8075303,8075304,8075305,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,8072311,8072758,8072759,8072760,8072761,8072762,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8072817,8072818,8072819,8072820,8072821,8072822,8072823,8072824,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,8072853,8072854,8072855,8072856,8072857,8072858,8072859,8072860,8072865,8072866,8072867,8072868,8072869,8072870,8072871,8072872,8072873,8072874,8072875,8072876,8072877,8072878,8072879,8072880,8072881,8072882,8072883,8072884,8072891,8072892,8072893,8072894,8072895,8072896,8072909,8072910,8072911,8072912,8072913,8072914,8072915,8072916,8072925,8072926,8072927,8072928,8072929,8072930,8072931,8072943,8072944,8072945,8072946,8072947,8072948,8072949,8072958,8072959,8072960,8072961,8072962,8072963,8072964,8072965,8072974,8072975,8072976,8072977,8072978,8072979,8072980,8072981,8073003,8073004,8073029,8073030,8073031,8073036,8073091,8073094,8073097,8073171,8073209,8073293,8073447,8073455,8073456,8073500,8073513,8073515,8073541,10622962,10622976,10622990,10622991,10622993,10622994,10622995,10622996,10622997,10622998,10622999,10623002,10623031,10623049,10623059,10623061,10623062,10623063,10623306,10623333,10623427,10623499,10623501,10623658,10623672,10623673,10623674,10623959,10622226,10622227,10622232,10622235,10622238,10622239,10622246,10622406,10622416,10622417,10622418,10622419,10622420,10622421,10622422,10622423,10622424,10622430,10622434,10622611,10622694,10622695,10622699,10622751,10622876,10622877,10622878,10622879,10622904,10622909,10622910,10622920,10622924,10622935,10622937,10622938,10622940,10622948,10622949,10622953,10622954,10622961,10619966,10619967,10620049,10620050,10620066,10620069,10620098,10620112,10620113,10620123,10620124,10620125,10620126,10620127,10620128,10620129,10620130,10620131,10620132,10620133,10620134,10620135,10620136,10620137,10620138,10620139,10620140,10620141,10620142,10620191,10620192,10620235,10620236,10620238,10620253,10620270,10620271,10620341,10620361,10620371,10620523,10620524,10620661,10620662,10620663,10620664,10620665,10620666,10620667,10620668,10620670,10620859,10621070,10621074,10621075,10621076,10621288,10621289,10621426,10621450,10621531,10621532,10621533,10621568,10621621,10621622,10621623,10621625,10621667,10621674,10621677,10621678,10621679,10621680,10621728,10621746,10621747,10565196,10565224,10565334,10565893,10565894,10565895,10565896,10565897,10565898,10565899,10565900,10565901,10565902,10565903,10565904,10565905,10565906,10565907,10565979,10565980,10565981,10565982,10565983,10565984,10565985,10565986,10565987,10565988,10565989,10565990,10565991,10565992,10565993,10565994,10565995,10565996,10565997,10565998,10565999,10566000,10566001,10566055,10563182,10563183,10563192,10563193,10563194,10563215,10563327,10563347,10563348,10563791,10563792,10563793,10563794,10563795,10563796,10563797,10563798,10563799,10563800,10563801,10563802,10563803,10563804,10563805,10563806,10563807,10563808,10563809,10563810,10563811,10563812,10563813,10563814,10563815,10563816,10563817,10563818,10563819,10563820,10563821,10563822,10563823,10563824,10563825,10563826,10563827,10563828,10563829,10563830,10563831,10563832,10563833,10563834,10563835,10563836,10563837,10563838,10563839,10563840,10563841,10563842,10563843,10563844,10563845,10563846,10563847,10563848,10563849,10563850,10563851,10563852,10563853,10563854,10563855,10563856,10563857,10563858,10563859,10563860,10563861,10563862,10563863,10563864,10563865,10563866,10563867,10563868,10563869,10563870,10563871,10563872,10563873,10563874,10563875,10563876,10563877,10563878,10563879,10563880,10563881,10563882,10563883,10563884,10563885,10563886,10563887,10563888,10563889,10563890,10563891,10563892,10563893,10563894,10563895,10563896,10563897,10563898,10563899,10563900,10563901,10563902,10563903,10563904,10563905,10563906,10563907,10563908,10563909,10563910,10563911,10563912,10563913,10563914,10563915,10563916,10563917,10563918,10563919,10563920,10563921,10563922,10564426,10564427,10564428,10564429,10564430,10564431,10564432,10564433,10564434,10564435,10564436,10564437,10564438,10564439,10564440,10564441,10564442,10564443,10564474,10564475,10564476,10564477,10564478,10564479,10564480,10564481,10564510,10564511,10564512,10564513,10564514,10564515,10564516,10564519,10564520,10564521,10564522,10564537,10564538,10564555,10564618,10564619,10564620,10564621,10564650,10564651,10564652,10564703,10564704,10564705,10564706,10564707,10564708,10564709,10564710,10564711,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,10564796,10564797,10564798,10564799,10564800,10564801,10564802,10564989,10564991,10564992,10564993,10517143,10517144,10517225,10517231,10517232,10517233,10517319,10517398,10517399,10517400,10517401,10517402,10517403,10517404,10517405,10517406,10517407,10517408,10517409,10517410,10517411,10517412,10517413,10517414,10517415,10517416,10517417,10517418,10517419,10517420,10517421,10517422,10517423,10517424,10517425,10517426,10517427,10517428,10517429,10517430,10517431,10517432,10517433,10517434,10517435,10517436,10517437,10517438,10517439,10517440,10517441,10517442,10517443,10517444,10517445,10517446,10517447,10517448,10517553,10517554,10517555,10517669,10517749,10517794,10517795,10517803,10517804) 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'