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(8630906,8630907,8630908,8631019,8631020,8631194,8631195,8631196,8631197,8631198,8631199,8631200,8631201,8631202,8631203,8631204,8631211,8631212,8631213,8631214,8631215,8631216,8631217,8631218,8631219,8631220,8631221,8631222,8631223,8631224,8631225,8631226,8631227,8631228,8631229,8631230,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631238,8631239,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,8631276,8631480,8631481,8631482,8631483,8631484,8631485,8631486,8631487,8631488,8631489,8631490,8631491,8631492,8631493,8631494,8631495,8631496,8631497,8631498,8631499,8631500,8631501,8631502,8631503,8631504,8631505,8631506,8631507,8631508,8631509,8631510,8631511,8631512,8631513,8631514,8631515,8631516,8631517,8631686,8632190,8632191,8632192,8632193,8632194,8632195,8632196,8632197,8632198,8632199,8632202,8632203,8632204,8632205,8632241,8632246,8632248,8632252,8632270,8632303,8632312,8632323,8632329,8632332,8632343,8632352,8632357,8632358,8632359,8632360,8632380,8632381,8632382,8632383,8632384,8632385,8632386,8632387,8632390,8632392,8632393,8632394,8632395,8632396,8632397,8632398,8632399,8632408,8632410,8632424,8632425,8632426,8632427,8632428,8632429,8632430,8632431,8632432,8632433,8632434,8632435,8632436,8632437,8632438,8632439,8632440,8632441,8632442,8632443,8632444,8632445,8632446,8632447,8632448,8632449,8632450,8632451,8632452,8632453,8632454,8632455,8632456,8632457,8632458,8632459,8632460,8629509,8629510,8629511,8629512,8629513,8629594,8629595,8067943,8629705,8629706,8629707,8629708,8629709,8629809,8629840,8629841,8629842,8629843,8629844,8629845,8629846,8629847,8629848,8630266,8630267,8630268,8630269,8630270,8630271,8630272,8630273,8630274,8630275,8630276,8630277,8630278,8630279,8630280,8630281,8630282,8630283,8630284,8630442,8630443,8630444,8630445,8630446,8630447,8630448,8630449,8630450,8630451,8630452,8630453,8630454,8630455,8627596,7201213,7201215,7201216,7201217,7201218,7201219,7201220,7201221,7201222,7201319,7201339,7201340,7201341,7201342,7201343,8627870,8627871,7201660,7201661,7201662,7201663,7201664,7201665,8628122,8628154,8628157,8628158,8628164,8628165,8628175,8628179,8628185,8628186,8628189,8628190,8911609,8911610,8911611,8911612,8628237,8628241,8628242,8628243,8628244,8628245,7202054,7202059,7202060,7202061,7202062,7202063,8628467,7202108,7202109,7202110,7202111,7202112,7202113,7202114,7202115,7202122,7202123,7202125,7202126,7202127,7202132,7202136,7202138,7202161,7202187,7202189,7202194,7202196,7202197,7202205,7202206,7202211,7202212,7202213,7202215,7202216,7202217,7202218,7202257,7202285,7202296,7202297,7202298,7202318,7202319,7202329,8628730,8628793,8628794,8628814,8628818,8628819,8628820,8628821,8628822,8628823,8628824,8628825,8628826,8628827,8628828,8628829,8628830,8628831,8628832,8628833,8628834,8628835,8628836,8628837,8628838,8628839,8628840,8628841,8628842,8628843,8628844,8628845,8628846,8628847,8628848,8628849,8628850,8628851,8628852,8628853,8628854,8628855,8628856,8628857,8628858,8628859,8628860,8628861,8628862,8628863,8628864,8628865,8628866,8628867,8628868,8628869,8628870,8628871,8628872,8628873,8628874,8628875,8628876,8628877,8628878,8628879,8628880,8628881,8628882,8628883,8628884,8628885,8628886,8628887,8628888,8628889,8628890,8628891,8628892,8628893,8628894,8628895,8628896,8628897,8628898,8628899,8628900,8628901,8628902,8628903,8628904,8628905,8628906,8628907,8628908,8628909,8628910,8628911,8628912,8628913,8628914,8628915,8628916,8628917,8628918,8628919,8628920,8628921,8628922,8628923,8628924,8628925,8628926,8628927,8628928,8628929,8628930,8628931,8628932,8628933,8628934,8628935,8628936,8628937,8628938,8628939,8628940,8628941,8628942,8628943,8628944,8628945,8628946,8628947,8628948,8628949,8628950,8628951,8628952,8628953,8628954,8628955,8628956,8628957,8628958,8628959,8628960,8628961,8628962,8628963,8628964,8628965,8628966,8628967,8628968,8628969,8628970,8628971,8628972,8628973,8628974,8628975,8628976,8628977,8628978,8628979,8628980,8628981,8628982,8628983,8628984,8628985,8628986,8628987,8628988,8628989,8628990,8628991,8629003,8629004,8629017,8629018,8629019,8629020,8629021,8629022,8629023,8629024,8629025,8629026,8629027,8629028,8629029,8629030,8629031,8629032,8629033,8629034,8629035,8629036,8629037,8629038,8629039,8629040,8629041,8629042,8629043,7202676,8629108,8629109,8629110,8629111,8629112,8629113,8629116,8629137,8629138,8629139,9794578,8629164,8629165,8629166,8629167,8629168,8629169,8629170,8629171,8629172,8629173,8629174,8629175,8629176,8629177,8629178,8629179,8629180,8629181,8629182,8629183,8629184,8629185,8629186,8629187,8629188,8629189,8629190,8629191,8629192,8629193,8629194,8629195,8629196,8629197,8629198,8629199,8629200,8629201,8629203,8629205,8629206,8629249,8629258,8629287,8629288,8629289,8629290,8629291,8629292,8629293,8629294,8629295,8629296,8629297,3227206,8626477,8626479,8626480,8626482,8626485,8626488,7200271,8626820,7200455,8627062,8627063,8627071,7200906,7200907,7200908,8627314,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8627430,8627431,8627432,8627433,8627434,8627435,8627441,8627442,8627443,8627444,8624496,8624497,8624498,8624499,8624500,8624501,8624502,8624503,8624504,8624505,8624506,8624507,8624508,8624509,8624510,8624511,8624512,8624514,8624515,8624516,8624517,8624518,8624519,8624520,8624521,8624522,8624523,8624524,8624525,8624526,8624527,8624590,8624591,8624680,8624693,3235763,7198677,7198678,7198679,7198680,7198681,7198682,7198683,7198684,7198685,7198686,7198687,7198688,7198689,7198690,7198691,7198692,7198693,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198705,7198706,7198707,7198708,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198726,7198727,7198728,7198729,7198730,7198731,7198732,7198733,7198734,7198735,7198736,7198737,7198738,7198739,7198740,7198741,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198758,7198759,7198760,7198761,7198762,7198763,7198764,7198765,7198766,7198767,7198768,7198769,7198770,7198771,7198772,8625250,8625251,8625252,8625253,8625254,8625255,8625256,8625257,8625258,8625259,8625260,8625261,8625262,8625263,8625264,8625265,8625266,8625267,8625268,8625527,8625528,8625529,8625530,8625533,8625534,8625535,8625536,8625537,8625550,8625557,8625558,8625559,8625563,8625564,8625565,8625566,8625568,8625573,8625574,8625577,8625580,8625581,8625583,8625588,8625589,8625590,8625591,8625592,8625593,8625594,8625595,8625596,8625597,8625598,8625621,8625622,8625623,8625624,8625625,8625626,8625627,8625628,8625629,8625630,8625631,8625632,8625633,8625634,8625635,8625636,8625637,8625638,8625639,8625640,8625641,8625642,8625643,8625644,8625645,8625646,8625647,8625648,8625649,8625650,8625651,8625652,8625653,8625654,8625655,8625656,8625657,8625658,8625659,8625660,8625661,8625662,8625663,8625664,8625665,8625666,8625667,8625668,8625669,8625670,8625671,8625672,8625673,8625674,8625675,8625676,8625677,8625678,8625679,8625680,8625681,8625682,8625683,8625684,8625685,11035974,8860445,10838853,7197608,7197619,7197621,7197630,7197633,7197635,7197636,7197639,7197640,7197641,7197644,7197649,7197651,7197654,7197657,7197660,7197661,7197663,7197664,7197667,7197668,7197671,7197672,7197674,7197676,7197679,7197681,7197682,10615435,10615758,10615759,10615810,10426356,10611830,10611831,10611864,10611892,10612075,10612076,10609348,10609350,10609351,10609352,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609376,10609377,10609378,10612381,10609385,10609386,10609772,10610000,10613145,10613152,10613153,10613154,10613155,10613156,10613163,10613169,10613173,10613191,10613192,10613266,9204792,10613678,10613695,10613696,10613697,10613698,10613699,10117611,9169587,9169588,6674195,10418361,10418367,10418371,10418398,10418425,10418427,10418450,6672814,10417980,10418997,10418998,10418999,10470166,10468225,9168023,9168024,10883680,10888971,10888973,10630117,10630118,10494362,10494364,10494365,10494377,10494380,10494381,10494382,10494383,10408025) 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'