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(4970159,4970160,4970161,4970162,4970163,4970164,4970165,4970166,4970167,4970168,4970169,4970170,4970171,4970172,4970173,4970174,4970175,4970176,4970177,4970178,4970179,4970180,4970181,4970182,4970183,4970184,4970185,4970186,4970187,4970188,4970189,4970190,4970191,4970192,8068855,10943465,10943466,10943467,10943468,4970921,10944108,10944109,10944110,10944111,10944112,10944113,10944114,10944115,10944116,10944117,10944118,10944119,10944120,10944121,10944122,10944123,10944124,10944125,10944126,10944127,10944128,10944129,10944130,10944131,10944132,10944133,10944134,10944135,10944136,10944137,10944138,10944139,10944140,10944141,10944142,10944143,4970969,10944144,10944145,10944146,10944147,10944148,10944149,10944150,10944151,10944152,10944153,10944154,10944155,10944156,10944157,10944268,10944269,10944270,10944271,10944272,10437546,10437612,10437654,10437655,10437656,10437657,8067833,8067834,8067835,8067836,8067837,8067883,8067884,8067885,8067886,8067887,8067907,8067917,4969294,4969295,4969296,4969297,8067956,8067957,8067958,8067959,8067972,8067973,8067974,8067975,8067991,8067992,8067993,8067994,8067995,8067996,8068006,8068007,8068008,8068045,8068046,8068047,8068067,8068068,8068069,8068070,8068071,8068072,8068073,8068090,8068091,8068114,8068119,8068120,8068121,8068122,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,8068139,8068178,8068179,8068180,8068181,8068182,8068217,8068218,8068224,8068225,8068226,8068227,8068228,8068229,8068230,8068231,8068253,8068254,8068269,8068270,8068271,8068285,8068286,8068287,8068302,8068304,8068307,8068340,8068341,8068342,8068363,8068364,8068365,8068366,8068367,8068368,8068379,8068385,8068398,8068409,8068410,8068411,8068430,8068431,8068432,8068433,8068442,8068450,8068451,8068455,8068473,8068474,8068475,8068484,8068485,8068497,8068498,8068499,8068500,8068501,8068502,8068503,8068504,8068505,8068506,8068507,4969860,4969861,4969862,4969863,4969864,4969865,4969866,4969867,4969868,4969869,4969870,4969871,8068519,4969872,4969873,4969874,4969875,4969876,4969877,4969878,4969879,4969880,4969881,4969882,4969883,4969884,4969885,4969886,8068533,8068534,4969887,8068535,4969888,8068536,4969889,8068537,4969890,4969891,4969892,4969893,4969894,4969895,4969896,4969897,4969898,4969899,4969900,4969901,4969902,4969903,4969904,4969905,4969906,4969907,4969908,4969909,4969910,4969911,4969912,4969913,4969914,4969915,4969916,4969917,4969918,8068566,4969919,4969920,8068567,8068568,4969921,4969922,8068569,4969923,4969924,4969925,4969926,4969927,4969928,4969929,4969930,4969931,4969932,4969933,4969934,4969935,4969936,4969937,4969938,4969939,4969940,4969941,4969942,4969943,4969944,4969945,4969946,4969947,4969948,4969949,4969950,4969951,4969952,8068599,4969953,4969954,8068602,4969955,4969956,4969957,4969958,4969959,4969960,8068608,4969961,4969962,4969963,4969964,4969965,4969966,4969967,4969968,4969969,4969970,4969971,8068619,4969972,4969973,4969974,4969975,4969976,4969977,4969978,4969979,4969980,4969981,4969982,4969983,4969984,4969985,4969986,4969987,4969988,4969989,4969990,4969991,4969992,4969993,4969994,8068642,4969995,4969996,4969997,4969998,4969999,8068647,4970000,4970001,8068648,8068649,4970002,4970003,4970004,8068652,4970005,8068653,4970006,4970007,4970008,4970009,4970010,4970011,4970012,4970013,4970014,4970015,4970016,4970017,4970018,4970019,4970020,4970021,4970022,4970023,4970024,4970025,8068672,4970026,8068673,8068674,4970027,4970028,4970029,4970030,4970031,4970032,4970033,4970034,4970035,4970036,8068683,4970037,4970038,4970039,4970040,4970041,4970042,4970043,8068691,4970044,4970045,4970046,4970047,4970048,4970049,4970050,4970051,8068699,4970052,8068700,4970053,8068701,4970054,4970055,8068702,4970056,4970057,4970058,4970059,4970060,4970061,4970062,4970063,4970064,4970065,4970066,4970067,8068714,4970068,4970069,8068716,4970070,4970071,4970072,4970073,4970074,4970075,4970076,8068724,4970077,4970078,4970079,4970080,4970081,4970082,4970083,4970084,4970085,4970086,4970087,4970088,4970089,4970090,4970091,4970092,4970093,4970094,4970095,4970096,4970097,4970098,4970099,4970100,4970101,4970102,8068750,4970103,4970104,4970105,4970106,4970107,8068755,4970108,8068756,4970109,8068757,4970110,8068758,4970111,4970112,4970113,4970114,4970115,4970116,8068764,4970117,4970118,4970119,4970120,4970121,4970122,4970123,4970124,4970125,4970126,4970127,4970128,4970129,4970130,4970131,4970132,4970133,4970134,4970135,4970136,4970137,4970138,4970139,4970140,4970141,4970142,4970143,4970144,4970145,4970146,4970147,4970148,4970149,4970150,4970151,4970152,4970153,4970154,4970155,4970156,4970157,4970158,10931558,10931559,10931560,10931561,10931562,10931563,10931564,10931565,10931566,10931567,10931568,10931569,8075247,8075248,10932082,10932168,10932202,10932207,10932208,4967167,4967168,4967169,4967170,4967171,4967172,4967173,4967174,4967175,4967176,4967177,4967178,4967179,4967180,4967181,4967182,4967183,4967184,4967185,4967186,4967187,4967188,4967189,4967190,4967191,4967192,4967193,4967194,4967195,4967196,4967197,4967198,4967199,4967200,4967201,4967202,4967203,4967204,4967205,4967206,4967207,4967208,4967209,4967210,4967211,4967212,4967213,4967214,4967215,4967216,4967217,4967218,4967219,4967220,4967221,4967222,4967223,4967224,4967225,4967226,4967227,4967228,4967229,4967230,4967231,4967232,4967233,4967234,4967235,4967236,4967237,4967238,4967239,4967240,4967241,4967242,4967243,4967244,4967245,4967246,4967247,4967248,4967249,4967250,4967251,4967252,4967253,4967254,4967255,4967256,4967257,4967258,4967259,4967260,4967261,4967262,4967263,4967264,4967265,4967266,4967267,4967268,4967269,4967270,4967271,4967272,4967273,4967274,4967275,4967276,4967277,4967278,4967279,4967280,4967281,4967282,4967283,4967284,4967285,4967286,4967287,4967288,4967289,4967290,4967291,4967292,4967293,4967294,4967295,4967296,4967297,4967298,4967299,4967300,4967301,4967302,4967303,4967304,4967305,4967306,4967307,4967308,4967309,4967310,4967311,4967312,4967313,4967314,4967315,4967316,4967317,4967318,4967319,4967320,4967321,4967322,4967323,4967324,4967325,4967326,4967327,4967328,4967329,4967330,10933246,10942820,10942830,10942887,10942888,10942926,10942933,10942935,10942942,10942970,10942971,10943017,10943041,10943046,10943055,10943061,10943090,10943093,10943094,10940693,10940715,10940716,8072873,8072874,8072875,8072876,8072877,8072878,8072879,8072880,10942302,10942303,10923495,10923496,10923497,10923528,10923535,10923548,10923549,10923550,10923551,10923571,10923572,10923581,10923597,10923598,10923630,10923631,10923632,10923667,10923762,10923763,10923764,10923765,10923766,10923767,10923768,10923769,10923770,10923771,10623306,10923843,10923844,10923845,10923846,10623337,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10623431,10923983,10923984,10923985,10924071,10924072,10924073,10924074,10924075,10924077,10924078,10924079,10924107,10924173,10924174,10924175,10924235,10924236,10924237,10924238,10924267,10924274,10924275,10924448,10924449,10924450,10924451,10924452,10924453,10924454,10924455,10924456,10924457,10924458,10924459,10924460,10924461,10924462,10924463,10924464,10924465,10924466,10924467,10924468,10924469,10924470,10924471,10924472,10924473,10924474,10924475,10924476,10623959,10924477,10924478,10924479,10924480,10924481,10924482,10924483,10924484,10924485,10924486,10924681,10924682,10924683,10924684,10924685,10924686,10924687,10924771,10924915,10924916,10924917,10924918,10925116,10925117,10925130,10925131,10925132,10622406,10622431,10622909,10620106,10620371,10621247,10621248,10621249,10621250,10621258,10621259,10621284,10621288,10621289,10621290,10621295,10621312,10621313,10621324,10621356,10621376,10621377,10621378,10621379,10621390,10621391,10621392,10621393,10621394,10621395,10621406,10621407,10621408,10621409,10621426,10621450,10621469,10621470,10621508,10621531,10621532,10621533,10621568,10621574,10621590,10621591,10621592,10621602,10621621,10621622,10621623,10621624,10621625,10621634,10621661,10621662,10621667,10621674,10621677,10621678,10621679,10621680,10621685,10621699,10621710,10621711,10621728,10621746,10621747,10517112,10517113,10517114,10517115,10517116,10518643,10419467,10419705,10419958,10419959,10419960,10419961,10419962,10419963,10419964,10420065,10471496,10469928,10470009,10470010,10470011,10470112,10470129,10470130,10470325,10470400,10470403,10470518,10470524,10470671) 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'