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(4970645,4970666,4970667,4970668,4970669,4970745,4970853,4970854,4970855,4970856,4970857,4970858,4970859,4970860,4970861,4970862,4970863,4970864,4970865,4970866,4970867,4970868,4970869,4970870,4970871,4970872,4970873,4970874,4970875,4970876,4970877,4970878,4970879,4970880,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970891,4970892,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970938,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970972,4970973,4970974,4970975,4970976,4970977,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971137,4971138,4971139,4971140,4971141,4971142,4971143,4971144,4971145,4971146,4971147,4971148,4971149,4971150,4971151,4971152,4971153,4971154,4971155,4971156,4971157,4971158,4969282,4969283,4969284,4969285,4969286,4969287,4969288,4969589,4969590,4969591,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,8075284,8075285,8075286,8075287,8075288,8075289,8075290,8075291,8075292,8075337,8075338,4967031,4967032,4967033,4967034,4967035,4967036,4967037,4967038,4967039,4967040,4967041,4967042,4967043,4967044,4967045,4967046,4967047,4967048,4967049,4967050,4967051,4967052,4967053,4967054,4967055,4967056,4967057,4967058,4967059,4967060,4967061,4967062,4967063,4967064,4967065,4967066,4967067,4967068,4967069,4967070,4967071,4967072,4967073,4967074,4967075,4967076,4967077,4967078,4967079,4967080,4967081,4967082,4967083,4967084,4967085,4967086,4967087,4967088,4967089,4967090,4967091,4967092,4967093,4967094,4967095,4967096,4967097,4967098,4967099,4967100,4967101,4967102,4967103,4967104,4967105,4967106,4967107,4967108,4967109,4967110,4967111,4967112,4967113,4967114,4967115,4967116,4967117,4967118,4967119,4967120,4967121,4967122,4967123,4967124,4967125,4967126,4967127,4967128,4967129,4967130,4967131,4967132,4967133,4967134,4967135,4967136,4967137,4967138,4967139,4967140,4967141,4967142,4967143,4967144,4967145,4967146,4967147,4967148,4967149,4967150,4967151,4967152,4967153,4967154,4967155,4967156,4967157,4967158,4967159,4967160,4967161,4967162,4967163,4967164,4967165,4967166,4967167,4967168,4967169,4967170,4967171,4967172,4967173,4967174,4967175,4967176,4967177,4967178,4967179,4967180,4967181,4967182,4967183,4967184,4967185,4967186,4967187,4967188,4967189,4967190,4967191,4967192,4967193,4967194,4967195,4967196,4967197,4967198,4967199,4967200,4967201,4967202,4967203,4967204,4967205,4967206,4967207,4967208,4967209,4967210,4967211,4967212,4967213,4967214,4967215,4967216,4967217,4967218,4967219,4967220,4967221,4967222,4967223,4967224,4967225,4967226,4967227,4967228,4967229,4967230,4967231,4967232,4967233,4967234,4967235,4967236,4967237,4967238,4967239,4967240,4967241,4967242,4967243,4967244,4967245,4967246,4967247,4967248,4967249,4967250,4967251,4967252,4967253,4967254,4967255,4967256,4967257,4967258,4967259,4967260,4967261,4967262,4967263,4967264,4967265,4967266,4967267,4967268,4967269,4967270,4967271,4967272,4967273,4967274,4967275,4967276,4967277,4967278,4967279,4967280,4967281,4967282,4967283,4967284,4967285,4967286,4967287,4967288,4967289,4967290,4967291,4967292,4967293,4967294,4967295,4967296,4967297,4967298,4967299,4967300,4967301,4967302,4967303,4967304,4967305,4967306,4967307,4967308,4967309,4967310,4967311,4967312,4967313,4967314,4967315,4967316,4967317,4967318,4967319,4967320,4967321,4967322,4967323,4967324,4967325,4967326,4967327,4967328,4967329,4967330,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,4967424,4967425,4967426,4967427,4967428,4967429,4967430,4967431,4967432,4967433,4967434,4967435,4967436,4967437,4967438,4967439,4967440,4967441,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967451,4967452,4967453,4967454,4967455,4967456,4967457,4967458,4967459,4967460,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,4967510,4967511,4967512,4967513,4967514,4967515,4967516,4967517,4967518,4967519,4967520,4967521,4967522,4967523,4967524,4967525,4967526,4967527,4967528,4967529,4967530,4967531,4967532,4967533,4967534,4967535,4967536,4967537,4967538,4967539,4967540,4967541,4967542,4967543,4967544,4967545,4967546,4967547,4967548,4967549,4967550,4967551,4967552,4967553,4967554,4967555,4967556,4967557,4967558,4967559,4967560,4967561,4967562,4967563,4967564,4967565,4967566,4967567,4967568,4967569,4967570,4967571,4967572,4967573,4967574,4967575,4967576,4967577,4967578,4967579,4967580,4967581,4967582,4967583,4967584,4967585,4967586,4967587,4967588,4967589,4967590,4967591,4967592,4967593,4967594,4967595,4967596,4967597,4967598,4967599,4967600,4967601,4967602,4967603,4967604,4967605,4967606,4967607,4967608,4967609,4967610,4967611,4967612,4967613,4967614,4967615,4967616,4967617,4967618,4967619,4967620,4967621,4967622,4967623,4967624,4967625,4967626,4967627,4967628,4967629,4967630,4967631,4967632,4967633,4967634,4967635,4967636,4967637,4967638,4967639,4967640,4967641,4967642,4967643,4967644,4967645,4967646,4967647,4967648,4967649,4967650,4967651,4967652,4967653,4967654,4967655,4967656,4967657,4967658,4967659,4967660,4967661,4967662,4967663,4967664,4967665,4967666,4967667,4967668,4967669,4967670,4967671,4967672,4967673,4967674,4967675,4967676,4967677,4967678,4967679,4967680,4967681,4967682,4967683,4967684,4967685,4967686,4967687,4967688,4967689,4967690,4967691,4967692,4967693,4967694,4967695,4967696,4967697,4967698,4967699,4967700,4967701,4967702,4967703,4967704,4967705,4967706,4967707,4967708,4967709,4967710,4967711,4967712,4967713,4967714,4967715,4967716,4967717,4967718,4967719,4967720,4967721,4967722,4967723,4967724,4967725,4967726,4967727,4967728,4967729,4967730,4967731,4967732,4967733,4967734,4967735,4967736,4967737,4967738,4967739,4967740,4967741,4967742,4967743,4967744,4967745,4967746,4967747,4967748,4967749,4967750,4967751,4967752,4967753,4967754,4967755,4967756,4967757,4967758,4967759,4967760,4967761,4967762,4967763,4967764,4967765,4967766,4967767,4967768,4967769,4967770,4967771,4967772,4967773,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,4967819,4967820,4967821,4967822,4967823,4967824,4967825,4967826,4967827,4967828) 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'