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(8574624,8574625,8574626,8574627,8574628,8574629,8574630,8574631,8574632,8574633,8574634,8574635,8574636,8574637,8574638,8574639,8574640,8574641,8574642,8574643,8574644,8574645,8574646,8574647,8574648,8574649,8574650,8574651,8574652,8574653,8574654,8574655,8574656,8574657,8574658,8574659,8574660,8574661,8574662,8574663,8574664,8574665,8574666,8574667,8574668,8574669,8574670,8574671,8574672,8574673,8574674,8574675,8574676,8574677,8574678,8574679,8574680,8574681,8574682,8574683,8574684,8574685,8574686,8574687,8574688,8574689,8574690,8574691,8574692,8574693,8574694,8574695,8574696,8574697,8574698,8574699,11041289,10963434,10940529,10940530,7067239,7067285,10845327,10845341,10845484,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068635,8068636,8068637,8068638,8068639,8068640,8068641,8068642,8068643,8068644,8068645,8068646,8068647,8068648,8068649,8068650,8068651,8068652,8068653,8068654,8068655,8068656,8068657,8068658,8068659,8068660,8068661,8068662,8068663,8068664,8068665,8068666,8068667,8068668,8068669,8068670,8068671,8068672,8068673,8068674,8068675,8068676,8068677,8068678,8068679,10447677,8620694,8835572,8835573,8835574,8835575,10103794,10103795,8618699,8065986,10843923,10932681,10932690,10932733,10932834,10844350,7073639,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066636,8066637,8066638,8066639,8066640,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066654,8066655,8066656,8066657,8066658,8066659,8066660,8066661,8066662,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8066670,8066671,8066672,8066673,8066674,8066675,8066676,8066677,8066678,8066679,8066680,8066681,8066682,8066683,8066684,8066685,8066686,8066687,8066688,8066689,8066690,8066691,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066701,8066702,4967941,8066703,8066704,8066705,8066706,8066707,8066708,8066709,8066710,8066711,8066712,8066713,8066714,8066715,8066716,8066717,8066718,8066719,8066720,8066721,8066722,8066723,8066724,8066725,8066726,8066727,8066728,8066729,8066730,8066731,8066732,8066733,8066734,8066735,8066736,8066737,8066738,8066739,8066740,8066741,8066742,8066743,8066744,8066745,8066746,8066747,8066748,8066749,8066750,8066751,8066752,8066753,8066754,11010843,11010844,11010845,11010846,10102419,10102420,10102421,11037022,11037159,8910805,8910834,8910835,10103043,8908042,7069035,8072683,8072684,8072685,8072686,8072687,8564814,8564815,8564816,8564817,8564818,8564819,8616042,8565118,11010235,11010236,11010237,10841335,10841580,10841581,10841582,10841583,10841584,10841585,10841586,4936905,8613842,8613843,10619041,8071125,4938387,4938388,4938389,4938390,4938391,10927805,10837046,10967015,10967016,10967017,10967018,8576397,10930760,10930761,10930762,10930900,10930901,10621115,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621454,10621455,10621456,10621457,10621458,10621459,10621460,10621461,10621462,10621463,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621476,10621477,10621478,10621479,10621480,10621481,10621482,10621483,10621484,10621485,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10426927,10426928,10426929,10426930,10426931,10426932,10426933,10426934,10426935,10426936,10426937,10426938,10426939,10426940,10426941,10621716,9205313,10611763,9179371,9179372,9179373,9179374,9179375,9179376,9179377,9179378,9179379,9179380,9179381,9179382,9179383,9179384,9179385,9179386,9179387,9179388,9179389,9179390,9179391,9179392,9179393,9179394,9179395,9179396,9179397,9179398,9179399,9179400,9179401,9179402,9179403,9179404,9179405,9179406,9179407,9179408,9179409,9179410,9179411,9179412,9179413,9179414,9179415,9179416,9179417,9179418,9179419,9179420,9179421,9179422,9179423,9179424,9179425,9179426,9179427,9179428,9179429,9179430,9179431,9179432,9179433,9179434,9179435,9179436,9179437,9179438,9179439,9179440,7057832,7057833,7057834,7057835,7057836,9188597,10564634,10564635,10564655,10564774,10564775,10564826,10564827,8863623,8863624,9205208,9193341,9193342,9193343,9169373,9210122,7056689,7056690,7056691,7056692,7056693,7056694,7056695,7056696,7056697,7056698,7056699,7056700,7056701,7056702,7056703,7056704,7056705,7056706,7056707,7056708,7056709,7056710,7056711,7056712,7056713,7056714,7056715,7056716,7056717,7056718,7056719,7056720,7056721,7056722,7056723,7056724,7056725,7056726,7056727,7056728,7056729,7056730,7056731,7056732,7056733,7056734,7056735,7056736,7056737,7056738,7056739,7056740,7056741,7056742,7056743,7056744,7056745,7056746,7056747,7056748,7056749,7056750,10518996,10518997,10518998,10518999,10415296,10415297,10415623,10415626,10415872,10416135,10416164,9161245,9161246,10469590,10469605,9199131,8550529,8550530,8550531,8550532,8550533,4972245,4972246,4972247,4972248,4972249,4972250,4972251,4972252,4972253,4972254,10469984,10469985,8917203,8917204,8917205,8917206,8917207,8917208,8917209,8917210,8917211,8593956,8593957,8593958,8593959,8593960,8593961,8593962,8593963,8593964,8593965,8593966,8593967,8593968,8593969,8593970,8593971,8593972,8593973,8593974,8593975,8593976,8593977,8593978,8593979,8593980,8593981,8593982,8593983,8593984,8593985,8593986,8593987,8593988,8593989,8593990,8593991,8593992,8593993,8593994,8593995,8593996,8593997,8593998,8593999,8594000,8594001,8594002,8594003,8594004,8594005,8594006,8069039,8069040,8069137,8069231,10169040,10169041,10169042,10169043,10169044,10169045,10169046,10169047,10169048,10169049,10169050,10169051,10169052,10169053,10169054,10169055,10169056,10169057,10169058,10169059,10169060,10169061,10169062,10169063,10169064,10169065,10169066,10169067,10169068,10169069,10169070,10169071,10169072,10169073,10169074,10169075,10169076,10169077,10169078,10169079,10169080,10169081,10169082,10169083,10169084,10169085,10169086,10169087,10169088,10169089,10169090,10169091,10169092,10169093,10169094,10169095,10169096,10169097,10169098,10169099,10169100,10169101,10169102,10169103,10169104,10169105,10169106,10169107,10169108,10169109,10169110,10169111,10169112,10169113,10169114,10169115,10169116,10169117,10169118,10169119,10169120,10169121,10169122,10169123,10169124,10169125,10169126,10169127,10169128,10169129,10169130,10169131,10169132,10169133,10169134,10169135,10169136,10169137,10169138,10169139,10169140,10169141,10169142,10169143,10169144,10169145,10169146,10169147,10169148,10169149,10169150,10169151,10169152,10169153,10169154,10169155,10169156,10169157,10169158,10169159,10169160,10169161,10169162,10169163,10169164,10169165,10169166,10169167,10169168,10169169,10169170,10169171,10169172,10169173,10169174,10169175,10169176,10169177,10169178,10169179,10169180,10169181,10169182,10169183,10169184,10169185,10169186,10169187,10169188,10169189,10169190,10169191,10169192,10169193,10169194,10169195,10169196,10169197,10169198,10169199,10169200,10169201,10169202,10169203,10169204,10169205,10169206,10169207,10169208,10169209,10169210,10169211,10169212,10169213,10169214,10169215,10169216,10169217,10169218,10169219,10169220,10169221,10169222,10169223,10169224,10169225,10169226,10169227,10169228,10169229,10169230,10169231,10169232,10169233,10169234,10169235,10169236,10169237,10169238,10169239,10169240,10169241,10169242,10169243,10169244,10169245,10169246,10169247,10169248,10169249,10169250,10169251,10169252,10169253,10169254,10169255,10169256,10169257,10169258,10169259,10169260,10169261,10169262,10169263,10169264,10169265,10169266,10169267,10169268,10174269,10169269,10174270,10169270,10169271,10169272,10169273,10169274,10169275,10169276,10169277,10169278,10169279,10169280,10169281,10169282,10169283,10169284,10169285,10169286,10169287,10169288,10169289,10169290,10169291,10169292,10169293,10169294,10169295,10169296,10169297,10169298,10169299,10169300,10169301,10169302,10169303,10169304,10169305,10169306,10169307,10169308,10169309,10169310,10169311,10169312,10169313,10169314,10169315,10169316,10169317,10169318,10169319,10169320,10169321,10169322,10169323,10169324,10169325,10169326,10169327,10169328,10630189,10590005,10590006,10590043,10566372,10566373,10566374,10566375,10566376,10566377,10566378,10566379,10519167,10519168,10519169,10519170,10519171,10519172,10519173,10519174,10520147,10423392,10424573,10421128,10473335,10473336,10473352,10473411,10473412,10473449,10473450,10473451,10473518,10473519,10473520,10473521,10473913,10473914,10473915,10474008,10487158,10476568,10476837) 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'