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(10939571,10939643,10939737,10939738,10939739,10939740,10939794,10939882,10939883,10939884,10939911,10939982,10940060,4970700,4970711,4970738,10940289,10940290,4970994,4971024,4971025,4971029,4971063,4971064,4971065,10940497,10940502,4968188,8066966,4968310,4968311,4968315,8067077,4968425,4968488,4968489,4968490,8067252,4968491,4968492,4968493,4968494,4968520,8067290,4968565,4968566,8067374,8067377,8067434,8067439,8067448,8067465,8067473,8067474,8067477,8067479,8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067490,8067491,8067492,8067493,8067494,8067495,8067496,8067497,8067498,8067499,8067500,8067501,8067502,8067503,4968846,4968861,4968863,4968864,4968865,4968866,4968867,4968868,4968869,8067636,4968888,8067679,8067689,8067702,4968962,8067779,4969043,4969177,4969178,4969179,4969193,4969194,4969195,4969196,4969197,4969198,4969199,4969215,4969257,4969258,10938722,10938755,4969364,10938776,10938796,10938814,10938815,10938895,10938930,10938951,4969611,4969612,4969613,4969614,10939028,10939079,10939080,10939081,10939082,10939083,10939093,10939122,10939176,10939382,10939384,10939444,10939470,8065081,8065087,8065088,8065089,8065208,8065209,8065210,8065211,8065212,8065213,8065214,8065215,8065216,8065217,8065218,8065219,8065220,8065221,8075324,8065936,8065945,8065991,8065992,8065993,8065994,8065995,8065996,8065997,8065998,8065999,8066000,8066001,8066002,8066003,8066004,8066005,8066070,8066432,8066468,8066474,4967743,4967744,4967745,4967746,4967747,4967769,8066590,8066672,8066678,8066740,4968029,4968030,4968031,4968032,8066838,8064280,8064281,8064652,8064809,8064841,8064857,8064891,3655553,3655607,3655608,3655793,3655957,3656005,3656012,3656013,3656014,3656034,3656035,3656036,3656037,3656038,3656039,3656055,3656056,3656057,3656058,3656059,3656076,3656078,3656079,3656080,3656081,3656082,3656083,3656084,3656085,3656086,3656087,3656088,3656089,3656094,3656124,3656139,3656140,3656201,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072396,8072463,8072464,8072465,8072466,8072467,8072468,3656347,3656348,3656349,3656350,3656351,3656352,3656380,8072699,8072704,8072709,8072714,8072719,8072724,8072729,8072734,8072739,8072744,8072749,3656630,3656667,3656669,3656670,3656673,3656674,3656677,3656678,3656684,8072849,8072857,3656716,3656744,3656745,3656746,3656747,3656797,3656798,3656799,3656834,3656835,3656836,3656837,3656838,3656839,3656840,3656841,3656842,3656888,3656909,3656910,8073449,8073458,8073460,8073461,8073465,8073467,8073468,8073472,8073473,8073479,8073488,11049749,11049750,11049751,10622985,10623041,10918651,10918652,10918653,10918654,10918655,10918656,10918657,10918658,10918659,10918660,10918661,10918662,10918663,10918664,10918665,10918666,10918667,10918668,10918669,10918670,10918671,10918672,10918673,10918674,10918675,10918676,10918677,10918678,10918679,10918680,10918681,10918682,10918683,10918684,10918685,10918686,10918687,10918688,10918689,10918690,10918691,10918692,10918693,10918694,10918695,10918696,10918746,10918747,10918748,10918749,10918750,10918751,10918752,10918753,10918754,10918755,10918756,10918757,10918758,10918759,10918760,10918761,10918762,10918763,10918764,10918765,10918766,10623256,10918767,10623257,10623258,10918768,10623259,10918769,10918770,10623260,10918771,10918772,10918773,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10918783,10918784,10918785,10918786,10918787,10918788,10918789,10918790,10918791,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10918801,10918802,10918803,10918804,10918805,10918806,10918807,10918808,10918809,10918810,10918811,10918812,10918813,10918814,10918815,10918816,10918817,10918818,10918819,10918820,10918821,10918822,10918823,10918824,10918825,10918826,10918827,10918828,10918829,10918830,10918831,10918832,10918833,10918834,10918835,10918836,10918837,10918838,10918839,10918840,10918841,10918842,10918843,10918844,10918845,10918846,10918847,10918848,10918849,10918850,10918851,10918852,10918853,10918854,10918855,10918856,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,10918867,10918868,10918869,10918870,10918871,10918872,10918873,10918874,10918875,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10918884,10918885,10918886,10918887,10918888,10918889,10918890,10918891,10918892,10918893,10918894,10918895,10918896,10918897,10918898,10918899,10918900,10918901,10918902,10918903,10918904,10918905,10918906,10918907,10918908,10918909,10918910,10918911,10918912,10918913,10918914,10918915,10918916,10918917,10918918,10918919,10918920,10918921,10918922,10918923,10918924,10918925,10918926,10918927,10918928,10918929,10918930,10918931,10918932,10918933,10918934,10918935,10918936,10918937,10918938,10918939,10918940,10918941,10918942,10918943,10918944,10918945,10918946,10918947,10918948,10918949,10918950,10918951,10918952,10918953,10918954,10918955,10918956,10918957,10918958,10918959,10918960,10918961,10918962,10918963,10918964,10918965,10918966,10918967,10918968,10918969,10918970,10918971,10918972,10918973,10918974,10918975,10918976,10918977,10918978,10918979,10918980,10918981,10918982,10918983,10918984,10918985,10918986,10918987,10918988,10918989,10918990,10918991,10918992,10918993,10918994,10918995,10918996,10918997,10918998,10918999,10919000,10919001,10919002,10919003,10919004,10919005,10919006,10919007,10919008,10919009,10919010,10919011,10919012,10919013,10919014,10919015,10919016,10919017,10919018,10919019,10919020,10919021,10919022,10919023,10919024,10919025,10919026,10919027,10919028,10919029,10919030,10919031,10919032,10919033,10919034,10919035,10919036,10919037,10623567,10623568,10623569,10623582,10623628,10623693,10623768,10623809,10623817,10623827,10623833,10623834,10623835,10623836,10623837,10623838,10623839,10623840,10623862,10623863,10623865,10623866,10623867,10624098,10624217,10624218,10624219,10624225,10624229,10624632,10624633,10624659,10624660,10624661,10624662,10624663,10624664,10624665,10624666,10624841,10624888,10624915,10621975,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622064,10622065,10622066,10622074,10622075,10622076,10622089,10622093,10622103,10622132,10622409,10622548,10622679,10622730,10622843,10622847,10622872,10622873,10622903,10622924,10622947,10620002,10620044,10620045,10620065,10620074,10620076,10620324,10620329,10620346,10620348,10620352,10620372,10620409,10620566,10620567,10620568,10620569,10620570,10620571,10620576,10620577,10620578,10620589,10620636,10620857,10620858,10620996,10621063,10621064,10621116,10621144,10621163,10621165,10621567,10621568,10621775,10565176,10565195,10565329,10565330,10565463,10565464,10565465,10565466,10565467,10565619,10565620,10565621,10565883,10565887,10565970,10563567,10563693,10563694,10563695,10563696,10563697,10563698,10563699,10563700,10563701,10563702,10563703,10563704,10563705,10563706,10563707,10563708,10563709,10563710,10563711,10563712,10563713,10563714,10563715,10563716,10563717,10563718,10563719,10563720,10563721,10563722,10563723,10563724,10563725,10563726,10563727,10563728,10563729,10563730,10563731,10563732,10563795,10563796,10563813,10563827,10563828,10563829,10563924,10563925,10563936,10563937,10563945,10563946,10563955,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563975,10563976,10564141,10564142,10564151,10564200,10564882,10517272,10517276,10517333,10517334,10517335,10517336,10517337,10517338,10517339,10517340,10517341,10517342,10517343,10517344,10517345,10517346,10517347,10517348,10517349,10517350,10517351,10517352,10517353,10517354,10517355,10517356,10517357,10517358,10517359,10517360,10517361,10517362,10517363,10517364,10517365,10517366,10517367,10517368,10517369,10517370,10517371,10517372,10517373,10517374,10517375,10517376,10517377,10517378,10517379,10517380,10517381,10517382,10517383,10517384,10517385,10517386,10517387,10517388,10517389,10517390,10517391,10517392,10517393,10517394,10517395,10517396,10517397,10517552,10517605,10517650,10517651,10517652,10517653,10517670,10517944,10518202,10419306,10419314,10419315,10419316,10419317,10419318,10419350,10419446,10419447,10419524,10419525,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419592,10419593,10419594,10419627,10419628,10419629,10419703,10419757,10419796,10419923,10419936,10420061,10420099,10420136,10420142,10420143,10420149,10471005,10471006,10471087,10471088,10471249,10471415,10471457,10471524,10471525,10471532,10471533,10471534,10471535,10471536,10471566,10469895,10469906,10469915,10469917,10469931,10469936,10469938,10469939,10469942,10469946,10469990,10469991,10469992,10469993,10470312,10470345,10470356,10470357,10470358,10470809) 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'