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(10447821,10447879,10448032,10846013,7076296,10846452,4970957,3229175,10976570,8621766,7065946,7074036,7074099,8583648,8067159,8067160,8067161,8067162,8067163,8067164,8067165,8067166,8067167,8067168,7074264,7074277,8575588,8575600,8067517,8584061,8584069,10977286,10977287,11016292,11016293,11016294,11016295,11016296,10847594,3230313,8619856,10961755,10961756,8619965,10961857,8620049,8620050,8620172,8620173,8620174,8620251,8620266,8620294,8620315,8573689,8573716,8838049,8838050,8573777,8573778,8838116,8838117,8838118,8838119,8838120,8838196,11014527,10972707,10842815,10842816,10972807,8617977,10972843,10972844,7072187,10103408,10986060,10986061,7064394,10986078,10843312,10843315,7072566,7072599,11012293,11012371,8836226,10960439,7072797,7072890,7073012,7073037,7073065,8836681,8836705,8836715,5654658,8619225,10104653,10104654,8619446,8837101,8837102,10844400,10961425,10961426,10961427,10961428,10844561,10844562,10844563,10844564,10984630,10984631,10984632,10984633,10984634,10984635,10984636,10984637,10984638,10984639,10984640,10984641,10984642,10984643,10984644,3237395,10942730,10942734,7071168,7071169,7071217,8617058,11049134,8617084,8617125,8617253,8910515,8910516,10102630,8617352,8617444,8617445,7071627,7071628,11011352,10102850,7071768,7071769,8617623,8617667,7071860,7201153,7201154,7201179,8617769,10100119,7198332,10969976,10969977,10969978,3235813,10970158,10970159,10970160,8615428,7069593,8615445,10970301,10970302,10970303,3656224,3656225,3656226,10970376,10941331,7069726,8615630,11035482,10970674,10970675,10970676,10970677,3236552,8909263,11023036,10841208,8616313,7070654,7070656,7070660,7070662,7070665,7070666,7070668,7070669,10971354,8909752,10971392,8909773,7070720,7070724,7070725,7070727,8909907,11048769,7070873,7070874,10617995,8906054,7196251,7196252,10618040,10618041,10618042,10618043,10618104,10618105,8906166,7196401,8906333,7196553,11007367,11007368,7196947,7196948,10994508,10994509,10994510,10994518,10994519,10994520,10994521,10994522,10994523,3234356,10968784,10968785,11046826,11046832,8614047,8614048,7197480,10968969,10968970,10968971,10968972,10968973,10968974,10968975,10968976,10968977,10968978,10968979,10968980,10981989,10920031,10920032,8907618,8907619,8907853,8907854,8614674,10839665,11005691,10617054,10617056,11018757,10617116,10617117,10617166,10622417,10928227,10928228,10928229,10928230,10928231,10928232,11045607,10615001,10615002,10920562,10920583,10920693,10920752,10615269,10615289,10615335,10620402,8576578,8576579,8576580,10920972,10920973,10920974,10620537,10620538,10921062,10921063,10921064,10921065,10921066,10615568,10615569,10848332,10848333,10848334,10848335,10848336,10991341,10991342,10991348,10991349,10991350,10991351,10991352,10991353,8576902,10952386,10991474,8576995,10991579,8577144,8577145,10921557,8577235,8577297,8904224,8577379,8577380,8577381,10921775,8904351,10921932,10922025,10922026,10616596,8541127,8541130,8577816,8577849,6677627,10611151,10611152,10611159,10611160,10611161,10614201,6677859,6677860,6677861,6677862,6677863,10614357,6678189,9189994,9189995,6678263,6678264,6678265,10562920,10562921,10562922,10562923,10562924,10122436,6678499,9171303,9171327,9171347,9195356,9195357,9195359,9203367,9203368,9195379,10612053,9195432,9195433,9211463,9203465,9203466,9187466,9187468,10612191,10612192,10612201,9195538,9195539,9195540,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,10609827,9172175,9204295,9204315,9204316,9204317,9204346,9204347,9204348,9204460,9204477,9204478,9204533,10613235,8863195,6676956,10610491,6677236,9189054,10610862,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,10117680,10515322,10515323,10515324,10515325,10117724,10117725,9185584,9185592,9169641,9193643,9193701,9193702,9193765,6673997,10126007,10126008,10118037,9193875,7023558,10555812,10555813,10555814,9194072,9194073,9194074,9194075,9202187,10118541,10514158,10514159,10514160,10514161,10514162,10514163,10514164,10514165,10556265,10556266,10556267,10556268,10556269,10556270,10556271,10556272,9194468,9194469,9202560,9194577,9194578,10556432,10556433,10556434,10556435,10556436,10556437,10556438,10556522,9194709,10556523,10556524,10556525,10556526,9202726,9202727,9202728,9194824,9194825,9194826,9194827,9194828,9194829,9194830,9202845,9202846,9202847,10556676,10556677,10556678,10556679,10556680,10556681,10556682,10556683,10556684,10556685,10556686,10556687,10556688,10556689,10556690,10556691,10556692,10556693,10556694,10556695,10556696,10556697,10556698,7057090,10556922,10556923,10556924,10516989,10516990,10557019,9171251,9171252,9195255,9195256,10124527,9160466,9160467,9160468,9160469,10124697,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,10123332,10123388,10123389,3963615,9191574,10470374,8917521,10470475,9199985,9199986,10470587,10124304,10124305,7021774,6668122,10462723,10462724,10462725,10462726,10462727,10124404,10174531,10883641,10179666,10179667,10883658,10164777,10628268,10628269,10628270,10179963,10884035,10165050,10175078,10175079,10175080,10175081,10175082,10180087,10180088,10180089,10165168,10165169,10884214,10884215,10884216,10884217,10884218,10884219,10884220,10165540,10165541,10165542,10170624,10165681,10170699,10884788,10180897,10171028,10629539,10171076,10181190,10181191,10875267,10629836,10629909,10632050,10183735,10183736,7000924,7001168,10154008,10154009,10154010,10888045,10888171,10164216,10164217,10164218,10164219,10164220,10164221,10164222,10164223,10164224,10888339,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,10887309,10882352,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,10577838,10574838,10574886,10574887,10599026,10599027,10599028,10599029,10599030,10599031,10599032,10599033,10599034,10599035,10599036,10599037,10578151,10590190,10590191,10599313,10599332,10599333,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,10540724,10540767,10528780,10528781,10528782,10540843,10540873,10540874,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,10493885,10487915,10493926,10493994,10487996,10488083,10494115,10494236,10481518,10477894,10477895,10496935,10481958,10481959,10481960,10481961,10481962,10496983,10478008,10478009,10497038,10478060,10478108,10478109,10478178,10478393,10478394,10493404,10495500,10493721,10482779,10482802,10493835,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'