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(4971098,4971099,4971100,4971101,4971102,4971103,4971104,4971105,4971106,4971107,4971108,4971109,4968264,4968431,4968607,4968608,4968609,4968610,4968611,4968612,4968613,4968614,4968615,4968616,4968617,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968630,4968631,4968632,4968633,4968634,4968635,4968636,4968637,4968638,4968639,4968640,4968641,4968642,4968643,4968644,4968645,4968646,4968647,4968648,4968649,4968650,4968651,4968652,4968653,4968654,4968655,4968656,4968657,4968658,4968659,4968660,4968661,4968662,4968663,4968664,4968665,4968666,4968667,4968668,4968669,4968670,4968671,4969285,4969286,4969287,4969288,4969290,4969291,4969292,4969293,4969294,4969295,4969296,4969297,4969298,4969299,8075226,8075227,8075228,8075229,8075230,8075231,8075232,8075233,8075234,8075235,8075236,8075237,8075238,8075239,8075240,8075241,8075242,8075243,8075244,8075245,8075246,8075247,8075248,8075249,8075250,8075251,8075252,8075253,8075254,8075255,8075256,8075257,8075258,8075259,8075260,8075261,8075262,8075263,8075264,8075265,8075266,8075267,8075268,8075269,8075270,8075271,8075275,8075277,8075278,8075279,8075280,8075282,8075312,8075317,8075342,8075343,8075344,8075345,8075346,8075347,8075348,8075349,8075350,8075351,8075352,8075353,8075354,8075355,8075356,8075357,8075358,8075359,8075360,8075361,8075362,8075363,8075364,8075365,8075366,8075367,8075368,8075369,8075370,8075371,8075372,8075373,8075374,8075375,8075376,8075377,8075378,8075379,8075380,8075381,8075382,8075383,8075384,8075385,8075386,8075387,8075388,8075389,8075390,8075391,8075392,8075393,8075394,8075395,8075396,8075397,8075398,8075399,8075400,8075401,8075402,8075403,8075404,8075405,8075406,8075407,8075408,8075409,8075410,8075411,8075412,8075413,8075414,8075415,8075416,8075417,8075418,8075419,8075420,8075421,8075422,8075423,8075424,8075425,8075426,8075427,8075428,8075429,8075430,8075431,8075432,8075433,8075434,8075435,8075436,8075437,8075438,8075439,8075440,8075441,8075442,8075443,8075444,8075445,8075446,8075447,8075448,8075449,8075450,8075451,8075452,8075453,8075454,8075455,8075456,8075457,8075458,8075459,8075460,8075461,8075462,8075463,8075464,8075465,8075466,8075467,8075468,8075469,8075470,8075471,8075472,8075473,8075474,8075475,8075476,8075477,8075478,8075479,8075480,8075481,8075482,8075483,8075484,8075485,8075486,8075487,8075488,8075489,8075490,8075491,8075492,8075493,8075494,8075495,8075496,8075497,8075498,8075499,8075500,8075501,8075502,8075503,8075504,8075505,8075506,8075507,8075508,8075509,8075510,8075511,8075512,8075513,8075514,8075515,8075516,8075517,8075518,8075519,8075520,8075521,8075522,8075523,8075524,8075525,8075526,8075527,8075528,8075529,8075530,8075531,8075532,8075533,8075534,8075535,8075536,8075537,8075538,4967027,4967028,4967029,8072995,8072996,8072997,8072998,8072999,8073000,8073001,8073002,8073003,8073004,8073005,8073006,8073007,8073008,8073009,8073010,8073011,8073012,8073013,8073014,8073015,8073016,8073017,8073018,8073019,8073020,8073021,8073022,8073023,8073024,8073025,8073026,8073027,8073028,8073029,8073030,8073031,8073032,8073033,8073034,8073035,8073036,8073037,8073038,8073039,8073040,8073041,8073042,8073043,8073044,8073045,8073046,8073047,8073048,8073049,8073050,8073051,8073052,8073053,8073054,8073055,8073056,8073057,8073058,8073059,8073060,8073061,8073062,8073063,8073064,8073065,8073066,8073067,8073068,8073069,8073070,8073071,8073072,8073073,8073074,8073075,8073076,8073077,8073078,8073079,8073080,8073081,8073082,8073083,8073084,8073085,8073086,8073087,8073088,8073089,8073090,8073091,8073092,8073093,8073094,8073095,8073096,8073097,8073098,8073099,8073100,8073101,8073102,8073103,8073104,8073105,8073106,8073107,8073108,8073109,8073110,8073111,8073112,8073113,8073114,8073115,8073116,8073117,8073118,8073119,8073120,8073121,8073122,8073123,8073124,8073125,8073126,8073127,8073128,8073129,8073130,8073131,8073132,8073133,8073134,8073135,8073136,8073137,8073138,8073139,8073140,8073141,8073142,8073143,8073144,8073145,8073146,8073147,8073148,8073149,8073150,8073151,8073152,8073153,8073154,8073155,8073156,8073157,8073158,8073159,8073160,8073161,8073162,8073163,8073164,8073165,8073166,8073167,8073168,8073169,8073170,8073171,8073172,8073173,8073174,8073175,8073176,8073177,8073178,8073179,8073180,8073181,8073182,8073183,8073184,8073185,8073186,8073187,8073188,8073189,8073190,8073191,8073192,8073193,8073194,8073195,8073196,8073197,8073198,8073199,8073200,8073201,8073202,8073203,8073204,8073205,8073206,8073207,8073208,8073209,8073210,8073211,8073212,8073213,8073214,8073215,8073216,8073217,8073218,8073219,8073220,8073221,8073222,8073223,8073224,8073225,8073226,8073227,8073228,8073229,8073230,8073231,8073232,8073233,8073234,8073235,8073236,8073237,8073238,8073239,8073240,8073241,8073242,8073243,8073244,8073245,8073246,8073247,8073248,8073249,8073250,8073251,8073252,8073253,8073254,8073255,8073256,8073257,8073258,8073259,8073260,8073261,8073262,8073263,8073264,8073265,8073266,8073267,8073268,8073269,8073270,8073271,8073272,8073273,8073274,8073275,8073276,8073277,8073278,8073279,8073280,8073281,8073282,8073283,8073284,8073285,8073286,8073287,8073288,8073289,8073290,8073291,8073292,8073293,8073294,8073295,8073296,8073297,8073298,8073299,8073300,8073301,8073302,8073303,8073304,8073305,8073306,8073307,8073308,8073309,8073310,8073311,8073312,8073313,8073314,8073315,8073316,8073317,8073318,8073319,8073320,8073321,8073322,8073323,8073324,8073325,8073326,8073327,8073328,8073329,8073330,8073331,8073332,8073333,8073334,8073335,8073336,8073337,8073338,8073339,8073340,8073341,8073342,8073343,8073344,8073345,8073346,8073347,8073348,8073349,8073350,8073351,8073352,8073353,8073354,8073355,8073356,8073357,8073358,8073359,8073360,8073361,8073362,8073363,8073364,8073365,8073366,8073367,8073368,8073369,8073370,8073371,8073372,8073373,8073374,8073375,8073376,8073377,8073378,8073379,8073380,8073381,8073382,8073383,8073384,8073385,8073386,8073387,8073388,8073389,8073390,8073391,8073392,8073393,8073394,8073395,8073396,8073397,8073398,8073399,8073400,8073401,8073402,8073403,8073404,8073405,8073406,8073407,8073408,8073409,8073410,8073411,8073412,8073413,8073414,8073415,8073416,8073417,8073418,8073419,8073420,8073421,8073422,8073423,8073424,8073425,8073426,8073427,8073428,8073429,8073430,8073431,8073432,8073433,8073434,8073435,8073436,8073437,8073438,8073439,8073440,8073441,8073442,8073443,8073444,8073445,8073446,8073447,8073448,8073449,8073450,8073451,8073452,8073453,8073454,8073455,8073456,8073457,8073458,8073459,8073460,8073461,8073462,8073463,8073464,8073465,8073466,8073467,8073468,8073469,8073470,8073471,8073472,8073473,8073474,8073475,8073476,8073477,8073478,8073479,8073480,8073481,8073482,8073483,8073484,8073485,8073486,8073487,8073488,8073489,8073490,8073491,8073492,8073493,8073494,8073544,10623058,10623059,10623060,10623064,10623495,10623496,10623504,10623660,10623661,10623662,10623663,10623664,10623665,10623666,10623667,10623668,10623669,10623670,10623671,10623672,10623673,10623674,10623675,10623676,10623677,10623678,10623679,10623680,10623681,10623682,10623683,10623684,10623685,10623686,10623687,10623688,10623689,10623690,10623691,10623692,10623693,10623694,10623695,10623696,10623697,10623698,10623699,10623700,10623701,10623702,10623703,10623704,10623705,10623706,10623707,10623708,10623709,10623710,10623711,10623712,10623713,10623714,10623715,10623716,10623717,10623718,10623719,10623720,10623721,10623722,10623723,10623724,10623725,10623726,10623727,10623728,10623729,10623730,10623731,10623732,10623733,10623734,10623735,10623736,10623737,10623738,10623739,10623740,10623741,10623742,10623743,10623744,10623745,10623746,10623747,10623748,10623749,10623750,10623751,10623752,10623753,10623754,10623755,10623756,10623757,10623758,10623759,10623760,10623761,10623762,10623763,10623764,10623765,10623766,10623767,10623768,10623769,10623770,10623771,10623772,10623773,10623774,10623775,10623776,10623777,10623778,10623779,10623780,10623781,10623782,10623783,10623784,10623785,10623786,10623787,10623788,10623789,10623790,10623791,10623792,10623793,10623794,10623795,10623796,10623797,10623798,10623799,10623800,10623801,10623802,10623803,10623804) 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'