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(8630690,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630737,8630738,8630739,8630740,8630741,8630743,8630744,8630745,8630765,8630913,8630914,8630998,8631004,8631009,8631024,8631025,8631026,8631027,8631028,8631029,8631069,8631070,8631072,8631074,8631075,8631077,8631079,8569453,8631125,8631126,8631130,8631131,8631133,4970738,8631188,8631190,8631191,10963260,8631254,8631277,8631471,8631472,8631473,8631474,8631475,8631476,8631477,8631478,8631479,8631496,10950485,8631506,8631521,8631522,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8631566,8631567,8631568,8631569,8631570,8631571,8631572,8631573,8631574,8631575,8631576,8631577,8631612,8631613,8631622,8631623,8631624,8631625,8631626,8631628,8631629,8631630,8631631,8631632,8631633,8631634,8631640,8631641,8631642,8631643,8631677,8631678,8631679,8631693,8631694,8631695,8631697,8631698,8631702,8631711,8631712,8631716,8631730,8631731,8631732,8631775,8631807,8631828,8631846,8631849,8631852,8631854,8631860,8631861,8631862,8631867,8631900,8575658,8575659,8575733,8575734,8575735,10437503,8632430,8632431,8632432,8632433,8632434,8632490,8632491,8632492,8632493,8632494,8632495,8632496,8632497,8632498,8632499,8632500,8632501,8632502,8632503,8632507,8632508,8632509,8632510,8632511,8632512,8632513,8632514,8632515,8632516,8632517,8632518,8632519,8632520,8632521,8632522,8632523,8632524,8632525,8632526,8632527,8632528,8632530,8632537,8632538,8632540,8632542,8632543,8632557,8632558,8632559,8632560,8632575,8629581,8629582,8629583,8629584,8629585,8629586,8629587,8629588,8629589,8629596,8629598,8629599,8629600,8629601,8629602,8629603,8629604,8629607,8629608,8629609,8629610,8629611,8629612,8629613,8629615,8629616,8629617,8629618,8629619,8629620,8629621,8629622,8629623,8629624,8629625,8629626,8629627,8629628,8629629,8629630,8629631,8629632,8629633,8629634,8629635,8629639,8629640,8629641,8629642,8629643,8629647,8629648,8629649,8629650,8629652,8629654,8629655,8629656,8629657,8629658,8629659,8629660,8629661,8629662,8629663,8629664,8629665,8629666,8629667,8629668,8629669,8629670,8629671,8629672,8629673,8629674,8629679,8629680,8629681,8629688,8629689,8629690,8629691,8629692,8629693,8629702,8629705,8629706,8629707,8629708,8629709,8629712,8629713,8629714,8629716,8629717,8629718,8629719,8629720,8629721,8629722,8629723,8629724,8629725,8629726,8629727,8629728,8629729,8629730,8629731,8629732,8629733,8629734,8629735,8629736,8629737,8629738,8629739,8629740,8629741,8629742,8629743,8629744,8629745,8629746,8629747,8629748,8629749,8629750,8629751,8629752,8629753,8629754,8629755,8629756,8629757,8629758,8629759,10844866,8629760,8629765,8629769,8629770,8629771,8629772,8629773,8629774,8629775,8629776,8629777,8629778,8629779,8629780,8629781,8629782,8629783,8629784,8629786,8629787,8629788,8629789,8629790,8629809,8629810,8629811,8629812,8629816,8629817,8629818,8629819,8629820,8629821,8629822,8629823,8629824,8629826,8629827,8629828,8629829,8629830,8629831,8629832,8629833,8629834,8629835,8629836,8629837,8629838,8629839,8629840,8629841,8629842,8629843,8629844,8629845,8629846,8629847,8629848,8629849,8629850,8629851,8629852,8629853,8629854,8629855,8629856,8629857,8629858,8629859,8629860,8629861,8629862,8629863,8629864,8629865,8629866,8629867,8629868,8629869,8629870,8629871,8629872,8629873,8629874,8629875,8629876,8629877,8629878,8629879,8629880,8629881,8629882,8629883,8629884,8629885,8629886,8629887,8629888,8629889,8629890,8629891,8629892,8629893,8629894,8629895,8629896,8629897,8629898,8629899,8629900,8629901,8629902,8629903,8629904,8629905,8629906,8629907,8629908,8629909,8629910,8629911,8629912,8629913,8629914,8629915,8629916,8629917,8629918,8629919,8629920,8629921,8629922,8629923,8629924,8629925,8629926,8629927,8629928,8629929,8629930,8629931,8629932,8629933,8629934,8629935,8629936,8629937,8629938,8629939,8629940,8629941,8629942,8629943,8629944,8629945,8629946,8629947,8629948,8629949,8629950,8629951,8629952,8629953,8629954,8629955,8629956,8629957,8629958,8629959,8629960,8629961,8629962,8629963,8629964,8629965,8629966,8629967,8629968,8629969,8629970,8629971,8629972,8629973,8629974,8629975,8629976,8629977,8629978,8629979,8629980,8629981,8629982,8629983,8629984,8629985,8629986,8629987,8629988,8629989,8629990,8629991,8629992,8629993,8629994,8629995,8629996,8629997,8629998,8629999,8630000,8630001,8630002,8630003,8630004,8630005,8630006,8630007,8630008,8630009,8630010,8630011,8630012,8630013,8630014,8630015,8630016,8630017,8630018,8630019,8630020,8630021,8630022,8630023,8630024,8630025,8630026,8630027,8630028,8630029,8630030,8630031,8630032,8630033,8630034,8630035,8630036,8630037,8630038,8630039,8630040,8630041,8630042,8630043,8630044,8630045,8630046,8630047,8630048,8630049,8630050,8630051,8630052,8630053,8630054,8630055,8630056,8630057,8630058,8630059,8630060,8630061,8630062,8630063,8630064,8630065,8630066,8630067,8630068,8630069,8630070,8630071,8630072,8630073,8630074,8630075,8630076,8630077,8630078,8630079,8630080,8630081,8630082,8630083,8630084,8630085,8630086,8630087,8630088,8630089,8630090,8630091,8630092,8630093,8630094,8630095,8630096,8630097,8630098,8630099,8630100,8630101,8630102,8630103,8630104,8630105,8630106,8630107,8630108,8630109,8630110,8630111,8630112,8630113,8630114,8630115,8630116,8630117,8630118,8630119,8630120,8630121,8630122,8630123,8630124,8630125,8630126,8630127,8630128,8630129,8630130,8630131,8630132,8630133,8630134,8630135,8630136,8630137,8630138,8630139,8630140,8630141,8630142,8630143,8630144,8630145,8630146,8630147,8630148,8630149,8630150,8630151,8630152,8630153,8630154,8630155,7201253,7201266,7201272,7201273,7201274,7201275,7201321,7201335,7201336,7201366,7201367,7201632,7201633,7201634,7201668,7201669,7201670,7201671,7201672,7201673,7201674,7201675,7201676,7201677,7201678,7201679,7201680,7201681,7201682,7201683,7201684,7201685,7201686,7201687,7201690,7201691,7201692,7201693,7201694,7201695,7201696,7201697,7201727,7201728,7201729,7201758,7201761,3899204,7202066,7202067,7202071,7202072,8618687,8618743,8618846,3899574,7202439,9794592,8572971,10997793,10997794,3237634,7200594,7200595,7200596,7200597,7200609,10985137,3238029,10943256,7200925,10996689,8564730,8564865,7199402,7199403,7199414,10101477,10101492,8565097,8565098,3233390,7196276,7196307,7196316,7196317,7196337,7196508,7196512,7196516,7196527,10623490,3233944,7196890,7196891,7196892,10839048,8907434,8907435,10839142,3235171,10619864,10619865,10619866,10619872,10619895,10619896,10953951,10953995,8612272,3230564,3230566,10620183,8570134,10620207,10951941,8576528,3231129,10965470,3231293,10616033,10621034,10621036,10621037,10621038,10621041,8541017,10616553,10611193,10611194,9189545,9189549,9173757,10559709,10559710,10559711,10559712,6665932,10562767,10614744,9214288,7057713,7057714,10609309,9211688,9211948,10610005,9220473,10613306,10610333,10613475,9197129,9169355,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10515316,10118827,4973244,4973903,9193226,9193255,10123176,9175497,9175498,9191534,10893950,10893983,10893986,10893990,10884653,10626963,10632106,10632107,10632108,10632109,10632110,7000890,7000891,10627319,7001145,10630100,10630101,10630102,10630103,10630104,10630105,10161923,10161924,10161926,10161927,10161928,10631885,10626955,10626956,10626957,10601174,10598808,10598832,10598841,10590278,10525567,10521871,10521872,10521873,10522404,10528578,10528579,10528580,10528581,10528582,10528583,10499116,10499117,10499118,10499119,10499120,10499121,10499122,10499123,10499124,10422354,10422361,10422363,10422364,10422365,10422366,10422367,10422368,10422372,10422373,10422374,10422375,10422376,10422377,10422378,10422379,10422380,10422381,10422382,10422383,10422403,10422599,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10420768,10420769,10423922,10424998,10407228,10407229,10407232,10407238,10407327,10486561,10486562,10486563,10486564,10486565,10486566,10486567,10486568,10486569,10486570,10486571,10487109,10487110,10487111,10487112,10406981) 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'