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(10939561,11014771,8838642,8838643,8838646,8838647,8838648,8838649,11001894,11001895,7068245,7068246,7068247,7068248,7068249,7068250,11015006,11015007,11015008,11015017,11015018,11015019,7076355,10940161,10940162,10940163,10940164,10940165,11041263,4970859,4970939,11002438,10963492,11002575,11015612,11015613,11015614,11015615,11015616,11015617,11015618,11015619,11015620,11002730,11041774,11041786,11041787,11041788,11041789,11041790,11041791,11041792,11041807,11041835,11041836,11041837,11041838,11041839,11041855,11041867,11041889,11041890,11041891,11041892,11041893,11041894,11041895,11041896,11041897,11041898,11041899,11041900,11041901,11041903,11041912,11041918,11041919,11041920,11041921,11041922,11041923,11041924,11041925,11041926,11041927,11041928,11041929,11041930,11041931,10976931,11041932,11041967,11041969,11041970,11041975,11041976,11041977,11041990,11041991,11041992,11041996,11041997,11041998,11041999,11042027,11042028,11042029,11042030,11042068,11042075,11042077,11042078,11042079,11042089,11042101,11042117,11042118,11042135,11042144,11042145,11042146,11042147,11042148,11042149,11042150,11042151,11042152,11042158,11042175,11042176,11016224,11016225,11016226,11016227,11016228,11016229,11016230,11016231,11016232,11016233,11016248,11016249,11016250,11029268,7074598,11003284,11003313,11003314,11003315,11042321,7074676,7066692,8067691,11029469,11029470,7074826,7074827,7074935,7074941,11039642,11039643,11039644,11039645,10974689,11026689,10974690,11026690,11026691,10974691,11026692,10974692,10974693,11026693,10974694,10974695,10974696,10974697,10974698,10974699,10974700,10974701,10974702,10974703,10974704,10974705,10974706,10974707,10974708,10974709,10974710,10974711,10974712,10974713,10961732,10961733,10961734,10961735,7075137,11039838,11039844,10961852,11013907,11026956,11026980,11026981,7075371,7075372,7075375,7075379,7075380,11001149,11001150,7075677,7075680,10975367,10975368,10975369,7075689,8068598,8068599,7075845,7075848,7075849,7075852,7075853,11012311,11012352,11012359,11012360,8065967,11012832,11012879,10961135,8066557,10961276,10961277,10961290,10961343,10961344,10961345,10961346,10961347,10961348,10961349,10961350,10961351,10961352,10961353,10961460,10961461,11039469,10961484,10961485,11039485,11039486,11039487,11039488,11039489,11039493,11013592,11013593,11023791,11023792,11023793,11023794,11023795,10942966,10942967,11024110,10943051,11049477,10943235,10943246,10943247,11024315,11024316,11024317,11024318,11024350,11024351,11024352,11024353,11024354,11024355,11024356,11024357,11024358,11024359,11024360,11024361,11024362,11024363,7071802,11035103,11035104,8072357,8072358,8072359,8072360,8072361,11035336,8072429,8072470,11035818,11022879,10942063,11036126,11036127,11048478,7070622,10997369,10942494,10918485,10918504,10918505,10923623,10923624,10923628,10918789,10918790,10918791,10923825,10923826,10923827,10923828,11020131,10924031,10924032,10924033,10924034,10924035,10924051,10924052,10924053,10924054,10924055,10924340,10924341,10924342,10924343,10924344,10924345,10924346,10924347,10924348,10924349,10924350,10924351,10924352,10924353,10924354,10924355,10924356,10924357,10924358,10924359,10924360,10924361,10924362,10924363,10924364,10924365,10924366,10924367,10924368,10924369,10924370,10924371,10924372,10924373,10924374,10924375,10924376,10924377,10924378,10924379,10924380,10924381,10924382,10924383,10924384,10924385,10924386,10924387,10924388,10924389,10924577,10924578,10924579,10924600,10924601,10924602,10924603,10924604,10924605,10924606,10924607,10924608,10924609,10924610,10924611,10924612,10994784,10994785,10994808,10994809,10994810,10994811,10994910,10994911,10994912,10994913,10919836,10919840,10919841,10919842,11008052,11034096,11034097,10919960,10919961,10919962,10920013,10920014,10920018,10920019,10920020,10925100,11018727,11018728,11018729,10927582,11018730,10927596,10927622,10927638,10927642,10927643,10927646,10927648,10927649,10927650,10927651,10927652,10927653,10927686,10917694,10917695,10927696,10927697,10927701,10917727,10917728,10917729,10927748,10927764,10927768,10927786,10927787,10927788,10927789,10927806,10927829,10927830,10922959,11006144,11006173,11006174,11006177,11006178,11032287,11032288,11032346,11032347,11032348,11019388,11019425,11006605,10615080,10620100,10620101,10620102,10964939,10925863,11004168,8570482,11004281,11004282,10991324,10965396,10965397,10965528,10965529,10965530,10965531,10965532,10965533,10965534,10965535,10965536,10926396,10926397,10926502,11004652,11004653,10926534,10926552,10926556,10926557,10926558,10926559,10926560,10930984,11004761,10921636,11030821,10926690,10979135,10979136,10979137,10979138,10979139,10979140,10979141,10979142,10979143,10979144,10979145,10979146,10979147,10979148,10979149,10979150,10979151,10979152,10979153,10979154,10979155,10917007,10917008,10917009,10917010,11005176,11005179,11005180,11005181,10966222,10927261,10927263,10927265,10927267,10927268,11031434,11031435,11031436,10616784,10927339,11005524,10927401,10927413,11018605,11018606,11018607,11018608,7059550,7059565,7059579,7059600,7059601,7059603,7059649,7059686,7059711,8864296,9173877,9173878,9173879,10611706,9190154,8864676,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10612263,9187770,9187882,9187883,9187884,9187896,7058108,10609695,10613099,10613142,7059416,7059425,7059426,7059427,7059428,7059429,4974159,4974160,9193559,4974825,4974826,4974827,4974828,9169982,4974917,4974918,10512118,10512119,10512120,4975175,4975178,2809391,2809392,2809393,10518619,9170890,9171044,9171045,9171046,9171165,9179198,9179199,9179200,9179201,9171250,8918096,8918196,8918197,10417553,10417560,10418814,10418815,10416005,10416006,10417092,10417105,10418158,10417182,9177272,9177273,9177274,8864996,8864998,4971390,4971391,8865109,8865126,8865155,8865156,8865157,8865160,8865161,9190843,9190858,9190860,9190909,6666968,6667204,4972132,4972133,9175395,9191748,9191924,9191953,6668153,8917840,10159605,10174814,10175410,10155579,10155580,10170598,10166290,10166291,10163798,10168811,10168812,10168813,10168814,10168815,10168816,10168817,10168818,10168819,10168820,10168821,10168822,10168823,10168824,10173885,10161902,10177333,10162434,10177715,10177716,10177736,10631418,10163065,10631757,10631758,10631776,10631777,10631778,10631779,10631786,10631787,10568535,10568536,10568537,10568538,10568539,10568540,10568541,10568542,10568543,10568544,10568545,10568546,10568547,10568548,10586634,10586635,10586636,10586648,10586662,10586663,10586664,10586665,10586666,10586667,10586707,10586708,10586709,10586710,10586727,10586728,10586729,10586741,10571757,10586766,10586767,10586768,10586769,10586771,10586774,10586775,10586776,10586786,10586804,10586805,10586811,10586812,10586813,10586814,10586815,10586834,10586851,10586883,10586884,10586885,10586886,10586887,10586891,10586942,10586943,10586944,10586945,10586946,10586947,10586948,10586949,10586953,10586954,10586955,10586967,10586985,10587006,10587050,10587051,10587052,10587055,10587056,10587057,10587058,10587069,10587070,10587079,10587080,10587081,10587082,10587083,10587084,10587085,10587086,10587087,10587099,10587102,10587103,10587104,10584608,10584609,10584610,10584611,10584612,10584613,10584614,10584733,10584742,10584743,10584746,10584747,10584783,10584784,10584785,10584786,10584787,10584788,10584789,10584790,10575799,10584803,10584804,10584805,10584806,10584807,10584838,10584844,10584845,10584846,10584865,10584871,10584918,10584919,10584958,10584959,10584999,10585023,10585024,10585025,10585026,10585027,10585028,10585044,10585045,10585066,10585067,10585085,10585086,10585097,10585098,10585158,10585159,10585164,10585165,10585166,10585167,10585168,10585169,10585192,10585193,10582197,10585222,10585223,10585228,10585229,10585230,10585231,10585232,10585243,10585244,10585250,10585257,10585258,10585259,10585260,10585261,10585262,10585263,10585282,10585283,10585284,10585355,10585356,10585357,10585358,10585359,10585360,10585361,10585362,10585363,10585364,10585365,10585366,10585367,10585368,10585369,10585370,10585371,10585390,10585392,10585393,10585394,10585395,10585396,10585398,10585402,10585407,10585419,10585432,10585435,10585436,10585437,10585438,10585439,10585440,10585441,10585442,10585444,10585446,10585447,10585450,10585451,10585453,10585454,10585467,10585468,10585474,10585501,10585502,10585503,10585504,10585505,10585506,10585507,10573529,10573530,10573531,10573532,10573533,10585890,10585893,10523133,10523134,10523135,10523136,10523137,10523138,10523139,10521347,10521348,10521349,10521350,10528104,10528155,10424591,10422596,10422597,10424597,10421932,10421107,10480998,10477399,10477400,10479611,10479612,10479636,10479637,10479638,10479639,10479640,10479641,10479642,10479643,10479644,10479645,10479646,10479647,10479648,10479649,10479650,10479651,10479652,10479653,10481880,10479995,10480001,10480002,10480003,10480004,10480005) 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'