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(10939643,11001744,8574287,10939757,10939905,10939907,8574476,8574477,8574479,8574481,8574482,8574486,8574487,8574488,8574490,8574491,8574492,8574493,8574494,8574507,8574508,8574509,8574510,8574511,8574516,8574517,8574518,8574519,8574520,8574529,8574530,8574531,8574532,8574533,10989095,3229008,3229010,10940220,8621465,3229108,10976438,8583479,8583481,8583482,10950848,10950850,8575581,10951109,8575768,3230067,8609570,8609571,8609572,8609573,3227401,10844749,7067298,10845422,10845423,10845424,10845425,10845426,7067767,10447778,10447794,10447801,10447803,7201199,7201273,7201386,7201387,10842980,8618066,10842998,10843025,10999067,10999068,10999135,10931902,10103768,10103769,7201898,10843580,10843582,8618679,10104055,8618811,8618812,10843797,10986752,10986753,10986754,7202371,7202448,7202449,7202450,7202451,7202452,7202453,10999898,10999917,11000066,11000067,11000068,11000069,11000070,11000071,11000072,11000073,11000074,11000082,11000093,11000094,10844178,10844179,7202672,10844180,10104578,10104579,11000164,11000165,7202770,10961218,10961219,7073622,11000310,10932979,10933000,7065694,11000384,11010620,11010621,11010622,11010623,11010624,11010625,11010626,11010627,11010628,11010629,11010630,11010631,11010632,11010633,11010634,11010635,11010636,11010637,11010638,11010639,11010640,11010641,11010740,10997860,8834762,7200599,7200606,7200609,8910574,7200779,11037228,11037229,11037234,11037235,11037239,11037240,11037241,11037242,11037249,10943257,8064656,11011438,11011439,11011441,10102901,6000196,6000197,7198383,7198390,10100300,10100301,10995912,8615274,10996415,3656396,8615755,10941716,10941719,10996784,10840883,10840884,10941757,10941763,10941767,10941773,10941782,10941809,11048307,7070497,8565245,8565255,8565256,11048460,10101770,11048671,10997519,10997520,10997529,10997530,10997531,10997532,10997533,10997534,10997535,10997536,10997537,10997564,10997565,10102055,8579115,10837777,8612935,8612937,8612938,10967840,11045973,10955114,10623731,10838528,8613644,8906884,8907030,10838833,10838968,10838970,10838972,10838975,10838982,10838985,10838988,10838990,8907300,10839015,10839016,8907668,10995358,10995366,10995367,10995373,10995376,10995377,10995378,11047458,11047479,11047507,8563610,10922518,10922520,11044826,11044847,11044848,11044849,11044850,8905258,8905259,8905261,8905262,8905263,10954029,10954030,10954031,10617378,8612196,8612197,8612198,10617394,10617407,10617419,10622428,10617440,10617441,10617442,10617454,10928029,10954257,8612448,10928326,8612733,8612734,10425356,10951651,10951652,10615167,8576393,10615472,10952320,10952321,10952323,10952324,10952325,10620765,10620766,10620767,10620768,11043453,10991457,10965471,11043479,11043493,11043494,10426204,10952581,10930951,10991733,10931016,10616118,10616119,8611003,8611004,8904273,10991935,8611086,8611087,8611088,8611089,10991956,10991957,10991958,8904364,10992315,10992316,10992388,10922282,8578018,8578023,10616905,10610988,9205389,7019061,7019096,7019134,10565324,10565325,10565326,10565327,7059757,7019289,7019323,7019355,10611375,10611376,10611381,10611428,10611466,10611509,10611519,10611544,10122122,10714438,10714444,9174059,9174060,9174061,9174073,9174082,9174085,9174086,9174208,9190244,9190245,9190246,10611949,7019948,10611969,10612059,9187499,10119704,10119705,10119724,9187551,9187552,9211555,10612292,10612293,9211926,9211936,9172154,10609844,7017938,7017958,7017978,10609988,8862865,8862873,9196360,9188363,9188381,9188395,10610126,10613137,7018177,10610310,10613393,8863271,7018513,7018547,7018581,7018615,7018649,9173136,7018821,10564992,10564993,7018855,7018889,10610947,10610958,9169317,9177367,9185607,7015282,7015302,9209652,7015322,9185725,9185726,9169727,9185730,9185737,9185738,9185744,7055923,9185856,9185866,9185879,9185896,9185897,9169943,9185944,9185945,9185946,9169982,7056303,7056304,10118374,10118375,10514021,10514023,10516164,9178498,9186790,10119044,10516787,10516913,10516917,10119392,10119416,4973195,9192346,10415372,4973424,10419497,10419498,9168790,10419712,10419724,10419741,10419742,9193120,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10418141,9169232,10419189,7019976,7020004,7020032,7020060,8549563,10463033,10463042,10463060,10467095,10467098,10467099,10467102,7020185,10467114,7020213,10467144,10467148,7020241,10471175,10467224,8549882,8549902,8549918,8549919,7020468,7020492,7020516,9190866,7020540,7020564,7020588,8550097,7020612,7020636,9198994,10463587,10463589,10463590,10463591,10463592,10463593,9199023,9199024,9199025,9199026,9199027,9199028,9199029,7020685,9199040,9199041,8916698,10463648,10463650,10463651,10463652,10463653,10463655,10463656,10463657,10463658,10463660,7020738,10463663,10463664,10463670,10463673,10463674,10463678,10465684,10465685,7020763,10465686,10465687,10465688,10465690,10463694,10465695,10465698,10465699,10465700,10465705,10465706,10465707,10465709,10465710,7020788,7020809,7020829,7020850,10463774,10463786,10463787,10465788,7020872,10463798,10463799,10465801,10465802,10463805,10465806,10465808,10465809,10465810,10465811,7020893,10465825,10463828,10463829,7020913,10465848,9175273,7020933,8916928,10465859,8916929,10465860,8916930,10465861,9175288,10465869,10465870,10465871,10465872,10465873,10463877,9175300,10463879,10465881,10465882,10463883,10465883,10463884,10465888,10463889,10465889,10465890,10463896,10463898,10463899,10465899,10463900,10463901,10465901,7020979,10465903,10463907,10463908,10465908,10463909,10463910,10465915,10465917,10463923,10463924,10463925,10463929,7021083,7021103,8563362,7021136,8550648,10466208,10466209,10466211,10466212,10466214,10466215,10466216,10466219,10466221,10466222,10466227,10466228,10466230,10466237,10466238,10466240,10466242,10462293,10462298,10462300,10462310,10462311,10462312,10462313,10462314,10462315,10462316,10462317,10462318,10462319,8550898,10462320,10462324,10466330,10462335,10462336,10462337,8550922,8550924,10466347,10466349,10466351,10466361,10466362,10466395,10462397,10466397,10462400,10462404,10466405,10466406,10466407,10466408,10466413,10466415,8550994,8550995,8550996,10466427,10466428,10462430,10466436,10466446,10466448,10466449,10466451,10466453,10466457,10466458,9175881,10462460,9175893,10462475,10462476,10462477,10462486,10462490,10462491,10462492,10462493,10462494,10462498,10462508,10462509,10462512,10462514,10462521,10462522,10462523,10462537,10462539,10462581,10462582,10462583,10462585,10462586,10462587,9192014,10462596,10462597,10462600,10462603,10462610,10462617,10462620,10462621,10462625,10462627,10462628,10462629,10462630,9168100,10462756,9192226,9192227,9192228,9192229,9160272,10884075,10884077,10884080,10884081,10884629,10884653,10884725,10156210,10163533,7000845,10163785,10632300,10632301,10632302,10153871,10173958,7001165,10184047,10184048,10184049,10883044,10184381,10184382,10184383,10184384,10184386,10184396,10184400,10184401,10184402,10184403,10184404,10184405,10184406,10184407,10184408,10184409,10184410,10184411,10883421,10172016,10172019,10172076,10162248,10167560,10626131,10626132,10626235,10626258,10167914,10631414,10631415,10631416,10631417,10631418,10167943,10167954,10626439,10167971,10167972,10167973,10167988,10167995,10168001,10168012,10168015,10168019,10168043,10168046,10168047,10168056,10882061,10173113,10173114,10173115,10950082,10950154,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10643482,10580477,10580478,10566188,10590298,10590673,10579479,10591802,10539113,10539114,10541367,10541368,10541369,10521609,10539811,10539812,10527840,10528142,10528146,10528162,10528176,10522303,10522315,10522341,10522357,10522358,10524426,10522889,10520893,10539094,10422280,10422383,10421398,10421400,10421401,10421402,10421406,10421407,10420434,10420441,10420442,10498369,10498370,10422536,10422537,10422562,10421574,10422595,10422596,10422597,10423661,10423662,10423667,10423668,10423669,10423672,10423673,10423674,10423675,10423676,10423677,10423678,10423680,10423681,10423682,10423683,10420849,10423151,10489982,10477100,10483158,10483159,10483161,10483162,10483163,10483164,10483165,10483166,10483167,10483168,10483169,10483173,10483174,10483175,10483176,10473265,10473270,10488299,10490356,10490357,10490358,10490359,10490360,10490361,10490362,10490363,10490364,10490365,10490366,10490367,10477385,10483453,10490721,10490723,10490725,10490726,10490727,10490728,10490729,10486951,10478007,10493046,10474090,10474091,10474092,10474093,10474094,10474095,10474096,10474097,10474098,10474099,10474100,10474101,10474102,10474103,10474104,10474105,10474106,10476537,10487541,10487542,10472755,10487786,10478842) 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'