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(4970248,4970260,4970261,4970262,4970263,4970264,4970319,4970320,4970321,4970322,4970388,4970389,4970390,4970391,4970392,4970650,4970668,4970669,4970672,4970681,4970701,4970728,4970737,4970740,4970744,4970761,4970783,4970811,4970812,4970816,4970817,4970818,4970888,4970908,4970909,4970910,4970921,4970922,4970925,4970928,4970951,4971077,4971081,4971103,4971107,4971108,4971109,4971121,4968233,4968335,4968411,4968608,4968616,4968655,4968656,4968657,4968658,4968659,4968660,4968691,4968791,4968792,4968793,4968794,4968795,4968796,4968797,4968798,4968799,4968800,4969000,4969001,4969094,4969095,4969179,4969271,4969272,4969273,4969282,4969283,4969284,4969318,4969319,4969320,4969321,4969332,4969333,4969334,4969335,4969336,4969337,4969397,4969398,4969399,4969400,4969401,4969402,4969403,4969404,4969405,4969406,4969407,4969408,4969409,4969410,4969411,4969412,4969413,4969414,4969465,4969466,4969467,4969468,4969469,4969470,4969533,4969547,4969550,4969551,4969552,4969553,4969554,4969555,4969556,4969557,4969558,4969559,4969560,4969561,4969562,4969569,4969570,4969581,4969860,4969866,4969867,4969868,4969888,4969889,4969890,4969891,4969892,4969953,4969954,4969955,4969956,4970078,4970079,4970080,4970096,4970097,4970098,4970144,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074706,8074707,8074708,8074709,8074710,8074711,8074712,8074713,8074714,8074715,8074716,8074717,8074718,8074719,8074720,8074721,8074722,8074723,8074724,8074725,8074726,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074748,8074749,8074750,8074751,8074752,8074753,8074754,8074755,8074756,8074757,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8074767,8074768,8074769,8074770,8074771,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074792,8074793,8074794,8074795,8074796,8074797,8074798,8074799,8074800,8074801,8074802,8074803,8074804,8074805,8074806,8074807,8074808,8074809,8074810,8074811,8074812,8074813,8074814,8074815,8074816,8074817,8074818,8074819,8074820,8074821,8074822,8074823,8074824,8074825,8074826,8074827,8074828,8074829,8074830,8074831,8074832,8074833,8074834,8074835,8074836,8074837,8074838,8074839,8074840,8074841,8074842,8074843,8074844,8074845,8074846,8074847,8074848,8074849,8074850,8074851,8074852,8074853,8074854,8074855,8074884,8074885,8074886,8074887,8074888,8074889,8074929,8074930,8074931,8074932,8074933,8075288,8075317,4967029,4967183,4967184,4967185,4967186,4967192,4967193,4967212,4967213,4967255,4967256,4967257,4967258,4967259,4967302,4967303,4967304,4967331,4967332,4967333,4967334,4967335,4967336,4967337,4967338,4967339,4967340,4967341,4967342,4967343,4967344,4967345,4967346,4967347,4967348,4967349,4967350,4967351,4967352,4967353,4967354,4967355,4967356,4967357,4967358,4967359,4967360,4967361,4967362,4967363,4967364,4967365,4967366,4967367,4967368,4967369,4967370,4967371,4967372,4967373,4967374,4967375,4967376,4967377,4967378,4967379,4967380,4967381,4967382,4967383,4967384,4967385,4967386,4967387,4967388,4967389,4967390,4967391,4967392,4967393,4967394,4967395,4967396,4967397,4967398,4967399,4967400,4967401,4967402,4967403,4967404,4967405,4967406,4967407,4967408,4967409,4967410,4967411,4967412,4967413,4967414,4967415,4967416,4967417,4967418,4967419,4967420,4967421,4967422,4967423,4967439,4967440,4967446,4967447,4967467,4967474,4967475,4967476,4967477,4967478,4967479,4967498,4967510,4967546,4967547,4967548,4967557,4967558,4967559,4967560,4967588,4967589,4967610,4967611,4967612,4967613,4967614,4967674,4967675,4967676,4967706,4967707,4967708,4967754,4967755,4967762,4967763,4967768,4967774,4967775,4967777,4967778,4967779,4967780,4967781,4967801,4967802,4967803,4967804,4967906,4967907,4967908,4967913,4967914,4967947,8074037,8074038,8074039,8074040,8074041,8074042,8074043,8074044,8074045,8074046,8074047,8074048,8074049,8074050,8074051,8074052,8074053,8074054,8074055,8074056,8074057,8074058,8074059,8074060,8074061,8074062,8074063,8074064,8074065,8074066,8074067,8074068,8074069,8074070,8074071,8074072,8074073,8074074,8074075,8074076,8074077,8074078,8074079,8074080,8074081,8074082,8074083,8074084,8074085,8074086,8074087,8074088,8074089,8074090,8074091,8074092,8074093,8074094,8074095,8074096,8074097,8074098,8074099,8074100,8074101,8074102,8074103,8074104,8074105,8074106,8074107,8074108,8074109,8074110,8074111,8074112,8074113,8074114,8074115,8074116,8074117,8074118,8074119,8074120,8074121,8074122,8074440,8074441,8074442,8074443,8074444,8074483,8074484,8074485,8074486,8074487,8074499,8074500,8074501,8074502,8074503,8074504,8074505,8074506,8074507,8074508,8074509,8074510,8074511,8074512,8074513,8074514,8074515,8074516,8074517,8074518,8074519,8074520,8074521,8074522,8074523,8074524,8074525,8074526,8074527,8074528,8074529,8074530,8074531,8074532,8074533,8074534,8074535,8074536,8074537,8074538,8074539,8074540,8074541,8074542,8074543,8074544,8074545,8074546,8074547,8074548,8074549,8074550,8074551,8074552,8074553,8074554,8074555,8074556,8074557,8074558,8074559,8074560,8074561,8074562,8074563,8074564,8074565,8074566,8074567,8074568,8074569,8074570,8074571,8074572,8074573,8074574,8074575,8074576,8074577,8074578,8074579,8074580,8074581,8074582,8074583,8074584,8074585,8074586,8074587,8074588,8074589,8074590,8074591,8074592,8074593,8074594,8074595,8074596,8074597,8074598,8074599,8074600,8074601,8074602,8074603,8074604,8074605,8074606,8074607,8074608,8074609,8074610,8074611,8074612,8074613,8074614,8074615,8074616,8074617,8074618,8074619,8074620,8074621,8074622,8074623,8074624,8074625,8074626,8074627,8074628,8074629,8074630,8074631,8074632,8074633,8074634,8074635,8074636,8074637,8074638,8074639,8074640,8074641,8074642,8074643,8074644,8074645,8074646,8074647,8074648,8074649,8074650,8074651,8074652,8074653,8074654,8074655,8074656,8074657,8074658,8074659,8074660,8074661,8074662,8074663,8074664,8074665,8074666,8074667,8074668,8074669,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8072359,8072365,8072376,8072380,8072384,8072387,8072393,8072396,8072398,8072402,8072408,8072414,8072418,8072424,8072435,8072439,8072444,8072450,8072456,8072520,8072588,8072589,8072763,8072764,8072765,8072766,8072767,8072889,8072891,8072892,8072893,8072894,8072895,8072896,8072899,8072900,8073029,8073030,8073031,8073032,8073033,8073034,8073035,8073044,8073045,8073046,8073047,8073048,8073062,8073063,8073064,8073065,8073066,8073067,8073068,8073069,8073070,8073071,8073072,8073073,8073074,8073075,8073219,8073229,8073237,8073247,8073390,8073395,8073398,8073403,8073461,8073510,8073530,10623042,10623045,10623112,10623178,10623179,10623189,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623199,10623252,10623272,10623273,10623274,10623275,10623276,10623277,10623278,10623279,10623280,10623281,10623304,10623338,10623348,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623442,10623480,10623483,10623484,10623491,10623492,10623499,10623500,10623507,10623610,10623611,10623612,10623638,10623724,10623725,10623726,10623727,10623728,10623729,10623730,10623743,10623768,10623917,10623965,10623966,10623967,10624057,10624131,10624132,10624133,10624199,10624200,10624234,10624235,10624255,10624256,10624257,10624258,10624259,10624260,10624261,10624262,10624340,10624452,10624552,10624553,10624617,10624618,10624652,10624653,10624709,10624710,10624712,10624714,10624716,10624717,10624718,10624720,10624721,10624722,10624734,10624741,10624742,10624743,10624744,10624745,10624746,10624747,10624748,10624749,10624750,10624751,10624752,10624753,10624754,10624755,10624756,10624757,10624758,10624759,10624760,10624761,10624889,10624890,10624891,10624947,10624948,10624949,10624950,10624951,10624957,10621978,10622029,10622031,10622080,10622095,10622096,10622097,10622098,10622099,10622100,10622123,10622124,10622165) 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'