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(8630758,8630759,8630760,3228947,10989238,10989239,10989240,10989241,3228992,3228993,3229016,3229019,3229020,10861936,10861989,10861990,10861991,10861992,10861993,10861994,10861995,3229184,3229189,3229302,3229303,3229304,3229305,7065949,10950612,10950659,10950875,10862592,10849724,10849725,10862839,10862840,10862842,3229975,3229979,10849851,10849852,10849853,10849854,10849855,10849856,10862875,11042378,10850034,10850035,10863085,10860254,10860255,10860256,7201201,10858312,3238521,7201585,7201586,7201587,7201588,7201608,7201610,7201612,7201614,7201615,7201616,7201617,7201618,7201619,7201620,7201621,7201637,10858825,8595229,3899100,8595298,10858968,7202147,7202149,7202151,7202153,7202154,7202158,7202160,7202183,7202184,7202185,7202186,7202188,7202193,7202195,10867276,10867277,10867278,10867279,10867280,7202322,7202373,7202374,10859538,10859553,5654600,5654601,10859566,10859599,10859601,5654647,10859602,5654684,7202598,7202599,7202600,7202646,7202647,7202663,7202664,7202675,10860053,10860054,10860056,10860058,10860061,10860063,10860065,10860067,10860068,10860069,10860070,10860071,10860072,10860073,10860079,10860080,10860082,10860083,10860110,10860111,10860112,10860113,10860115,10860116,10860117,10860163,10860168,10860209,10860217,10857266,10857268,10857271,10857274,10857279,10857280,10865370,10865371,10865372,10865381,10865393,10865394,10865397,10865407,10857453,10857458,8626907,8626908,7200534,7200535,7200540,7200541,7200542,7200543,7200544,7200545,7200546,7200547,7200548,7200549,7200550,7200551,7200552,7200553,7200554,7200556,7200557,7200558,7200559,7200560,7200561,7200562,7200563,7200564,7200565,7200566,7200567,7200568,7200569,7200570,7200571,7200572,7200573,7200574,7200575,7200576,7200577,7200578,7200579,7200580,8626989,8626993,8626994,8626995,8626998,8626999,8627000,8627001,8627002,8627003,7200645,7200646,7200647,7200648,7200649,7200650,7200651,7200652,7200653,7200654,7200655,7200656,7200657,7200658,7200659,7200660,7200661,7200662,7200663,7200664,7200665,7200666,7200667,7200668,7200669,7200670,7200671,7200672,7200673,7200674,7200675,7200676,7200677,7200678,7200679,7200722,7200723,7200724,7200725,7200726,4430162,4430163,4430164,10865846,7200849,7200850,7200924,10866027,10858118,10858119,10858120,10863294,10863296,10863300,10863301,10863303,10863304,10863307,10863310,10863313,10863315,10863317,10863319,10863320,10863322,10863323,10863325,10863328,10863329,10863330,10863331,10863332,10863334,10863336,10863337,10863338,10863341,10863344,10863346,10863349,10863352,10863354,10863360,10863432,7198408,7198409,7198410,7198412,7198414,7198415,7198417,7198419,7198457,7198458,7198459,7198461,7198462,7198464,7198465,10863814,10863815,10863816,10863817,8556489,10840305,10863867,10863873,10863874,10863878,10863885,10863887,8625269,8625270,8625271,8625272,8625273,8625274,8625275,8625276,8625277,8625278,8625279,8625280,8625342,8625343,8625344,8625345,8625346,8625347,8625348,8625349,8625350,8625351,7199018,7199019,10864065,10856118,10856120,8615671,8625508,8625512,10864154,10864155,8625513,10864156,10864157,10864158,10864159,10864160,8625519,10864161,10864162,10864163,10864164,10864165,10864166,7199398,8557165,7199530,7199531,7199532,7199533,10101937,7196257,7196258,7196259,7196260,3923408,7196261,7196262,7196263,7196264,7196265,7196266,7196267,7196268,7196269,7196270,7196271,7196272,7196273,7196274,7196275,7196276,7196277,7196278,7196279,7196280,7196281,7196282,7196283,7196284,7196285,7196286,7196287,7196288,7196289,7196290,7196291,7196292,7196293,7196294,7196295,7196296,7196297,7196298,7196299,7196300,7196301,7196302,7196303,7196304,7196305,7196306,7196307,7196308,7196309,7196310,7196311,7196312,7196313,7196314,7196315,7196316,7196317,7196318,7196319,7196320,7196321,7196322,7196323,7196324,7196325,7196326,7196327,7196328,7196329,7196330,7196331,7196332,7196333,7196334,7196335,7196336,7196337,7196338,7196339,7196340,7196341,7196342,7196343,7196344,7196345,7196346,7196347,7196348,7196349,7196350,7196351,7196352,7196353,7196354,7196355,10853459,3233593,10618265,10618266,10618267,10618270,10618271,10618272,10618282,10618283,10618284,10618287,10618288,10618289,10618290,10618292,10618294,10618295,10618298,10618299,10618300,10618301,10618302,10618304,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618320,10618321,10618322,10618323,10853654,10853655,10853656,11007777,11007778,3234724,7197840,7197854,7197855,7197856,8624368,8624372,8624373,8624378,8624440,8624442,10616971,10616997,10617005,10617006,10617008,10617037,10617041,10617059,10617093,10617094,10852361,10617231,10617232,10617246,10617248,10852519,10852527,10852530,10852535,10852536,10852538,10852540,10852541,10852542,10852560,10617316,10617317,11045035,10852661,8612210,10852662,10852663,10852664,10852665,10852666,10852667,10852668,10852669,10852670,10852671,10852672,10852673,10852674,10852676,10852677,10852678,10852679,10852680,10852681,10852682,10852683,10852684,10852685,10852686,10852687,10852688,10852689,10852690,10852691,10852692,10852693,10852694,10852695,10852696,10852697,10852698,3232857,3922832,10617513,10853030,10853032,7196151,10615161,10850673,10850674,10850675,10850676,10850677,10850678,10850788,10850789,10850790,10850798,10850799,10850800,10615540,10850841,10850842,10850843,10850844,10850845,10850846,10850847,10850848,10850849,10850850,10850851,10850852,10615677,3231081,10615818,10615867,10426253,10426254,8633953,8633954,8633955,8633956,8633957,8633958,8633959,8633960,8633961,8633962,8633963,10616464,10616469,10616471,10616472,10616485,10616490,10616491,10616492,10616493,10616494,10616495,10616510,10616512,10616517,10616519,10616520,10616522,10616576,8552565,10616698,10616699,10616700,8611518,10616730,10616733,10616734,10616735,10616739,8904821,8904823,10616844,10616845,10616850,10852112,10616851,10616853,10616854,8541385,10616905,10852181,10852187,10852188,10852189,10852190,10852191,10852192,10852193,10852194,10852195,10852196,10852197,10852198,10852199,10852200,10852201,10852202,10852203,10852204,10852205,10852206,10852207,10852208,10852209,10852210,10852211,10852212,10852213,10852214,10852215,10852216,10616955,10852217,10852218,10852219,10852220,10610990,10611025,10611123,10611147,10611196,10614221,10614466,10614552,10614553,10614554,10611861,10614861,10611862,10611962,10611989,10612043,10612049,10609141,10612207,10612208,10612210,10612211,10612227,10612238,10609284,10609339,9211866,8851703,10612958,8566848,10610046,10610104,8852330,10610293,10613296,10610299,10613303,10613356,10613357,10613373,9915042,9915043,10610503,10613646,8852916,10613769,10610941,10117500,10117501,10117502,9161683,10117933,9169843,9912052,10118256,10118257,10118258,10118323,10118365,10118367,10118373,8850115,9912888,8850517,10119481,10119482,10416236,10417273,10417274,10417275,10417276,9168372,10417300,10417310,10417311,10417315,10417324,10417325,10417327,9168463,10416403,10416406,10416441,10116890,10418693,10418694,10418697,10418705,10415738,10117031,10117032,10416822,10416824,10416828,10416829,10416831,10416832,10416835,10416838,10416841,10416843,10416845,10416847,10416849,10416852,10416853,10416855,10416858,10416859,10416861,10416862,10416863,10416864,10416866,10416868,10416869,10416871,10416873,10416875,10416879,10416881,10416884,10416887,10416889,10416893,10416896,10416967,10419016,10420102,10420103,10420104,10420105,10420106,10420107,10117425,10471106,10471107,10471108,10471109,10471110,10471111,10471114,10471117,10471119,8550027,8550244,10465856,10123834,10468226,10468227,10466248,10466249,9167857,10116158,10470727,10470733,10628020,10628311,10628312,10628313,10628323,10628324,10908930,10889697,10889698,10879915,10884998,10875287,10632300,10627325,10883445,10630116,10162851,10887377,10604531,10604552,10424578,10507670,10507671,10507716,10507717,10411232,10411234,10407359,10407360,10413373,10407438,10413469,10407469,10407470,10409675,10407934,10407935,10407936,10407937,10407938,10407939,10407940,10407941,10413992,10414004,10408024,10408025,10408026,10414035,10414037,10414038,10408058,10408059,10408060,10408061,10408062,10408063,10408064,10408065,10408066,10408067,10408068,10412175,10412181,10414447,10414448,10414450,10414452,10414455,10414457,10414459,10414461,10414462,10414467,10414468,10414469,10414470,10414501,10414502,10414503,10414504,10414505,10414506,10408761,10408800,10412844,10408982,10408991,10408994,10408999,10409000,10409002,10409003,10409004,10409013,10409016,10409081,10409082,10409083,10409084,10409085,10409086,10409087,10409088,10409089,10409090,10409091,10409092,10409093,10409094,10409095) 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'