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(8574471,8574474,8574497,8574525,8583099,8583522,10950744,7066120,7066214,7066220,7066222,7066230,11029226,8575742,10990267,11042412,8609637,8837462,10938602,8837486,8067909,8837563,8573370,11040000,11040001,11040002,11040003,11040005,11040006,8573640,10962194,10962195,10939382,10939385,10999087,10960474,8065837,8911947,8572149,8572158,10932570,8572851,8837231,8572989,8573007,8837341,8837349,8837356,7065914,7065918,8573097,8837417,8910047,8910052,8910053,8910054,8910055,8910245,8834735,10959114,10101064,8564673,10101158,10101459,10101461,10101466,10101504,10101511,10101540,8906004,10623061,10618268,10618275,10618276,10618277,10618278,10618279,10618280,10618281,10618296,10618300,10618301,10618303,10623323,10618324,10618326,10623417,11007190,8906638,8906639,8906640,8906641,8906642,8906732,8906733,8906734,8906735,8906810,8906892,8906979,8906980,8906981,8906982,8906985,8906986,8906987,8907065,8907066,8907436,8907465,8907473,8905000,8905013,8905024,8905025,8905026,8905032,8905060,10617032,10617035,10617040,10617041,8905147,10617126,10617130,10617131,10617134,10617135,10617136,10617157,10617204,8905256,10617474,8905536,8905621,10993337,8905723,8905724,10617773,10617774,10617775,10617776,10617778,8905837,8905917,8905948,8905968,10615137,10615182,10620187,10620189,10620190,10620191,10620192,10620193,10620194,10620198,10620199,10620200,10620203,10620204,10620205,10620206,10620208,10615257,10615320,10615335,10615391,10615439,10615568,10615569,10615573,10615601,10615605,10952214,10615628,10615740,10620741,10615767,10615796,10615797,10615798,10615820,10615822,10615862,10615909,10615943,10615944,10615967,10615971,10615972,10991661,10991662,10616033,10616039,10616068,10616069,10616073,10616100,10616101,10616102,10616103,10616104,10616105,10616106,10616133,10616202,10616205,10616206,10616208,10616209,10616212,10616219,10616221,10616224,10616225,10616239,10616255,10616256,10616259,10616266,10616271,10616272,10616273,10616274,10616275,10616282,10616283,8904315,10616286,10616288,10616290,10616291,10616292,10616300,10616307,10616319,10616321,10616322,10616325,10616328,10616336,10616337,10616338,10616358,10616359,10616368,10616369,10616376,10616379,10616380,10616381,10616382,10616383,10616391,10616392,10616414,10616417,10616418,10616425,10616429,10616433,10616451,10616460,8904499,10616635,10616636,10616637,10621649,10621658,10616685,10616689,10621702,10621707,8577869,10621718,10621722,10621723,10616734,10616790,8904822,10616791,10616859,8904911,8904912,8904932,10616905,8904945,8904947,8904948,8904951,10616923,10616924,8904959,8904989,10613973,10611007,10611016,10611060,10614085,10614086,10614094,10611107,10611108,10611109,10611135,7059641,10614188,10614189,10614190,10614191,9165556,10614221,10614222,10611267,10614314,10614323,10614343,10614357,10614376,10611445,9165801,9165802,9165803,10614475,10614477,10614478,10614486,10614517,10611680,10611681,10611754,10611755,10614761,10611772,10611774,10611799,10611825,10611832,10614864,10614889,10614897,10614898,10614899,10614911,10611955,10609011,10612030,10612031,10612032,10612035,10612036,10612053,10612088,10612093,10612178,10612201,10612294,10609332,10612334,10612336,10609350,10609351,10609352,10609353,10609360,10609361,10609375,10609397,10609398,10609405,10609408,10609416,10609419,10609431,10609432,10609433,10612489,10609504,10612506,10612529,10609531,10609555,10612559,10612575,10612588,10609593,10609595,10609609,10609616,10609623,10609624,10609625,10609626,10609627,10609628,10609629,10609630,10609631,10609632,10609633,10609644,10609657,10612669,7017661,10612670,7017662,7017663,7017664,7017665,7017666,7017667,7017668,7017671,7017672,10609707,10609708,7017701,10609710,7017702,7017703,7017704,7017705,7017706,7017707,7017708,10609718,10609720,10609721,10609724,10609730,10609731,10609732,10609736,10609742,7058247,10609744,10609745,10609747,10609752,10612755,10609757,10609758,10612758,10609772,7017767,7017768,7017769,7017770,7017771,7017772,7017779,10609795,10609820,10609824,10609825,10609826,10609827,10609828,10609830,10609834,10609837,10612873,10609880,10609881,10609900,10609901,10609911,10609916,10609917,10609918,10609942,10609943,10609944,7017936,10609948,10609949,10609950,10612950,7017948,10609958,10609960,7017956,10609968,10609969,10609970,10609974,7017968,10612981,7017976,10612990,10612993,10613000,10613012,10610013,10613023,10610030,10610045,10610046,10610047,10610048,10610053,10610054,10613061,10613062,10610086,10610096,10610103,10610105,10610120,10610137,10610138,10610139,10610140,10613235,10613273,10610282,10613287,10610289,10613292,10613299,10610300,10613305,10613315,10610395,10610434,9164777,10610497,10610686,10613693,10610695,10610697,10610732,10613798,10613823,10610837,10613860,10613861,10613862,10613863,10613864,10613865,10613866,10613895,10610915,10613927,10613929,9169488,9169497,9169724,9169725,9169726,7056001,9169923,9169942,10516135,10516139,9210939,9210940,10419228,10419234,10418252,10419253,9168354,9160355,10417288,10416307,10417398,10417399,10417400,10417401,10417405,10415435,9168518,10415444,10416482,10416483,10419504,10419508,9168592,9168593,9168595,9168596,9168598,9168615,10415538,10416542,10415579,10415580,10415581,10415582,10419596,10419600,10419607,10419608,10419609,10419611,10419613,10419614,10419615,10419617,10419630,10419632,10419633,10419635,10419637,9168717,10415641,10417655,10417656,10415663,10419666,10419667,10415668,10415672,10417676,10417677,10415680,10418682,9160808,9160809,9160810,9160812,9160813,9160814,10415751,10415769,10415770,10419773,10419774,10419775,10419776,10416779,10415784,10415785,9168867,10416800,10416801,10416802,10416803,10416804,10416805,10416808,10416809,10416810,10416811,10416812,10418812,10416813,10416814,10416815,10416816,10416817,10416818,10416819,10416820,10416821,9168900,10418850,10418852,10415890,10415891,9169023,9169024,9169027,9169036,9169044,10418967,10418968,9169056,10419008,10419009,10419010,10419011,10419012,10419013,10419023,10418035,10419055,9161157,10420086,10420089,10420092,9169207,9169216,10418148,10417183,10418191,10417191,9169271,7055441,10417199,7055449,7055452,10418209,7055453,10468980,10468982,10468985,10471005,10471006,10471007,10469010,10471029,10469050,10471066,10469074,10469088,10471120,10469142,10469161,10469200,9166625,9166647,9166656,10469340,10469341,10469342,9166772,10467490,10467491,10469505,10467511,10467531,10467532,10467533,10467539,10467558,10467562,9183003,9175035,10467615,10467622,10467637,10467638,10469669,10467684,10467686,10467761,10467867,10469872,10469873,10467947,10469974,10469975,10469976,10469977,10467981,10469981,10467982,10469983,10469989,10469990,10467990,10469991,10469992,10469993,10469994,10469995,10469996,10469997,10469998,10469999,10470000,10470032,10470033,10470034,10470035,10470045,10470049,10470050,10470051,10470052,10470053,10470054,10470055,10470056,10470057,10464078,9167657,9167687,9167692,10468302,10468314,9167739,9167740,9167741,9167742,9167750,9167751,9167770,9167782,9183787,9167799,9183800,9167818,9167819,9167826,9167828,9167829,9167838,9167839,9167843,9167844,9167850,9167851,9167853,9167899,9175965,9168014,9168018,10468639,10468655,9168099,9168157,10470735,9168159,10470775,9168220,9168227,9168228,10468830,10468831,10470834,10470835,10470836,10470837,10470838,10470839,10946375,10946399,10184608,10946445,10946464,10946712,10946770,10946795,10946828,10946837,10946842,10946857,10946887,10946888,10946897,10946898,10946899,10946911,10947059,10947064,10947071,10947073,10947074,10947076,10947080,10947090,10947093,10947103,10947117,10947120,10947129,10947134,10947144,10947170,10947204,10947205,10947230,10947243,10947295,10947297,10947380,10947391,10947644,10947774,10947789,10947878,10947879,10947899,10948024,10948033,10948096,10948146,10948186,10948195,10948254,10632106,10632109,10632110,10627114,10945540,10945579,10945591,10945599,10945607,10945608,10945609,10945610,10627325,10945724,10945743,10945816,10945817,10945822,10945846,10945851,10945866,10946003,10946086,10946091,10627776,10946152,10946210,10946214,10946244,10630022,10161776,10161782,10161796,10161806,10161825,10161826,10161827,10161833,10161834,10162083,10162103,10162202,10626100,10626103,10167926,10626443,10167990,10626473,10626475,10626476,10168017,10168067,10168068,10945173,10626947,10626954,10581900,10581901,10581902,10581903,10581911,10420253,10420257,10420261,10420265,10420291,10420297,10421522,10421523,10420833,10420835,10420861,10420862,10420864,10420867,10420869,10420870,10420871,10420872,10420873,10420874,10420875,10420876,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10420884,10420885,10420886,10486621,10486680,10489181,10489184,10489185,10489186,10489216,10489217,10489218,10489219,10489221,10474333,10474361,10476443,10476458,10476459,10476460,10476461,10476464,10472514,10472540,10474564,10474595) 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'