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(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,4970475,4970476,4970477,4970651,4970652,4970653,4970654,4970655,4970656,4970657,4970658,4970667,4970668,4970683,4970686,4970707,4970718,4970733,4970746,4970747,4970770,4970879,4970880,4970901,4970903,4970904,4970907,4970909,4970910,4970913,4970915,4970916,4970954,4970955,4970967,4970968,4970990,4970991,4971090,4968164,4968168,4968531,4968648,4968649,4968682,4968692,4968716,4968717,4968718,4968719,4968720,4968721,4968722,4968723,4968930,4969175,4969298,4969375,8075245,8075253,8075261,8075262,8075263,8075264,8075265,8075266,8075267,8075402,8075403,8075406,8075411,8075412,8075416,8075417,8075418,8075434,8075451,8075452,8075454,8075456,4967032,4967134,4967140,4967344,4967514,4967773,4967873,4967874,4967875,4967876,4967877,4967878,4967879,4967880,4967881,4967882,4967883,4967884,4968075,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,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,8073528,8073529,8073545,10622972,10623100,10623128,10623139,10623140,10623141,10623142,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623204,10623206,10623208,10623248,10623363,10623381,10623493,10623494,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,10624336,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,10621982,10621984,10621985,10621986,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622012,10622014,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622026,10622029,10622031,10622033,10622034,10622035,10622036,10622037,10622038,10622039,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622053,10622054,10622055,10622057,10622058,10622059,10622060,10622061,10622062,10622063,10622064,10622065,10622066,10622068,10622069,10622070,10622071,10622074,10622075,10622076,10622078,10622079,10622080,10622081,10622083,10622088,10622089,10622090,10622092,10622093,10622094,10622095,10622099,10622100,10622101,10622102,10622103,10622106,10622107,10622108,10622109,10622110,10622113,10622114,10622115,10622116,10622117,10622118,10622119,10622120,10622121,10622122,10622123,10622127,10622128,10622129,10622130,10622132,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,10622499,10622503,10622504,10622505,10622536,10622542,10622547,10622677,10622678,10622679,10622680,10622681,10622701,10622702,10622703,10622715,10622716,10622717,10622729,10620080,10620103,10620104,10620137,10620172,10620225,10620254,10620255,10620256,10620257,10620258,10620259,10620302,10620306,10620338,10620339,10620340,10620341,10620342,10620346,10620348,10620350,10620351,10620352,10620353,10620354,10620357,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620371,10620372,10620374,10620375,10620376,10620377,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620389,10620390,10620391,10620392,10620393,10620394,10620395,10620396,10620397,10620398,10620399,10620400,10620401,10620402,10620403,10620404,10620405,10620406,10620407,10620408,10620411,10620412,10620413,10620414,10620415,10620416,10620417,10620418,10620419,10620420,10620421,10620422,10620423,10620425,10620467,10620680,10620713,10620714,10620715,10620716,10620717,10620718,10620798,10620799,10620800,10620916,10620917,10620918,10620919,10620923,10620939,10620940,10620941,10620942,10620943,10620944,10620945,10620946,10620947,10620948,10620949,10620950,10620951,10620952,10620953,10620954,10620955,10620956,10620957,10620958,10621051,10621052,10621123,10621139,10621143,10621277,10621280,10621282,10621283,10621374,10621792,10621950,10621951,10621952,10621953,10621954,10621955,10621956,10565142,10565152,10565156,10565174,10565209,10565214,10565215,10565216,10565233,10565243,10565245,10565343,10565344,10565345,10565346,10565674,10565675,10565676,10565677,10565678,10565679,10565680,10565681,10565682,10565683,10565684,10565685,10565686,10565687,10565688,10565689,10565690,10566080,10566081,10566082,10563292,10563295,10563296,10563366,10563367,10563368,10563369,10563393,10563394,10563395,10563396,10563397,10563398) 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'