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(10939610,10939617,10939618,10939628,10939649,10939677,10939694,10939700,10939703,10939772,10939792,10939796,10939822,10939848,7076239,10939868,10939914,10939915,7076293,10939916,10943842,10940061,4970670,4970671,4970738,8569625,10940293,8569647,4971037,10944265,4971081,10940507,10940524,7065936,7065941,7065946,7065947,7066142,7074294,8067368,7066766,7066784,7066821,7066822,7066823,7066824,7066825,7066836,7066882,7066883,7066884,7066917,10938787,10938791,10938792,10938794,10938795,10938797,10938854,10938881,7075460,10939126,7067815,7067824,10939467,10939492,10939495,10939503,10939511,10939537,7072072,7072073,7072074,7064587,7064592,8065932,8065933,8065934,8065935,7065352,7073403,7065421,10942600,10942666,10942671,10942692,10942693,10942710,10942712,10942714,10942715,10942734,10942735,10942737,10942743,10942745,10942793,10942799,10942804,10942812,10942817,10942861,10942992,10942994,10943018,10943019,10943026,10943044,10943045,10943048,10943113,10943122,10943248,10943270,10943290,10943304,10943308,10943309,10943342,10943419,10940578,10940580,10940633,10940741,10940742,10940783,10940883,10940969,10940993,10940998,10941002,10941103,10941128,10941161,10941163,10941195,10941226,10941262,10941278,10941285,10941296,10941383,10941389,10941391,10941400,10941477,10941512,10941589,10941636,10941651,10941682,10941745,10941749,10941791,10941929,10941948,10941961,10941969,10941979,10941984,10942106,11048438,11048439,10942201,10942205,10942210,10942213,10942218,10942219,10942222,10942228,10942229,11048540,11048541,10942286,10942304,10942325,10942343,10942344,10942346,10942347,10942348,10942350,7070729,10942357,10942358,10942361,10942366,10942367,10942385,10942390,10942395,10942435,10942448,10942477,10942489,10942534,10942535,10618178,10618179,10618180,10618181,10618183,10618253,10618254,10618255,10618256,10618265,10618266,10618267,10618268,10618269,10618270,10618271,10618272,10618273,10618274,10618275,10618276,10618277,10618278,10618279,10618280,10618281,10618282,10618283,10618284,10618285,10618286,10618287,10618288,10618289,10618290,10618291,10618292,10618293,10618294,10618295,10618296,10618297,10618298,10618299,10618300,10618301,10618302,10618303,10618304,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618313,10618314,10618315,10618316,10618317,10618318,10618319,10618320,10618321,10618322,10618323,10618324,10618325,10618326,10618360,10618361,10618362,10618363,10618364,10618366,10618367,10618368,10618369,10618370,10618442,10618448,10618452,10618861,10618862,10619129,10619130,10619131,10619132,10619133,10619134,10619135,10619136,10619137,10619138,10619139,10619140,10619141,10619142,10619143,10619146,10619147,10619148,10619149,10619150,10619151,10619152,10619153,10619154,10619155,10619156,10619157,10619158,10619159,10619160,10619161,10619162,10619163,10619164,10619165,10619166,10619175,10619840,10619842,10619843,10619844,10619854,10619863,10619864,10619865,10619866,10619871,10619874,10619875,10619885,10619886,10619887,10619889,10617209,10622217,10622224,10622225,10622235,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10622269,10622360,10622365,10622402,10622405,10622408,10622428,10622429,10622430,10622431,10622441,10622445,10622447,10622460,10617461,10622508,10622514,10622516,10622523,10622533,10622548,10622549,10617573,10614983,10614991,10614992,10614993,10614994,10614995,10614998,10620172,10615179,10615437,10615438,10615439,10620559,10615711,10615820,10621034,10616056,10616058,10616220,10616258,10616265,10616295,10616303,10616341,10616342,10616350,10616351,10616389,10616404,10616430,10616431,10616553,10616790,10616955,10610995,10610996,10610997,10614064,10614085,10614086,10611105,10611250,10614376,10611459,10559622,10611560,10611615,10611649,10611659,10562851,10614744,10611804,10611856,10612132,10609375,10609749,10561087,10561088,10561089,10561090,10561091,10561092,10561093,10561094,10561095,10561096,10561097,10561098,10561099,10561100,10561101,10561102,10561103,10561104,10561105,10561106,10561107,10609988,10610005,10610015,10610024,10610026,10610030,10610044,10610046,10610054,10610056,10610057,10610060,10610061,10610063,10610064,10610065,10610075,10610095,10610096,10610097,10610104,10610126,10558304,10610233,10610241,10610242,10610243,10610244,10610245,10610246,10610247,10610248,10610249,10610250,10610251,10558442,10610292,10558443,10558444,10558445,10558446,10558447,10558448,10558449,10558450,10558451,10558452,10558453,10610304,10613306,10610306,10610307,10610310,10610311,10610312,10610333,10610337,10610343,10610344,10610347,10610351,10610352,10610353,10613369,10610376,10613393,10610418,10613421,10610429,10613431,10613432,10610434,10613434,10610435,10558591,10558592,10558593,10558596,10610449,10610473,10610474,10613475,10610479,10610480,10610481,10610482,10613504,10613505,10613513,10613514,10613525,10613527,10613531,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,10610588,10610589,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10610633,10610634,10610635,10610636,10610637,10610638,10610639,10610640,10610641,10610642,10610643,10610644,10610645,10610646,10610647,10610648,10610649,10610650,10610651,10610652,10610653,10610654,10610655,10610656,10610657,10610658,10610659,10610660,10610661,10610662,10610663,10610697,10564885,10564886,10564887,10564888,10564889,10564890,10564891,10564892,10564893,10564894,10564895,10564896,10564897,10564973,10565037,10565038,10565039,10565040,10565041,10610901,10515134,10515135,10515136,10517143,10517144,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517220,10517221,10517222,10517223,10517224,10517225,10515280,10513386,10517614,10517615,10517616,10517617,10517618,10513619,10513620,10517670,10517681,10517820,10517821,10513914,10513915,10513952,10513961,10513974,10513975,10517994,10513994,10517995,10513997,10513998,10513999,10514015,10514017,10514018,10514021,10514023,10514028,10514029,10514030,10514031,10514032,10514033,10514037,10514090,10514091,10514092,10514093,10514364,10514386,10514387,10514388,10514390,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10514666,10514667,10514668,10514669,10514833,10514834,10514963,10514964,10514965,10514966,10514968,10514969,10514970,10514971,10514972,10514973,10514974,10514976,10514980,10514983,10514986,10514987,10514988,10514989,10514992,10514993,10514994,10514995,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10515010,10515013,10515019,10515020,10515021,10515022,10515028,10515029,10515030,10515031,10515032,10515039,10515040,10515041,10515042,10515043,10515044,10515047,10515048,10515049,10515050,10515051,10515052,10515053,10515054,10515059,10515060,10515061,10515062,10515063,10515065,10515066,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10417296,10417297,10417298,10417300,10417312,10417313,10417314,10417315,10417318,10417319,10417322,10417323,10417324,10417325,10417326,10417327,10417331,10415575,10415576,10415791,10415792,10415793,10415794,10415795,10415796,10415797,10415815,10415816,10415821,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10415873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,10419888,10419889,10419890,10419891,10419892,10419893,10419894,10419895,10419897,10419898,10419899,10419900,10419904,10419905,10419906,10419907,10418048,10420149,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10420216,10420217,10420218,10420219,10420220) 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'