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(10939586,10939607,8068885,8068886,8068887,7068044,7068045,7068046,7068047,7068048,10939713,10939714,10939715,10939716,10943527,10939739,10939747,10939810,10939875,10943775,10940058,10940059,10940060,10940061,4970673,7068461,7068462,7068466,4970684,10940092,4970687,4970711,4970753,7068585,10944012,10944013,7068602,7068612,7068613,7068614,7068615,7068616,7068628,7068629,7068630,7068640,7068641,10940264,7068642,10944065,10944068,7068652,7068653,7068654,7068655,7068656,7068657,7068678,7068679,7068681,7068683,7068686,7068687,7068696,7068699,7068700,7068701,7068705,7068711,10940334,7068712,10940342,4971083,4971091,4971092,4971093,8066948,8066949,4968310,4968311,7066113,7066174,7066175,8067162,8067163,8067164,8067165,8067166,8067167,8067168,8067185,4968520,7066384,8067414,8067415,8067433,8067443,8067444,8067445,8067447,8067448,8067461,8067518,7066577,8067679,10437626,10437627,10437628,10437629,7066866,7066867,10938596,8067868,7066978,7066979,10938605,10938619,7067003,8067904,8067911,8067912,4969260,8067949,10938796,7067241,7067268,8068171,4969547,4969570,7067425,7067453,10939176,7067796,7067924,7067925,7067927,6000232,6000234,6000236,6000237,6000258,6000259,6000283,6000284,6000285,6000286,6000297,7064036,8065174,8065175,8065176,7064218,7064221,7064230,7064231,7064235,8065219,8065220,8065221,7064251,7064354,7064355,7064374,7064385,7064386,7064460,10931817,10931827,7064516,7064531,8075321,10931941,10931959,7064655,7064709,4967032,7064951,8065945,4967448,4967449,4967455,4967456,7065330,4967560,7065357,10932774,7065445,10932950,8066589,8066590,10932966,10933019,10933020,10933021,10933022,10933073,10933074,8066740,4967982,4967993,4967994,4967995,7065786,7065787,10933166,7065920,10942575,10942628,10942632,10942649,11048937,10942677,10942695,10942701,10942702,10942703,10942704,10942706,10942707,10942708,10942711,10942715,10942719,10942720,10942721,10942725,10942726,11049009,11049010,11049011,11049012,11049013,11049161,8064244,8064252,8064253,8064254,8064255,8064256,8064257,8064258,8064265,8064266,8064267,8064268,8064280,8064281,8064282,8064283,8064284,8064285,8064289,8064290,8064324,11049291,11049293,11049469,11049470,11049492,10943216,10943226,10943227,10943255,10943256,5999944,5999945,5999946,5999972,10943315,10943316,5999978,5999979,5999980,10943321,5999981,10943322,10943324,10943327,6000012,6000013,6000014,6000069,6000072,8970207,6000133,6000159,6000164,6000166,6000168,6000169,6000180,6000184,6000186,6000187,6000188,6000189,10944384,10940673,10940685,10940689,10940717,10940748,10940752,10944590,10944631,3655792,10944745,3655974,3655975,10941052,10944850,10944851,10944852,3656011,3656043,3656044,10941117,3656099,3656109,10941169,10944992,3656151,3656152,3656153,3656154,3656155,3656163,3656164,3656165,3656166,3656167,11047601,11047602,11047603,11047604,11047605,11047608,11047632,10941498,3656563,8072764,10941667,3656633,3656640,3656641,3656642,3656684,3656703,3656704,8072887,8072893,10941850,10941851,10941852,10941853,10941854,10941855,10941856,3656804,10941857,10941858,10941873,10941874,10941883,10941884,10941894,3656843,10941896,3656844,10941901,10941904,10941906,10941909,10941910,10941911,10941912,10941913,10941914,10941915,10941931,10941932,10941933,10941940,3656888,10941941,10941942,10941943,10941944,10941947,10941955,10941956,10941957,10941958,10941970,10941971,10941972,3656921,10941975,10941976,10941977,10941978,10941979,10941980,10941981,10941982,10941983,10941984,10941985,10941986,10941987,10941989,10941994,10941996,10941999,10942001,10942007,10942009,10942010,10942013,10942014,10942015,10942017,10942019,11048302,3656996,10942096,10942098,11048463,11048464,10942320,10942321,11049567,11049568,11049571,8073485,8073486,8073489,8073490,11048659,11048689,10942509,10942510,11049750,11049751,10928599,10928601,10923685,10923697,10623198,10928751,10923788,10923789,10923997,10923999,10924012,10924013,10924014,10924015,10623507,10919052,10919060,10919069,10924086,10924094,10924095,10924096,10623655,10924201,10623694,10623695,10924205,10623696,10623697,10623698,10623699,10623700,10623701,10623702,10623703,10623704,10924241,10623889,10924526,10924539,10624114,10924713,10924729,10925037,10925038,10925041,10925058,10925321,10925324,10925327,10925328,10925332,10925333,10925334,10925336,10927478,10922478,10922479,10922480,10621984,10622027,10622029,10927556,10927557,10927558,10622068,10922585,10622078,10622079,10622080,10922607,10622098,10927755,10927837,10927860,10927965,10927966,10927967,10927968,10927969,10927970,10927971,10927972,10927973,10927974,10927975,10917976,10927976,10927977,10928200,10622816,10622905,10620051,10620165,10620324,10620482,10620564,10620565,10620566,10620567,10620568,10620569,10620570,10620571,10620572,10620573,10620574,10620575,10620576,10620577,10620578,10620579,10620580,10620581,10926100,10926111,10926112,10926113,10926114,10926115,10926116,10926117,10926118,10926119,10916253,10916254,10916255,10916256,10916257,10916261,10916262,10916263,10916264,10916265,10916272,10916273,10916274,10916276,10916279,10916280,10916283,10916284,10916285,10916286,10916287,10916288,10916289,10916290,10916291,10916299,10916300,10916305,10926310,10916310,10926311,10916311,10916312,10916318,10916319,10916320,10916321,10916322,10916323,10916332,10916333,10916338,10916339,10916344,10916345,10916346,10916347,10916348,10916352,10916353,10916354,10916355,10916361,10916362,10916365,10916366,10916368,10916369,10916370,10916371,10916372,10916373,10916374,10916375,10916378,10916379,10916380,10916381,10916393,10916394,10916395,10916396,10916397,10926398,10916403,10916404,10916405,10916414,10916421,10916423,10916425,10916426,10916429,10921556,10921557,10921558,10921559,10921584,10921589,10921592,10921593,10621084,10921594,10921596,10921597,10921598,10921599,10921609,10921614,10921615,10921616,10921617,10621163,10621359,10921965,10921970,10917003,10927072,10927073,10927074,10927110,10927111,10927191,10917275,10917277,10917281,10917286,10917287,10917291,10917299,10917303,10917310,10922329,10927340,10927459,10927460,10613975,10611049,10565221,10565222,10565241,10565249,10565254,10559323,10611179,10614207,10614279,10611306,10611307,10565468,10565469,10565470,10565471,10565472,10565473,10565474,10565475,10565476,10565477,10565478,10614340,10559561,10559562,10559563,10559564,10559565,10559566,10559567,10559568,10559569,10559570,10559571,10559572,10559573,10559574,10559575,10559576,10559577,10559578,10559579,10559580,10559581,10559582,10559583,10559584,10559585,10559594,10559595,10559596,10559597,10559598,10559599,10559600,10559601,10559603,10559604,10559605,10559606,10559607,10559608,10559609,10611578,10611579,10611580,10611581,10611598,10611615,10611616,10611623,10611624,10611630,10611631,10611632,10611633,10611634,10611635,10611636,10611647,10611648,10611721,10614771,10614849,10614894,10566061,10566062,10614940,10614943,10608974,10611975,10611976,10611977,10611978,10608985,10611985,10608986,10611998,10609001,10609004,10609008,10612008,10609012,10609015,10612035,10612036,10609037,10612037,10609062,10612086,10609095,10612252,10563489,10612344,10563510,10609374,10609375,10563528,10609382,10563534,10563535,10563536,10563537,10563538,10563539,10563540,10612405,10563583,10609443,10609444,10609457,10609503,10563700,10612628,10612629,10612630,10609703,10609717,10609749,10557969,10557973,10612840,10612851,10609854,10609855,10609856,10612895,10612896,10609907,10612927,10612971,10610036,10613057,10610068,10613079,10613091,10610175,10610176,10610177,10610180,10610181,10610182,10613189,10613315,10610395,10610676,10613678,10610740,10613753,10610837,10610937,10610938,10517276,10517331,10517449,10517450,10512144,10512237,10512238,10512239,10512350,10512355,10512357,10512359,10512361,10512506,10512509,10512510,10512511,10512514,10513047,10513048,10513049,10513050,10416291,10419314,10419315,10419316,10419317,10419318,10415350,10415352,10416448,10416495,10419527,10419632,10419633,10419634,10419635,10419636,10416648,10416671,10416678,10416698,10416834,10416835,10416836,10416837,10416881,10416882,10416883,10417163,10417164,10417165,10417166,10417167,10417168,10417169,10417170,10417171,10417172,10417173,10417174,10417175,10417176,10417177,10417178,10417179,10462910,10462911,10462926,10462933,10462970,10463046,10463050,10463051,10463052,10463054,10463116,10463158,10463221,10463434,10463556,10463557,10463558,10463559,10463560,10463561,10463562,10463679,10465723,10463762,10463809,10463812,10463813,10463815,10463817,10463818,10465833,10465837,10465839,10469901,10469903,10469904,10469905,10463915,10463916,10463979,10464199,8563534,10462349,10462350,10462353,10462354,10462355,10462356,10462357,10462358,10462360,10462365,10462368,10462386,10462387,10462450,10462451,10462452,10464508,10462528,10462530,10462531,10464583,10462613,10462614,10470662) 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'