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,4970247,4970254,4970260,4970262,4970279,4970286,4970287,4970288,4970289,4970290,4970291,4970302,4970320,4970334,4970339,4970340,4970341,4970342,4970362,4970368,4970376,4970382,4970384,4970396,4970400,4970401,4970402,4970403,4970404,4970405,4970406,4970407,4970408,4970409,4970410,4970411,4970412,4970413,4970414,4970415,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970425,4970426,4970427,4970428,4970429,4970430,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970440,4970441,4970442,4970443,4970444,4970445,4970446,4970447,4970448,4970449,4970450,4970451,4970452,4970453,4970463,4970475,4970476,4970477,4970490,4970509,4970514,4970522,4970523,4970524,4970525,4970526,4970527,4970534,4970543,4970545,4970559,4970563,4970565,4970576,4970584,4970597,4970598,4970604,4970618,4970625,4970627,4970628,4970629,4970630,4970631,4970632,4970633,4970634,4970635,4970636,4970651,4970653,4970667,4970668,4970707,4970718,4970733,4970740,4970741,4970746,4970747,4970753,4970770,4970879,4970880,4970891,4970895,4970901,4970903,4970904,4970907,4970909,4970910,4970913,4970915,4970916,4970917,4970921,4970922,4970931,4970952,4970954,4970955,4970962,4970965,4970967,4970968,4970984,4970986,4970990,4970991,4971070,4971072,4971090,4971129,4971131,4968164,4968168,4968531,4968648,4968649,4968682,4968692,4968716,4968717,4968718,4968719,4968720,4968721,4968722,4968723,4968860,4968930,4969175,4969298,4969375,4969581,4969588,4969593,4969600,4969606,4969610,4969619,4969624,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,8075245,8075261,8075262,8075263,8075264,8075265,8075266,8075267,8075288,8075402,8075403,8075406,8075411,8075412,8075416,8075417,8075418,8075434,8075451,8075452,8075454,8075456,4967032,4967134,4967140,4967344,4967514,4967549,4967550,4967551,4967552,4967558,4967561,4967562,4967563,4967564,4967565,4967566,4967574,4967575,4967576,4967577,4967578,4967579,4967580,4967586,4967596,4967597,4967598,4967606,4967613,4967615,4967618,4967646,4967647,4967648,4967654,4967655,4967656,4967657,4967658,4967659,4967666,4967669,4967677,4967678,4967679,4967680,4967706,4967709,4967723,4967731,4967739,4967743,4967759,4967763,4967767,4967770,4967773,4967774,4967775,4967780,4967782,4967785,4967786,4967808,4967817,4967835,4967836,4967873,4967874,4967875,4967876,4967877,4967878,4967879,4967880,4967881,4967882,4967883,4967884,4968075,4968126,4968131,8072303,8072304,8072305,8072306,8072307,8072308,8072309,8072310,8072311,8072312,8072313,8072314,8072315,8072316,8072317,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072375,8072376,8072377,8072378,8072379,8072380,8072381,8072382,8072383,8072384,8072385,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,8072396,8072397,8072398,8072399,8072400,8072401,8072402,8072403,8072404,8072405,8072406,8072407,8072408,8072409,8072410,8072411,8072412,8072413,8072414,8072415,8072416,8072417,8072418,8072419,8072420,8072421,8072422,8072423,8072424,8072425,8072426,8072427,8072428,8072429,8072430,8072431,8072432,8072433,8072434,8072435,8072436,8072437,8072438,8072439,8072440,8072441,8072442,8072443,8072444,8072445,8072446,8072447,8072448,8072449,8072450,8072451,8072452,8072453,8072454,8072455,8072456,8072457,8072458,8072459,8072460,8072461,8072462,8072463,8072464,8072465,8072466,8072467,8072468,8072469,8072470,8072471,8072472,8072473,8072474,8072475,8072476,8072477,8072478,8072479,8072480,8072481,8072482,8072483,8072484,8072485,8072486,8072487,8072488,8072489,8072490,8072491,8072492,8072493,8072494,8072495,8072496,8072497,8072498,8072499,8072500,8072501,8072502,8072503,8072504,8072505,8072506,8072507,8072508,8072509,8072510,8072511,8072512,8072513,8072514,8072515,8072516,8072517,8072518,8072519,8072520,8072521,8072522,8072523,8072524,8072525,8072526,8072527,8072528,8072529,8072530,8072531,8072532,8072768,8072769,8072770,8072771,8072772,8072778,8072779,8072780,8072781,8072782,8072793,8072794,8072795,8072796,8072797,8072798,8072799,8072800,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8072809,8072810,8072811,8072812,8072813,8072814,8072815,8072816,8072817,8072818,8072819,8072820,8072821,8072822,8072823,8072824,8072825,8072826,8072827,8072828,8072829,8072830,8072831,8072832,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,8072841,8072842,8072843,8072844,8072845,8072846,8072847,8072848,8072849,8072850,8072851,8072852,8072853,8072854,8072855,8072856,8072857,8072858,8072859,8072860,8072861,8072862,8072863,8072864,8072865,8072866,8072867,8072868,8072869,8072870,8072871,8072872,8072873,8072874,8072875,8072876,8072877,8072878,8072879,8072880,8072881,8072882,8072883,8072884,8072885,8072886,8072887,8072888,8072889,8072890,8072891,8072892,8072893,8072894,8072895,8072896,8072897,8072898,8072899,8072900,8072901,8072902,8072903,8072904,8072905,8072906,8072907,8072908,8072909,8072910,8072911,8072912,8072913,8072914,8072915,8072916,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072925,8072926,8072927,8072928,8072929,8072930,8072931,8072932,8072933,8072934,8072935,8072936,8072937,8072938,8072939,8072940,8072941,8072942,8072943,8072944,8072945,8072946,8072947,8072948,8072949,8072950,8072951,8072952,8072953,8072954,8072955,8072956,8072957,8072958,8072959,8072960,8072961,8072962,8072963,8072964,8072965,8072966,8072967,8072968,8072969,8072970,8072971,8072972,8072973,8072974,8072975,8072976,8072977,8072978,8072979,8072980,8072981,8072982,8072983,8073082,8073089,8073501,8073519,8073523,8073524,8073528,8073529,8073545,10622972,10623100,10623128,10623139,10623140,10623141,10623142,10623185,10623186,10623187,10623204,10623206,10623208,10623213,10623238,10623248,10623363,10623381,10623493,10623507,10623621,10623622,10623778,10623779,10623780,10623788,10623807,10623808,10623809,10623810,10623811,10623812,10623813,10623814,10623815,10623816,10623817,10623818,10623819,10623820,10623821,10623822,10623823,10623824,10623825,10623826,10623827,10623828,10623829,10623830,10623831,10623832,10624237,10624434,10624435,10624436,10624437,10624438,10624439,10624440,10624441,10624442,10624443,10624444,10624445,10624446,10624447,10624448,10624449,10624450,10624451,10624452,10624533,10624607,10624608,10624609,10624610,10624611,10624612,10624613,10624614,10624615,10624678,10624716,10624717,10624718,10624802,10624889,10624890,10624891,10624953,10624954,10624955,10624956,10624957,10624958,10624959,10624960,10621966,10621970,10621993,10621994,10621995,10622006,10622007,10622020,10622031,10622034,10622035,10622036,10622058,10622069,10622088,10622093,10622101,10622102,10622113,10622114,10622115,10622116,10622117,10622118,10622119,10622120,10622121,10622122,10622123,10622282,10622285,10622300,10622303,10622319,10622342,10622347,10622350,10622353,10622357,10622370,10622386,10622387,10622388,10622389,10622391,10622395,10622396,10622398,10622402,10622403,10622416,10622417,10622418,10622470,10622472,10622480,10622487,10622499,10622503,10622504,10622505,10622547,10622677,10622678,10622679,10622680,10622681,10622701,10622702,10622703,10622715,10622716,10622717,10622729,10620022,10620032,10620063,10620080,10620103,10620104,10620137,10620172,10620225,10620254,10620255,10620256,10620257,10620258,10620259,10620302,10620306,10620325,10620328,10620338,10620339) 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'