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(4970270,4970290,4970315,4970335,4970336,4970337,4970338,4970340,4970383,4970385,4970386,4970500,4970501,4970502,4970552,4970560,4970569,4970570,4970571,4970572,4970573,4970574,4970575,4970576,4970577,4970578,4970579,4970580,4970636,4970637,4970638,4970640,4970641,4970645,4970659,4970660,4970666,4970667,4970668,4970669,4970673,4970677,4970678,4970679,4970680,4970682,4970684,4970687,4970689,4970690,4970700,4970703,4970711,4970724,4970726,4970732,4970738,4970743,4970745,4970746,4970748,4970749,4970750,4970751,4970752,4970753,4970754,4970755,4970756,4970757,4970758,4970759,4970767,4970784,4970788,4970789,4970790,4970791,4970816,4970824,4970825,4970826,4970827,4970828,4970829,4970830,4970831,4970832,4970833,4970834,4970835,4970836,4970837,4970838,4970839,4970840,4970841,4970842,4970843,4970844,4970845,4970846,4970847,4970848,4970849,4970850,4970851,4970853,4970854,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,4970992,4970993,4970994,4971019,4971020,4971021,4971022,4971023,4971024,4971025,4971028,4971029,4971030,4971031,4971032,4971033,4971034,4971035,4971036,4971037,4971050,4971051,4971053,4971054,4971055,4971056,4971057,4971058,4971060,4971061,4971062,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971070,4971071,4971072,4971083,4971085,4971086,4971087,4971088,4971089,4971091,4971092,4971093,4971095,4971096,4971110,4971111,4971137,4971138,4971139,4971142,4971143,4971147,4968174,4968188,4968189,4968190,4968191,4968192,4968255,4968256,4968257,4968258,4968259,4968260,4968261,4968262,4968263,4968264,4968265,4968266,4968267,4968268,4968269,4968270,4968271,4968272,4968273,4968274,4968275,4968276,4968277,4968278,4968279,4968280,4968281,4968282,4968283,4968284,4968285,4968286,4968287,4968288,4968289,4968290,4968310,4968311,4968312,4968313,4968314,4968315,4968316,4968317,4968318,4968319,4968320,4968321,4968322,4968330,4968331,4968358,4968369,4968371,4968409,4968410,4968411,4968412,4968413,4968425,4968442,4968443,4968458,4968475,4968476,4968477,4968478,4968479,4968480,4968481,4968482,4968483,4968484,4968485,4968486,4968487,4968488,4968489,4968490,4968491,4968492,4968493,4968494,4968520,4968565,4968566,4968604,4968605,4968606,4968607,4968608,4968611,4968613,4968614,4968622,4968623,4968624,4968625,4968636,4968637,4968644,4968647,4968654,4968661,4968662,4968663,4968672,4968673,4968674,4968675,4968679,4968681,4968698,4968703,4968761,4968762,4968763,4968764,4968765,4968766,4968767,4968768,4968769,4968770,4968808,4968809,4968846,4968847,4968848,4968859,4968861,4968863,4968864,4968865,4968866,4968867,4968868,4968869,4968888,4968898,4968899,4968900,4968901,4968962,4968985,4968986,4968987,4968988,4969043,4969123,4969124,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969193,4969194,4969195,4969196,4969197,4969198,4969199,4969200,4969201,4969202,4969203,4969204,4969205,4969206,4969207,4969208,4969209,4969210,4969211,4969212,4969213,4969214,4969215,4969237,4969238,4969239,4969240,4969241,4969242,4969243,4969244,4969245,4969252,4969253,4969254,4969255,4969256,4969257,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969266,4969267,4969268,4969269,4969282,4969283,4969284,4969285,4969286,4969287,4969288,4969289,4969294,4969295,4969320,4969327,4969364,4969371,4969372,4969373,4969374,4969375,4969376,4969377,4969378,4969379,4969380,4969381,4969400,4969402,4969410,4969493,4969494,4969495,4969496,4969497,4969498,4969499,4969500,4969501,4969502,4969503,4969504,4969505,4969506,4969507,4969508,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,4969519,4969520,4969521,4969522,4969523,4969524,4969539,4969540,4969541,4969542,4969543,4969547,4969568,4969570,4969601,4969604,4969611,4969612,4969613,4969614,4969632,4969633,4969634,4969635,4969636,4969637,4969638,4969642,4969643,4969644,4969645,4969646,4969647,4969648,4969649,4969650,4969651,4969652,4969653,4969665,4969666,4969667,4969668,4969669,4969673,4969674,4969675,4969676,4969677,4969678,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969686,4969687,4969688,4969689,4969696,4969697,4969698,4969699,4969700,4969701,4969702,4969703,4969704,4969705,4969706,4969707,4969708,4969709,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,4969755,4969756,4969757,4969758,4969759,4969760,4969761,4969762,4969763,4969764,4969765,4969775,4969776,4969777,4969778,4969779,4969780,4969781,4969782,4969783,4969784,4969785,4969786,4969787,4969788,4969789,4969790,4969791,4969792,4969793,4969802,4969803,4969804,4969805,4969806,4969807,4969818,4969819,4969820,4969821,4969822,4969823,4969824,4969825,4969826,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969834,4969835,4969878,4969879,4969880,4969881,4969882,4969883,4969906,4969907,4969908,4969909,4969938,4970016,4970018,4970020,4970021,4970057,4970058,4970119,8075214,8075215,8075216,8075217,8075225,8075226,8075227,8075228,8075229,8075230,8075231,8075232,8075233,8075234,8075235,8075236,8075237,8075238,8075239,8075240,8075241,8075242,8075243,8075244,8075272,8075284,8075288,8075289,8075309,8075310,8075312,8075321,8075324,8075332,8075400,8075401,8075404,8075405,8075407,8075408,8075409,8075410,8075413,8075414,8075415,8075432,8075433,8075435,8075436,8075448,8075449,8075450,8075453,8075455,8075473,8075478,8075479,8075480,8075482,8075483,8075484,8075487,8075489,8075490,8075491,8075492,8075493,8075494,8075495,8075496,8075497,8075498,8075502,8075506,8075508,8075509,8075511,8075512,8075513,8075514,8075518,8075520,8075538,4967027,4967028,4967030,4967031,4967032,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,4967100,4967103,4967105,4967107,4967110,4967112,4967121,4967133,4967137,4967148,4967149,4967150,4967151,4967152,4967153,4967154,4967155,4967156,4967157,4967158,4967159,4967160,4967162,4967166,4967168,4967171,4967177,4967178,4967180,4967201,4967211,4967219,4967221,4967225,4967233,4967236,4967238,4967239,4967240,4967248,4967259,4967265,4967266,4967271,4967289,4967299,4967301,4967302,4967305,4967309,4967313,4967318,4967322,4967329,4967336,4967343,4967346,4967348,4967349,4967353,4967355,4967356,4967357,4967365,4967371,4967372,4967373,4967378,4967379,4967384,4967385,4967390,4967394,4967395,4967406,4967414,4967429,4967432,4967433,4967435,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,4967470,4967471,4967475,4967478,4967481,4967482,4967487,4967494,4967497,4967512,4967517,4967518,4967523,4967526,4967534) 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'