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(9214820,10963065,8631069,8631070,7068485,7068605,7068606,10963297,10874039,8631520,8631651,8631652,8631663,8631664,8631665,8631666,8631667,8631668,8631669,8631670,8631671,8631672,8631673,8631674,8631675,8631676,8631677,8631678,8631679,8631680,8631692,8631693,8631694,8631695,8631696,8631697,8631698,8631699,8631700,8631701,8631702,8631703,8631704,8631716,8631722,8631723,8631724,8631725,8631726,8631727,8631728,8631729,8631733,8631734,8631740,8631741,8631742,8631743,8631744,8631745,8631746,8631747,8631748,8631749,8631750,8631751,8631752,8631753,8631754,8631755,8631756,8631757,8631758,8631845,8631846,8631847,8631848,8631849,10868923,10847426,8629745,8629746,8629747,8629748,8629770,8629771,8629772,8629773,8629782,8629785,3227870,10845268,10845276,8630296,7075759,7067782,7067783,9214461,10930085,10930086,10930087,10447728,8617824,8617848,8617849,8617850,8617851,8617852,8617853,8617854,8617855,8617856,8617857,8617858,8617859,7201300,7201301,7201302,7201303,7201321,7201349,7201353,7201365,10103266,8627785,8627786,8627787,8627788,8618019,10103343,10103350,10103362,10103363,10103364,10103365,7201519,8627959,8627965,8627972,8627977,8627982,8627983,8627984,8627985,8627986,8627987,8627988,8627989,8627990,7201677,8835973,8618386,8628202,8628203,8628204,8628205,8628206,8628207,8628208,8628209,8628229,8628230,8628274,8628275,8628276,10103761,8628277,8628278,8628279,8628280,8628281,8628282,8628283,8628284,8628285,8628292,8628293,8628308,8628309,8628310,8628311,8628312,3899183,8628591,8628599,8628601,8628602,8628603,8628604,8628626,8628630,8628631,8628657,8628658,8628670,8628671,8628707,8628741,8628742,8628743,8628744,8628772,8628790,8628792,8596060,8596061,8596063,8629090,9794588,10099828,10844443,10844473,10844479,10958633,10997874,10959002,7200582,7200583,8626998,8626999,8627000,8627002,8627003,8558319,8627062,8627063,8627069,8627070,8627071,8627087,8627122,10102613,8910574,8910575,8910576,7200787,8910606,8910607,7200887,7200914,10103008,8624601,8624609,8624610,10839808,10839809,3925530,3235595,10839995,8624926,7198748,7198749,11009307,8625456,8625457,8615898,3926538,3926539,3926541,3926542,3926544,3926545,3926546,3926547,7070206,11009980,11009981,11009982,11009983,11009984,11010085,11010086,11010087,8626049,11010088,11010091,11010092,11010093,11010094,11010095,11010096,11010099,11010100,11010106,11010107,11010108,11010109,11010110,11010111,11010112,11010113,11010123,11010124,8626115,8626116,8626117,8626120,8626124,8626125,8626126,8626127,8626128,8626129,8626130,8626131,8626149,8626152,8626158,8626159,8626262,8626263,8626264,8626265,8626266,8626267,8626268,8626269,8626270,8626271,8626272,8626273,8626274,8626275,8626276,8626277,8626278,8626279,8626280,8626469,10942492,8612858,8612859,11006873,11006874,11006887,11006909,11006910,11006913,11006914,11006915,11006916,11006917,11006918,11006919,11006920,11006921,11006957,11006958,11006959,11006960,11006961,11006962,11006963,11006964,11006965,11006966,11006975,11006977,11006982,11006983,11006984,11006987,11006988,11006992,11006993,11006994,11006995,11006996,11006997,11006998,11006999,11007000,11007001,11007002,11007003,11007004,11007005,11007006,11007007,11007008,11007009,11007010,11007011,11007012,11007013,11007014,11007015,11007016,11007017,11007018,11007019,11007020,11007021,11007022,11007023,11007024,11007025,11007026,11007027,11007028,11007029,11007030,11007031,11007032,11007033,11007034,11007035,11007036,11007037,11007038,11007039,11007040,11007041,11007042,11007043,11007044,11007045,11007046,11007047,11007048,11007187,3924078,3924249,3234722,3235005,3235006,3235007,8624253,3925014,8624340,8624342,8624359,8624373,8624395,8624396,8624397,8624398,8624399,8614618,8614619,8614620,8624499,8624500,8624501,3232354,3232355,3232356,3232357,3232358,3232359,3232405,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8611929,8634923,8634949,8634950,8635008,8635009,8612202,3922921,10954312,10954388,10954389,11006563,11006564,11006565,11006571,9216608,9216609,9216610,9216611,9216612,9216613,9216614,9216615,9216616,9216617,9216618,9216619,9216620,9216621,9216622,9216623,9216624,9216625,9216626,9216627,9216628,9216629,9216630,9216631,9216632,9216633,9216634,9216635,9216636,9216637,9216638,9216639,9216640,9216641,9216642,9216643,9216644,9216645,9216646,9216647,9216648,9216649,9216650,9216651,9216652,9216653,9216654,9216655,9216656,9216657,9216658,9216659,9216660,9216661,9216662,9216663,9216664,9216665,9216666,9216667,9216668,9216669,9216670,9216671,9216672,9216673,9216674,9216675,9216676,9216677,8570024,8570025,8570026,9216773,9216869,9216870,9216871,9216872,9216873,9216934,9216961,9216962,9216963,9216964,10848098,10848099,11004128,8633169,3231075,9217372,9217373,9217374,9217375,9217376,9217377,9217378,8633399,3231711,8634155,8634156,8634157,8634158,8634159,8634160,8634161,8634162,8634163,8634164,8634165,8634166,8634167,8634168,8634169,8634170,8634264,8634304,8634312,8634313,8634314,8634315,8634317,8634318,8634319,8634344,8634351,8634352,8634353,3232136,3232349,3232353,10611226,10611815,10614861,9913858,9913859,9914099,9914107,9914108,9914110,9914111,9914112,7058357,7058359,7058360,7058361,7058362,7058363,7058465,9220272,7058466,9196382,9196383,9196384,9212460,10564458,10564459,9914873,9914881,10610351,9172866,9197257,10428786,10515352,10515386,10515387,10515388,10515389,10515390,10515391,10515392,10515393,10515394,10515405,10515406,10515407,10117806,10117807,10515424,10515427,7055800,9912089,9913027,9913277,9910571,4973613,9206357,9206358,9206359,9206360,9198369,10122668,9198699,8916896,10123481,10123482,10123484,6667377,6667378,6667381,6667402,10123804,9175791,8917487,8917488,8917489,8917490,8917491,8917492,8917493,8917494,8917495,8917496,8917497,8593570,10628152,10628157,10164865,10175060,10165146,10165479,10165955,10166025,10910026,10171146,10171153,10171233,10171536,10166781,10166875,10167214,10168205,10626845,10626846,10626847,10626849,10601213,10601214,10601215,10601216,10601217,10601218,10598520,10604306,10607660,10549890,10528103,10542365,10542367,10424639,10509747,10483445,10483446,10485830) 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'