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(10845708,8838515,10943677,8630946,10873852,8621402,10873975,10950314,8631800,10849753,8067551,10990289,10990290,10990291,10990292,10990293,10990326,10990327,10990328,10990329,3230068,10951368,10961621,11013734,11013735,11013736,11013737,11013738,11013739,11013742,11013743,10860581,3227713,3227715,10872752,8630115,8630116,8573774,8573853,8838197,10930107,10842701,10842874,10842875,8559494,8559495,8559497,8559501,8559502,8559503,8559505,8559506,8559507,8559508,8559509,8559510,8559511,11012254,8559578,8559597,8559616,10986431,8559724,8559726,8559727,8559728,8559739,10859118,10859119,8559844,8628591,8628603,8559915,10859303,8559962,10859304,8559969,8559979,8559980,8559981,8559982,8559986,8559990,3912098,3912099,3912100,3912118,8595921,10104504,10932944,7073793,10961609,10961610,10961611,7200190,10942686,11036831,11036841,11036862,11036936,11036941,10997941,10997944,10942970,11037147,8064488,8835047,8910678,10858035,10858036,8627473,8835356,8835360,7071906,8835415,7198200,8563738,8614908,8563850,8563857,10940808,8908334,10944714,10957164,3656064,3656094,10840295,10941293,3926254,10864209,8564822,8616211,3236797,10101585,8557457,8557458,11023266,10997423,11049645,8909882,8909909,8909911,8834349,8834350,3237280,10841615,10954815,10954818,10954819,10954825,10954826,10954827,10954828,10954830,8554509,8554510,8554511,8554512,8554513,3233986,8554516,8554517,8554518,8554519,8554520,8554521,8554522,8554523,8554524,3923974,3234010,8554887,10994814,10994815,10994816,10994817,3234601,10624534,10624535,10920151,10839429,3235291,3235292,3235293,10616987,10917500,10917502,8552925,11005693,11005701,8553004,3232511,8611933,10836889,10836890,11018855,8578533,8635023,11006077,3922829,10622627,11032450,8579098,11016690,11016691,11016692,10850463,3230677,10915803,10915804,10615295,8570245,10915805,10915806,10915807,8570248,10915808,11016957,10915809,10915810,10915811,10915812,10915813,10915814,10915815,10915816,10915817,10915818,10915819,10915820,10915821,10915822,10915823,8570295,3230823,10850725,3581862,3581870,11004505,11004506,3582212,11004525,11004526,10851154,11043640,11043641,9217643,9217644,10930949,9217653,7154570,7154572,3231559,8633978,10921879,10921880,8540869,10616470,8904578,10917149,8577891,8577893,8577903,8577904,8577984,8577989,8552823,7155449,6677628,9205453,9915801,9915802,9915846,10611399,10611433,8853596,8853597,10559727,10611625,10611677,9916295,9174215,3962605,3962606,9171339,9171340,9187981,7058583,9196534,8852386,10120842,8852544,7018600,7026743,9915368,9915381,10610960,10513142,10513143,9185352,8849368,9161549,9201586,8849741,8849742,8849743,8849744,8849745,8849746,8849747,9912174,9194214,9210301,9210302,9210303,8551661,8551662,9186545,7024284,10516695,10516696,10516697,10119332,9179162,9171226,9200300,9200301,9200303,9200304,9200307,9200308,9200309,9200310,9200311,9200312,9200313,9200315,9200321,9200322,9200323,9200324,6680761,7054892,9910933,9910939,9200817,10428272,10428273,10428274,9161017,4974031,9201258,4971167,8549500,8549516,6678580,6678581,8549540,8549589,8549590,3962764,6670689,9206502,9916751,9916752,10122894,9916951,10123008,10467572,10123262,8550365,6679435,6679436,8550506,8855259,9199531,976432,8550892,6474080,8550940,10464390,10124101,10124102,10124104,10124105,10124106,10124109,10124110,10124111,6474215,10124112,10124114,10124116,10124117,10124118,10124120,10124121,10124122,9192006,9192007,9208043,10464643,10464645,10464646,10427496,9176132,9176133,10468827,9200298,10946624,10946625,10946629,10946630,10946635,10159882,10179979,10884082,10884210,10889324,10889364,10889365,10884606,10889617,10629128,10629130,10629131,10170774,10170775,10909858,10904887,10904888,10904902,10904903,10155943,10155944,10155945,10155950,10155951,10155952,10155953,10155954,10155955,10155956,10155958,10155959,10155962,10155965,10155966,10155967,10155968,10155969,10155970,10155973,10155974,10155977,10155978,10155979,10155980,10155981,10155985,10629506,10629507,10629508,10629509,10629510,10629512,10885140,10156164,10910357,10885387,10877831,10877832,10877833,10888009,8593285,10184293,10913335,10913336,10913337,10913339,10913340,8593450,10630101,10890817,10176851,10176852,10176853,10176854,10176855,10162269,10891398,10891399,10626119,10876801,10178021,10178022,10178123,10158196,10950059,10912298,10912299,10912300,10912306,10912307,10912337,10605101,10605103,10605104,10605113,10605117,10605130,10605137,10598574,10652792,10652793,10652794,10650135,10650139,10572547,10572554,10587576,10644701,10644702,10644703,10644704,10644705,10644706,10644708,10644709,10644711,10644712,10644713,10644714,10644715,10644716,10647717,10644717,10644720,10644721,10644724,10644727,10644729,10644730,10644731,10644733,10644736,10644739,10644740,10650841,10650844,10650845,10644948,10584999,10570073,10570074,10570075,10570076,10570077,10570078,10570079,10570080,10570081,10570082,10570083,10570084,10570085,10570086,10570087,10570088,10570089,10570090,10570091,10570092,10570093,10570094,10570095,10570096,10570097,10570098,10570099,10570100,10570101,10570102,10570103,10570104,10570105,10570106,10570107,10570108,10570109,10570110,10570114,10570115,10570122,10570127,10570128,10570130,10570131,10570132,10570133,10570134,10570135,10570136,10570137,10570138,10570139,10570140,10570141,10570142,10570143,10570144,10570146,10570147,10570148,10570149,10570150,10570151,10570171,10570172,10570173,10570174,10570176,10570178,10570179,10570180,10570181,10570182,10570183,10570184,10570187,10570188,10570189,10570196,10570199,10570200,10570201,10570202,10570203,10570204,10570205,10570206,10570207,10570211,10570213,10570214,10570215,10570216,10570224,10570225,10570226,10570232,10570238,10570239,10570240,10570241,10570242,10570243,10570244,10570245,10645305,10570246,10570247,10645307,10570248,10570249,10570250,10570251,10570252,10570253,10570254,10570255,10570256,10570257,10570258,10570259,10570260,10570261,10570262,10570263,10570264,10570265,10570266,10570267,10570268,10570269,10570270,10570271,10570272,10570273,10570274,10570275,10570276,10570277,10570278,10570279,10570280,10570281,10570282,10570283,10570284,10570285,10570286,10570287,10570288,10570292,10570298,10570299,10570300,10570301,10570308,10570311,10570312,10570317,10570318,10570323,10570324,10570325,10570326,10570327,10570328,10570329,10570345,10570353,10570354,10570358,10570359,10570360,10570365,10570370,10570371,10570372,10570373,10570377,10570379,10570380,10570391,10570392,10570410,10570575,10570576,10570577,10570578,10570579,10570580,10570581,10570582,10573740,10573741,10573748,10573750,10573751,10573752,10573753,10573754,10573755,10573756,10573757,10607673,10529327,10529328,10529329,10529330,10529331,10529332,10529333,10519341,10519344,10519350,10519351,10519352,10519353,10519354,10519357,10519358,10519359,10519360,10519361,10519362,10519368,10519373,10519374,10541476,10529478,10525519,10525520,10525523,10547744,10527825,10527875,10527876,10527877,10551920,10551921,10545968,10545969,10545970,10545971,10545972,10545973,10545974,10545975,10545976,10545977,10545978,10545979,10545980,10545981,10545982,10545983,10545984,10545985,10545986,10545987,10545988,10545989,10545990,10545991,10545992,10546084,10546182,10546183,10546184,10538987,10538988,10498288,10498289,10498290,10505355,10424479,10423690,10498651,10498653,10498658,10498659,10498660,10407288,10496104,10409461,10413617,10413618,10409636,10409637,10494502,10494505,10494507,10494508,10407979,10412054,10473738,10473744,10473844,10487114,10482317,10482318,10480374,10480375,10480376,10480377) 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'