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(10845588,10845589,10845604,10845628,10845629,10845630,10845631,10943426,8574098,8574099,10873400,10846132,10873670,10873671,10873672,10873673,8583100,3229072,10846435,8631619,8621832,10849557,8067463,10847254,10847255,10847256,10871862,10871962,10871963,10871964,10871965,11042385,11042386,11042387,11042388,7066749,10964471,10844692,10872228,10844694,3227431,10872325,10844944,8573403,8561316,7075444,9214342,6000127,10866198,10866199,10866240,8617792,8617793,8617794,8617795,8617798,8617799,8617801,8617802,8617804,8617805,8617806,8617811,8617814,8617815,8617816,8617939,8617940,10972805,8559121,10103400,10103437,3238778,10843202,8595098,10866745,8559463,10986289,10986290,10986291,10986292,3899158,10103829,7201956,10843763,10867330,8618964,8618991,7073189,7073190,7073191,8836790,8619202,8619204,7073443,7073444,8596115,8836978,10844424,10844425,7073677,7073678,7073717,11010619,10865655,7071393,11011328,5999954,5999966,5999967,5999968,5999969,11011377,11011378,8558650,8558651,8558652,8558653,8970227,8970228,8970229,10839630,8563614,3235597,10996177,3656201,3656202,3656203,3656204,3656205,11009237,8908654,10840401,10840402,10970471,10840683,3926600,8565004,3926879,3926886,10101673,10942308,10971350,10971378,10971379,10971380,10971381,10942502,10967984,11006990,11006991,11007230,11007231,7197258,10981882,10981883,10981884,10981885,10981886,10981887,10981888,10981889,10981890,11008219,3235035,3235036,10854920,10855048,3235229,3235230,3235231,3235232,8552882,10953654,10427339,8611861,8611862,8611863,10836870,8905303,10953985,10617459,11045026,10928189,11045340,9216606,10425354,10615351,10850524,10615400,10952024,10926347,10848464,9217531,9217532,10952666,9217726,9217727,9217728,9217729,9217730,9217731,9217732,9217733,9217734,9217735,8540595,9217736,9217737,10952808,10952809,10952810,10952811,10952812,10952813,10926796,10926797,10926798,10926799,8541080,8541088,8904787,9189552,9165555,10562423,8568138,10559468,10559469,10559470,9197676,9197677,9197678,9197679,9197680,9197681,9197682,6669953,8864464,9166116,8542694,10612231,6676008,9171960,9171961,9211969,8566539,9212104,9188204,9188205,10609911,10613355,9204716,10121039,10561755,10561756,10561757,10561758,10561759,10561760,10561761,10561762,10561763,10561764,10561765,10561766,9188954,10561767,10561768,10561769,10561770,10561771,10561772,10561773,10561774,10561775,10561776,10561777,10561778,10561779,10561780,10561781,10561782,10561783,10561784,10561785,10561786,10561787,10561788,10561789,10561790,10561791,10561792,10561793,10561794,10561795,10561796,10561797,10561798,10561799,10561800,10561801,10561802,10561803,10561804,9173090,10125636,10513393,10513394,10513395,8592811,9201713,9161750,8592965,9169845,10118044,8551329,9170074,10118517,6674839,10514568,10514569,7056923,6675103,6675104,9913155,8552477,8552478,10427710,9160363,10419307,10419308,10419349,10428301,10428302,10418883,9209025,9209026,4973895,6681281,4973994,10420137,8549457,8549458,8549459,8549460,10122620,6666529,9190713,9174775,9174776,8550069,8550209,8854917,8916883,9191262,10123516,10123853,10123854,10123855,10123856,10123857,10123858,10123859,8917507,8917508,10462464,10462465,10462466,10462467,6667910,9191950,8917702,9168117,8917789,10628216,10628302,10628303,10628304,10628305,10628306,10628307,10628514,10175202,10175203,10894243,10894244,10884313,10628813,10628876,10628877,10628920,10628942,10628943,10628960,10628961,10628962,10628963,10889695,10889696,10910018,10900019,10910234,10905323,10912836,10912837,10153873,10153874,10153875,10153876,10153877,10153878,10153879,10153880,10153881,10153882,10153883,10153884,10908034,10164153,10164154,10164155,10164156,10164157,10164158,10908224,10908225,10908226,10908227,10176668,10176669,10176670,10176671,10176675,10176694,10630178,10630179,10161862,10910891,10177205,10891196,10891197,10891198,10891199,10177215,10177216,10177217,10177218,10177219,10177220,10177221,10177222,10177223,10177224,10177225,10177226,10177227,10177228,10177229,10177230,10177231,10177232,10177233,10177234,10177235,10177236,10177237,10177238,10177239,10177297,10177298,10177299,10177300,10177301,10631251,10876864,10881987,10881988,10912082,10912083,10950057,10945103,10631896,10652396,10652397,10652398,10643476,10643477,10643478,10643479,10643480,10643481,10643482,10643483,10602316,10602317,10602318,10602319,10583483,10583484,10608545,10647999,10648000,10590977,10590978,10590979,10590980,10590981,10578982,10590982,10590983,10590984,10590985,10590986,10590987,10590988,10590989,10590990,10579009,10604198,10579443,10579446,10579447,10579448,10579449,10525363,10523953,10527971,10527972,10527973,10527974,10527975,10527976,10527977,10527978,10546100,10540909,10521018,10521019,10510134,10424322,10424323,10424324,10508244,10509275,10423405,10423471,10510408,10510409,10509517,10509524,10509525,10509534,10509535,10509536,10509537,10509538,10509588,10509589,10509602,10509603,10510604,10509783,10509784,10509785,10509786,10509787,10509788,10509789,10509790,10509839,10509840,10509862,10509863,10509864,10509865,10509880,10424069,10423146,10423209,10423210,10483960,10407830,8562941,10492776,10410172,10493133) 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'