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(4970164,4970169,4970170,4970179,4970185,4970191,4970201,4970203,4970205,4970209,4970213,4970216,4970219,4970221,4970225,4970226,4970231,4970234,4970235,4970236,4970237,4970238,4970239,4970240,4970243,4970244,4970249,4970251,4970256,4970258,4970263,4970265,4970266,4970267,4970272,4970273,4970274,4970276,4970281,4970285,4970287,4970292,4970293,4970295,4970299,4970300,4970301,4970305,4970306,4970307,4970308,4970309,4970316,4970317,4970321,4970323,4970325,4970331,4970332,4970336,4970350,4970357,4970369,4970373,4970381,4970384,4970391,4970398,4970399,4970403,4970404,4970405,4970406,4970410,4970412,4970416,4970417,4970419,4970420,4970421,4970422,4970423,4970427,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970439,4970440,4970446,4970452,4970456,4970459,4970465,4970468,4970477,4970479,4970484,4970485,4970486,4970492,4970498,4970511,4970521,4970528,4970532,4970537,4970541,4970542,4970544,4970548,4970560,4970566,4970567,4970568,4970571,4970572,4970573,4970575,4970578,4970579,4970586,4970591,4970594,4970598,4970600,4970601,4970606,4970607,4970608,4970609,4970610,4970611,4970615,4970620,4970622,4970632,4970633,4970637,4970638,4970647,4970649,4970652,4970653,4970654,4970658,4970659,4970660,4970661,4970664,4970666,4970667,4970668,4970669,4970677,4970682,4970689,4970713,4970717,4970718,4970724,4970725,4970726,4970728,4970744,4970745,4970758,4970766,4970771,4970775,4970779,4970789,4970795,4970797,4970798,4970802,4970805,4970806,4970807,4970808,4970809,4970811,4970812,4970814,4970816,4970818,4970823,4970824,4970825,4970827,4970830,4970836,4970839,4970843,4970844,4970846,4970847,4970849,4970851,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,4970993,4970997,4970999,4971001,4971004,4971008,4971010,4971014,4971016,4971024,4971025,4971026,4971028,4971037,4971038,4971044,4971046,4971050,4971051,4971053,4971054,4971055,4971056,4971057,4971058,4971061,4971062,4971097,4971100,4971103,4971106,4971108,4971117,4971123,4971136,4971137,4971138,4971139,4971140,4971141,4971142,4971143,4971144,4971145,4971146,4971147,4971148,4971149,4971150,4971151,4971152,4971153,4971154,4968160,4968162,4968166,4968171,4968172,4968176,4968183,4968190,4968192,4968193,4968194,4968197,4968199,4968201,4968208,4968227,4968229,4968230,4968232,4968235,4968248,4968249,4968251,4968259,4968262,4968271,4968276,4968281,4968287,4968293,4968294,4968295,4968296,4968300,4968302,4968305,4968308,4968310,4968313,4968315,4968316,4968317,4968319,4968320,4968321,4968322,4968323,4968326,4968330,4968331,4968332,4968333,4968334,4968345,4968347,4968350,4968352,4968355,4968358,4968360,4968363,4968381,4968385,4968390,4968393,4968398,4968400,4968407,4968408,4968416,4968423,4968424,4968425,4968426,4968427,4968430,4968435,4968451,4968457,4968458,4968459,4968460,4968465,4968466,4968467,4968472,4968479,4968487,4968491,4968493,4968497,4968506,4968509,4968522,4968525,4968543,4968544,4968549,4968551,4968561,4968566,4968568,4968569,4968574,4968575,4968595,4968596,4968597,4968598,4968599,4968600,4968601,4968603,4968607,4968608,4968610,4968611,4968616,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968632,4968635,4968636,4968637,4968639,4968644,4968648,4968649,4968650,4968654,4968655,4968656,4968657,4968658,4968659,4968660,4968661,4968662,4968663,4968665,4968668,4968669,4968671,4968674,4968675,4968676,4968677,4968678,4968679,4968680,4968686,4968690,4968693,4968694,4968697,4968698,4968699,4968703,4968708,4968714,4968717,4968723,4968724,4968729,4968730,4968731,4968732,4968733,4968734,4968735,4968736,4968737,4968738,4968739,4968740,4968741,4968742,4968743,4968744,4968745,4968746,4968747,4968748,4968749,4968750,4968751,4968752,4968753,4968754,4968755,4968756,4968757,4968758,4968759,4968767,4968771,4968774,4968783,4968789,4968790,4968805,4968809,4968810,4968811,4968813,4968820,4968822,4968833,4968835,4968851,4968852,4968859,4968861,4968864,4968865,4968867,4968868,4968869,4968874,4968884,4968896,4968903,4968905,4968911,4968916,4968918,4968922,4968925,4968926,4968927,4968931,4968934,4968937,4968938,4968943,4968946,4968951,4968960,4968966,4968970,4968973,4968976,4968979,4968984,4968986,4968989,4968990,4968997,4969003,4969005,4969012,4969034,4969042,4969043,4969044,4969045,4969046,4969047,4969048,4969049,4969050,4969059,4969078,4969080,4969087,4969088,4969090,4969091,4969093,4969095,4969100,4969102,4969104,4969105,4969106,4969107,4969110,4969111,4969112,4969114,4969116,4969118,4969123,4969124,4969125,4969126,4969127,4969128,4969129,4969130,4969131,4969132,4969133,4969134,4969137,4969141,4969142,4969144,4969147,4969156,4969161,4969166,4969167,4969177,4969178,4969179,4969180,4969187,4969190,4969193,4969194,4969195,4969196,4969197,4969198,4969201,4969205,4969212,4969213,4969215,4969220,4969237,4969239,4969247,4969250,4969253,4969267,4969268,4969270,4969278,4969282,4969283,4969284,4969287,4969288,4969289,4969300,4969301,4969302,4969307,4969308,4969309,4969310,4969311,4969314,4969316,4969317,4969328,4969335,4969336,4969338,4969350,4969351,4969355,4969366,4969377,4969385,4969386,4969388,4969395,4969397,4969398,4969399,4969401,4969406,4969407,4969408,4969409,4969411,4969413,4969414,4969420,4969425,4969430,4969433,4969434,4969436,4969439,4969443,4969445,4969447,4969448,4969450,4969451,4969452,4969455,4969459,4969460,4969464,4969473,4969486,4969492,4969494,4969508,4969510,4969514,4969529,4969531,4969532,4969539,4969540,4969541,4969542,4969543,4969544,4969545,4969546,4969554,4969555,4969556,4969558,4969559,4969560,4969561,4969565,4969566,4969568,4969573,4969575,4969577,4969586,4969587,4969589,4969590,4969593,4969597,4969598,4969601,4969602,4969603,4969604,4969605,4969607,4969608,4969611,4969612,4969613,4969614,4969620,4969622,4969623,4969625,4969627,4969628,4969634,4969636,4969641,4969651,4969652,4969653,4969664,4969667,4969668,4969669,4969671,4969672,4969677,4969678,4969688,4969695,4969696,4969697,4969698,4969707,4969729,4969735,4969750,4969751,4969756,4969762,4969763,4969764,4969765,4969771,4969775,4969778,4969781,4969782,4969783,4969786,4969787,4969788,4969789,4969791,4969798,4969802,4969805,4969821,4969826,4969834,4969835,4969836,4969842,4969843,4969850,4969858,4969859,4969865,4969866,4969869,4969872,4969875,4969876,4969877,4969882,4969884,4969885,4969887,4969892,4969896,4969900,4969904,4969909,4969913,4969916,4969919,4969941,4969947,4969949,4969952,4969956,4969961,4969962,4969964,4969976,4969977,4969979,4969987,4969989,4969998,4970002,4970005,4970013,4970014,4970017,4970019,4970031,4970040,4970049,4970054,4970055,4970056,4970057,4970063,4970073,4970074,4970079,4970081,4970090,4970092,4970093,4970095,4970098,4970100,4970101,4970103,4970106,4970110,4970114,4970115,4970116,4970117,4970118,4970123,4970128,4970131,4970132,4970134,4970137,4970139,4970140,4970150,4970152,4970153,4970154,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074814,8074815) 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'