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(8068833,10988635,8068853,11001671,10988672,10988673,10988674,10988675,10988676,8068883,11001689,11001707,11001711,10962748,10962754,10962779,10962785,11001799,10939821,10939833,11001944,11001945,11001946,4970485,4970486,7076310,7068311,11002001,7076323,7076324,11002020,7076337,11002022,7068340,11002037,11002047,11002055,7068415,11002117,8569446,11002172,11002236,7068554,11002243,10963270,11015284,11002310,4970890,7068690,4970925,4970928,10963407,4970966,10963514,11002515,11002516,11002518,11002523,11002524,10989568,10989622,11002675,7073992,11002681,4968216,7066015,10989718,7074046,11002736,11002743,11002756,11002760,7074105,11002790,10933462,11002807,8067107,8067108,11002819,11002832,11002845,10989897,10989901,10989905,7066235,11002980,4968535,11003093,10990115,11003129,10437299,11003162,11003163,10990218,11003268,7066655,10437537,10990371,10990409,11003423,11003444,10964461,10964482,11003485,11003492,7074825,7066837,7074839,11003523,10437693,7074841,7066848,7074862,10990570,10990571,11003589,11003590,11003593,10437773,11003616,11003617,4969175,11000669,11000671,10987683,11000693,7067042,11013735,11013744,11000750,11000754,11000798,11000801,11000804,11000806,11000886,10987933,10987957,10988019,10988036,11014053,10988053,11001062,7067435,4969662,10975196,4969797,11001270,11001271,11001344,11014380,7067701,11014406,11001410,11014430,11014472,11001508,11001509,11001521,11001523,11001555,11001578,11001586,8068815,11001610,10998620,11011677,10998824,7072200,10959899,10959900,10959901,10959902,10959903,10959904,10959905,10959906,10959907,10931594,10931597,7072327,7072328,7072330,7072377,7072402,7072404,11012096,11012097,10999098,10999099,11012100,10999100,10999168,10931840,10999179,7072521,7072523,7064537,10999248,10999250,7072568,10999264,10999265,10960301,7072670,10999356,10999360,7072676,10986367,10999387,10986390,7072711,7072721,7072722,7072738,7072747,7072751,7072766,7072780,7072819,7072848,10932208,7072863,7072909,7072963,10999651,7072989,10986707,10986709,7073026,11012741,7073060,7065063,10999755,7073105,7073109,10960970,10960975,10960979,10960982,7065347,7065497,7065557,10974314,11000451,7065806,11000552,11000575,10933239,11000577,7070961,11010652,10984660,7070980,7070982,11010706,7071135,10942929,7071352,7071370,10985139,10959252,7071618,7071624,7071628,7071635,7071641,7071664,7071680,7071771,7071786,7071795,8970212,10998618,7068946,7068954,3655561,10995703,10940679,7069173,7069174,7069186,10983027,3655928,7069514,10941228,7069743,8072643,8072644,8072645,8072646,8072647,10941547,8072658,10941548,8072659,10941549,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072698,8072699,8072700,8072701,8072702,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,3656586,8072753,8072754,8072755,8072756,8072757,8072758,8072759,8072760,8072761,8072762,8072763,8072764,8072765,8072766,8072767,8072778,8072779,8072780,8072781,8072782,8072783,8072784,8072785,8072786,8072787,8072788,8072789,8072790,8072791,8072792,3656642,8072961,8072962,8072963,8072964,8072965,10996951,10996964,10996984,3656884,10997000,7070324,7070325,10997326,10997331,10997364,10997384,7070720,10997422,10942369,10942383,10942389,10997495,7070870,11010559,7070877,11010587,11010588,10993654,10993655,10928520,10928589,10928594,11006762,10993803,10967834,10967835,10623191,10993852,10993853,10993880,10928740,10993913,10993917,10618362,10618502,10623508,10968184,10968185,10618529,10618531,10623545,10968237,10968238,10968279,10924274,10924278,10919301,11007585,11007586,10994587,11007674,10619051,11007750,11007905,10982084,10982090,10920000,10920004,10920024,10920046,10920047,10920081,10920084,10920097,10920116,10920123,10920124,10925173,11008358,10920213,10920214,10920217,10920220,10920235,10982390,10995434,10920290,10995442,10920307,10920312,10619894,10995564,10995574,10995575,10619936,10619950,10619958,10992640,10992641,10992642,10992651,10917510,10992662,10992666,10992669,10917526,10992704,10992709,10992716,10992719,10992721,10917575,10992730,10992734,10992740,10992741,10992758,10992761,10992764,10992769,10992775,10992785,10992790,10992797,10992809,10992811,10992826,10917678,10992829,10992830,10992836,10992837,10953881,10622301,10622339,10917914,10917915,10917916,10917917,10967092,10967099,10617456,10622482,10622492,10622493,10622494,10622495,10622504,10954188,11019215,10918072,11019233,10954313,10967322,10954453,10928307,10967479,10993586,10993589,10967595,10915474,10620005,11003670,10915528,10620026,10915541,8569991,10990699,11003725,8570018,10964752,10915624,11003773,10925629,10925630,11003783,11003788,11003792,11003803,11003834,8570130,11003856,10925709,10915710,11003862,11003881,11003884,10964902,10964907,11003922,11003938,11003953,11003955,11003956,10920811,11003993,11004005,11004011,11004013,11004018,10920900,11004051,11004061,10991080,10920936,10915988,10916043,10916064,10916080,10916126,10916130,10965344,10615758,10916269,10615759,10921298,10991460,10916314,10965494,10921352,10916367,10916406,10620918,10991587,10991633,10921486,10921488,10916497,10921497,10921507,10616007,10965733,10991827,10616183,10921721,10921730,10916733,10916759,10952912,10952913,10921770,10916776,11017940,11017941,11017942,10965944,10921809,10991962,10916843,10921844,10916889,10916890,10916891,10916892,10916893,10916894,10916895,10916896,10916897,10916898,10916899,10916900,10916901,10916902,10926905,10921911,10926929,10966143,10992145,10992146,10992148,10992152,10966181,10966190,10966207,10917065,10966301,11018303,11018304,10992347,10992353,10992356,10917230,11018404,11018405,10992405,11018406,11018407,11018408,11018409,11018410,11018411,11018412,10966430,10992443,10992483,10992507,10917367,10992556,10917427,10917454,10621957,10992615,8863933,10614143,10562315,9189659,9189660,9189667,9181745,10611515,6666006,10614767,9190186,9174195,9190205,9182269,7057489,10611995,10611996,10611997,10557302,7057681,7057682,10557363,7057766,10609303,7057810,10563476,9171698,10560522,9187725,9187738,9187757,8862350,8862351,8862352,9171850,10609537,8862677,9180224,9180326,10613233,9172583,10613263,9188622,10558614,10564653,9172916,7059111,10613675,10613676,10613677,9165061,7059236,9173118,9173119,9173120,10613935,10613936,10613937,10610952,9169343,9169367,10555268,9185640,4974545,10555508,10555515,4974588,10555556,9177790,7056079,9185958,10555776,10555781,9161975,10555801,10555808,10555809,9170018,9186022,9186031,7056197,4974889,9186112,4975002,9186297,9186311,9186321,9186323,9186346,9186361,10556181,9186385,9186387,9186388,9186442,9186461,9186464,9186465,9186467,9186470,9186477,9186478,9186490,9186491,9186492,9186497,9186503,7056933,10512621,10518676,10518678,10556688,10556708,10518807,7057222,9187092,9171095,8861651,10556964,7057376,10557026,9171228,9184316,10417273,10417274,10417275,10417276,9160409,10416436,10416441,10416442,10418696,10418702,7054980,9184890,9184974,9184975,9184976,9184977,9184978,9169020,10415943,9169021,9177114,9177115,10418040,9169172,7055369,4971238,10466991,10466992,10466993,4971338,8865020,10469100,9166551,8865079,10469137,10469138,6666651,6666652,10469266,6666724,9166756,9166757,9166758,9166759,9166760,9166761,10467674,10469692,8916821,9175377,9167452,9175482,9167544,8563476,8917262,8917359,8917497,8917693,10470726,10174495,10174511,10174530,10174535,10628050,10628059,10159589,10628078,10628083,10170173,10170186,10170745,10629660,10632158,10173691,10632186,10627437,10627462,10627484,10174015,10627592,10627641,10627647,10627654,10159192,10159197,10159210,10159216,10159223,10159235,10159250,10159254,10159256,10159259,10159267,10159276,10174402,10174403,10174408,10174416,10174428,10174478,10161637,10161801,10630314,10625516,10162440,10626026,10167627,10631111,10626166,10626167,10631168,10626175,10626176,10626267,10626612,10163200,10168207,10168208,10168209,10168210,10571170,10577187,10574202,10571232,10574304,10577327,10571432,10577439,10568481,10583557,10577745,10577777,10577947,10569068,10569092,10569096,10569097,10569105,10569134,10578152,10569154,10569210,10569211,10569212,10569213,10569232,10569257,10569259,10578412,10581607,10578642,10575786,10572866,10578977,10579101,10579102,10573325,10567463,10567464,10567465,10567466,10567467,10567468,10579546,10579559,10579565,10579577,10579720,10579721,10576845,10576903,10577104,10519138,10527354,10523550,10521788,10521793,10521852,10520259,10524259,10526786,10526927,10520927,10526928,10526929,10422662,10422806,10424016,10479191,10479193,10476477) 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'