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(8630669,8630681,8630682,8630683,8630719,8630863,8630864,8630865,10848643,8631039,8631140,8631192,8631617,8631680,8631681,8631682,8631683,8631684,8631685,8631686,8631687,8631688,8631689,8631690,8631730,8631731,8631732,10950757,8631780,8631781,8631821,8631822,8631823,8631824,8631825,8631826,8631827,8631860,8631861,8631862,10849593,10862829,10990298,10863155,10863181,10863182,10863183,8629594,8629595,8629641,8629662,8629705,8629706,8629707,8629708,8629709,8630198,8630199,8630204,8630261,10845436,10861020,8630457,8630458,8630459,8630460,8630461,8630462,8630464,8630465,8630466,8630467,8630468,10861172,10861175,10861176,10861177,10861178,8630536,8630537,10861179,8630538,8627696,8627874,8627876,10866745,8628201,8628202,8628203,8628204,8628205,8628206,8628207,8628208,8628209,10960414,10960415,10960419,10960420,8628403,8628404,8628432,8628467,8065844,8628739,8628742,5654563,5654564,5654565,7202657,8629070,9794578,8629230,8629275,8629283,8629290,8629366,8629372,8629377,8629380,8629433,8629434,8629435,8629436,8629437,8629450,8626657,8626658,10857422,10865434,10865435,10865436,8626817,8834759,8834760,8627060,10865939,8627332,7201041,10858129,10858138,10858139,10858141,7201141,7201143,7198679,7198693,7198798,8625233,8625234,8625236,10856185,7199605,10864665,8626047,8626048,10864701,8626078,8626079,10101571,11048453,7199951,7199952,10865002,10865154,8626516,8626517,10865168,7196220,7196230,3923505,7196382,7196417,7196477,3923650,8906571,8906574,8906658,8906659,8906660,7196919,7196935,7196982,7197055,10838915,10838916,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,10854881,10854882,10854883,10854884,10854885,10854886,8624337,8624360,8624361,8624400,8624450,8624451,8624452,8624453,8624454,8624455,8624456,8624457,8624458,7198064,7198065,8624496,8624497,8624503,8624504,8624505,8624507,8624519,8624578,8904993,8904994,8904995,8905013,8634738,8634739,8634740,8634741,8634742,8634743,8634744,8634745,8634746,8634747,8634748,8634749,8634750,8634751,8634752,8634753,8634754,8634755,10617136,8634756,8634757,8634758,8634759,8634760,8634761,8634762,8634763,10617148,10617149,10617158,10617164,10617247,8634879,10954097,10954099,10622456,10954201,8905787,10425386,10425576,8633007,8633008,8633009,8633010,3581877,8633149,8633152,10850802,10850803,10615555,8633192,8633193,10425941,8633228,10426014,8633326,8633327,8633328,8633329,8633330,8633331,10615760,10426193,10426205,10615871,10615982,10426465,10426466,10616140,10616141,10616142,10616143,10616144,10616145,10616146,10616147,10616148,10616149,10616150,8611289,8634271,8634351,8634352,8634353,10851996,8904990,8904991,8904992,10614085,10614207,10714137,10611802,10611812,7057465,10612069,10609096,10609097,10609360,10612428,10609443,10609444,10612500,7017605,7017606,10612642,10612763,10612806,8852028,8852037,10609887,10609888,10609889,10609890,10609891,10609892,10609893,10609894,8566746,9220279,10609990,10613091,10610423,10610468,8852717,10613569,10117498,10117499,9911579,9177372,9169395,9911604,9169453,7055651,7055656,9911814,9911815,9169732,7015430,7015431,7015432,7015433,7015460,7015461,7015480,7015481,7015490,7015491,7015496,7015497,7015502,7015503,7015508,7015509,7015522,7015523,9177901,6674110,7015560,7015561,7015562,7015563,7015580,7015581,6674133,7015604,7015605,7015612,7015613,7015628,7015629,6674185,6674195,7015652,7015653,6674281,8849908,7016018,7016019,7016032,7016033,7016034,7016035,7016062,7016063,7016064,7016065,7016066,7016067,7016092,7016093,7016094,7016095,9912665,7016114,7016115,7016126,7016127,7016138,7016139,7016150,7016151,7016158,7016159,9912811,9171075,10418292,6672577,10416391,10418473,10416704,10418726,10418727,10418728,10418729,6673013,10416730,10416731,10416732,6673141,10418866,10417977,10418019,10418020,10418021,9169099,10418033,10418034,10117320,9169162,10117406,9169253,10470876,10470877,10470878,10470879,10471067,10467334,8550165,10467616,10469681,10116203,10883668,10888753,10888806,10889274,10889475,10884645,10885018,10890111,10882536,10882537,10882538,10882939,10882940,10882941,10882942,10882943,10882944,10888363,10888364,10888365,10888366,10885929,10885943,10886888,10886889,10886890,10886898,10887053,10882077,10882082,10882134,10882148,10882150,10608808,10608809,10608810,10647675,10607598,10607599,10607600,10607603,10604658,10604662,10604704,10508538,10508539,10508540,10508541,10508542,10507669,10411282,10410153,10410154,10410155,10410156,10410157,10410158,10410159,10410160,10410219,10412701,10412709,10412710,10412712,10406904,10415051,10415157,10415158,10415159,10415160,10407166) 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'