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(10939583,10939584,10939607,10943427,10943428,10943429,10943430,10943431,10943432,10943436,10943437,10939651,10939905,10939943,10939944,10939945,10940101,10940154,10940155,10940520,8066941,8066942,8066943,8066944,8066945,8066946,8066954,8066955,8066956,8066957,8066958,8066959,8066991,10437200,8067412,8067518,10437402,8067713,10437606,10938478,10938482,10938483,8067832,8067903,8067906,8067952,8067953,8067954,8067955,8067956,8067957,8067958,8067959,8067960,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068025,8068026,8068027,8068040,8068057,8068067,8068068,8068069,8068070,8068071,8068072,8068073,8068074,8068075,8068076,8068097,8068098,8068099,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,8068139,8068140,8068141,8068142,8068143,8068144,8068145,8068146,8068147,8068190,8068191,8068192,8068193,8068194,8068242,8068243,8068253,8068254,8068255,8068272,8068273,8068297,8068298,8068299,8068306,8068307,8068308,8068309,8068310,8068311,8068312,8068313,8068314,8068349,8068398,8068399,8068420,8068421,8068422,8068449,8068450,8068451,8068464,8068472,8068493,8068494,8068495,8068496,8068497,8068498,8068499,8068500,8068501,8068502,8068503,8068504,8068505,8068506,8068507,8068508,8068524,8068525,8068526,8068527,8068540,8068541,8068542,8068543,8068544,8068545,8068546,8068624,10939365,8068635,8068636,8068637,8068638,8068639,8068645,10939379,10939423,8068694,8068709,8068710,8068711,8068727,8065082,10931538,10931539,10931558,10931570,10932096,4967031,4967034,4967035,4967036,4967037,4967038,4967039,4967040,4967041,4967042,4967043,4967044,4967045,4967046,4967047,4967048,4967049,4967050,4967051,4967052,4967053,4967054,4967063,4967064,4967065,4967066,4967067,10932185,10932186,10932187,10932188,10932189,10932190,10932201,10932216,10932217,8065992,8066191,8066198,8066199,8066200,8066202,8066209,8066210,8066211,8066216,8066218,8066219,8066220,8066221,8066222,8066223,8066224,8066268,8066269,8066270,8066271,8066286,8066287,8066288,8066289,8066290,8066304,8066306,8066307,8066308,8066328,8066329,8066330,8066362,8066369,8066370,8066371,8066468,8066493,8066494,8066495,8066498,8066499,8066500,8066501,8066502,8066503,8066504,8066505,8066506,8066508,8066509,8066566,8066576,8066631,8066632,8066633,8066663,8066664,8066665,8066666,8066667,8066801,4968121,8066862,8066863,8066864,8066880,8063947,8063948,8063949,8063950,8063951,8063952,8063953,8063954,8063955,8063984,10942709,10942747,10942763,10942788,10942821,10942823,10942825,10942826,10943185,10943192,10943193,10943197,10943285,10943366,10943380,10943399,10943422,8970215,8970216,10940719,10940720,10940749,10940826,10941095,3656267,10941352,3656454,3656460,3656597,10941710,3656717,10941796,10941804,10941807,10941808,10941818,10941824,10941843,10941850,10941851,10941852,10941853,3656834,10941896,10941901,10941902,10941904,10941906,10941910,10941931,10941932,10941943,10941944,10941945,10941947,10941954,10941989,10941994,10941996,10941999,10942001,3656977,10942007,10942009,10942010,10942013,10942014,10942015,10942017,10942018,10942019,10942024,10942058,10942141,10942196,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,8073517,8073518,8073519,8073520,10942416,10923476,10923477,10923478,10923479,10918495,10923533,10923562,10923563,10923564,10923591,10923592,10923618,10923625,10923626,10923627,10923635,10923645,10923646,10923647,10923648,10923649,10923650,10923721,10923722,10923819,10923820,10923821,10623312,10923873,10923874,10924043,10924044,10924045,10623658,10924291,10919514,10919515,10919516,10919517,10919518,10919519,10919520,10919521,10919522,10919523,10624203,10924773,10924774,10924775,10924776,10924777,10924778,10924779,10924780,10924781,10924856,10924857,10919910,10924977,10924978,10924979,10924980,10924981,10924982,10925220,10925221,10925222,10925223,10925379,10925380,10925381,10925382,10925435,10925436,10925437,10925438,10925459,10925460,10925461,10925462,10925463,10621990,10621991,10621992,10622012,10622013,10622104,10622105,10922643,10622190,10922709,10622264,10622265,10622266,10622267,10622268,10622269,10922817,10922818,10922819,10922901,10922902,10922904,10922905,10922911,10922920,10922921,10922943,10922944,10922947,10922949,10922957,10922958,10922965,10922986,10622524,10923085,10923086,10923087,10923100,10923101,10923102,10923124,10918131,10918132,10923145,10622656,10622662,10923212,10923229,10923230,10923231,10923232,10923233,10923278,10923279,10923280,10918289,10918290,10918291,10918292,10918293,10918294,10918295,10923342,10923360,10622881,10622882,10923394,10622885,10923401,10923402,10622892,10923403,10622893,10923404,10923405,10923447,10923448,10923449,10923450,10923451,10920594,10920595,10920596,10920597,10620143,10620210,10920740,10920741,10920742,10920743,10920744,10920745,10920746,10920747,10920748,10920749,10920750,10920751,10920752,10920753,10920754,10920755,10920756,10920757,10920758,10920759,10920760,10920761,10920762,10920763,10920764,10920765,10920766,10920767,10620300,10620301,10620303,10620350,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620370,10620408,10620409,10620410,10620426,10620528,10620669,10621116,10621117,10621119,10621120,10621132,10621146,10621147,10621148,10621150,10621155,10621160,10621161,10621162,10621239,10621240,10621241,10621242,10621265,10621266,10621273,10621274,10621279,10621284,10621288,10621289,10621290,10621291,10621292,10621293,10621301,10621305,10621306,10621320,10621323,10621324,10621375,10621376,10621377,10621378,10621379,10621380,10621587,10621645,10621651,10621684,10621688,10621689,10621692,10621693,10621695,10621698,10621705,10610962,10610998,10565186,10565189,10565196,10611048,10611064,10611065,10611122,10611255,10611339,10611376,10611403,10611404,10611405,10611406,10611407,10611408,10611409,10611410,10611411,10611412,10611413,10611414,10611415,10611416,10611417,10611418,10611419,10611420,10611421,10611422,10611423,10611424,10611425,10611426,10611427,10611428,10611429,10611430,10611431,10611452,10565707,10565708,10611669,10611670,10611671,10611680,10611682,10611766,10611802,10611821,10611863,10611880,10566044,10611896,10566046,10611898,10566057,10566058,10611909,10611910,10611914,10611915,10611920,10611922,10611925,10611926,10611927,10611936,10611937,10611939,10611941,10563504,10563505,10563506,10563507,10563519,10563520,10563534,10563546,10563567,10563572,10610027,10610030,10610037,10610191,10610233,10610235,10610237,10610261,10610262,10610263,10610264,10610265,10610298,10610312,10610327,10610467,10610696,10610779,10610782,10610783,10610825,10610826,10610863,10610869,10610930,10517247,10517248,10517249,10517250,10517251,10517252,10517253,10517254,10517255,10555277,10555278,10555279,10555280,10555281,10555282,10555283,10555284,10555285,10555286,10555287,10517287,10555288,10517288,10517300,10517301,10517302,10517303,10517304,10517305,10555365,10517557,10517605,10517659,10517809,10517818,10556240,10556241,10556423,10556630,10556631,10556632,10556633,10556634,10556635,10556636,10556637,10556638,10556639,10556640,10556641,10556642,10556643,10556644,10556645,10419243,10415409,10419459,10415460,10419568,10415612,10419891,10419895,10419899,10419901,10419904,10419905,10419907,10419921,10419923,10419925,10419936,10419937,10419942,10419944,10419994,10420036,10420053,10420055,10420056,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10463023,10471128,10471129,10471176,10471177,10471193,10463587,10463588,10463648,10463649,10463650,10463651,10463652,10463730,10463741,10463742,10463743,10463744,10463768,10463769,10463770,10463771,10470116,10470117,8563597,8563602,10462312,10462313,10470370,10470372,10462406,10462407,10462408,10462426,10462427,10462428,10462470,10470471,10462471,10462472,10470473,10462473,10462474,10462475,10462476,10462477,10462478,10462479,10462480,10462481,10462482,10462483,10462484,10462485,10462486,10462487,10462488,10462489,10462490,10462491,10462492,10462493,10462494,10462495,10462496,10462497,10462498,10462499,10462500,10462501,10462502,10462503,10462504,10462505,10462506,10462507,10462508,10462509,10462510,10462511,10462512,10462513,10462514,10462515,10462516,10462517,10462518,10462519,10462520,10462521,10462522,10462523,10462524,10462525,10462526,10462527,10462528,10462529,10462530,10462531,10462532,10462533,10462534,10462535,10462536,10462537,10462538,10462539,10462540,10462541,10462542,10462543,10462544,10462545,10462546,10462547,10462548,10462549,10462550,10462581,10462582,10462583,10470586,10462632,10462633,10462634,10462635,10462636,10462637,10462638,10470644) 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'