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(4970159,4970161,4970174,4970175,4970176,4970193,4970194,4970195,4970196,4970197,4970198,4970199,4970200,4970201,4970202,4970203,4970204,4970205,4970206,4970207,4970208,4970209,4970210,4970211,4970212,4970213,4970214,4970215,4970216,4970217,4970223,4970426,4970427,4970428,4970668,4970681,4970712,4970719,4970740,4970747,4970770,4970780,4970781,4970853,4970874,4970894,4970895,4970901,4970902,4970903,4970904,4970907,4970908,4970909,4970910,4970913,4970915,4970921,4970922,4970951,4970952,4970954,4970955,4970962,4970963,4970964,4970965,4970967,4970968,4970984,4970986,4970990,4970991,4971024,4971025,4971030,4971085,4971089,4971094,4971104,4971120,4971121,4971148,4968433,4968436,4968437,4968485,4968556,4968641,4968682,4968791,4968921,4969003,4969098,4969099,4969130,4969160,4969161,4969208,4969265,4969266,4969267,4969268,4969269,4969271,4969280,4969287,4969294,4969298,4969299,4969303,4969304,4969305,4969306,4969307,4969318,4969320,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,4969375,4969376,4969377,4969378,4969379,4969380,4969381,4969382,4969424,4969426,4969427,4969428,4969429,4969430,4969431,4969432,4969433,4969458,4969465,4969474,4969493,4969497,4969498,4969500,4969504,4969509,4969517,4969518,4969519,4969521,4969535,4969632,4969639,4969640,4969641,4969642,4969645,4969648,4969649,4969650,4969651,4969659,4969675,4969693,4969694,4969695,4969709,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,4969727,4969731,4969758,4969767,4969776,4969784,4969809,4969847,4969860,4969862,4969874,4969879,4969888,4969897,4969898,4969899,4969900,4969901,4969902,4969903,4969904,4969905,4969918,4969929,4969930,4969931,4969935,4969936,4969945,4969946,4969951,4969955,4969957,4969963,4969964,4969965,4969988,4969990,4969996,4969997,4969998,4969999,4970000,4970001,4970025,4970030,4970044,4970052,4970053,4970054,4970069,4970085,4970086,4970087,4970094,4970121,4970146,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075058,8075059,8075060,8075061,8075062,8075063,8075064,8075065,8075066,8075067,8075068,8075069,8075070,8075071,8075072,8075073,8075074,8075075,8075076,8075077,8075078,8075079,8075080,8075081,8075082,8075083,8075084,8075085,8075086,8075087,8075088,8075089,8075090,8075091,8075092,8075093,8075094,8075095,8075096,8075097,8075098,8075099,8075100,8075101,8075102,8075103,8075104,8075105,8075106,8075107,8075108,8075109,8075110,8075111,8075112,8075113,8075114,8075115,8075116,8075117,8075118,8075119,8075120,8075121,8075122,8075123,8075124,8075125,8075126,8075127,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075149,8075150,8075151,8075152,8075153,8075154,8075155,8075156,8075157,8075158,8075159,8075160,8075161,8075162,8075163,8075164,8075165,8075166,8075167,8075168,8075169,8075170,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,8075191,8075192,8075193,8075194,8075195,8075196,8075197,8075198,8075199,8075200,8075201,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8075209,8075210,8075211,8075212,8075213,8075274,8075280,8075376,8075378,8075379,8075381,8075382,8075383,8075384,8075385,8075422,8075424,8075425,8075426,8075427,8075439,8075440,8075442,8075534,4967030,4967031,4967077,4967078,4967079,4967080,4967081,4967153,4967156,4967169,4967172,4967179,4967182,4967183,4967198,4967202,4967207,4967213,4967221,4967222,4967223,4967224,4967230,4967231,4967233,4967234,4967246,4967262,4967267,4967270,4967279,4967286,4967287,4967289,4967291,4967293,4967307,4967312,4967327,4967328,4967329,4967330,4967335,4967342,4967344,4967355,4967361,4967380,4967389,4967396,4967397,4967401,4967418,4967436,4967439,4967440,4967510,4967561,4967562,4967563,4967564,4967565,4967574,4967575,4967576,4967577,4967578,4967579,4967580,4967596,4967597,4967598,4967615,4967654,4967655,4967656,4967657,4967658,4967659,4967677,4967678,4967679,4967680,4968024,4968038,4968075,8074307,8074308,8074309,8074310,8074311,8074312,8074313,8074314,8074315,8074316,8074317,8074318,8074319,8074320,8074321,8074322,8074323,8074324,8074325,8074326,8074327,8074328,8074329,8074330,8074331,8074332,8074333,8074334,8074335,8074336,8074337,8074338,8074339,8074340,8074341,8074342,8074343,8074344,8074345,8074346,8074347,8074348,8074349,8074350,8074351,8074352,8074353,8074354,8074355,8074356,8074357,8074358,8074359,8074360,8074361,8074362,8074363,8074364,8074365,8074366,8074367,8074368,8074369,8074370,8074371,8074372,8074373,8074374,8074375,8074376,8074377,8074378,8074379,8074380,8074381,8074382,8074383,8074384,8074385,8074386,8074387,8074388,8074389,8074390,8074391,8074392,8074393,8074394,8074395,8074396,8074397,8074398,8074399,8074400,8074401,8074402,8074403,8074404,8074405,8074406,8074407,8074408,8074409,8074410,8072295,8072311,8072506,8072507,8072508,8072509,8072510,8072511,8072512,8072513,8072514,8072515,8072516,8072517,8072518,8072519,8072520,8072643,8072644,8072645,8072646,8072647,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072693,8072694,8072695,8072696,8072697,8072698,8072699,8072700,8072701,8072702,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,8072748,8072749,8072750,8072751,8072752,8072753,8072754,8072755,8072756,8072757,8072758,8072759,8072760,8072761,8072762,8072763,8072764,8072765,8072766,8072767,8072768,8072769,8072770,8072771,8072772,8072773,8072774,8072775,8072776,8072777,8072778,8072779,8072780,8072781,8072782,8072783,8072784,8072785,8072786,8072787,8072788,8072789,8072790,8072791,8072792,8072804,8072805,8072806,8072807,8072808,8072820,8072821,8072822,8072823,8072824,8072836,8072837,8072838,8072839,8072840,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,8072892,8072893,8072894,8072895,8072896,8072912,8072913,8072914,8072915,8072916,8072927,8072928,8072929,8072930,8072931,8072943,8072944,8072945,8072946,8072947,8072948,8072949,8072961,8072962,8072963,8072964,8072965,8072977,8072978,8072979,8072980,8072981,8073036,8073086,8073087,8073094,8073300,8073311,8073318,8073331,8073422,8073425,8073428,8073434,8073501,8073519,8073523,8073524,10622996,10623185,10623186,10623187,10623188,10623206,10623256,10623341,10623380,10623435,10623493,10623496,10623504,10623604,10623607,10623608,10623639,10623672,10623730,10623774,10623775,10623776,10623777,10623979,10623980,10623981,10624126,10624127,10624128,10624129,10624272,10624273,10624274,10624275,10624276,10624277,10624278,10624279,10624280,10624281,10624282,10624283,10624284,10624285,10624286,10624287,10624288,10624387,10624388,10624657,10624680,10624709,10624710,10624712,10624722,10624889,10624890,10624891,10621981,10621982,10621983,10621984,10621985,10621986,10621987,10621988,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622012,10622013,10622014,10622015,10622016,10622017,10622018,10622019,10622020,10622021) 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'