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(10943460,10943553,10943557,7068140,7068142,10943561,7068143,7068144,7068146,7068147,7068148,10943567,10943568,7068149,10943569,7068150,10943570,7068151,10943571,7068152,7068153,10943572,7068154,10943573,7068155,10943574,7068156,10943575,10943576,7068157,7068158,7068159,7068162,7068166,7068167,7068168,7068169,7068170,7068171,7068172,7068173,7068174,7068184,7068185,7068186,7068187,7068203,7068215,7068225,7068228,7068231,7068236,7068239,7068244,7068247,7068248,7068255,7068256,7068260,7068261,7068263,7068264,7068265,7068266,7068267,7068268,7068269,7068270,7068271,7068272,7068273,7068274,7068275,7068276,7068277,7068278,7068281,7068282,7068283,7068284,7068285,7068286,7068287,7068288,7068289,7068290,7068291,7068292,7068295,7068301,7068312,7068313,7068314,7068315,7068316,7068317,7068318,7068325,7068333,7068335,7068342,7068346,7068350,7068354,7068356,7068359,7068363,7068365,7068366,7068369,10940098,10940099,10940109,10940110,10940111,10940131,10940152,10940153,10940155,10940162,10940167,10940168,10940169,10940170,10940173,10940174,10940176,10940177,10940178,10940179,10940181,10940182,10940183,10940184,10940185,10940186,10940191,10940192,10940195,10940196,10940198,7068620,7068634,4970859,7068666,4970916,4970959,7068759,7068765,7068766,10944192,4971030,4971031,4971032,4971033,10940490,10940514,7068906,10933290,10933291,10933292,10933293,10933294,10933297,8066929,8066930,10933333,10933470,10933471,10933472,7066244,8067334,8067432,8067504,8067505,7066659,7066662,7066663,8067739,7066770,7066771,7066827,7066831,7066832,10437698,7066857,10437744,10437789,8067845,8067850,8067851,8067852,8067853,8067854,8067855,10938630,10938638,10938641,10938642,10938643,10938647,10938653,10938654,10938655,10938656,10938657,8068002,8068223,8068237,8068267,7067444,8068336,7067544,7067545,8068563,10939298,7067803,8068740,8068741,8068742,8068748,8068793,6000287,6000288,10931517,7064263,7064264,7064268,7064271,7064281,7064289,7064290,10931641,10931642,7064298,7064299,7064302,7064303,7064304,7064305,7064307,7064314,8065365,8065366,8065422,8075232,8075261,8075262,8065563,8065564,8065565,8065566,10931986,7064712,10932087,10932099,8075488,10932104,4967032,4967047,8065816,8066002,8066165,8066166,4967523,4967546,4967547,4967548,4967557,4967558,4967559,4967560,4967574,8066343,8066346,4967588,4967589,4967610,4967611,4967612,4967613,4967614,4967634,4967635,4967636,4967637,4967638,4967639,4967674,4967675,4967676,8066442,8066443,8066444,8066445,4967685,8066446,8066447,8066450,8066464,4967706,10932838,4967707,4967708,10932840,4967717,4967719,4967721,4967751,4967754,4967755,4967756,10932888,4967757,4967758,4967759,4967760,4967761,4967762,4967763,4967764,4967765,4967766,4967767,10932898,4967768,4967769,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,10932945,4967814,4967815,4967816,4967817,4967818,4967826,4967829,8066634,8066661,8066698,10933249,8066907,8064159,10942931,10942963,10942966,10942988,8064348,8064352,8064354,8064355,8064359,8064363,8064381,8064387,8064388,8064389,8064392,8064399,8064401,10943050,10943051,8064408,10943060,8064423,8064424,8064425,8064426,8064449,8064475,8064483,8064484,8064485,8064486,8064487,8064488,8064489,8064490,8064491,8064492,8064493,8064494,10943141,8064495,8064496,8064497,8064498,8064499,8064500,8064501,8064502,8064503,8064504,8064505,8064506,8064507,8064508,8064509,8064510,8064511,8064512,8064513,8064514,8064515,8064517,8064518,8064519,8064521,8064526,8064582,10943235,10943246,10943247,8064726,10943391,8970213,10940563,10940564,10940571,3655647,10940720,10940722,3655969,3656071,3656092,8072359,3656199,8072365,8072376,3656212,8072380,8072383,8072387,8072393,8072398,8072402,8072408,8072414,8072418,8072424,8072427,8072434,8072435,8072436,8072437,8072439,8072444,8072447,8072450,8072451,8072456,8072459,8072460,8072461,8072462,3656501,3656502,3656503,3656504,3656505,8072672,3656577,3656578,3656579,3656580,3656653,3656654,3656655,3656656,10941713,10941714,3656662,10941715,10941717,10941720,10941722,10941724,10941725,10941765,10941766,3656715,10941930,10942042,10942076,3657150,3657151,3657152,3657153,3657157,10942230,10942233,10942318,10942332,11049573,11049574,11049575,11049585,11049592,11049597,11049608,11049612,11049613,11049614,11049615,11049616,11049617,11049618,10942494,10942503,10923531,10918651,10623317,10623411,10923946,10923976,10623508,10924061,10924062,10919234,10924343,10924369,10924378,10924382,10924577,10924579,10924613,10924615,10924616,10624256,10924796,10919842,10924854,10924863,10924872,10924883,10919973,10919980,10919981,10919982,10919983,10919984,10920078,10920079,10920080,10925100,10624733,10624734,10925383,10925434,10622115,10922729,10917813,10922814,10622312,10917833,10917834,10917835,10917836,10917837,10622344,10923025,10622776,10622777,10622815,10622816,10622817,10923390,10923406,10915623,10620155,10620164,10620168,10620169,10620183,10620188,10620302,10620303,10620381,10620403,10620408,10920925,10920927,10920930,10920931,10920932,10920944,10920962,10620651,10620653,10620670,10620695,10620699,10620700,10620701,10620702,10620703,10620704,10620705,10620706,10620707,10620708,10620709,10620710,10921392,10921409,10921499,10921519,10921520,10921522,10921597,10621090,10921614,10921636,10621269,10921825,10921832,10621353,10621355,10621403,10621405,10621447,10921958,10621453,10621461,10621529,10917053,10917054,10917055,10917056,10621620,10621639,10621641,10621672,10621706,10621717,10917419,10922460,10922461,10922462,10922463,10621958,10613981,10610991,10611119,10614167,10611245,10614274,10614291,10611335,10611423,10611453,10611454,10611455,10611456,10611458,10611459,10611460,10614503,10614504,10614505,10614552,10614553,10611563,10611615,10611641,10614650,10611679,10614798,10611807,10611880,10611912,10611927,10611929,10608981,10608982,10611998,10609053,10609054,10609055,10609056,10612069,10612124,10612129,10563356,10612267,10612335,10609339,10609340,10609341,10609342,10609344,10612344,10609356,10609360,10609366,10612604,10612641,10612658,10612685,10609719,10612720,10609764,10609765,10609829,10609879,10609886,10609921,10612943,10612960,10612961,10610000,10613058,10613163,10564314,10564315,10564385,10564453,10613363,10610390,10613469,10613479,10564768,10610691,10613731,10613787,10610805,10610950,10511199,10511224,10511225,10511226,10511227,10511263,10511264,10511265,10511266,10517285,10555327,10555349,10555418,10555805,10555826,10555827,10555828,10555962,10518078,10556432,10556444,10556445,10556463,10556470,10556471,10556472,10556473,10556474,10556484,10556486,10556489,10556490,10556492,10556495,10556496,10556501,10512760,10512761,10557030,10557040,10519065,10519066,10519067,10519069,10513074,10519079,10519081,10416365,10415373,10419385,10416400,10416415,10416416,10419637,10419638,10419639,10419640,10419696,10416710,10416711,10416797,10419825,10419826,10419827,10419892,10419896,10416033,10416034,10420040,10416043,10417057,10417058,10420132,10420133,10462943,10470959,10463004,10463006,10463017,10463018,10463023,10463024,10463032,10463033,10463036,10463046,10463047,10463048,10463049,10463050,10463051,10463052,10463053,10463054,10463055,10463056,10463057,10463058,10463059,10463061,10463063,10463072,10463081,10463103,10463107,10463113,10463114,10463115,10463116,10463117,10463118,10463120,10463122,10463129,10463130,10463132,10463134,10463135,10463136,10463137,10463138,10463142,10463143,10463144,10463149,10463157,10463158,10463159,10463160,10463184,10463187,10463190,10463191,10463201,10463202,10463203,10463204,10463205,10463206,10463207,10463208,10463209,10463210,10463211,10463212,10463213,10463214,10463215,10463216,10463217,10463218,10463219,10463220,10463221,10463222,10463223,10463224,10463225,10463226,10463227,10463228,10471233,10463250,10463251,10463256,10463257,10463258,10463259,10463260,10463261,10463262,10463263,10463264,10463265,10463266,10463267,10463268,10463269,10463270,10463271,10463272,10463273,10463274,10463275,10463276,10463277,10463278,10463279,10463280,10463281,10463282,10463283,10463284,10463285,10463286,10463287,10463288,10463289,10463290,10463291,10463292,10463293,10463294,10463295,10463296,10463297,10463298,10463299,10463300,10463302,10463305,10471477,10471478,10471479,10471480,10463878,10469918,10469919,10469980,8563438,8563439,8563467,8563470,8563477,10470170,10470171,10470274,10470291,10470292,10470293,10464344,10464345,10464346,10462375,10470666) 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'