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(7076016,7076017,7076045,7076046,7076047,7076048,7076050,9214740,9214741,9214742,9214743,9214744,9214745,9214746,9214747,9214748,9214749,9214750,9214751,9214752,9214753,9214754,9214755,9214756,9214757,9214758,9214759,8631161,8621625,3229278,8631809,8631832,8631833,8631834,8631835,8631836,8631876,8631877,8631878,8631879,8631880,8631881,8631882,8631883,8631884,8631885,8631886,8631887,8631888,7074305,8575575,10847312,7066679,7066686,7066696,8632417,9216441,7066798,7066799,7066800,7066801,10869145,8632515,10990557,8632545,8632546,8632559,8632560,9216569,8629599,10844714,10844716,10872703,10872704,10872705,10872706,10872707,10872708,10872709,10872710,10872711,10872712,10872713,10872714,10872715,7075503,10929901,9214292,9214293,8620490,8620491,10845439,8630404,8630405,9214423,9214424,7067773,7067774,7067775,7067776,7067798,7067799,10939429,7067806,7067837,7067838,7067839,7067840,7067841,9214507,10962543,10962544,10962545,10962546,10962547,10962548,10103160,10960063,10960351,7064690,10843447,10999422,10999423,8836280,8628574,10843756,10843757,10843758,7073161,10867458,10867459,10104456,7065451,10844217,10844218,10104595,10104612,10844259,10844308,10844309,10844355,8629278,10844411,10844452,10844454,10844455,8629471,8629568,10102112,8616849,8616850,8616851,8616852,3927531,8626840,8626841,8626842,8626843,8626844,8626845,8626846,7071336,7071570,7071571,7071572,7071573,7071577,7071578,7071579,7071580,7071581,7071582,7071583,7071584,7071585,7071586,7071587,10102863,7201007,10102895,10842548,10102985,10102986,10102995,10839704,10839824,10100265,8624810,8624811,8624812,10839993,8615253,7198678,7198679,7198680,7198681,7198683,7198684,7198685,7198688,7198690,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198705,7198706,7198707,7198709,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198727,7198728,7198729,7198730,7198731,7198733,10840242,7198736,7198737,7198738,7198739,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,8625155,7198757,7198759,7198760,7198762,7198763,7198764,7198765,8625166,7198766,8625167,7198769,7198771,7198772,8625364,8625366,8625371,3656296,10840569,10840570,10840612,10996786,10996787,10996788,10996789,8625779,10840894,10840904,10840905,10840906,10840907,10840910,10840925,10840949,10840994,10840995,10840996,10101373,10841001,10841002,10841005,8625916,8625917,8625918,8625919,8625920,8625921,10841049,10841050,10841063,10841064,8557260,8557261,10841073,8625966,10841078,10841080,10841091,10101503,8626069,10942057,8626084,10101599,10101600,10101601,8626126,11036182,11036183,8626198,10101715,8626253,10958371,10101991,10101998,3927276,3927277,3927279,8626546,3923384,3233457,3233458,3233459,3233460,3233461,3233462,3233463,8613010,8613011,11045878,3233618,10967902,3233638,3233639,3233640,3233641,3233702,3233703,3233704,3233705,3233716,3233719,10968148,10968149,7196711,10968214,10968215,10968216,10968217,10968218,10968219,8554632,10968441,7197241,7197243,10839007,8555315,8555316,10839212,3924928,10839429,8624406,8541491,8634670,8634671,8634672,8634673,8634674,8634675,8634676,8541562,8611952,8611953,10622187,10836916,10622217,10966878,10966879,10966880,10622224,10622225,10622235,10837019,8541851,10928067,10837321,11045347,11045348,10837424,10837425,10617736,11006428,11006429,11006430,11006436,11006437,11006438,11006439,11006440,11006441,11006442,11006443,11006444,11006445,11006446,11006447,11006448,11006449,11006450,11006451,11006452,10622877,10622878,10622879,8542389,7196134,7196136,7196138,7196140,7196144,7196146,7196148,7196149,7196170,7196172,7196174,7196177,8576141,8569964,3230463,3230464,8632720,10620107,10951720,10620139,10615179,10847983,10848116,10848117,8633263,10848408,10848409,10615683,10991357,10991358,10991359,10991360,10991361,8633509,8633510,8633511,8633512,8633513,8633514,8633515,8633516,8633517,8633518,8633519,8633520,8633521,8633522,8633523,8633524,8633525,8633526,8633527,8633528,8633529,8633530,8633531,8633532,8633533,8633534,8633535,8633536,8633537,8633538,8633539,8633540,8633541,10952900,10952901,8540781,3231695,3231697,8634316,8634345,8634346,8634347,8634348,8634349,8634350,10953432,8634432,8541338,10616888,8634559,8634560,7059764,7059766,7059767,9189623,3654852,3654853,3654854,7059861,6665751,9189835,6670232,6670233,10122408,10122409,10122410,7057470,7057471,9187441,9187442,10119741,9171601,10612264,7057913,9211844,9211845,9211846,9211847,9211848,9211849,9211902,7058094,10609707,8862698,9172322,9172323,3653575,10613077,9914642,10613292,8852771,6677303,6677304,10610791,8567732,9173254,9185485,9185486,10515311,7055775,10117938,10125957,4974664,4974665,4974666,9177910,7056189,7056190,7056213,9186152,6674713,6674715,6674721,6674731,10118904,10118905,7057244,9176357,9176365,9176366,9176367,9176419,6680970,9209137,10122496,6670624,10122727,9182549,6666667,8865199,6666896,10123123,8916902,9207304,6667380,6667403,6667683,10116158,9175976,6668107,6668108,9176202,9176261,9176275,9176276,9176277,9176278,10883552,10904084,10632166,10632189,10162047,10172270,10891375,10891376,10626432,10626433,10626434,10626435,10631546,10631549,10631885,10601175,10580339,10580340,10598532,10598533,10598534,10598560,10605445,10605446,10530196,10534280,10534281,10534282,10534283,10534284,10534285,10534286,10522818,10522890,10420244,10420245,10421371,10421372,10423646,10423647,10423648,10423649,10423650,10423651,10423652,10423653,10423654,10423655,10423656,10423657,10486098,10477598,10477599,10477600,10477601,10477602,10477603,10477604,10477605,10477606,10477607,10477608,10477609,10477610,10477611,10477612,10477613,10714837) 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'