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(8836226,7076296,10250801,10250831,4970957,8836681,8836705,8836715,8619225,7065946,10104653,10104654,7074036,8619446,8837101,7074099,8837102,10277428,10277429,10277430,10277459,10277460,7074264,7074277,10277648,8619856,8619965,10251896,8620049,8620050,10251970,10264987,10264988,10264989,10264990,10264991,10264992,10264993,10264994,10264995,10264996,10264997,10264998,10264999,10265000,10265001,10265002,8620172,8620173,8620174,10213053,8617253,10262135,8910515,8910516,10102630,8617352,8617444,8617445,10102850,10197465,8617623,10197520,8617667,10197545,8617769,10197743,10197744,10197745,10197746,10197761,10197762,10197763,10197850,8617977,10262955,10262956,10262957,10262958,10262959,10262960,10262961,10262962,10262963,10262964,10262965,10262966,10262967,10262968,10103408,7071860,10260268,10260269,10260270,10260271,10260272,10260273,10260274,10260275,10260276,10260277,10260278,10260279,10260280,10260281,8615428,8615445,7072187,8615630,7064394,7072566,7072599,8909263,7072797,10235115,7072890,10209173,10261180,10261181,10261182,8616313,7073012,10209268,7073037,10235278,10235279,7073065,10209304,10209305,8909752,8909773,10196452,10261457,10261458,10235491,10235492,10222500,10222501,10222520,8909907,10222668,10222669,10222670,10222671,10261716,8617058,10261939,10261940,10261941,8617084,8617125,10272061,10272062,8860733,10272103,10272106,7070873,7070874,10272131,10207143,10207144,10207145,10207146,10942730,10942734,8907618,8907619,10272355,10272356,10272379,7071168,7071169,10259408,10259409,8861112,7071217,10272460,8907853,8907854,8614674,10272619,10100119,10246730,10246731,10207827,10272848,7071627,10207866,7071628,10272942,7071768,7071769,10221046,10221047,10221048,10221049,10221050,10221051,10221052,10221053,10221054,10221055,10221056,10221057,10221058,10221059,10221060,10205274,10205275,10205468,10205469,10283470,10205470,10205471,10205472,10205473,10205474,10205475,10205476,10205477,10205478,10205479,10205480,10205481,10218496,10257641,10270642,10270663,8906054,10270790,10270791,10270792,10270793,10270794,8906166,7069593,10941331,7069726,8906333,10244997,10245015,10245016,10245077,10245078,10271251,10271252,10271253,10232404,10232405,10232406,10232414,10232415,10232416,10232417,10232418,10232419,10232453,10232454,10206467,10206468,10206469,10232555,10206623,10206624,10206625,10258656,10258657,10232657,10258658,10258659,10258660,10258661,10232690,10232709,10206768,10206769,10206770,10284822,10284828,10206843,10271861,7070654,7070656,7070660,7070662,7070665,7070666,7070668,7070669,10245913,10271920,8614047,10271921,8614048,10271922,10271923,10271924,7070720,7070724,7070725,7070727,10272060,10617995,8576578,8576579,8576580,10229113,10242119,10242120,10618040,10618041,10618042,10618043,10618104,10618105,10229221,10268311,8576902,10242453,10242454,10242455,10433324,8576995,10268555,10268556,10255595,10255596,10255597,10255598,10255599,10255600,10242665,10242666,10242667,10242668,8577144,8577145,10268760,10268761,10268762,10268763,10268764,10268765,10268766,8577235,10268767,10242808,8577297,8904224,10242898,8577379,8577380,8577381,8904351,10243047,10243116,10243117,10269227,10269228,10269229,8577816,10243352,10243353,8577849,10243396,10243397,10243398,10243860,10243861,8575588,8575600,10617054,10617056,10617116,10617117,10241251,10617166,10267288,10267289,10267290,10267291,8584061,8584069,10241443,10622417,10241644,10241645,10241646,10928227,10928228,10928229,10928230,10928231,10928232,10241864,10228950,10228951,10228958,10228959,10228960,10228961,10228962,10228963,10228964,10228965,10228966,10228967,10228968,10228969,10228970,10228971,10228972,10228973,10228975,10228976,10242009,10615001,10615002,10920562,10920583,8573689,8573716,10920693,8838049,8838050,8573777,8573778,10920752,8838116,8838117,8838118,8838119,8838120,10615269,10615289,8838196,10615335,10620402,10920972,10920973,10920974,10620537,10620538,10921062,10921063,10921064,10921065,10921066,10447821,10615568,10615569,10447879,10213864,10213865,10448032,10253129,10253130,10253131,10921557,10240249,10240250,10253345,10253346,10253347,10921775,10921932,10922025,10922026,10240654,10616596,10253804,8583648,10253922,10240928,10240929,10240930,10240931,10240932,10279970,10614201,10614357,9189994,9189995,10562920,10562921,10562922,10562923,10562924,9171327,9171347,9195356,9195357,9195359,9203367,9203368,9195379,10612053,9195432,9195433,9211463,9203465,9203466,9187466,9187468,10612191,10612192,9195538,9195539,9195540,10612201,9187575,9187576,9187577,9187605,7057797,9211658,9203668,9203669,10557508,9195704,9203745,9203746,9203747,9195765,9195766,9195767,9195768,9203786,9187786,9203787,9187787,10563694,10563695,9187893,9187894,9187914,9203946,9187980,10563794,10563795,10563796,10563797,9196073,10612737,10612745,10612746,10612747,10612748,10612752,10612753,9188146,10612821,9172175,9204295,9204315,9204316,9204317,9204346,9204347,9204348,9204460,9204477,9204478,9204533,10613235,8863195,9189054,9185374,9185375,9185384,9185387,9185394,9185395,9185414,9185420,9185427,9185428,9185432,9185433,9185444,9185445,9185446,9185447,9185448,9185449,9185450,9185451,9185452,9185453,9185454,4974319,9185466,9185467,9185468,9185469,9185470,9185471,9185472,9185476,9185477,9185478,9185479,9185480,9185481,9185482,10515322,10515323,10515324,10515325,9185584,9185592,9169641,9193643,9193701,9193702,9193765,9193875,7023558,9194072,9194073,9194074,9194075,9202187,10514158,10514159,10514160,10514161,10514162,10514163,10514164,10514165,9194468,9194469,9202560,9194577,9194578,9194709,9202726,9202727,9202728,9194824,9194825,9194826,9194827,9194828,9194829,9194830,9202845,9202846,9202847,7057090,10516989,10516990,9171251,9171252,9195255,9195256,9171303,9160466,9160467,9160468,9160469,7022159,7022160,7022161,7022162,7022163,7022164,7022165,7022166,9176520,9176558,9176645,9200700,9200701,9200730,9200731,9200732,9200735,9200830,4973712,9200971,9208990,9177033,10417102,7014842,7014843,7014844,7014845,7014846,7014847,9201197,10417121,10417122,7014918,7014919,7014920,7014921,7014922,7014923,7014924,7014925,9190636,9191574,10470374,8917521,10470475,9199985,9199986,10470587,7021774,6668122,10174531,10179666,10179667,10164777,10628268,10628269,10628270,10179963,10165050,10175078,10175079,10175080,10175081,10175082,10180087,10180088,10180089,10165168,10165169,10165540,10165541,10165542,10170624,10165681,10170699,10180897,10171028,10629539,10171076,10181190,10181191,10875267,10629836,10629909,10632050,10183735,10183736,7000924,7001168,10154008,10154009,10154010,10164216,10164217,10164218,10164219,10164220,10164221,10164222,10164223,10164224,10164446,10174482,10166587,10166842,10166843,10166896,10182015,10167019,10167070,10167071,10167072,10167073,10167074,10167075,10182186,10167240,10167317,10172326,10172343,10182463,10182581,10182582,10177779,10182783,10183064,10183128,10183240,10183308,10183393,10577206,10577380,10577381,10577382,10577383,10577384,10577385,10577386,10577387,10577388,10577389,10568604,10568605,10568606,10568607,10568608,10568609,10571762,10571763,10571764,10571765,10574815,10577833,10577834,10577835,10577836,10577837,10574838,10577838,10574886,10574887,10599026,10599027,10599028,10599029,10599030,10578151,10590190,10590191,10578391,10575414,10590507,10569511,10578564,10578565,10578566,10578567,10575676,10575677,10569862,10578865,10578866,10581923,10581924,10581941,10579070,10579071,10576193,10579583,10576675,10576676,10576677,10576678,10571046,10571047,10571048,10577098,10523367,10523368,10523369,10523370,10523371,10523372,10523373,10523374,10523375,10523376,10523377,10523378,10523379,10533691,10533692,10533693,10533694,10529749,10529750,10529751,10529752,10529753,10529771,10529772,10529773,10529774,10529775,10529776,10529777,10529778,10529779,10529790,10529791,10527793,10529795,10529796,10529797,10529798,10529799,10529800,10529801,10529802,10529803,10529804,10529805,10529806,10529807,10529808,10529809,10529810,10529811,10529812,10529813,10529814,10529815,10529816,10529817,10529818,10529819,10529820,10529821,10529822,10529823,10529833,10529975,10524312,10524313,10536614,10528780,10528781,10528782,10424389,10424390,10424391,10424392,10424393,10424394,10424395,10424396,10424397,10424398,10424399,10424400,10424401,10424403,10424405,10424407,10424408,10424409,10424410,10424411,10424412,10424413,10424415,10424416,10424417,10424418,10424419,10424420,10424421,10424423,10424424,10424426,10424427,10424428,10424429,10424430,10424431,10424432,10424433,10424434,10424435,10424436,10424437,10498382,10498383,10498384,10424673,10480876,10487915,10487996,10488083,10481518,10477894,10477895,10481958,10481959,10481960,10481961,10481962,10478008,10478009,10478060,10478108,10478109,10478178,10478393,10478394,10482779,10482802,10480875) 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'