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(8574232,8574233,11040776,11040777,11040778,11040779,11040780,10930403,7068164,7068165,10448082,10448083,10448086,10448087,8630946,7076302,9214966,9214967,9214968,10940097,10846346,10846347,10846348,10846349,10846350,10846351,10846352,10846353,10846354,10846355,10846356,10846357,10846358,10846359,8621516,8621517,8621518,8583172,8583173,11041584,11041585,10933289,10950875,8622095,8067251,8622171,7066345,10847103,3229976,8067740,10850098,8609661,10850144,10850145,10850146,8576052,8560881,8067858,7066996,10938652,3227518,3227519,3227520,3227521,10844865,10929484,7075279,8629968,8629969,8630002,8630003,8630006,8630007,8620511,8620512,8620513,8620514,8620515,8620516,8620517,8620518,8620519,8620520,8620521,8620522,8620524,11040377,11040378,8618094,8618095,8618101,8618102,8618103,8618104,7064276,7064277,7064278,7064279,7064280,7064281,7064282,10103492,10103493,10103497,7072721,7072722,7072723,10986546,10986547,10986548,10986549,10986550,10986551,10986552,10986553,10986554,10986555,10999570,10986588,10986589,10843723,10932357,8572188,10932358,10932359,8572189,8572190,8572191,8836810,8560310,8560311,8560312,8560313,4967739,4967740,4967741,4967742,4967743,4967744,4967745,4967746,4967747,4967748,10974217,4967749,4967750,4967751,4967752,4967753,4967754,4967755,10928848,10928849,10933219,3927507,3927508,3927509,3927510,10942926,11049393,11049394,11049395,8064477,8064478,8064479,8064480,8064481,8064482,10943141,8558498,8558499,8558500,8558507,3238180,3925450,8624707,3925454,3925460,3925465,3925468,3925472,3925473,3925474,3925478,3655683,3655684,8563883,8563884,8563885,7069333,8908412,11047616,11047617,11047618,11047619,3926151,3236254,8615693,8564771,3656658,3656659,3656660,10996792,10996793,8557218,3236691,3236692,3236693,3236694,3236695,3236696,3236697,3236698,3236699,3236700,3236701,3236702,3236703,3236704,3236705,3236706,3236707,8564998,3236708,3236709,3236710,3236711,3236712,3236713,3236714,3236715,3236716,3236717,3236718,3236719,3236720,3236721,3236722,3236723,3236724,3236725,3236726,10984344,10984345,10984346,10984347,10984348,10984349,10984350,10984351,10984352,10984353,8834197,8834198,8834199,8834200,8834201,8834202,8834203,8834204,8834205,8834206,10101896,10102045,8612867,3233887,10623508,11007246,8554823,8613820,8614103,8614104,8614105,8614106,8614107,8614108,8614109,8614110,8614111,8614112,8614113,8614114,8614115,8614116,8614117,8614118,8614143,11008329,11008330,11008331,11008332,11008333,11008334,11008335,11008336,11008337,8555599,11008338,11008339,11008340,11008341,11008342,11008343,11008344,11008345,11008346,11008347,11008348,11008349,10966873,8612204,8612208,8541947,11006563,11006564,11006565,11006566,8579059,11006567,11006568,11006569,11006570,10925592,10925593,8570037,10425499,10925727,10951874,10951875,10951877,10920926,3230813,10615454,10615455,10952060,10620652,10926175,10926176,10926177,10926178,7154504,8904416,10953319,10953320,10953321,10953322,10953323,10953324,10953325,10953326,10953327,10953328,10953329,10953330,8541320,8552760,8552761,8552762,8552763,8552764,9189303,9189314,9189462,9213658,8864200,9181724,9181725,9181726,9189727,9181727,9189728,9181728,9181729,9181730,9181731,9181732,9181733,6665759,8568344,8568345,9213862,9213864,9213875,9213880,9213949,9174018,9174019,9174020,9166113,9166115,9166116,10559980,10559981,10559982,10559983,10559984,10559985,10559986,10559987,10559988,10559989,10559990,10559991,3962495,10559992,3962496,10559993,10559994,10559995,10559996,10559997,10559998,10559999,10560000,10560001,10560002,10560003,10560004,10560005,10560006,10560007,10560008,10560009,10560010,10560011,10560012,10560013,10560014,10560015,10560016,10560017,10560018,10560019,10560020,10560021,10560022,10560023,10560024,10560025,10560026,10560027,10560028,10560029,10560030,10560031,10560032,10560033,6670450,6670451,6670452,6670453,6670454,6670455,6670456,6670457,6666295,9187408,10120031,9172383,9172391,9220392,9220393,10120765,8863237,9204988,9204989,9204990,9204991,9204992,9204993,9204994,9204995,9204996,9197166,9197167,9197168,9197169,9197170,9197171,9189180,6673711,9193575,9185652,7023308,7023309,9185693,9912147,8849798,7056158,8849842,8849843,8849878,10118328,4975010,4975011,9186192,9170199,9170200,9170201,9170202,8551502,8551503,8551504,8551505,8551506,8551507,8551508,8551509,8551510,8551511,8551512,9186213,8551513,9186214,8551514,8551515,8551516,9186284,9186286,9186293,3285986,3285987,3285988,7056580,7056581,7056582,7056583,7024248,7024249,7024250,7024251,7024252,7024253,7024254,7024255,7024256,7024257,7024258,7024259,7024260,7024261,7024262,7024263,7024264,7024265,7024266,7024267,7024268,7024269,7024270,7024271,7024272,7024273,7024275,7024276,7024277,7024278,7024279,7024280,7024292,7024293,7024294,7024295,7024296,7024297,7024298,7024299,7024300,7024305,7024306,7024307,7024308,7024309,7024310,7024311,7024312,7024313,7024314,7024315,7024316,7024317,7024318,7024319,7024320,7024321,7024322,7024323,7024324,8565684,8565685,8565686,8565687,8861769,8861770,8861771,8861772,10519064,9187294,9910760,9910761,9161056,9161057,9161058,9161059,9161060,9161061,10125280,9177134,6681386,10125448,10125449,10125450,10125451,8864915,8864916,8864917,8864918,8864919,8864920,8864921,8864922,10463184,10463185,10463186,10463187,10463188,10463189,10463190,10463191,10463192,10463193,10463194,10463195,10463196,10463197,10463198,10463199,10463200,6666624,6666625,9206792,9206793,6679049,6666875,6666999,6667149,6667153,6667154,9175248,9175265,8917063,6667502,6667503,9175553,9207684,9207685,9207686,9207687,9207688,9207689,9207690,9207691,9207692,9207693,9207694,6667707,10115953,10115954,10115955,10115956,10115957,6474125,6667843,6672108,9191918,6474220,9191931,9191932,9191933,9191934,6474291,6474305,6474306,6474307,6474308,9208101,9192198,10174577,10174578,10893669,10893670,10159862,10159863,10159864,10159865,10908883,10908884,10155022,10155023,10155024,10155025,10155026,10155027,10155028,10155029,10155030,10155031,10155032,10155033,10155034,10155035,10155036,10909169,10909170,10909171,10909172,10909173,10909174,10909175,10909176,10909177,10909178,10909179,10909180,10170663,10170664,10170665,10170666,10899816,10899817,10899818,10899819,10899820,10899821,10899822,10899823,10899824,10879894,10895354,10895355,10168816,10183926,10183927,10183928,10183929,10183930,10183931,10183932,10183933,10908190,10946001,10946002,10946003,10946004,10946005,10946006,10946007,10946008,10946009,10946010,10946011,10946012,10946013,10946014,10946015,10946016,10888349,10910561,10910562,10910563,10162252,10876315,10876316,10876317,10876318,10876319,10876320,10876321,10876322,10876323,10876324,10876325,10876326,10876327,10876328,10876329,10876330,10876331,10876332,10876333,10876334,10876335,10876336,10876337,10876338,10876339,10876340,10876341,10876342,10876343,10876344,10876345,10876346,10162910,10631725,10626903,10589635,10589636,10589637,10589638,10589639,10589640,10608634,10643930,10643931,10643932,10643933,10643934,10643935,10643936,10643937,10643938,10643939,10583937,10583938,10583939,10583940,10583941,10653334,10653335,10599380,10599381,10603386,10603387,10603388,10603389,10603390,10603391,10603392,10603393,10603394,10603395,10603396,10603397,10603398,10653745,10653746,10653910,10584863,10582016,10582017,10606945,10607004,10648216,10582243,10648718,10648719,10648720,10648721,10553261,10553262,10553263,10553264,10553265,10553266,10553267,10553268,10553269,10553270,10553271,10553272,10553273,10553274,10553275,10553276,10553277,10553278,10553279,10553280,10553281,10553282,10553283,10553284,10553285,10553286,10553287,10553288,10553289,10545508,10545509,10545510,10545511,10545512,10545532,10545547,10545548,10545549,10545550,10545551,10545552,10545553,10545554,10545555,10545556,10545575,10545576,10545585,10545586,10545587,10545588,10545597,10545654,10545655,10545656,10545657,10545658,10545659,10545660,10545661,10545662,10545663,10545664,10545665,10545666,10545667,10545717,10545718,10545719,10545720,10545721,10545722,10545723,10545724,10545725,10545726,10545727,10545728,10545729,10545730,10522501,10522518,10524648,10524649,10524650,10524651,10524652,10524653,10524654,10524655,10524656,10524657,10524658,10524659,10524660,10524661,10524662,10524663,10524664,10524665,10524666,10524667,10530709,10530714,10530715,10530716,10530717,10530718,10530719,10530720,10530721,10530722,10530723,10530744,10530745,10538767,10550826,10550827,10531029,10422384,10422411,10423669,10423670,10423671,10423839,10423980,10423981,10423999,10488100,10407526,10486512,10486513,10714558,10714559,10714560,10714561,10714562,10714563,10714865,10714866,10487496) 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'