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(8630720,7076128,8630894,10939882,10459017,10459023,3228960,10950480,9215605,10950885,8067275,8067286,8067292,10459894,10459895,10459897,10459898,10459914,10459915,10459917,10459918,10459919,10459921,10459922,10459924,10459925,10459926,10459927,10459928,10459936,10459937,10459939,10459940,10459956,10459957,10459959,10459960,10459961,10459963,10459964,10459966,10459967,10459968,10459969,10459970,10459976,10459977,10459979,10459980,10459996,10459997,10459999,10460000,10460001,10460003,10460004,10460006,10460007,10460008,10460009,10460010,10460016,10460017,10460019,10460020,10460036,10460037,10460039,10460040,10460041,10460043,10460044,10460046,10460047,10460048,10460049,10460050,10460056,10460057,10460059,10460060,10460076,10460077,10460079,10460080,10460081,10460082,10460084,10460086,10460087,10460088,10460089,10460090,10460096,10460097,10460099,10460100,10849819,10460116,10460117,10460119,10460120,10460121,10460123,10460124,10460126,10460127,10460128,10460129,10460130,10460136,10460137,10460139,10460140,10460156,10460157,10460159,10460160,10460161,10460163,10460164,10460166,10460167,10460168,10460169,10460170,10460176,10460177,10460179,10460180,10460196,10460197,10460199,10460200,10460201,10460203,10460204,10460206,10460207,10460208,10460209,10460210,10460216,10460217,10460219,10460220,10460236,10460237,10460239,10460240,10460241,10460243,10460244,10460246,10460247,10460248,10460249,10460250,10460256,10460257,10460259,10460260,10460276,10460277,10460279,10460280,10460281,10460283,10460284,10460286,10460287,10460288,10460289,10460290,10460296,10460297,10460299,10460300,10460316,10460317,8632393,8632394,10460319,8632395,10460320,8632396,10460321,8632397,8632398,10460323,8632399,10460324,10460326,10460327,10460328,10460329,10460330,10460336,10460337,10460339,10460340,10460356,10460357,10460359,10460360,10460361,10460363,10460364,10460366,10460367,10460368,10460369,10460370,8629585,8629586,8629587,8629588,8629589,8629628,8629656,8629657,8629658,8629659,8629660,8629661,8629662,8629663,8629664,8629665,8629666,8629667,8629668,8629669,8629670,8629689,8629745,8629746,8629747,8629748,8629757,8629758,8629759,10872470,10872471,8629850,8629851,8629852,8629934,8630406,8630443,8630445,8630446,9214509,8627728,10103266,8627863,8627864,8627876,7201683,10960174,8628138,3899414,8628672,8628679,8628681,8628688,8628729,8628790,3227094,8629382,8629385,8629386,8629387,8629388,8629389,8629390,8629423,8629424,8629572,8626617,8626628,8626630,8626631,8626632,8626633,8626634,8626635,8626638,8626639,8626642,8626644,8626645,8626646,8626647,8626648,8626656,8626659,8626660,8626663,8626669,8626670,8626674,8626709,8626832,10102550,10842345,10842346,10842347,10842348,10842349,10842350,10842351,10842352,10842353,10842354,7200911,7200912,7200913,7200914,8627335,8627336,8627337,8627338,8627339,10839695,7198679,7198680,7198683,7198695,7198696,7198697,7198698,7198699,7198701,7198702,7198703,7198704,7198710,7198711,7198713,7198714,7198716,7198717,7198719,7198720,7198721,7198723,7198728,7198729,7198736,7198737,7198739,7198750,7198764,7198770,8626033,3926821,8626087,8626088,8626089,8626090,8626091,8626092,8626093,8626094,8626095,10101591,8626202,8626205,8626249,8626254,8626367,8626370,8626373,10853360,3234111,3234125,10838679,8624358,8624435,8624436,8624438,8634965,10617455,3232902,3232903,10617511,3922896,8633292,10848432,8634266,8634267,8634268,8634269,8634270,8634271,3232171,3232174,8634406,8634414,8634417,8634421,8634453,8634454,10565150,7059733,7059734,7059800,10559585,10559609,10559705,10559706,10559715,10559716,10559717,10559719,10559720,10559721,10559723,10559724,10559725,10559726,10559744,10559745,10559756,9174061,6666207,6666208,6666210,6666211,6666212,6666213,6666214,6666215,9211568,10561035,9188228,10561078,10561079,10561080,10561094,10561095,10561096,10561097,10561098,10561099,10561100,10561101,10561102,10561103,10561104,10561105,10561106,10561107,10558303,10558304,10558317,10558318,10558319,10558320,10561523,10561524,8852820,8852823,8853027,10517143,10517144,10515327,10515329,10515377,10515422,10515423,10517614,10517615,10517616,10517617,10517618,10513622,10517670,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10513952,10513961,10513974,10513975,10514015,10514029,10514030,10514090,10514091,10514092,10516129,10516130,10516131,10516132,10516157,10516163,10516164,10516165,10516171,10516172,10516173,10516174,10516175,10516176,10514390,10512530,10518648,10518668,10518681,10518695,10518696,10518697,10518706,10518707,10518708,10512780,10512782,10516866,10516867,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,6666777,9207761,10627775,10892157,10631882,10568112,10568113,10568128,10568129,10580130,10568130,10580131,10601174,10568297,10568298,10568299,10568300,10568301,10568306,10568307,10568308,10568309,10568311,10568312,10568315,10601338,10601339,10601340,10601341,10601342,10598560,10598808,10598832,10598841,10583862,10583873,10583874,10583875,10602730,10584059,10584066,10584067,10584068,10584082,10584083,10584112,10584113,10584114,10566149,10584224,10584225,10590269,10590272,10590273,10590274,10590275,10590276,10590278,10590279,10590280,10590283,10590284,10590287,10590288,10590289,10590294,10590295,10590296,10590297,10590304,10590305,10590306,10590308,10590310,10590311,10599386,10578444,10578445,10578446,10578447,10578448,10584536,10590564,10590565,10584592,10566666,10566667,10590673,10590811,10567318,10567319,10567320,10591360,10591361,10591362,10582476,10582477,10582561,10582566,10582567,10582568,10582569,10582570,10582587,10582588,10582589,10591828,10591829,10591830,10591832,10568111,10539121,10539122,10539123,10551153,10551158,10527205,10527206,10519308,10529344,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529385,10529386,10529387,10529388,10529389,10529390,10529391,10529392,10529393,10529394,10529395,10529396,10529397,10529398,10529399,10529400,10529401,10529402,10529403,10529404,10529405,10529406,10529407,10529408,10529409,10529410,10529411,10529412,10529413,10529415,10529416,10529417,10529418,10529419,10529420,10529421,10529423,10529424,10529425,10541443,10529443,10541444,10541445,10541446,10541447,10541448,10525567,10549588,10549589,10537643,10537644,10537645,10521691,10521692,10521696,10537759,10541763,10541780,10541793,10541794,10541795,10541800,10541808,10541809,10541810,10541811,10541812,10541813,10541814,10541815,10541816,10541885,10539886,10539888,10541896,10541897,10541898,10541899,10541904,10541905,10541907,10541908,10541924,10541925,10541926,10547927,10541928,10547928,10547929,10541933,10541934,10530125,10532143,10532144,10532145,10532146,10532147,10532148,10532149,10532150,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10532164,10532165,10550193,10550197,10550198,10550199,10522257,10522293,10548294,10522294,10522295,10522296,10522297,10522298,10522299,10522300,10522301,10522302,10522303,10522304,10522305,10522306,10522307,10522308,10522309,10534309,10522310,10522311,10522312,10522313,10522314,10522315,10522317,10550319,10522348,10522349,10522350,10522351,10522352,10522353,10522354,10522355,10522356,10538357,10522357,10522358,10538358,10522359,10522360,10542423,10542424,10542440,10542441,10550445,10542453,10548482,10548512,10548513,10542526,10542527,10542528,10548565,10548566,10548567,10548568,10548569,10548570,10548571,10528579,10528580,10528582,10528583,10542602,10542603,10542654,10548684,10548685,10548747,10548748,10548750,10542795,10544815,10544816,10548841,10548842,10524867,10524868,10548885,10522946,10550993,10543042,10539096,10539097,10539099,10499123,10499124,10508205,10422361,10508407,10423583,10423584,10507544,10508595,10508598,10506819,10506820,10506821,10506822,10506823,10506824,10506825,10507922,10507956,10507957,10508037,10407327,10409521,10714989,10714990,10714991,10714992,10714993) 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'