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(10962593,7067917,10939725,7076091,10939811,7076244,7076252,7076283,7076284,7076288,7076317,7076327,7076394,7076395,7068596,7068598,10940344,10940346,10940355,10940356,10940357,10940358,10940359,8569621,10940360,10940361,10940362,10940363,10940364,10940365,10940366,10940367,10940368,10940369,10940370,10940371,10940372,10940373,10940374,10940375,10940376,10940377,10940378,10940379,10940380,10940381,10940382,10940383,10940384,10940385,10940386,10940387,10940388,10940389,10940390,10940391,10940392,10940393,10940394,10940395,10940396,10940397,10940398,7068714,7068720,7068721,7068722,7068723,7068730,7068745,7068758,7068779,8066966,8066967,7066001,10963695,10963696,10963697,7066050,10976757,10976758,10976759,10976760,10976786,7074268,7074270,7074273,7074274,7074275,7066276,7074276,10976973,10976974,10976975,10976976,10976977,10976978,10976979,10977234,10977235,10977236,10977237,10977238,10977239,10977240,10977241,10977242,10977243,10977244,10977245,10977246,10977247,10977248,7066564,10977249,7066565,10977250,7066566,7066567,10977251,10977252,7066568,10977253,7066569,10977269,10977270,10977271,10977272,10977273,10977274,10977275,10977276,10977277,10977278,10977279,10977280,10977281,10977282,10977283,10977284,8067746,8067747,8067850,7074878,7066992,10961945,10961950,7075275,7075276,7075324,7075390,7075391,7067446,7075473,10939188,10939189,7075474,10939190,10939191,10939192,10939193,7067647,7067701,10962418,10962419,10962420,10962421,7067753,6000140,6000141,6000142,6000143,6000144,10959551,10959552,10959564,8065087,10931613,10931615,10931617,10931651,7064263,7072278,7072279,10973076,10973077,10973078,10973079,10973080,10973081,10973082,10973083,8075288,10973168,10973169,10973170,10960434,10960675,7073087,10960837,7073285,7073286,7073287,7073288,7073297,10961087,7065456,7070883,7070897,7070901,7070912,7070917,7070922,7070928,7070932,10971620,10971621,10971622,10971623,7070939,10971624,10971625,10971626,10971627,10971628,10971629,10971630,10971631,10971632,10971633,10971634,10971635,10971636,10971637,10971638,10971639,10971640,10971641,10971642,10971643,10971644,10971645,10971646,10971647,10971648,10971649,10971650,10971651,10971652,10971653,10971654,10971655,10971656,10971657,10971658,10971659,10971660,10971661,10971662,7070978,10971663,7070979,10971664,7070980,10971665,7070981,10971666,7070982,10971667,7070983,10971668,7070984,10971669,7070985,10971670,10971671,10971672,10971673,10971674,10971675,10971676,7070992,10971677,8860897,7070997,8860904,7071001,7071006,7071009,8860915,7071012,7071013,7071021,7071026,7071032,7071039,10971725,10971726,7071043,10942758,10942759,10971732,7071048,7071064,10971784,10971785,10971786,10971787,10971813,10971842,10971843,10971844,10971845,10971846,10971847,10971848,10971849,7071235,7071240,10971944,10971945,10971946,10971947,10971948,10971949,10971950,10971951,10971952,10971953,10971954,10971955,10971956,10971957,10971958,10971959,10971960,10971961,10971962,10971963,10971964,10971965,10971966,10971967,10971968,10971969,10971970,10971971,10971972,10972022,10972023,10972024,10972025,10972026,10972059,10972060,7071381,7071382,7071383,7071384,10972086,10972087,10972088,10972089,10972090,10972091,10972092,10972093,10972101,10943160,10959184,10959185,10959186,10959187,8861409,10972315,10972316,10972317,10972318,10972319,10972320,10972321,10972322,10972323,10972324,10972325,10972326,10972327,10972328,10972329,10972330,10972331,10972332,10972333,10972334,10972335,10972336,10972337,10972338,10972339,10972340,10972341,10972342,10972343,10972344,10972345,10943377,10972346,10972347,10972348,10972349,10972350,10972351,10972352,10972353,10972354,10972355,10972356,10972357,10972358,10972359,10972360,10972361,10972362,10972363,10943395,10972364,10972365,10972366,10972367,10972368,10972369,10972370,10972371,7071687,10972372,10972373,10972374,10972375,10972376,10972377,10972378,10972379,10972380,10943412,10972381,10972382,10972383,10972384,10972385,10972386,10943419,10972441,7068868,7068869,7068903,7068913,7068922,7068925,7068933,7068935,10940743,10940744,10940749,10940750,10940751,10940774,10940775,10940776,10940777,10940778,10940779,7069223,7069224,7069268,7069313,7069318,7069339,7069385,7069409,7069411,7069412,7069413,7069414,7069417,7069419,7069420,7069451,10941321,10941322,10941323,10941324,10941325,10941326,10941330,10941331,10941332,10941333,10941334,10941335,10941336,10941337,10941338,10941339,10941340,10941351,3656645,3656646,3656647,3656648,3656649,3656650,3656651,3656652,3656678,3656686,3656734,7070070,7070072,7070074,7070076,10941792,7070079,10941799,7070088,10941805,7070093,7070094,7070095,10941812,10941816,7070104,10941835,10941837,10941840,10941842,10941863,10941864,10941878,10941887,10941892,10941899,10941905,10941908,10941923,10941924,10941936,10941937,10941974,10941993,10941997,10942002,10942005,10942008,10942012,10942038,10942040,8860434,8860435,3657269,3657270,10942311,7070737,7070802,7070814,10928600,10928622,10928629,10928639,10928656,10928658,10928660,10928661,10928664,10618157,10618162,10618163,10928676,10967786,10618299,10618304,10618993,10618994,8070811,10619880,10619885,10619886,10619888,10619889,10619891,10624896,10619921,10619922,10619923,10617033,10617080,10617084,10622093,10966664,10966665,10622195,10966797,10622261,10966806,10966807,10622277,10622343,10622462,10622463,10928005,10617796,10617797,10928333,10622880,10622884,10622945,10617955,10615062,10615115,10615125,10615129,10615143,10615152,10615153,10615161,8570137,10620322,10620338,10620339,10620340,10620341,10620342,10620343,10620389,10615443,8570381,8570382,8570383,10926147,10926148,10926149,8570521,8570522,10926253,10926319,10926320,10926321,10926322,10926323,10926324,10926325,10930626,10926326,10926327,10926328,10926329,10926330,10926331,10926332,10926333,10926334,10926335,10926336,10926337,10965456,10615941,10615985,10926555,10616046,10921586,10921590,10921591,10952750,10965769,10965770,10965771,10965772,10965773,10926777,10616503,10616517,10922028,10922029,10922032,10922033,10922034,10922035,10922036,10922037,10922038,10922039,10922040,10922041,10616641,10616642,10616643,10953190,10927415,10611162,10614191,10614197,10614297,10614465,10614466,10614467,10614468,10614469,10614470,10611788,10611854,10611878,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611895,10611901,10611902,10611903,10611904,10611905,10566071,10566072,10566073,10566074,10566075,10566076,10566077,10566078,10566079,10611942,10609307,10557517,10609394,10609422,10557643,10557644,10557645,10557659,10612559,10612563,10612623,10612646,10612767,10609770,10609828,8862689,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10609942,10609943,10609972,10610031,10613171,10610197,10610334,10610339,10610340,10610377,10610390,8863288,8863289,8863290,8863291,8863292,8863293,8863294,8863295,8863296,10558602,10558610,10610465,10610476,10613567,10610667,10610676,10610698,10613744,10610891,10513144,10513145,10513146,10513147,10513149,10513150,10513151,10513152,10513154,10513156,10513157,10513158,10513159,10513160,10513161,10513162,10513163,10515163,10515164,10515165,10515166,10515167,10515168,10517246,10517252,10517253,10517255,10517257,10517260,10517261,10517262,10517267,10517268,10517269,10517270,10517277,10517278,10517280,10517281,10517282,10517283,10517285,10517289,10517294,10517295,10517298,10517299,10515349,10515350,10515351,10515546,10517551,10515823,10513994,10513995,10513996,10513997,10513998,10513999,10514000,10514001,10514002,10514003,4975244,4975246,4975273,4975274,4975275,4975276,4975277,4975278,4975279,4975280,4975281,4975282,4975283,4975284,10518646,10518647,10514794,10417260,10416373,10416415,10416416,10416417,10416418,10415429,10417472,10419569,10419570,10419571,10416605,10417825,10417826,10417844,10417845,10417861,10417862,10417879,10417896,10417897,10417914,10417915,10416929,10418978,10420007,10463014,10463015,10463016,10463017,10463018,10463019,10463020,10463021,10463022,10463023,10463024,10463025,10463026,10463027,10463028,10463029,10463030,10463031,10463032,10463033,10463034,10463035,10463036,10463037,10463038,4971934,4971935,4971946,10467828,10469918,10469919,10469920,10469921,8563397,8563398,10470117,8563466,10468151,10468152,4972485,4972486,4972487,10466474,10466475,10466476,10466477,10466478,10466479,10466480,10466481,10466482,10466483,10466484,10466485,10466486,10470544,10627289,10627423,10627771,10627772,10627773,10627774,10627787,10627790,10627814,10627849,10627855,10627884,10627910,10627927,10627928,10627929,10627930,10626275,10626280,10626314,10626325,10626326,10626327,10626332,10626571,10520144,10520806,10520807,10520808,10420322,10420675) 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'