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(10198082,10943433,7067934,7067935,7067936,7076009,10198347,10198400,10198401,10198402,10198403,10198404,10198492,10198493,10198494,10198495,7076285,7076310,7076311,8836419,10237762,10250948,10251002,10251003,10238067,10238068,10238069,10104620,7073975,7073976,7073999,7066018,7066270,7066271,10277727,10277728,10277729,8573404,7066753,7066754,7066755,10102514,8067906,10102595,10197290,7067197,7067205,7067207,10249518,10249625,10249633,10249634,10249647,10249648,10249649,8911096,6000215,7064055,7064071,10247622,7072588,7072589,7072590,7072591,7072592,7072593,7072594,7072607,10195947,4967055,10101424,10274412,10274413,10235437,10235438,10235439,10235440,10932646,10261446,10261447,10261448,10261449,10261470,10261471,10196471,10261472,10261473,10261474,10261475,10261476,10274545,10261551,10261552,10261553,10261554,10261555,10261556,10261557,10261558,10261559,10261560,10261561,10261562,10261563,10261564,10261565,10261566,10261567,10261568,10261569,10261570,10261571,10261572,7065339,10261597,10261598,8910253,8910258,10933193,10933194,7070944,10272320,10272321,7071130,10272426,10285444,4938497,4938498,4938499,8563615,8563616,10943133,10207863,10207864,8908214,8908215,8908216,10231123,10231379,10231380,7069312,7069313,7069408,10245008,10245009,10245010,10245011,10245012,8072793,8072794,8072795,8072796,8072797,8072798,8072799,10245184,8072800,10245328,10258460,10258461,10258462,10258463,8073096,8073097,10245502,10245503,10258580,10284613,10284614,10284615,10942139,10942140,8860373,10245827,10271829,7070660,8907259,8907260,8907261,8907262,8907263,7070766,10229232,10229233,10928680,10255443,10255444,10255445,10255446,10255447,10255448,10255449,10255450,10255451,10255452,10618389,10230123,10230124,8070921,10619373,10204488,10204489,10204490,10230544,10256556,10230713,10230714,10230715,10282803,10282804,10282805,10282845,10927481,10254265,10254332,10254333,10254354,10254355,10189451,10927937,10254887,10254888,10254889,10254890,10228890,10228891,10254891,10280965,10280966,10280967,10925528,10925529,10925530,10925531,10620072,10920598,10920599,10920600,10615232,10615233,10920847,10920848,10920849,10920850,10920851,10920852,10920853,10920854,10920855,10920856,10920857,10920858,10920859,10926016,10926017,10926018,10926019,10200666,10200667,10200730,10200733,8838712,10252969,10252970,10252971,10252972,10252973,10252974,10252975,10252976,10252977,10252978,10252979,10615880,10252980,10252981,10252982,10252983,10252984,10252985,10252986,10252987,10252988,10252989,10252990,10252991,10252992,10252993,10252994,10252995,10252996,10252997,10252998,10252999,10253000,10253001,10253002,10253003,10253004,10253005,10253006,10253007,10253008,10253009,10253010,10253011,10253012,10253013,10253014,10253015,10253016,10253017,10253018,10253019,10253020,10253021,10253022,10253023,10253024,10253025,10253026,10253027,10253028,10253029,10253030,10253031,10253032,10253033,10253034,10253035,10253036,10253037,10253038,10253039,10253040,10253041,10253042,10253043,10253044,10253045,10253046,10253047,10253048,10253049,10253050,10253051,10253052,10253053,10253054,10253055,10253056,10253057,10253058,10253059,10253060,10279061,10253061,10253062,10253063,10253064,10253065,10253066,10253067,10253068,10253069,10253070,10253071,10253072,10253073,10253074,10253075,10253076,10253077,10253078,10253079,10253080,10253081,10253082,10253083,10253084,10253085,10253086,10253087,10253088,10253089,10253090,10253091,10253092,10921609,10921621,10188507,10188508,10188509,10922064,10927110,10188702,10253798,10201879,10279907,10279908,10279909,10279920,10279921,10279922,10279923,10927446,10922458,10922459,9189323,9189501,9213554,7059748,7059749,9213594,8864302,9173789,9173790,9173791,9173792,9173793,9173794,9173795,9173796,9173797,9173798,9173799,9173812,9173813,9173814,9173818,9173819,10566059,10566063,10566064,10566065,10566066,9211346,7057517,9187495,10557444,10557445,10557446,10557447,9211783,9195863,9171967,9171970,9171971,9196152,9196153,8862680,8862681,8862682,9212316,9172432,9172433,9172434,9172435,10613352,10564680,10564681,10564682,9204931,9204932,9205119,4974316,9193478,9161480,10517306,10517307,10517308,10517309,10517310,10517311,10517312,9169553,4974415,9185660,9185661,9185662,9185663,10515491,9209963,9185969,9170011,10513887,10513888,10513889,10515897,10515898,10515899,10515900,10513900,10515901,10513901,10515902,10513902,10515903,10515904,10515905,10515906,9170190,9186196,9170210,4975159,9186327,10512155,10512156,10512176,10512177,9186494,9186609,9186633,9186703,9186729,10518771,10518772,10518773,10518774,10518775,10518776,10518777,10518778,10518779,10518780,10518781,10518782,10518783,10518784,9203032,7057452,10416240,10416242,9160372,9176437,10416535,10416643,10419668,9168791,4973664,4973665,10417765,10417774,10417782,10417797,10417798,9208902,9200951,9200957,10416934,10416935,10416936,10416937,10416938,10416939,10416940,10418051,9201137,10418081,10418093,10418123,4974125,4974154,9198387,9198429,9198430,9198431,9198502,9198503,9198504,6666532,6666534,9206747,9206748,9206749,9206750,4971643,10469516,10469517,10469518,10469587,10469602,9199047,8916779,8916787,10465754,8916911,8916912,9175299,10469936,10469937,9183389,10469967,10469968,10469969,6667539,9207556,9207557,9207558,8917321,8917477,9175900,10468766,10468767,10468768,10468838,10468839,10468840,10468841,10468842,10468843,10468844,9200285,9200286,9200287,9200288,9200289,9200290,10159487,10159488,10159489,10159490,10159491,10159492,10159493,10159494,10159495,10159496,10159497,10159498,10159499,10159500,10159501,10159502,10159717,10159718,10159719,10159898,10159899,10159941,10175655,10175656,10175657,10175658,10175659,10175660,10175661,10175662,10175777,10175778,10175779,10175815,10175819,10170880,10170881,10657371,10166143,10156206,10183493,10183494,10632123,10153845,10153846,10153898,10153899,10153900,10153901,10153902,10153903,10153904,10153905,10153906,10153907,10164043,10164044,10630100,10161838,10171981,10171982,10171983,10172102,10162109,10162400,10162401,10162408,10162409,10162410,10162411,10177494,10177495,10172510,10631059,10631060,10631061,10177688,10177689,10187700,10187701,10163283,10631797,10631810,10631811,10631816,10654649,10654650,10654651,10654652,10654653,10626954,10586293,10586456,10586457,10586458,10586459,10589648,10583670,10583671,10583672,10583673,10590148,10590149,10590150,10590151,10572496,10569676,10569677,10569678,10569679,10569680,10569681,10569682,10569683,10569684,10569685,10569686,10569687,10569688,10569689,10569690,10569691,10569692,10569693,10569694,10569695,10569696,10569697,10569698,10569699,10569700,10569701,10569702,10569703,10569704,10569705,10569706,10569707,10569708,10569709,10569710,10569711,10569712,10569713,10569714,10569715,10569716,10569717,10569718,10584719,10569719,10584720,10569720,10584721,10569721,10584722,10569722,10584723,10569723,10584724,10569724,10569725,10569726,10569727,10569728,10569729,10569730,10569731,10569732,10569733,10569734,10569735,10569736,10569737,10569738,10569739,10569740,10569741,10569742,10569743,10569744,10569745,10569746,10569747,10569748,10569749,10569750,10569751,10569752,10569753,10569754,10569755,10569756,10569757,10569758,10569759,10569760,10569761,10569762,10569763,10569764,10569765,10569766,10569767,10569768,10569769,10569770,10569771,10569772,10569773,10569774,10569775,10569776,10569777,10569778,10569779,10569780,10569781,10569782,10569783,10569784,10569785,10569786,10569787,10569788,10569789,10569790,10569791,10569792,10569793,10569794,10569795,10569796,10569797,10569798,10569799,10569800,10569801,10569802,10569803,10569804,10569805,10569806,10569807,10569808,10569809,10569810,10569811,10569812,10569813,10569814,10569815,10569816,10569817,10569818,10569819,10569820,10569821,10569822,10569823,10569824,10569825,10569826,10569827,10569828,10581965,10581966,10573218,10573219,10573220,10573221,10573222,10570481,10579789,10585973,10585974,10585975,10585976,10585977,10585978,10529161,10525372,10525373,10531377,10531378,10531379,10531380,10531532,10531533,10531534,10531535,10531536,10531537,10531775,10529908,10531929,10531930,10531931,10531932,10530069,10534204,10528267,10532325,10532326,10532327,10532329,10530401,10522682,10522683,10520738,10532738,10520739,10532757,10532758,10532759,10532760,10532761,10532762,10532763,10532764,10532835,10522862,10424641,10424644,10423823,10422006,10422017,10422037,10423051,10483085,10483200,10483201,10483205,10483206,10483213,10483214,10473283,10473284,10473285,10473286,10473287,10473288,10473289,10473290,10473291,10473292,10473293,10473294,10473355,10473356,10473357,10473358,10473359,10473360,10473458,10473459,10473460,10473461,10473462,10473463,10481612,10481613,10481614,10481615,10481616,10481617,10481618,10481619,10481620,10481623,10481624,10481625,10481626,10481627,10481628,10481868,10481869,10479991,10480043,10480046,10476509,10476510) 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'