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(10944045,10944046,10944047,10944048,10944049,10944050,10944051,10944086,10944087,10944088,10944089,10944090,10944091,10944092,10944093,10944094,10944095,10944096,10944097,10944098,10944099,10944100,10944101,10944102,10944103,10944104,10944105,10944106,10944107,4971100,4971104,4971105,4971106,10437213,10437215,10437216,4968633,4968638,4968639,4968640,4968641,10437287,10437288,10437289,10437290,10437305,10437310,10437422,10437429,10437430,10437431,10437432,10437576,10437577,10437578,10437579,10437580,8067881,8068097,4969493,4969494,4969495,4969496,4969497,4969498,4969499,4969500,4969501,4969502,4969503,4969504,4969505,4969506,4969507,4969508,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,4969519,4969520,4969521,4969522,4969523,4969524,4969628,4969629,4969630,4969631,4969632,4969633,4969634,4969635,4969636,4969637,4969638,4969639,4969640,4969641,4969642,4969643,4969644,4969645,4969646,4969647,4969648,4969649,4969650,4969651,4969652,4969653,4969654,4969655,4969656,4969657,4969658,4969659,4969660,4969661,4969662,4969663,4969664,4969665,4969666,4969667,4969668,4969669,4969670,4969671,4969672,4969673,4969674,4969675,4969676,4969677,4969678,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969686,4969687,4969688,4969689,4969690,4969691,4969692,4969693,4969694,4969695,4969696,4969697,4969698,4969699,4969700,4969701,4969702,4969703,4969704,4969705,4969706,4969707,4969708,4969709,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969728,4969729,4969730,4969731,4969732,4969733,4969734,4969735,4969736,4969737,4969738,4969739,4969740,4969741,4969742,4969743,4969744,4969745,4969746,4969747,4969748,4969749,4969750,4969751,4969752,4969753,4969754,4969755,4969756,4969757,4969758,4969759,4969760,4969761,4969762,4969763,4969764,4969765,4969766,4969767,4969768,4969769,4969770,4969771,4969772,4969773,4969774,4969775,4969776,4969777,4969778,4969779,4969780,4969781,4969782,4969783,4969784,4969785,4969786,4969787,4969788,4969789,4969790,4969791,4969792,4969793,4969794,4969795,4969796,4969797,4969798,4969799,4969800,4969801,4969802,4969803,4969804,4969805,4969806,4969807,4969808,4969809,4969810,4969811,4969812,8068459,4969813,8068460,4969814,4969815,4969816,4969817,4969818,4969819,4969820,4969821,4969822,4969823,4969824,4969825,4969826,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969834,4969835,4969836,4969837,4969838,4969839,4969840,4969841,4969842,4969843,4969844,8068492,4969845,4969846,4969847,4969848,4969849,4969850,4969851,4969852,4969853,4969854,4969855,4969856,4969857,4969858,4969859,8068610,8068645,8068646,8068647,8068648,8068649,8068650,8068682,8068718,8068748,8068749,8068750,8068751,8068767,8068768,8068769,8068770,8068771,10931571,10931634,10931638,10931672,10931706,10931707,10931708,10931709,8075225,10931859,10931860,10931861,8075298,10931996,4967148,4967149,4967150,4967151,4967152,4967153,4967154,4967155,4967156,4967157,4967158,4967159,4967160,10932305,10932324,10932369,10932370,10932386,10932387,10932388,10932389,10932390,10932441,10932442,10932471,10932578,10932736,10932745,10932751,10932783,10932784,10932787,10932912,10932928,10932929,10932930,10932943,10933004,10933005,10933023,10933035,10933191,10942781,10942820,10942821,10942822,10942823,10942824,10942825,10942826,10942905,10942906,10942907,10942908,10942909,10942910,10942911,10943049,10943128,10943153,10943154,10943304,10943305,10943306,10943307,10943317,10943319,10943322,10943327,10943371,10943385,10943405,10943414,10940534,10940554,8072554,8072555,8072586,8072587,8072753,8072754,8072755,8072756,8072757,10941791,10941800,10941820,10941827,10941828,10941834,10941860,10941861,10941876,10941877,8073024,10941886,8073025,8073026,8073027,8073028,8073030,8073044,8073045,8073046,8073047,8073048,10941921,10941934,10941941,10941962,10941986,10942000,10942116,10942117,10942441,10942475,10942483,10942484,10942524,10923474,10923475,10923498,10923499,10923500,10923501,10622993,10622994,10622995,10622997,10622998,10622999,10923512,10923513,10923529,10623057,10923613,10923614,10923615,10923616,10923617,10923618,10923619,10923620,10923621,10923622,10623334,10623428,10623605,10623606,10925099,10925100,10925101,10925102,10925103,10925104,10925105,10925106,10925107,10925108,10925109,10925110,10925111,10925112,10925113,10925114,10925115,10925116,10925117,10925118,10925119,10925120,10925121,10925122,10925123,10925124,10925393,10925394,10925395,10925396,10925400,10925401,10925402,10925403,10925404,10925405,10925406,10925407,10925408,10925415,10925416,10925417,10925418,10925419,10925420,10925426,10925427,10925428,10925432,10925433,10925446,10925447,10925448,10621981,10922534,10922550,10922551,10922552,10922553,10922554,10922555,10922583,10922584,10922620,10922621,10922622,10922623,10922624,10922631,10922653,10922654,10922655,10922656,10922657,10922658,10922659,10922660,10922661,10922662,10922663,10922664,10922665,10922666,10922667,10922692,10922696,10922722,10622260,10622261,10622263,10622270,10622272,10622277,10622279,10622305,10922848,10622343,10622361,10622362,10622363,10622364,10622366,10622371,10622376,10622378,10622379,10622399,10622400,10622417,10922930,10922931,10922932,10922933,10922934,10922935,10622425,10922936,10922937,10922938,10922939,10922940,10922941,10922942,10622433,10622434,10922947,10622438,10622439,10922956,10622457,10622458,10922969,10922970,10922978,10922982,10922983,10923014,10622506,10923018,10622521,10622524,10622525,10622527,10622528,10622530,10622535,10622537,10622538,10923081,10923441,10622939,10622940,10923464,10920519,10620014,10620015,10620016,10620018,10920603,10920677,10620209,10620210,10620211,10620212,10920736,10920737,10620239,10620240,10620241,10620252,10920780,10920787,10920788,10620361,10620362,10620491,10921281,10921606,10921677,10621282,10621283,10621360,10621361,10621363,10621364,10621365,10621366,10621369,10621370,10621373,10621424,10621430,10621431,10621434,10621442,10621443,10621494,10621495,10621498,10621499,10621504,10621506,10621509,10621512,10621535,10621536,10922081,10621579,10621612,10621613,10621614,10621616,10621617,10621618,10922218,10922219,10922220,10922221,10922222,10922223,10922224,10922227,10922228,10922229,10922436,10922437,10614094,10614243,10614250,10614268,10614272,10614316,10565673,10614730,10614731,10614786,10614808,10614809,10614810,10612105,10612253,10612264,10612286,10612411,10612483,10612493,10612520,10612524,10612525,10612526,10612527,10612528,10612531,10612532,10612538,10612547,10612551,10612552,10612554,10612555,10612556,10612557,10612558,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612579,10612580,10612608,10612609,10612618,10612619,10612644,10612711,10612716,10612717,10612737,10612755,10612836,10612837,10612838,10612839,10612844,10612845,10612847,10612848,10612853,10612865,10612874,10612875,10612876,10612879,10612880,10612881,10612936,10612993,10613023,10613090,10613163,10613171,10613201,10613225,10613233,10564428,10564429,10564430,10564433,10564434,10564435,10564436,10564437,10564438,10564439,10564440,10564443,10613538,10613549,10613550,10613557,10564991,10564995,10511168,10511169,10511170,10511310,10511311,10511356,10511357,10517555,10517714,10517715,10517716,10517717,10517958,10517959,10517960,10517961,10517962,10517963,10517964,10517965,10517966,10517967,10517968,10517969,10517970,10517971,10517972,10517973,10517974,10517975,10517976,10518145,10518146,10518147,10518424,10518425,10518426,10518427,10518428,10518429,10518430,10518431,10518432,10518433,10518434,10518435,10518436,10518437,10518438,10518439,10518440,10518441,10518442,10518443,10518444,10518445,10518446,10518447,10518448,10518449,10518450,10518451,10518452,10512549,10512550,10512551,10512753,10512754,10512755,10513075,10513082,10416277,10416349,10416350,10419364,10419365,10416371,10419388,10419389,10419390,10419391,10416415,10416492,10416505,10416506,10416519,10419569,10419570,10419908,10419909,10419910,10419911,10419912,10419913,10419914,10419915,10419916,10419918,10419919,10419920,10419922,10419924,10416925,10419926,10416926,10419927,10416927,10419928,10416928,10419929,10416929,10419930,10416930,10416931,10419931,10419932,10419933,10419934,10419935,10419939,10419940,10419941,10419943,10419945,10419946,10419947,10419948,10419949,10419950,10416983,10416984,10420003,10420005,10417014,10417055,10417185,10417193,10417201,10465734,10465735,10465736,10465737,10465738,10465761,10465762,10465770,10465796,10465797,10465798,10465799,10465800,10465801,10465802,10465803,10465804,10465805,10465806,10465807,10465808,10465809,10465810,10469909,10469918,10469950,10469953,10470407,10470529,10470630) 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'