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(10845932,10845933,3228622,3228623,3228624,3228625,3228626,10944071,10944072,10944073,10944074,10944075,10940459,10940460,11041460,11041461,11041462,8583348,7074051,7074052,7074053,7074054,7074055,7074056,9215738,8573080,8573081,10929183,8619768,8619769,8837682,8837683,8837684,8837685,8837686,10929513,10929514,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,10939196,10939197,10939198,10959554,10959555,8065191,8065192,8065193,8065194,8065195,8065196,8065197,8065198,8065199,8065200,8065201,8065202,8065203,8065204,8065205,8065206,8065207,8065507,8065508,8065509,8065510,8065511,8065512,8065513,10843459,10103940,7065462,7065463,7065464,8834619,8834620,8834621,8834622,8834623,10997830,10997831,10959225,10959226,10959227,10959228,10959229,10959230,4430342,4430343,4430344,4430345,4430346,4430347,4430348,4430349,7068959,7068960,8555941,8555942,8564313,8564314,8564315,8564526,8564527,8564528,8564529,8564530,8564531,8564532,10101142,10101143,8970129,8970130,8553792,8553793,3923247,3923248,3923249,8553885,8553886,8553887,11032840,11032841,11032842,11032843,11032844,11032845,11032846,11032847,11032848,11032849,11032850,11032851,11032852,11032853,11032854,8554680,8554874,8554876,8554879,8555003,8555159,10852709,10920530,10920531,10920532,10920533,10920534,10920535,10920536,10920537,10920538,10920539,10920540,10920541,10920542,10920543,10920544,10920545,10920546,10920547,10920548,10920549,10920550,10920551,10920552,10920553,10920554,10920555,10920556,10920557,10920558,10920559,10920560,10920561,10920562,10920563,10920564,10920565,10920566,10920567,10920568,10920569,10920570,10920571,10920572,10920573,10920574,10920575,10920576,10920577,10920578,10920579,10920580,10920581,10920582,10920583,10920584,10920585,10920586,10920587,10920588,10920589,10920590,10920591,10920592,10920593,10952252,8633278,10921656,8610925,8577664,8577665,9166219,9166220,9166221,9166222,9166223,9166224,9166225,9166226,9166227,8862152,8862153,8862154,8862155,3653045,3653046,3653047,3653048,8566389,10120405,10120406,10120407,10120408,10558143,7058690,7058691,7058692,7058693,7058694,7058695,7058696,7058697,7058698,7058699,7058700,7058701,7058702,7058703,7058704,7058705,7058706,7058707,7058708,7058709,7058710,7058711,7058712,7058713,7058714,7058715,7058716,7058717,7058718,7058719,7058720,7058721,7058722,7058723,7058724,7058725,7058726,7058727,7058728,7058729,7058730,7058731,7058732,7058733,7058734,7058735,7058736,7058737,7058738,8863307,10610958,2809241,8551922,8551923,8551924,9178885,9203129,9203130,9203131,9203132,9203133,9203134,9203135,9203136,9203137,9203138,9203139,9203140,9203141,9203142,9203143,9203144,9203145,9203146,9203147,9203148,9203149,9203150,9203151,9203152,9203153,9203154,9203155,9203156,9203157,9203158,9203159,10116826,10116827,9911275,9911276,10428482,10428483,10428484,10428485,10428486,10428487,10428488,10428489,9911410,9911411,9911412,9911413,8549817,8549818,3963156,3963157,3963158,4972036,4972037,976400,6672082,6672083,6672084,6672085,6672086,6672087,6672088,6672089,6672090,6672091,6672092,6672093,6672094,6672095,6672096,6672097,6672098,6672099,6672100,6672101,6672102,6672103,6672104,6672105,6672106,6672107,6672108,6672109,6672110,6672111,6672112,6672113,6672114,6672115,6672116,6672117,10466500,10427592,10427593,10159961,10159962,10159963,10159964,10159965,10159966,10159967,10159968,10159969,10159970,10160755,10160756,10160757,10160758,10160759,10160760,10160761,10160762,10160763,10160764,10160765,10160766,10160767,10160768,10160769,10947864,10947865,10947866,10947867,10947868,10947869,10947870,10947871,10947872,10947873,10947874,10947875,10947876,10629573,10629574,10629575,10629576,10629577,10629578,10629579,10880327,10880328,10880329,10880330,10880331,10880332,10880333,10880334,10880335,10880336,10880337,10880338,10880339,10880340,7000779,8593392,8593393,8593394,10948408,10948409,10948410,10948411,10948412,10948413,10948414,10948415,10948416,10948417,10948418,10948419,10880874,10880877,10880878,10880879,10880880,10880881,10880882,10880883,10880884,10880885,10880886,10880887,10880888,10880889,10880890,10880891,10880892,10880893,10880894,10880895,10880896,10880897,10880898,10880899,10880900,10897285,10608031,10608032,10608033,10608034,10608035,10608036,10608037,10608038,10608039,10646249,10608040,10646250,10608041,10646251,10608042,10646252,10608043,10646253,10608044,10646254,10608045,10608046,10608047,10608048,10608049,10608050,10608051,10608052,10608053,10608054,10608055,10608056,10608057,10646587,10646588,10646589,10646590,10646591,10646592,10646593,10646594,10653121,10650278,10599335,10650660,10650661,10650662,10576120,10576121,10576122,10576123,10576124,10576125,10576126,10576127,10576128,10576129,10576130,10576131,10576132,10576133,10576134,10576135,10576136,10576137,10576138,10576139,10576140,10576141,10576142,10576143,10576144,10576145,10576146,10576147,10576148,10576149,10576150,10576151,10576152,10576153,10576154,10576155,10576156,10576157,10576158,10576159,10576160,10576161,10576162,10576163,10576164,10576165,10576166,10576167,10576168,10576169,10576170,10576171,10576172,10576173,10576174,10576175,10576176,10576177,10576178,10576179,10576180,10576181,10576182,10576183,10576184,10576185,10576186,10576187,10576188,10576189,10576190,10576191,10576192,10576193,10576194,10576195,10576196,10576197,10576198,10576199,10576200,10576201,10576202,10576203,10576204,10576205,10576206,10576207,10576208,10576209,10576210,10576211,10576212,10576213,10576214,10576215,10576216,10576217,10576218,10576219,10576220,10576221,10576222,10576223,10576224,10576225,10576226,10576227,10607661,10607662,10607663,10607664,10607665,10607666,10607667,10607668,10607669,10607670,10714738,10714739,10714907) 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'