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(7067880,10939887,10943723,7076293,7076294,10943888,10943889,8569481,8569482,8569578,8569579,8569580,8569581,8569605,8569606,8569607,8569608,8569609,8569610,8569611,8569612,8569613,8569614,8569615,8569631,10944274,10944275,10944278,10944279,10944280,10944281,10944282,10944284,10944285,10944302,10944303,10944304,10944305,10944306,10944307,10944308,10944309,10944310,10944311,10944312,10944313,10944314,10944315,7065901,10933364,7066210,4968602,4968603,4968672,4968673,4968674,4968675,4968676,4968677,4968678,4968679,4968680,4968681,4968682,4968683,4968684,4968685,4968686,4968687,4968688,4968689,4968690,4968691,7074356,4968692,4968693,4968694,4968695,4968696,4968697,4968698,4968699,4968700,4968701,4968702,4968703,4968704,4968705,7066370,4968706,7074371,4968707,4968708,7066373,4968709,7066374,4968710,4968711,7066376,4968712,4968713,4968714,4968715,4968716,4968717,4968718,4968719,4968720,4968721,4968722,4968723,4968724,4968725,4968726,4968727,4968728,4968729,4968730,4968731,4968732,4968733,4968734,4968735,4968736,4968737,4968738,4968739,4968740,4968741,4968742,4968743,4968744,4968745,4968746,4968747,4968748,4968749,4968750,4968751,4968752,4968753,4968754,4968755,4968756,4968757,4968758,4968759,4968760,4968761,4968762,4968763,4968764,4968765,4968766,4968767,4968768,4968769,4968770,4968771,4968772,4968773,4968774,4968775,4968776,4968777,4968778,4968779,4968780,4968781,7066445,4968782,4968783,4968784,4968785,4968786,4968787,7066451,4968788,7066453,4968789,4968790,7066454,7066455,4968791,4968792,4968793,4968794,7066459,4968795,7066460,4968796,4968797,4968798,4968799,4968800,4968801,4968802,4968803,4968804,4968805,4968806,4968807,4968808,4968809,4968810,4968811,4968812,4968813,4968814,4968815,4968816,4968817,4968818,4968819,4968820,4968821,4968822,4968823,4968824,4968825,4968826,4968827,4968828,4968829,4968830,4968831,4968832,4968833,4968834,4968835,4968836,4968837,4968838,4968839,4968840,4968841,4968842,4968843,4968844,4968845,7066611,10964369,7066780,7066781,7066785,7066786,7066787,7066788,7066803,7074905,10938890,10938891,10938892,10938893,10938894,10938895,10938896,10938897,10938898,10938899,10938900,10938901,10938902,10938903,10938904,10938905,10938906,10938907,10938908,10938909,10938910,10938911,10938912,10938913,10938914,10938915,10938916,10938917,10938918,10938919,10938920,10938921,10938922,10938923,10938924,10938925,10938926,10938927,7075441,7075616,7075636,7067666,7067667,7067675,10959563,7064096,7064097,10931573,10931586,10931630,10960119,10960120,10960121,8075296,7072443,8075297,7072444,7072445,7072446,7072447,7064541,7064590,7064592,7064593,7064594,10960340,10960341,10960342,10960343,10960344,10960345,7064716,7064717,7064718,10960737,10960738,10960739,10960740,10960741,10960742,10960743,10960744,10960751,10960752,10960753,10960754,10960755,10960756,10960763,10960768,10960769,7065091,7065092,7065093,7065094,7065095,7065096,7065097,7065098,7065099,7065100,7065101,7065102,7065103,7065104,7065105,7065106,7065107,7065108,7065109,7065110,7065111,7065112,7065113,7065114,7065115,7065116,7065117,7065118,7065119,7065120,7065121,7065122,7065123,7065124,7065125,7065126,7065127,7065128,7065129,7065130,7065131,7065132,7065133,7065134,7065135,7065136,7065137,7065138,7065139,7065140,7073175,7073181,7065754,7065756,7065757,7065758,8064779,10931208,8064853,8064857,8064858,8064859,8064860,8064861,8064862,8064863,8064864,8064865,8064866,8064867,8064868,8064869,8064870,8064871,8064872,8064873,8064874,8064875,8064876,8064877,8064878,8064879,8064880,8064881,8064882,8071677,10944345,3655524,10944346,3655552,8071742,8071807,8071872,8071937,8072002,8072067,10956960,10956961,10956962,8072132,10956963,10956964,10956965,10956966,10956967,10956968,10956969,10956970,10956971,10956972,10956973,10956974,10956975,10956976,10956977,10956978,10956979,10956980,10956981,10956982,10956983,10956984,10956985,10956986,10956987,10956988,10956989,10956990,10956991,10956992,10956993,10956994,10956995,10956996,10956997,10956998,10956999,10957000,10957001,10957002,10957003,10957004,10957005,10957006,10957007,10957008,10957009,10957010,10957011,10957012,10957013,10957014,10957015,10957016,10957017,10957018,10957019,10957020,10957021,10957022,10957023,10957024,10957025,10957026,8072197,10957027,10957028,10957029,10957030,10957031,10957032,10957033,10957034,10957035,10957036,10957037,10957038,10957039,10957040,10957041,10957042,10957043,10957044,10957045,10957046,10957047,10957048,10957049,10957050,10957051,10957052,10957053,10957054,10957055,10957056,10957057,10957058,10957059,10957060,10957061,10957062,10957063,10957064,10957065,10957066,10957067,10957068,10957069,10957070,10957071,10957072,10957073,10957074,10957075,10957076,10957077,10957078,10957079,10957080,10957081,10957082,10957083,10957084,8072262,8072358,8072371,8072372,8072391,8072392,8072436,8072447,8072449,8072459,8072464,8072489,8072490,8072491,8072499,8072526,8072527,8072574,3656679,3656716,8860173,8860174,8860175,8860176,8860177,8860178,8860179,8860180,8860181,8860182,8860183,8860184,8860185,8860186,8860187,8860188,8860189,8860190,8860191,8860192,8860193,8860194,8860195,10942124,10942125,10942148,10942239,8860455,8860456,8860459,8860460,8860461,8860462,3657275,8860492,8970038,8970039,8970040,8970041,8970042,8970043,7070730,8070786,8070799,8070806,8071189,8071293,8071305,8071544,8071612,10617624,10617625,10617626,10617627,10617628,10617630,10617639,10617640,10617641,10617642,10617643,10617645,10617650,10617654,10617655,10617656,10617657,10617658,10617659,10617660,10617661,10617662,10617663,10617664,10617665,10617667,10617668,10617669,10617670,10617671,10617672,10615219,10615220,10615677,10926290,10614245,10614246,10614247,10614248,10614249,10614250,10614252,10614253,10614254,10614261,10614263,10614271,10614272,10559735,10559736,10559737,10559738,10612190,10612203,10609296,10609297,10609298,10609299,10609300,10609301,10609302,10609387,10613342,10613769,10515251,10515252,10515253,10515254,10515255,10515256,10515257,10515258,10515644,10515645,10515646,10515647,10515648,10515649,10515650,10515651,10515652,10515653,10515654,10515655,10515656,10515657,10515658,10515659,10515660,10515661,10515662,10515663,10515664,10515665,10514090,10514091,10514092,10514093,10514370,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514447,10514448,10514449,10514450,10514451,10514452,10514453,10514454,10514455,10514456,10514457,10514458,10514459,10514460,10514461,10514462,10515062,10515063,10515071,10515072,10515104,10515105,10515106,10515107,10515108,10515109,10515110,10515111,10415647,10415648,10415649,10415650,10415651,10415654,10415655,10415683,10415684,10419966,10419969,10419970,10419971,10419973,10464914,10464915,10464916,10464917,10464918,10464919,10464920,10464921,10464922,10464923,10464924,10464925,10464926,10464927,10464928,10464929,10464930,10464931,10464932,10464933,10464934,10464935,10464936,10464937,10464938,10464939,10464940,10464941,10464942,10464943,10464944,10464945,10464946,10464947,10464948,10464949,10464950,10464951,10464952,10464953,10464954,10464955,10464956,10464957,10464958,10464959,10464960,10464961,10464962,10464963,10464964,10464965,10464966,10464967,10464968,10464969,10464970,10464971,10464972,10464973,10464974,10464975,10464976,10464977,10464978,10464979,10464980,10464981,10464982,10464983,10464984,10464985,10464986,10464987,10464988,10464989,10464990,10464991,10464992,10464993,10464994,10464995,10464996,10464997,10464998,10464999,10465000,10465001,10465002,10465003,10465004,10465005,10465006,10465007,10465008,10465009,10465010,10465011,10465012,10465013,10465014,10465015,10465016,10465017,10465018,10465019,10465020,10465021,10465022,10465023,10465024,10465025,10465026,10465027,10465028,10465029,10465030,10465031,10465032,10465033,10465034,10465035,10465036,10465037,10465038,10465039,10465040,10465041,10465042,10465043,10465044,10465045,10465046,10465047,10465048,10465049,10465050,10465051,10465052,10465053,10465054,10465055,10465056,10465057,10465058,10465059,10465060,10465061,10465062,10465063,10465064,10465065,10465066,10465067,10465068,10465069,10465070,10465071,10465072,10465073,10465074,10465075,10465076,10465077,10465078,10465079,10465080,10465081,10465082,10465083,10465084,10465085,10465086,10465087,10465088,10465089,10465090,10465091,10465092,10465093,10465094,10465095,10465096,10465097,10465098,10465099,10465100,10465101,10465102,10465103,10465104,10465105,10465106,10471112,10471335,10471339,10471340,10471341,10469639,8563521,8563535,8563595,10462757,10468771,10468772,10468849,10468850,10468851) 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'