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(10939584,10939593,10939598,10939599,10939600,10939601,10939711,10939712,10939874,4970700,4970763,4970765,4970766,10940163,10940171,10940193,10940194,10940400,10940406,10940407,10940424,10940440,10940441,10940442,10940443,10940466,10940492,10940493,4971143,8066885,4968321,4968322,4968323,4968324,4968325,4968326,4968327,4968328,4968329,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968341,8067540,4968849,4968859,4968860,8067801,4969177,10938936,4969619,4969620,4969621,4969622,4969623,4969624,10939072,10939177,10939178,10939202,10939368,8065224,8065225,8065226,8065960,8065982,8066023,8066032,8066084,8066191,8066192,8066211,8066212,8066213,8066233,8066234,8066235,8066236,8066237,8066238,8066239,8066240,8066241,8066274,8066275,8066276,8066277,8066278,8066294,8066295,8066309,8066310,8066311,8066312,8066313,8066314,8066315,8066339,8066340,8066341,8066359,8066360,8066380,8066381,8066382,8066383,8066384,8066385,8066386,8066387,8066388,8066389,8066390,8066391,8066392,8066429,8066430,8066431,8066432,8066451,8066452,8066453,8066454,8066472,8066481,8066511,8066512,8066513,8066514,8066515,8066516,4968029,8066882,8064693,3655628,3656309,3656310,3656318,3656319,3656320,3656321,3656322,3656323,3656324,3656325,3656326,3656366,3656370,3656371,8072723,8072724,8072725,8072726,8072727,3656627,3656628,3656631,3656632,3656887,3656888,3656889,3656890,3656891,3656892,3656893,3656894,3656895,3656896,3656897,3656898,3656899,3656990,3656991,3656992,3656993,3656994,10623065,10918621,10918622,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623328,10623422,10919932,10920174,10920175,10920176,10920177,10621979,10621980,10917526,10917527,10622404,10622405,10622406,10622407,10917978,10917979,10917980,10917981,10622677,10622678,10622679,10622680,10622714,10622727,10622919,10619985,10619986,10620012,10620013,10620046,10620065,10620106,10620235,10620236,10620271,10620323,10620324,10620328,10620329,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10915912,10915913,10915914,10915915,10915916,10915917,10915918,10915919,10915920,10915921,10915922,10915923,10620414,10915924,10915925,10620487,10621077,10621078,10621122,10621123,10621153,10621154,10621247,10621248,10621249,10621250,10621251,10621269,10621294,10621295,10621310,10621311,10621312,10621313,10621314,10621315,10621341,10621342,10621363,10621364,10621365,10621366,10621367,10621373,10621389,10621390,10621391,10621392,10621393,10621394,10621395,10621396,10621572,10621573,10621574,10621583,10621637,10621638,10621668,10621669,10621670,10621718,10621719,10621720,10621721,10610986,10611037,10565189,10565225,10611084,10611100,10611101,10611102,10611103,10611142,10565318,10565338,10565339,10565340,10565341,10565342,10565648,10611692,10565885,10565886,10565887,10565888,10565889,10565890,10565891,10565892,10611774,10565927,10565937,10565938,10565957,10565958,10565959,10565963,10565964,10565965,10565966,10565967,10565968,10565969,10565970,10565971,10565972,10565973,10565974,10565975,10565976,10565977,10565978,10611832,10566007,10566008,10611861,10611862,10566016,10566017,10566018,10566019,10566020,10566021,10566022,10566023,10566039,10566064,10566065,10609303,10609318,10609319,10609332,10563568,10609669,10609676,10563923,10563924,10563925,10563926,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563934,10563935,10563936,10563937,10563938,10563939,10563940,10563941,10563942,10563943,10563944,10563945,10563946,10563947,10563948,10563949,10563950,10563951,10563952,10563953,10563954,10563955,10563956,10563957,10563958,10563959,10563960,10563961,10563962,10563963,10563964,10563965,10563966,10563967,10563968,10609818,10563969,10609819,10563970,10563971,10563972,10563973,10563974,10563975,10563976,10563977,10563978,10563979,10563980,10563981,10563982,10563983,10563984,10563985,10563986,10563987,10563988,10563989,10563990,10563991,10563992,10563993,10563994,10563995,10563996,10563997,10563998,10563999,10564000,10564001,10564002,10564003,10564004,10564005,10564006,10564007,10564008,10564009,10564010,10564011,10564012,10564013,10564014,10564015,10564016,10564017,10564018,10564019,10564020,10564021,10564022,10564023,10564024,10564025,10564026,10564027,10564028,10564029,10564030,10564031,10564032,10564033,10564034,10564035,10564036,10564037,10564038,10564039,10564040,10564041,10564042,10564043,10564044,10564045,10564046,10564047,10564048,10564049,10564050,10564051,10564052,10564053,10564054,10564055,10564056,10564057,10564058,10564059,10564060,10564061,10564062,10564063,10564064,10564065,10564066,10564067,10564068,10564069,10564070,10564071,10564072,10564073,10564074,10564075,10564076,10564077,10564078,10564079,10564080,10564081,10564082,10564083,10564084,10564085,10564086,10564087,10564088,10564089,10564090,10564091,10564092,10564093,10564094,10564095,10564096,10564097,10564098,10564099,10564100,10564101,10564102,10564103,10564104,10564105,10564106,10564107,10564108,10564109,10564110,10564111,10564112,10564113,10564114,10564115,10564116,10564117,10564118,10564119,10564120,10564121,10564122,10564123,10609973,10610053,10610054,10610170,10610192,10610196,10610197,10610232,10610270,10610271,10610279,10610284,10610296,10610318,10610319,10610327,10610408,10610497,10610791,10610928,10610937,10610939,10610940,10517267,10517268,10517269,10517317,10517318,10517325,10517326,10517327,10517552,10517614,10517615,10517616,10517654,10517655,10517673,10517674,10517675,10517682,10517683,10517684,10556630,10556631,10556632,10556633,10556634,10556635,10556636,10556637,10556638,10556639,10556640,10556641,10556642,10556643,10556644,10556645,10556646,10556647,10556648,10556649,10556650,10556651,10556652,10556653,10556654,10556655,10556656,10556657,10556658,10556659,10556660,10556661,10556662,10556663,10556664,10556665,10556666,10556667,10556668,10556669,10556670,10556671,10556672,10556673,10556674,10556675,10556676,10556677,10556678,10556679,10556680,10556681,10556682,10556683,10556684,10556685,10556686,10556687,10556688,10556689,10556690,10556691,10556692,10556693,10556694,10556695,10556696,10556697,10556698,10556699,10556700,10556701,10556702,10556703,10556704,10556705,10556706,10556707,10556708,10556709,10556710,10556711,10556712,10556713,10556714,10556715,10556716,10556717,10556718,10556719,10556720,10556721,10556722,10556723,10556724,10556725,10556726,10556727,10556728,10556729,10556730,10556731,10556732,10556733,10556734,10556735,10556736,10556737,10556738,10556739,10556740,10556741,10556742,10556743,10556744,10556745,10556746,10556747,10556748,10556749,10556750,10556751,10556752,10556753,10556754,10556755,10556756,10556757,10556758,10556759,10556760,10556761,10556762,10556763,10556764,10556765,10556766,10556767,10556768,10556769,10556770,10556771,10556772,10556773,10556774,10556775,10556776,10556777,10556778,10556779,10556780,10556781,10556782,10556783,10556784,10556785,10556786,10556787,10556788,10556789,10556790,10556791,10556792,10556793,10556794,10556795,10556796,10556797,10556798,10556799,10556800,10556801,10556802,10556803,10556804,10556805,10556806,10556807,10556808,10556809,10556810,10556811,10556812,10556813,10556814,10556815,10556816,10556817,10556818,10556819,10556820,10556821,10556822,10556823,10556824,10556825,10556826,10556827,10556828,10556829,10556830,10556831,10556832,10556833,10556834,10556835,10556836,10556837,10556838,10556839,10556840,10556841,10556842,10556843,10556844,10556845,10556846,10556847,10556848,10556849,10556850,10556851,10556852,10556853,10556854,10556855,10556856,10556857,10556858,10556859,10556860,10556861,10556862,10556863,10556864,10556865,10556866,10556867,10556868,10556869,10556870,10556871,10556872,10556873,10556874,10556875,10556876,10556877,10556878,10556879,10556880,10556881,10556882,10556883,10556884,10556885,10556886,10556887,10556888,10556889,10556890,10556891,10556892,10556893,10556894,10556895,10556896,10556897,10556898,10556899,10556900,10556901,10556902,10556903,10556904,10556905,10415223,10415224,10415228,10415229,10415233,10415300,10415301,10415302,10415303,10415341,10419404,10419405,10415413,10415422,10415437,10419438,10419439,10415484,10415485,10415486,10419564,10419565,10415599,10415806,10415924,10419940,10415948,10415958,10415976,10415987,10415993,10420002,10416098,10416099,10420125,10416138,10416139,10420160,10420161,10416166,10416167,10416168,10420178,10420179,10420187,10420193,10420206,10420210,10420213,10463004,10463009,10463023,10463028,10463029,10463053,10463054,10463059,10463397,10463398,10463439,10471537,10471541,10463656,10463676,10463677,10463729,10463732,10463755,10463756,10463757,10463795,10463796,10463797,10463798,10463799,10463802,10463810,10463811,10470345,10470346,10470347,10470348,10470349,10470350,10470351,10470352,10470353,10470354,10470355,10470647,10470648,10470804) 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'