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(8068857,10861282,10962690,10962692,8838541,10930368,7076109,11014870,11041100,11041101,11041102,11041103,11041104,11041105,11041106,11041107,11041108,11041109,11041110,11041111,8621345,8621346,8621347,8621348,8621349,8621350,8621351,8621352,8621353,8621354,8621355,8621356,8621357,10873835,10873851,10873880,10848977,10989389,11015520,11041643,10933327,7073986,11028804,10846979,10846980,7074243,7066269,8067356,8067357,8067358,8067735,7075119,10929400,10845109,10845110,10845111,10845112,10845113,8630064,8630094,8630095,8630113,7067471,8561589,8620703,10930145,6000278,7201326,8618046,8618047,8627893,8627894,8627899,8627900,8627902,8627903,8627904,8627905,8627906,8627920,8627921,8627922,8627925,8627926,8627928,8627929,8627930,8627931,8627932,8627933,8594942,8594943,7201614,7201615,8835915,8835916,11012267,10960336,8618532,8618533,8618534,8618535,8618536,8618537,8618538,8618539,8618540,8618541,8618542,8618543,8618544,10859130,10986582,10986583,10986584,10986585,10986586,7202257,10867322,8628775,10843911,7073198,10932546,10932547,10932548,10932549,10932550,10932551,10932552,10932553,10932554,10932555,10843968,8560186,10844074,8619200,8619201,10844280,10844281,10844282,11013220,11013221,11013222,11013223,11013224,11013225,7073575,11026301,11026302,11026303,11026304,7065654,7065683,10933058,10933059,10933060,10099869,3227186,8837282,10100010,8560833,8560839,3927459,11049212,10865620,10865621,8558284,8558285,8558286,8558287,8558294,8558295,8558296,8558297,11049379,8835126,10998351,8910780,8558827,8558828,8558829,11009213,3656198,10840448,10840449,10996688,11009716,11009717,11009718,11009719,11009720,11009721,11009722,11009723,11009724,11009725,11009726,11009727,11009728,11009729,11009730,11009731,11009732,11009733,11009734,11009735,10101515,10971310,10971311,3927181,8626548,8626549,8626550,8626551,8626552,10942553,10942554,11032679,3923455,10623373,10853650,10623464,10981274,8613741,8613742,8613743,8613744,8613745,8613746,8613747,8613748,8613749,8613750,7157467,3924419,3924420,3234555,3234598,10839573,10839574,10839575,10839576,10839594,10920404,10920405,10920406,10920407,10927483,10927484,10927485,10927486,10922490,10927494,11005833,8612028,11005960,11005961,10622516,8542007,10918095,8612401,11006369,8542210,11006519,7156460,10990652,3230391,8609838,8632704,8576285,8576286,8576287,10964824,10615222,10925821,10850608,10850609,10850610,10850611,8570377,8570378,3582039,3582040,3582041,3582042,3582043,3582044,3582045,3582046,3582047,3582048,11043391,11030533,11030534,9217520,9217521,10978622,10978623,10978624,10978625,10978626,10978627,10978628,10978629,10978630,10978631,10978632,9217720,9217721,9217722,9217723,10916690,10916691,10916692,10916693,10916694,10916695,10916696,10916697,10916698,10926897,11018097,11018098,11018099,11018100,11018101,11018102,11018103,11018104,11018105,11018106,8577647,8541089,8541244,10922469,10610965,7059512,7059513,7059514,7059724,7059725,9916005,8568325,10559698,10559699,6678163,9198015,9198016,9198017,9198018,9198019,9198020,9198021,9198022,9198023,9198024,10614858,8549450,8542528,10563195,10563196,10563197,10563198,10563199,10563200,10563201,10563202,10563203,10563204,10563205,10563206,10563207,10563208,10563209,10563210,10563211,10563212,10563213,10563214,10563215,8566135,7057863,8851656,9171876,8851705,10612546,9195924,10612623,10612715,7017910,7017911,7017912,7017913,6676569,6676570,8862898,8862899,9914627,10558621,10558650,10558651,10558670,10558671,10558672,10558673,9172909,9189126,9189213,9189222,7015068,9201422,8849260,10117739,9911825,9911826,4974570,8849961,3286096,9178679,9178680,9178681,9178682,9178683,9178684,9178685,10118988,9913049,9913056,9203020,9203021,10516909,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10516917,10516918,10517025,10517026,10517027,10415249,9168328,10415250,8918020,8918021,10117034,10117066,10418849,10418850,10117141,10117219,4973922,4973923,4973924,10428481,10125308,7055445,6666518,6678849,6666807,9174846,9174847,9166876,10471540,9917194,9917195,9207188,9207189,9207190,10123431,6679493,8916986,10123777,9207585,9207586,8550745,6667653,10116136,8917607,8917608,8917609,8917610,8917611,8917612,6667981,8847931,8551269,8917787,8917788,7013827,9176226,9176227,9176228,10179599,10898711,10169874,10169875,10169876,10159897,10628491,10884087,10175136,10175137,10175138,10175139,10175371,10175372,10175373,10175374,10175375,10175376,10175377,10175378,10175379,10175380,10175381,10175382,10175383,10175384,10175385,10175386,10175387,10175388,10175389,10175390,10170674,10170675,10170911,10156359,10156420,10912813,10907836,10179053,10179054,10179055,10179056,10179057,10179058,10174380,10913448,10166508,10905793,10905794,10910946,10910947,10910948,10910949,10910950,10910951,10911001,10911002,10911003,10911004,10911005,10911006,10949049,10187467,10187468,10187469,10187470,10187471,10157513,10187780,10187790,10187870,10631444,10631445,10188093,10188204,10907430,10574236,10574237,10652314,10652466,10652467,10652468,10652469,10598858,10598859,10572154,10572155,10569655,10572837,10572838,10572839,10572840,10653975,10653976,10575939,10570018,10582445,10582446,10582447,10582448,10582449,10582450,10582451,10591803,10591804,10523661,10546166,10546167,10546168,10546169,10550173,10550174,10520271,10520272,10520273,10534371,10538766,10522788,10424462,10424478,10424508,10508426,10508427,10508428,10508429,10508430,10508431,10508432,10505941,10505942,10505943,10505944,10505945,10505946,10505947,10505948,10505949,10505950,10505951,10505952,10505953,10505954,10505955,10489902,10489903,10489904,10489905,10489906,10489907,10489908,10489909,10489910,10489911,10489912,10473200,10473201,10473202,10473203,10473204,10473205,10413629,10409672,10492395,10492396,10492397,10486560,10492765,10490910,10490911,10474297,10495543,10415030) 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'