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(4970552,4970553,4970554,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970637,4970677,4970678,4970682,4970684,4970700,4970703,4970704,4970706,4970738,4970745,4970749,4970752,4970754,4970756,4970758,4970767,4970772,4970824,4970825,4970826,4970827,4970828,4970829,4970830,4970831,4970832,4970833,4970834,4970840,4970842,4970845,4970846,4970847,4970848,4970849,4970850,4970851,4970852,4970861,4970862,4970863,4970864,4970865,4970872,4970875,4970876,4970877,4970878,4970881,4970886,4970887,4970888,4970889,4970891,4970896,4970897,4970898,4970900,4970901,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970912,4970913,4970914,4970915,4970923,4970924,4970925,4970930,4970931,4970932,4970940,4970941,4970942,4970943,4970946,4970947,4970948,4970949,4970951,4970952,4970953,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970970,4970971,4970973,4970975,4970978,4970979,4970980,4970982,4970983,4970984,4970985,4970988,4970989,4970991,4970992,4970993,4971022,4971023,4971024,4971025,4971028,4971029,4971030,4971031,4971032,4971033,4971034,4971035,4971036,4971060,4971061,4971062,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971095,4971096,4971104,4971105,4971106,4968206,4968228,4968229,4968232,4968431,4968443,4968634,4968775,4968832,4968833,4969089,4969140,4969253,4969257,4969259,4969260,4969261,4969265,4969268,4969272,4969285,4969286,4969287,4969288,4969289,4969290,4969291,4969292,4969293,4969294,4969295,4969296,4969297,4969298,4969299,4969381,4969402,4969410,4969493,4969494,4969495,4969496,4969497,4969498,4969499,4969500,4969501,4969502,4969503,4969504,4969505,4969506,4969507,4969508,4969516,4969517,4969519,4969520,4969521,4969522,4969523,4969524,4969547,4969548,4969573,4969574,4969578,4969583,4969937,8075288,8075306,8075309,8075310,8075312,8075314,8075317,8075318,8075321,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075404,8075405,8075408,8075409,8075410,8075415,8075419,8075432,8075435,8075449,8075450,8075455,8075457,4967027,4967028,4967029,4967030,4967031,4967034,4967035,4967036,4967037,4967038,4967039,4967040,4967041,4967042,4967043,4967044,4967045,4967046,4967047,4967048,4967049,4967050,4967051,4967052,4967053,4967054,4967055,4967057,4967060,4967063,4967064,4967065,4967066,4967067,4967211,4967517,4967567,4967608,4967744,4967844,4967980,4967996,4967999,4968029,4968031,4968072,4968121,8072429,8072430,8072470,8072471,8072547,8072549,8072553,8072555,8072561,8072566,8072569,8072571,8072574,8072576,8072583,8072585,8072587,8072589,8072796,8072797,8072798,8072799,8072800,8072804,8072805,8072806,8072807,8072808,8072812,8072813,8072814,8072815,8072816,8072820,8072821,8072822,8072823,8072824,8072828,8072829,8072830,8072831,8072832,8072836,8072837,8072838,8072839,8072840,8072848,8072849,8072850,8072851,8072852,8072856,8072857,8072858,8072859,8072860,8072868,8072869,8072870,8072871,8072872,8072876,8072877,8072878,8072879,8072880,8072886,8072887,8072888,8072889,8072890,8072892,8072893,8072894,8072895,8072896,8072904,8072905,8072906,8072907,8072908,8072912,8072913,8072914,8072915,8072916,8072920,8072921,8072922,8072923,8072924,8072927,8072928,8072929,8072930,8072931,8072938,8072939,8072940,8072941,8072942,8072945,8072946,8072947,8072948,8072949,8072953,8072954,8072955,8072956,8072957,8072961,8072962,8072963,8072964,8072965,8072969,8072970,8072971,8072972,8072973,8072977,8072978,8072979,8072980,8072981,8073001,8073002,8073015,8073024,8073025,8073026,8073027,8073028,8073032,8073033,8073035,8073037,8073044,8073046,8073047,8073048,8073079,8073080,8073081,8073100,8073101,8073102,8073103,8073104,8073105,8073106,8073108,8073109,8073110,8073111,8073112,8073115,8073116,8073117,8073118,8073119,8073120,8073121,8073125,8073126,8073127,8073128,8073130,8073131,8073132,8073133,8073134,8073135,8073136,8073179,8073180,8073181,8073265,8073267,8073268,8073270,8073271,8073272,8073273,8073275,8073276,8073277,8073278,8073279,8073281,8073282,8073284,8073285,8073286,8073288,8073290,8073291,8073292,8073293,8073294,8073295,8073296,8073297,8073342,8073343,8073345,8073346,8073349,8073350,8073354,8073355,8073356,8073408,8073409,8073411,8073412,8073414,8073415,8073418,8073419,8073420,8073460,8073461,8073462,8073463,8073464,8073465,8073466,8073480,8073481,8073482,8073484,8073486,8073487,8073488,8073489,8073490,8073491,8073492,8073493,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,8073505,8073506,8073507,8073508,8073509,8073510,8073511,8073514,8073516,8073517,8073518,8073519,8073520,8073521,8073522,8073523,8073525,8073526,10622967,10622968,10622971,10622972,10622990,10622992,10622993,10622994,10622995,10622998,10622999,10623002,10623016,10623022,10623034,10623036,10623043,10623047,10623048,10623049,10623050,10623057,10623058,10623059,10623060,10623061,10623062,10623063,10623064,10623065,10623069,10623070,10623071,10623072,10623073,10623074,10623075,10623076,10623077,10623078,10623079,10623080,10623081,10623082,10623083,10623084,10623085,10623086,10623087,10623088,10623089,10623170,10623181,10623182,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623208,10623256,10623257,10623296,10623297,10623298,10623299,10623300,10623301,10623302,10623303,10623305,10623309,10623312,10623480,10623481,10623482,10623491,10623492,10623493,10623494,10623495,10623497,10623498,10623499,10623500,10623501,10623502,10623503,10623504,10623505,10623507,10623508,10623516,10623519,10623520,10623521,10623566,10623582,10623585,10623586,10623601,10623602,10623607,10623609,10623617,10623622,10623625,10623626,10623656,10623658,10623659,10623660,10623661,10623662,10623663,10623664,10623665,10623666,10623667,10623668,10623669,10623670,10623671,10623672,10623673,10623674,10623675,10623676,10623677,10623678,10623679,10623680,10623681,10623682,10623683,10623684,10623685,10623686,10623687,10623688,10623689,10623690,10623691,10623692,10623718,10623753,10623758,10623760,10623761,10623762,10623763,10623764,10623765,10623766,10623782,10623798,10623808,10623810,10623811,10623812,10623831,10623938,10623963,10623964,10623976,10623981,10624043,10624067,10624069,10624081,10624109,10624112,10624173,10624196,10624197,10624198,10624200,10624203,10624226,10624233,10624271,10624335,10624336,10624337,10624343,10624344,10624345,10624346,10624401,10624434,10624506,10624533,10624575,10624603,10624608,10624611,10624625,10624632,10624633,10624639,10624670,10624695,10624710,10624712,10624714,10624725,10624726,10624729,10624730,10624740,10624786,10624787,10624788,10624831,10624835,10624841,10624850,10624871,10624886,10624893,10624896,10624897,10624920,10621973,10621981,10621982,10621984,10621986,10621987,10621988,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622012,10622013,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622026,10622027,10622028,10622029,10622030,10622031,10622032,10622033,10622037,10622038,10622039,10622040,10622041,10622042,10622043,10622044,10622045,10622046,10622049,10622050,10622051,10622052,10622053,10622054,10622056,10622057,10622058,10622059,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622070,10622072,10622073,10622074,10622075,10622076,10622077,10622078,10622079,10622080,10622081,10622082,10622083,10622084,10622085,10622086,10622087,10622088,10622089,10622090,10622091,10622092,10622093,10622094,10622095,10622096,10622097,10622098,10622099,10622100,10622101,10622102,10622103,10622104,10622105,10622106,10622107,10622108,10622109,10622110,10622113,10622114,10622116,10622117,10622118,10622119,10622120,10622121,10622122,10622123,10622128,10622129,10622130,10622131,10622132,10622141,10622142,10622143,10622144,10622178,10622186,10622187,10622190,10622191,10622192,10622193,10622194,10622195,10622196,10622197,10622217,10622224,10622225,10622261,10622264,10622265,10622266,10622267,10622268,10622269,10622272,10622275,10622277,10622285,10622289,10622304,10622321,10622322,10622335,10622343,10622345,10622346,10622347,10622348,10622349,10622352,10622355,10622358,10622361,10622362,10622371,10622378,10622384,10622406,10622409,10622414,10622417,10622428,10622433,10622457,10622462,10622463,10622466,10622468,10622469,10622470,10622474,10622475,10622476,10622478,10622480,10622481,10622490,10622491,10622497) 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'