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(4970255,4970256,4970257,4970258,4970259,4970268,4970269,4970333,4970334,4970358,4970359,4970360,4970364,4970365,4970370,4970371,4970377,4970378,4970379,4970380,4970381,4970382,4970387,4970393,4970394,4970395,4970396,4970397,4970398,4970440,4970441,4970442,4970443,4970444,4970445,4970446,4970447,4970448,4970449,4970478,4970479,4970480,4970666,4970676,4970677,4970683,4970707,4970711,4970713,4970716,4970719,4970720,4970762,4970763,4970765,4970766,4970782,4970807,4970808,4970809,4970920,4970925,4970926,4970948,4970960,4970961,4970993,4971021,4971057,4971081,4971101,4971102,4971143,4968156,4968157,4968158,4968169,4968170,4968171,4968190,4968191,4968207,4968208,4968209,4968210,4968220,4968226,4968227,4968230,4968231,4968233,4968239,4968240,4968241,4968297,4968298,4968299,4968310,4968311,4968316,4968317,4968323,4968324,4968325,4968326,4968333,4968334,4968335,4968341,4968342,4968343,4968357,4968371,4968384,4968402,4968410,4968411,4968412,4968413,4968414,4968415,4968416,4968417,4968418,4968419,4968420,4968421,4968422,4968423,4968424,4968425,4968426,4968427,4968428,4968429,4968430,4968431,4968432,4968448,4968467,4968468,4968483,4968508,4968514,4968516,4968517,4968518,4968519,4968520,4968521,4968522,4968527,4968536,4968575,4968576,4968577,4968578,4968579,4968580,4968592,4968604,4968605,4968606,4968607,4968608,4968609,4968610,4968611,4968612,4968613,4968614,4968616,4968617,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968630,4968632,4968635,4968636,4968637,4968642,4968643,4968645,4968646,4968647,4968651,4968652,4968653,4968655,4968656,4968657,4968658,4968659,4968660,4968664,4968665,4968666,4968667,4968668,4968669,4968678,4968679,4968680,4968683,4968687,4968691,4968692,4968693,4968694,4968695,4968696,4968697,4968702,4968703,4968751,4968760,4968788,4968789,4968790,4968791,4968792,4968793,4968794,4968795,4968796,4968797,4968798,4968799,4968800,4968801,4968802,4968803,4968804,4968805,4968806,4968807,4968818,4968836,4968839,4968845,4968846,4968847,4968848,4968858,4968859,4968860,4968861,4968862,4968866,4968886,4968900,4968919,4968939,4968942,4968948,4968949,4968950,4968951,4968952,4968953,4968971,4968995,4969000,4969001,4969007,4969008,4969009,4969010,4969014,4969018,4969019,4969024,4969032,4969041,4969049,4969058,4969070,4969094,4969095,4969102,4969103,4969104,4969105,4969106,4969108,4969115,4969116,4969123,4969127,4969132,4969133,4969145,4969151,4969162,4969163,4969164,4969165,4969166,4969167,4969172,4969173,4969174,4969178,4969179,4969185,4969209,4969210,4969211,4969212,4969221,4969247,4969248,4969387,4969388,4969442,4969443,4969444,4969445,4969446,4969447,4969448,4969538,4969549,4969551,4969574,4969575,4969576,4969577,4969578,4969579,4969580,4969587,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,8075155,8075156,8075157,8075158,8075159,8075197,8075198,8075199,8075200,8075201,8075225,8075249,8075251,8075252,8075260,8075321,8075341,8075490,4967042,4967043,4967044,4967122,4967129,4967139,4967144,4967145,4967146,4967162,4967163,4967337,4967338,4967349,4967350,4967362,4967363,4967364,4967375,4967376,4967388,4967389,4967390,4967391,4967392,4967417,4967418,4967419,4967420,4967421,4967422,4967423,4967461,4967462,4967463,4967464,4967465,4967466,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967474,4967475,4967476,4967477,4967478,4967479,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967497,4967498,4967499,4967500,4967501,4967502,4967503,4967504,4967505,4967506,4967507,4967508,4967509,4967769,4967789,4967790,4967791,4967792,4967793,4967794,4967811,4967812,4967813,4967870,4967871,4967912,4967916,4967917,4967925,4967926,4967927,4967928,4967929,4967930,4967985,4968039,4968040,4968041,4968042,4968071,4968079,4968080,4968081,4968082,4968083,4968084,4968085,4968086,4968087,4968088,4968089,4968090,4968091,4968092,4968093,4968094,4968095,4968096,4968097,4968098,4968099,4968100,4968101,4968102,4968103,4968104,4968105,4968106,4968107,4968108,4968109,4968110,4968111,4968112,4968113,4968114,4968115,4968116,4968117,4968118,4968119,4968120,4968124,4968135,8073681,8073682,8073683,8073684,8073685,8073735,8073736,8073737,8073738,8073739,8073787,8073788,8073789,8073790,8073791,8073836,8073837,8073838,8073839,8073840,8073855,8073856,8073857,8073858,8073859,8073860,8073861,8073862,8073863,8073864,8073865,8073866,8073867,8073868,8073869,8073870,8073871,8073872,8073873,8073874,8073875,8073876,8073877,8073878,8073879,8073880,8073881,8073882,8073883,8073884,8073885,8073886,8073887,8073888,8073889,8073890,8073891,8073892,8073893,8073894,8073895,8073896,8073897,8073898,8073899,8073900,8073901,8073902,8073903,8073904,8073905,8073906,8073907,8073908,8073909,8073910,8073911,8073912,8073913,8073914,8073915,8073916,8073917,8073918,8073919,8073920,8073921,8073922,8073923,8073924,8073925,8073926,8073927,8073928,8073929,8073930,8073931,8073932,8073933,8073934,8073935,8073936,8073937,8073938,8073939,8073940,8073941,8073942,8073943,8073944,8073945,8073946,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,8074150,8074151,8074152,8074153,8074154,8074195,8074196,8074197,8074198,8074199,8074236,8074237,8074238,8074239,8074240,8074241,8074283,8074284,8074285,8074286,8074287,8074288,8074523,8074524,8074525,8074526,8074527,8074528,8074572,8074573,8074574,8074575,8074576,8074577,8071903,8071904,8071905,8071906,8071907,8071908,8071909,8071910,8071911,8071912,8071913,8071914,8071915,8071916,8071917,8071918,8071919,8071920,8071921,8071922,8071923,8071924,8071925,8071926,8071927,8071928,8071929,8071930,8071931,8071932,8071933,8071934,8071935,8071936,8071937,8071938,8071939,8071940,8071941,8071942,8071943,8071944,8071945,8071946,8071947,8071948,8071949,8071950,8071951,8071952,8071953,8071954,8071955,8071956,8071957,8071958,8071959,8071960,8071961,8071962,8071963,8071964,8071965,8071966,8071967,8071968,8071969,8071970,8071971,8071972,8071973,8071974,8071975,8071976,8071977,8071978,8071979,8071980,8071981,8071982,8071983,8071984,8071985,8071986,8071987,8071988,8071989,8071990,8071991,8071992,8071993,8071994,8071995,8071996,8071997,8071998,8071999,8072000,8072001,8072002,8072003,8072004,8072005,8072006,8072007,8072008,8072009,8072010,8072011,8072012,8072013,8072014,8072015,8072016,8072017,8072018,8072019,8072020,8072021,8072022,8072023,8072024,8072025,8072026,8072027,8072028,8072029,8072030,8072031,8072032,8072098,8072099,8072100,8072101,8072102,8072103,8072104,8072105,8072106,8072107,8072108,8072109,8072110,8072111,8072112,8072113,8072114,8072115,8072116,8072117,8072118,8072119,8072120,8072121,8072122,8072123,8072124,8072125,8072126,8072127,8072128,8072129,8072130,8072131,8072132,8072133,8072134,8072135,8072136,8072137,8072138,8072139,8072140,8072141,8072142,8072143,8072144,8072145,8072146,8072147,8072148,8072149,8072150,8072151,8072152,8072153,8072154,8072155,8072156,8072157,8072158,8072159,8072160,8072161,8072162,8072365,8072373,8072374,8072376,8072380,8072384,8072396,8072398,8072402,8072414,8072424,8072434,8072435,8072436,8072444,8072447,8072456,8072459,8072465,8072466,8072469,8072493,8072521,8072522,8072523,8072524,8072525,8072526,8072527,8072528,8072529,8072530,8072531,8072532,8072534,8072559,8072560,8072561,8072605,8072606,8072607,8072608,8072609,8072702,8072707,8072712,8072717,8072718,8072719) 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'