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(10962638,10962639,10962640,10962641,10962642,10962643,10962644,10962645,7076163,10963045,10963046,10963047,10963049,10963050,10963052,10963053,10963056,10963057,10963058,10963066,10963067,10963068,10963072,10963076,10963082,10963083,10963084,10963085,10963086,10963087,11041316,10963386,10963387,10963388,10963389,10963390,10963391,10963392,10963394,10963395,10963396,11041707,7074291,10951390,7066784,7066890,7066891,10962070,10962071,10962072,10962073,10962083,10962084,10962085,10962086,10962087,10962088,10962111,10962112,10962115,10962116,10962117,10962118,11001346,11001347,11001348,11001349,10962581,10962582,10962583,10962584,10962585,10962599,10985688,10985690,10985698,10985699,10985702,10985703,10985704,10985705,10985755,10985758,7072083,11011945,10999073,10999074,10999075,10999076,10999077,10999078,10999079,10999080,10999081,10999082,10986166,10986167,10960435,10960436,10960437,10960438,10999453,10999454,10999455,10999456,10999462,10999463,10999666,10999667,10974245,10974246,10974247,10974248,11000327,11000328,11000329,11000330,11000331,11000332,11000333,11000334,11000335,11000336,11000337,11000338,11000339,11000340,11000341,11000342,11000343,11000344,11000345,11000346,11000347,11000348,11000349,11000350,11000351,11000352,11000353,11000354,11000355,11000356,11000357,11000358,11000359,11000360,11000361,11000362,11000363,11000364,11000365,11000366,11000367,11000368,11000369,11000370,11000371,11000372,11000373,11000376,11000377,11000378,11000379,11000380,11000381,7073706,11010766,11010767,11010769,11010770,11010771,11010772,11010773,11010774,11010775,11010776,11010777,11010778,11010779,11010780,11010781,11010782,11010783,11010784,7071260,7071261,10942887,7071267,7071297,7071298,7071299,7071300,7071301,7071304,11009188,10944990,10944991,10944992,11045860,10967994,10968017,11007192,11007193,11007194,11007195,10968228,10968232,10968233,10968234,11007694,10995306,10995524,10995525,10995526,10995527,10995531,10995535,10995553,10995554,10995555,10995556,10995559,10995560,10966666,10966667,10966668,10966669,11045102,11045104,11045105,11045106,11045107,11045108,11045109,11045110,11045116,11045117,11045118,11045120,11045123,11045124,11045134,11045135,11045146,11045147,11045148,11045149,11045150,11045151,11045152,11045153,11045155,11045159,11045160,11045161,11045168,11045169,11045170,11045180,11045181,11045182,11045183,11045184,11045185,11045186,11045188,11045189,11045190,10951862,10616790,7059488,10559271,10614567,10614568,9171582,9171596,9171597,9171598,9171599,10560487,10557610,10557619,10557620,9211844,9211847,9211850,9211852,10557665,10557666,9211860,9211861,7058493,9172331,9172332,9172407,9172660,9172661,9172662,9172664,9172666,10561572,10561573,10561579,10561580,10561581,10561585,10561588,10561589,10561590,10561591,10561596,10561598,10561607,10561617,10561618,10561619,10561620,10561623,10561624,10561628,9172815,10561629,10561630,9196818,9172818,10561638,10561639,10561658,10561659,10561660,10561661,10561669,10561678,10561679,10561680,10561681,10561682,9172881,9172882,10561697,9172885,10561698,9172888,9172891,10561704,10561705,10561710,10561714,10561715,10561716,10561717,10561718,10561739,10561740,10561741,10515497,10511632,10511662,10511669,10511676,10511687,10511692,10511693,10511694,10511695,10511696,10511697,10511698,10511699,10511700,10511701,10511702,10511703,10511709,10511722,10511723,10511724,10511731,10511744,10511745,10511746,9170069,9170071,10513965,10513966,9170322,9170323,9170324,9170325,10514220,10514228,10514230,10514232,10514242,10514244,10514255,10514259,10514262,10514263,10514264,10514266,10514267,10514268,10514269,10514270,10514273,10514274,10514277,10514278,10514281,10514283,10514284,10514286,10514290,10514291,10514292,10514360,10514361,10514362,10516664,10516665,10516666,10516667,10516668,10516669,10516670,10516671,10516672,10516673,10516674,10516675,10516676,10516678,10516680,10516681,10516713,10516714,10516715,10516716,10516717,10516718,10516783,10516784,10516785,10516786,10516787,10516801,10516802,10516803,10516804,9171088,10418226,10418227,10418228,10418229,10418230,10418231,10418232,10418233,10418234,10418235,10418236,10418237,10418238,10418239,10418240,10418241,10418242,10418243,10418244,10418245,10418246,10418247,10418248,10418249,10418252,10418253,10418254,10418259,10418260,10418261,10418262,10418263,10418264,10418265,10418266,10418267,10418268,9193118,9185129,9177157,9182881,9182887,9182905,9182914,9182919,9182921,9182928,9199092,9199093,9199094,9199095,9199096,9199098,9199099,9199100,9199101,9199102,8916803,9191261,9191262,9183285,9183286,9183328,9191506,9191509,9191518,9191521,9175768,9191801,9191803,9191804,9191811,9191819,9191838,9191839,9191840,9191841,9191842,9168028,10470644,10470645,10470646,10470647,10470648,10470649,10470650,10470651,10470652,10470653,8917758,9176127,10628827,10629384,10629385,10172431,10172432,10631292,10626651,10626652,10626653,10583448,10583449,10589798,10586889,10590038,10590039,10590092,10590096,10590109,10590653,10590654,10590655,10590656,10590657,10585873,10529305,10529337,10529338,10529339,10529340,10529341,10525388,10527513,10527515,10525622,10525665,10525666,10527705,10527706,10527707,10527708,10525751,10525752,10525756,10525757,10525758,10525759,10525760,10525761,10525762,10525763,10525764,10525765,10525766,10525767,10525768,10525769,10525770,10525771,10525772,10525773,10525774,10525775,10525776,10525777,10525778,10525779,10525780,10525781,10525782,10525783,10525784,10525785,10525786,10525787,10525788,10525789,10525790,10525791,10525792,10525793,10525794,10525795,10525796,10525797,10525798,10525799,10525800,10525801,10525802,10525803,10525804,10525805,10525806,10525807,10525808,10525809,10525810,10525848,10525849,10525850,10525851,10525852,10525853,10525854,10525855,10525856,10525857,10525870,10525871,10525872,10525873,10525874,10525875,10525876,10525877,10525878,10525879,10525880,10525881,10525882,10525883,10525884,10525885,10525886,10525887,10525888,10525889,10527956,10526114,10526119,10526120,10526149,10526150,10526151,10526160,10526161,10526162,10526163,10526164,10526165,10526166,10526167,10526168,10526169,10526170,10526171,10526172,10526173,10526174,10526175,10526176,10526177,10526178,10526179,10526180,10526181,10526182,10526183,10526184,10526185,10526186,10526187,10526188,10526189,10526190,10526191,10526218,10526219,10526220,10526221,10526222,10526223,10526224,10526225,10526226,10526227,10526228,10526229,10526230,10526231,10526232,10526233,10528234,10526234,10528235,10526235,10528236,10526236,10526237,10526238,10526239,10526240,10526241,10534242,10526242,10526243,10526244,10526245,10526246,10526247,10526248,10526249,10526250,10526251,10526252,10526253,10526254,10526255,10526256,10526257,10526258,10526264,10526265,10526266,10526267,10526268,10526269,10526272,10526281,10526282,10526283,10526284,10526285,10526291,10526334,10526372,10526373,10526374,10526435,10526439,10526440,10526441,10526443,10526444,10526445,10526446,10526447,10526448,10526450,10526451,10526452,10526453,10526454,10526455,10526456,10526457,10526458,10526459,10526460,10526470,10526481,10526482,10526561,10526572,10526573,10526583,10526584,10526585,10526587,10526588,10526589,10526590,10526591,10526592,10526593,10526594,10526595,10526596,10526605,10526616,10526617,10526618,10528630,10528631,10528632,10528633,10528634,10528635,10522644,10522645,10522646,10526647,10522647,10526648,10526649,10526650,10522651,10522652,10522653,10526656,10526657,10526658,10526659,10526660,10526661,10526677,10526678,10526679,10526680,10526681,10526682,10526683,10526684,10526685,10526698,10526699,10526700,10526701,10526702,10526703,10526704,10526705,10526706,10526707,10526723,10526724,10526725,10526726,10526727,10526728,10526729,10526730,10526731,10526732,10526746,10526747,10526748,10526749,10526750,10526751,10526752,10526753,10526754,10526755,10526756,10526773,10526774,10526775,10526776,10526777,10526778,10526779,10526780,10526781,10526782,10526783,10536787,10536788,10536789,10536790,10536791,10526791,10536792,10526792,10536793,10526793,10536794,10526794,10536795,10526795,10536796,10526796,10536797,10526797,10526803,10536804,10536805,10526805,10536806,10526806,10536807,10536808,10536809,10526817,10536818,10526818,10536819,10536820,10526820,10536821,10526821,10536822,10536823,10536824,10536825,10536829,10536830,10536831,10536832,10536833,10536834,10536835,10536836,10526836,10536837,10526837,10536838,10526838,10526839,10526840,10526841,10536842,10526842,10526843,10536844,10526844,10536845,10526845,10536846,10526846,10536847,10526847,10536848,10526848,10526849,10536857,10526859,10526860,10526861,10526862,10536863,10536864,10526877,10526878,10526879,10536913,10536914,10536915,10536916,10536917,10536918,10536919,10536920,10536921,10536922,10536923,10536925,10536926,10536927,10536928,10536929,10536930,10536931,10536932,10536933,10536934,10536935,10536936,10536937,10536938,10536939,10536940,10536941,10536947,10536948,10421395,10481479) 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'