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(7076128,10943628,10448383,8839040,3229206,10950602,10950639,10950673,7066348,8575567,3229962,8575735,10951339,8837571,10972643,10972645,7201293,7201294,7201319,7201330,7201381,7201468,11011910,11011911,10842997,10842998,10843002,7201514,7072286,10999062,10843157,7201818,7201819,10103845,10103965,8836431,7202211,7202212,7202213,7202214,5654555,5654577,5654578,5654579,5654581,5654606,5654620,5654658,5654661,7202695,7202696,7202697,7202698,8837114,3227094,8837240,3227259,8837394,8834735,10942913,8910449,8910450,8910574,7200911,7200913,8835196,11011425,11011426,11011427,6000119,6000194,6000195,6000196,6000197,6000198,6000199,7198391,7198392,7198681,7198685,7198696,7198697,7198718,7198720,7198731,7198733,7198751,7198760,7198766,7198770,7198784,10840910,10101528,7200030,10984537,10984538,10984539,10984540,10984560,10984561,10984562,10984563,10984564,10984565,10984566,10984567,10984568,10984569,10984570,10984571,10984572,10984573,10984574,10984575,10984576,10984603,10984604,10984605,10984606,10984607,3233403,3233404,3233408,3233416,3233422,3233423,3233424,3233425,3233426,3233428,3233429,7196261,11045716,3234046,3234098,3234101,3234102,3234107,3234108,3234120,10838501,10838519,10838531,8906891,3234358,3234359,3234360,3234364,3234365,3234369,3234370,3234371,3234373,10838968,10838984,7197552,3234736,3234738,3234741,3234744,8907409,8614229,8907591,8907592,8907593,8907596,8907601,8907602,3234964,3234965,3234971,3234972,3234973,8907612,8907613,8907616,8907618,8907619,8907622,8907623,8907624,7197813,7197814,7197815,8907628,7197816,8907637,8907640,8907641,8907644,8907645,8907649,8907650,8907654,8907658,8907662,8907665,8907668,8907670,8907673,8907674,8907682,8907685,8907686,8907691,8907694,8907695,8907699,8907703,8907704,8907708,7197907,7197913,3232418,3232419,11044697,11044698,8611889,8541576,8541577,8541578,8541579,8541580,8541593,8541594,3232538,3232539,3232540,3232541,8905262,8905263,10617332,10617344,10617345,10617346,10617353,10617354,10617373,10617374,10617379,10617446,10617452,10617457,10617458,8905686,8905720,8542251,8542254,11045522,11045523,11045524,10837649,10617955,10617957,10425577,10848006,10620302,10615338,10425911,10965320,10965372,10965373,10930728,10930729,10930730,10615824,10426197,10426340,10616023,8540568,8904210,8904222,8904224,8904226,8904232,8904234,8904236,8904242,8904254,8904260,8904267,8904269,8904271,8904272,8904277,8904278,8904280,8904282,8904284,8904288,8904289,8904290,8904292,8904297,8904299,8904300,8904302,8904334,8904337,8904339,3231700,3231701,8904341,3231703,8904344,8904346,8904351,8904354,8904358,8904364,8904370,8904375,8904382,8904390,3231764,8904403,8904420,8611260,3232020,3232021,3232022,3232023,3232024,3232025,10922143,3232026,8611455,3232047,3232048,8611465,8611466,3232049,3232050,8611467,3232051,3232067,3232068,3232069,3232074,3232075,3232076,8541212,3232159,8904798,3232168,3232172,3232184,3232185,3232186,3232187,3232248,3232249,3232250,11044555,11044556,11044557,11044558,11044559,11044560,11044561,11044562,11044563,11044564,3232328,3232329,3232330,3232331,3232332,3232333,3232334,3232335,3232337,3232338,3232339,3232340,3232341,3232342,3232343,3232346,10610965,10611037,10714020,10714023,10565423,10565424,10565425,6669818,10565426,10565427,10565428,10565429,6669823,10565430,6669913,10614500,10614501,10565663,10565664,10565665,10565666,10565667,10565668,10565669,10565670,10565671,10565672,10565700,9181892,9181893,10559706,9181894,9181895,9181896,9181900,10559722,10559723,10559724,10559725,10559726,10559744,9213993,9213998,9214240,9214286,10611969,9211551,9211552,9211556,9211558,9211560,9211561,9211562,9211563,9211564,9211565,9211566,8862099,10609285,10612295,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10612938,10609938,10609939,10609940,10609941,10609942,10612943,10609943,10609944,10609945,10612961,9212320,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,7058533,7058534,10610064,7058620,9188641,10613369,10613392,10610434,10613475,10610479,9172859,9172860,10613738,10610954,6673524,10515327,10515328,10515329,7055723,9193598,7015320,7015321,7015322,7015323,7015324,7015325,7015326,7015327,7015328,7015329,7015330,7015331,7015332,7015333,7015334,7015335,7015336,7015337,7015338,7015339,9169748,10517670,9185862,9185900,9169942,9169944,9169949,6674227,6674261,6674280,9170074,6674284,6674331,10118369,10118370,10118371,10118372,10118373,10118374,10118375,10516142,10118607,10118608,9194451,10118674,10118679,10512530,10518695,10518696,10518697,8552194,10119183,9211213,9211215,9211216,9211217,9211218,9211219,9211222,9160319,9160335,9168394,6672697,6672698,6672758,6672768,6672769,6672772,10419499,6672784,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,6672808,10419538,6672830,6672831,6672832,6672833,6672863,6672871,6672872,6672874,6672875,9168669,6672885,6672886,6672887,6672888,6672892,6672893,9168728,6672960,9168818,10417826,10417845,9168940,10417862,10417897,10417915,9169064,6673271,6673272,6673273,6673278,6673279,6673281,6673282,6673289,6673299,6673300,6673308,9193118,9193119,9193120,9193121,10417057,10417058,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417086,10417093,10417106,10417107,10417108,10417109,10418145,10418146,7055456,9190818,10467867,10123846,10123847,10123848,8550898,9175790,9175796,6672435,10883562,10883572,10883589,10883590,10883591,10883592,10883593,10883594,10883595,10883596,10883597,10883598,10883625,10883627,10883628,10883629,10883630,10883631,10883660,10883661,10883665,10893757,10884041,10884042,10884068,10884088,10884089,8594166,8594167,8594168,8594169,8594170,8594171,8594172,8594173,10889231,10894378,10889584,10889718,10875001,10890007,10890008,10890137,10890138,10890148,10887474,10887557,10632056,10632163,10632164,10632165,10627319,10153863,10882987,10882988,10882989,10882990,10883043,10888339,10888382,10630089,10885763,10885959,10167060,10167061,10167062,10167130,10167146,10167156,10167172,10167173,10162244,10162245,10162246,10162247,10167305,10167354,10886497,10886498,10886513,10886533,10886534,10886535,10626145,10891863,10887096,10887097,10887223,10887224,10887225,10887226,10887227,10887228,10887229,10887230,10887231,10887232,10631789,10631790,10631791,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568126,10568127,10568128,10568129,10568130,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10601403,10643545,10643546,10643547,10643548,10598573,10598866,10590269,10590270,10590271,10590276,10590278,10590279,10590285,10590286,10590287,10590288,10590290,10590291,10590292,10590293,10590294,10590295,10590296,10590297,10644404,10599386,10647702,10567621,10567622,10567623,10567624,10567625,10591756,10591921,10568110,10568111,10529398,10529399,10539850,10539851,10539852,10539853,10528105,10528138,10528140,10532143,10532144,10532145,10532146,10532147,10532148,10532149,10532150,10532155,10532156,10528156,10532157,10528157,10532158,10528158,10532159,10528159,10532160,10532161,10532162,10532163,10532164,10532165,10528184,10530281,10530285,10528350,10522420,10522455,10522469,10522470,10522471,10527020,10547031,10523075,10422598,10425030,10425042,10425046,10425051,10425053,10407787,10407788,10407827,10486567,10486571,10408191,10496934,10496935,10496936,10496937,10496938,10496939,10496940,10496941,10496942,10496943,10496944,10496945,10496946,10496947,10496980,10496981,10496983,10496984,10496985,10496986,10496987,10496988,10496989,10496990,10496991,10496992,10496993,10478003,10478005,10478006,10478007,10478008,10478010,10478011,10478012,10478013,10478014,10478015,10478016,10478017,10478018,10478019,10478020,10478021,10478022,10478023,10478024,10478025,10478027,10478028,10478029,10478030,10478031,10497032,10478032,10497033,10478033,10497034,10497035,10497037,10497038,10497039,10497040,10497041,10497042,10497043,10497044,10497045,10497046,10487110,10493251,10493252,10493253,10493254,10493255,10493296,10493297,10493298,10493299,10493300,10493301,10493302,10497383,10408756,10408780,10406991) 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'