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(10845809,10845810,10845811,10845812,7076250,10848684,10848685,10848686,10873733,3228942,8631275,8631278,8631279,8631280,8631281,8631282,8631283,8631284,8631285,10950751,8622051,9215875,10976969,10976970,8067423,7066692,10872376,10872377,10872410,10860715,7075673,7075674,10845612,7067875,7067876,7067884,11011898,10103436,8559313,8559314,8559315,8559316,10986306,10986307,10986308,10986309,10986310,10986311,10986312,10986313,10986314,10986315,10986316,10986317,10986318,10986319,10986320,10986321,10986322,3899183,3899468,10843730,8618963,8618964,10104420,7202654,8836970,8837017,7073618,10104850,10860030,7073830,7073831,7073832,7073833,8573024,3227267,7073872,7073875,4430417,4430426,4430427,4430456,4430475,4430482,4430484,4430487,4430492,10866210,3656103,3656104,3656105,3656106,3656107,11009412,10996564,8565001,10958205,10958209,3926926,3926927,3926928,8073483,8073484,10857048,11010473,11010474,11010475,10853269,10853270,10853272,10853273,11032957,11032958,11032959,11032960,11032961,11032962,11032963,11032964,11032965,11032966,11032967,11032968,11032969,11032970,11032971,11032972,11046016,11046017,11046018,11033133,11033134,11033135,11033136,11033137,11033138,11033139,10623481,11033140,11033141,7156998,7156999,7157000,7157001,11033319,11033320,11033321,11033322,11033323,11033324,11033325,11033326,8070886,11008048,11047518,8541923,8579078,8579079,8579080,8569930,10614991,8570258,8570259,10850686,3231075,3582193,10615984,10616050,8577682,8577730,10852013,10852014,10852015,10616790,9165376,9189470,10559318,10559319,10559471,10559472,10559473,10559474,10559475,10562671,10562672,10562673,10562674,10562675,9197866,9197867,9197868,9197869,9214144,9195957,9195961,9212117,9188236,9204761,9204762,9196799,9161769,9210003,10512149,9913288,9913291,9913292,9160374,10419319,10427787,10116712,8918180,4973405,9910865,9910866,9911164,9198913,9183335,10123541,6473735,9199595,6671802,9199596,8563593,8563594,9199726,9175759,10124006,9175977,8917701,8917702,9168152,10908622,10884214,10628844,10629210,10629211,10629212,10629213,10629214,10629215,10629216,10629217,10629330,10629331,10629332,10879904,10170916,10900342,10900343,10900344,10900345,10900346,10900347,10900348,10893371,10905902,10176971,10176972,10176973,10176974,10176975,10187693,10911810,10949856,10626906,10650402,10650403,10650404,10650405,10650406,10650407,10525367,10525368,10525369,10527849,10526114,10526115,10526116,10526117,10526118,10526119,10526120,10526121,10526122,10526123,10526124,10526125,10526126,10526127,10526128,10526129,10526130,10526131,10526132,10526133,10526134,10526135,10526136,10526137,10544137,10526138,10544138,10526139,10544139,10526140,10544140,10526141,10544141,10526142,10544142,10526143,10544143,10526144,10544144,10526145,10544145,10544146,10526146,10544147,10526147,10544148,10526148,10544149,10526149,10544150,10526150,10544151,10526151,10544152,10526152,10544153,10526153,10544154,10526154,10544155,10526155,10544156,10526156,10544157,10526157,10544158,10526158,10544159,10526159,10544160,10526160,10544161,10526161,10526162,10526163,10526164,10526165,10526166,10526167,10526168,10526169,10526170,10526171,10526172,10526173,10526174,10526175,10526176,10526177,10526178,10526179,10526180,10526181,10526182,10526183,10526184,10526185,10526186,10526187,10526188,10526189,10526190,10526191,10526192,10526193,10526194,10526195,10526196,10526197,10526198,10526199,10526200,10526201,10526202,10526203,10526204,10526205,10526206,10526207,10526208,10526209,10526210,10526211,10526212,10526213,10526214,10526215,10526216,10526217,10526218,10526219,10526220,10526221,10526222,10526223,10526224,10526225,10526226,10526227,10526228,10526229,10526230,10526231,10526232,10526233,10526234,10526235,10526236,10526237,10526238,10526239,10526240,10526241,10526242,10526243,10526244,10526245,10526246,10526247,10526248,10526249,10526250,10526251,10526252,10526253,10526254,10526255,10526256,10526257,10526258,10526259,10526260,10526261,10526262,10526263,10526264,10526265,10526266,10526267,10526268,10526269,10526270,10526271,10526272,10526273,10526274,10526275,10526276,10526277,10526278,10526279,10526280,10526281,10526282,10526283,10526284,10526285,10526286,10526287,10526288,10526289,10526290,10526291,10424373,10423513,10423514,10423545,10409454,10409455,10409457,10409458,10409459,10409460,10479134,10411903,10414424,10408682,10408683,10408684,10414949,10406950,10406951,10406952) 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'