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(10939663,8838594,11015245,11015246,11015247,11015248,11015249,8574792,8574793,8574794,8574795,8574796,8574797,8574798,8574799,11028328,4971101,4971102,4971103,4971107,4971108,4971109,7074015,8631751,8631754,10963976,10963977,10963978,10963979,10963980,10963981,10963982,10963983,10963984,10963985,10963986,10963987,10963988,10963989,10963990,10963991,10964018,8583815,8583816,10964031,8583817,8583818,8583819,8583820,8583821,8583822,8583823,8583824,8583825,8583826,10437214,10437217,10437218,10437219,8067346,10437224,10437225,8067351,8067352,10951007,10951021,10964217,10964218,10964219,10964220,10964221,10964222,10964223,10964224,10964225,10964226,10964227,10964228,10964229,10964230,10964231,10964232,10964233,10964234,10964235,10964236,10964237,10964238,10964239,8067535,3230020,10964292,10964293,10964294,10964295,10964296,8584180,10437565,8575920,8575929,10938626,10938627,10938628,7067032,8837539,7067063,7067064,7067065,7067066,7067074,10929345,7067075,10844827,10929356,10929357,10929382,7067184,7067185,10961982,8573499,8573500,8629972,8629973,8629977,8629981,8629982,8573521,8630001,8630012,8630017,8630021,8630022,8630027,8630029,8630030,11014089,11001121,11001122,11001127,11001128,10962151,10962152,10962153,10929941,10962446,10930053,7201226,8911055,8911056,8617836,8617837,8617838,10998690,8617854,8627738,7072112,8627790,8835668,8835669,7064256,8627902,8627903,8627906,8627917,8627919,8627922,8627930,8627933,10931673,10931674,10931675,10931689,10931710,10931711,10931727,10931728,10931729,3899151,3899152,3899157,8628433,8618673,8836328,8572162,11012676,11012677,8836617,11025829,11025830,11025831,7073149,7073150,10843911,10843961,8836747,8836748,8836749,4967511,4967512,4967513,4967514,10932799,10932800,7202726,8619412,10932934,10932935,10844469,10844470,8066887,11010629,10942632,8626704,8626737,11049147,8626958,11037007,10102462,10102463,8064333,3238217,6000081,6000082,8910930,10998580,10940568,10940569,10944370,7069067,7069068,7069070,7069071,10100207,10840025,10840026,10840066,10840067,10840068,10840069,10840070,10840071,10840072,10840073,10840074,10840075,10840076,10840077,10840078,7198751,8072427,8615756,8565042,10841248,10841249,10841250,10841328,11048484,10942289,11048574,11048585,11048586,10101818,10101819,8834181,8834182,10101825,10101852,10997540,10841675,10841676,10841677,10841678,10841679,10841680,10841681,10841682,10841683,10841684,10841685,11006634,11006635,10837768,10837867,11032826,11032827,10837901,10980874,10980875,10980876,10980877,10980878,10980879,10980880,10980881,10980882,10980883,10980884,10980885,10980886,10980887,10980888,10980889,10980890,10980891,10980892,10980893,10980894,10980895,10980896,10980897,10980898,10980899,10980900,10980901,10980902,10980903,10980904,10980905,10980906,10980907,10980908,10980909,10980910,10980911,10980912,10980913,10980914,10980915,10980916,10980917,10980918,11006960,11006961,11006962,11006963,11006964,11006965,11006966,10623351,10623445,11007225,10838551,8613712,11007834,11007835,10838921,10619256,10619259,10619260,10619261,10994959,4938165,3234994,10927482,10922484,10922485,10922486,10927491,8612019,11005984,8612294,8612295,8612296,8612297,8612298,11032158,8612311,8612312,8612313,8612314,8612315,8612322,10918074,11006325,8612564,10837546,11032611,10951718,10620167,8576330,8576331,10620180,10620181,10620182,10620183,10847930,10847932,10847933,10615229,10951833,11042917,11042918,11030290,11030291,11030292,11030293,11030294,11030295,3582012,3582013,10930661,8576944,10615819,10930869,11017704,11017705,11017706,11017707,11017708,11017709,11017710,10426470,8540687,8540690,3231644,11004959,8540850,8541042,8541106,10427015,10427016,10427017,10427018,10427019,10427020,10427021,10427022,10427023,10427024,10427025,10427026,10427027,10427028,11005379,10927252,10927253,10927254,8541334,3232245,10922444,10922445,10922468,9173348,9173349,9173350,9173351,9173352,9173353,9173354,9173355,9173356,7059546,9173395,9173396,9173471,9173472,9173473,9173474,9173508,9173509,9173510,9173511,9173512,9173513,9173514,9173515,9173516,9173517,9173518,9173519,7019396,7019502,7019520,10714440,7019713,7019784,7019898,10566080,10566081,10566082,9190270,10611961,9171406,9179694,9179695,9179696,9179697,9179698,9179699,9179700,9179701,9179702,9179703,9179704,9179705,9179706,9179707,9179708,10563521,10563522,9179709,9179710,10563523,10563524,9179711,10563525,9179712,10563526,9179713,9179714,10563527,9179715,10563528,9179716,10563529,9179717,9179718,9179719,9179720,9179721,9179722,9179723,9179724,9179725,9179726,9179727,9179728,9179729,9179730,9179731,9179732,9179733,9179734,9179735,9179736,9179737,10612430,10612517,8566434,9195961,9172066,10558052,10558053,10558054,10558055,10558056,10558057,10558058,10558059,10558060,10558061,9196282,9196285,9196286,6676548,6676549,6676550,6676551,6676552,10120555,7058837,7058838,7058937,10558599,8567320,8567321,8567322,8567323,8567324,8567325,8567326,8567327,8567328,8567329,8567330,8567331,8567332,8567333,8567334,8567335,8567336,8567337,8567338,8567339,7018705,9189194,9205254,7018935,7014976,9169351,7015025,7015091,7015144,9209601,4974533,7023348,7023349,7055942,4974670,4974698,4974699,4974700,4974701,4974719,4974720,4974721,4974722,4974723,4974724,4974725,9177902,10515814,10515815,10515816,10515817,10515818,10513853,9162059,10517977,10517978,10517979,10517980,10517981,10517982,10517983,10517984,10517985,10517986,10517987,10517988,10517989,10517990,10517991,10517992,10518108,10518109,10518110,10518111,10518421,10518422,10518423,10518455,10518456,10518457,10518458,10518459,10518460,10518461,10518462,10518463,10518464,10518465,10518466,10518467,10518468,10518469,10518470,10518471,10518472,10518473,10518474,10518475,10518476,10518477,10518478,10518479,10518480,10518481,10518482,10518483,10518484,10518485,10518486,10518487,10518488,7056866,7056867,7056868,7056869,7056870,7056871,7056872,7056873,7056874,7056875,7056876,7056877,7056878,7056879,7056880,10518539,10518540,10518541,10518542,10518543,10518544,10518545,10518546,10518547,10518569,10518570,10518644,10512774,10512775,8552445,10415245,10415246,10417353,10116813,10116814,10116815,10416558,4973551,4973614,4973615,9201073,9209145,7014801,9209157,7014886,7014929,10468887,9198323,6666545,7020300,7020352,6666728,6666730,9174732,9174733,10123016,10123043,6667288,6667289,10123490,8563209,9191312,9191313,9191314,7020997,7021014,9191368,7021111,7021177,7021182,10123787,10115921,10115922,10115923,8917396,8917493,9192037,9192038,9192039,9192040,9192043,9192054,9192055,8551268,10154590,10154591,10154592,10628127,10628128,10628129,10628130,10169699,10169700,10169701,10169702,10169703,10169704,10169705,10169706,10169707,10169708,10169709,10169710,10169711,10169712,10169713,10169714,10628195,10628196,10628197,10628198,10159887,10159888,10159889,10159890,10159932,8594083,8594084,10175573,10175574,10884610,8069164,8069165,10173502,10178710,7000895,7000896,10627355,10945727,10945728,10945729,10945730,10892941,10892942,10892943,10892944,10892945,10892946,10166487,10630085,10630104,10875947,10875948,10875949,10875950,10875951,10875952,10891059,10891155,10891301,10891302,10891303,10891380,10891414,10891415,10891940,10891941,10891942,10891984,10891985,10891986,10891987,10891988,10891989,10891990,10877178,10163361,10163362,10163363,10163364,10163365,10163366,10163367,10173367,10163368,10173368,10163446,10163447,10163448,10580255,10580256,10649823,10649824,10649825,10649826,10649827,10649828,10586938,10586939,10586940,10587321,10569401,10569402,10569403,10570187,10570188,10585189,10585190,10648334,10648335,10648336,10648337,10648338,10573292,10648390,10648391,10648392,10648393,10648394,10648395,10648409,10648410,10648411,10648412,10648413,10648414,10648415,10648416,10648417,10648583,10588741,10588742,10588743,10568004,10543303,10543444,10543445,10543446,10543447,10523736,10523737,10521901,10520124,10520125,10520126,10520127,10520128,10520129,10520130,10520131,10520132,10520133,10546173,10546326,10522775,10522776,10524875,10524876,10535078,10535079,10535080,10535081,10424451,10424474,10420495,10420504,10505592,10506653,10506654,10506655,10506656,10506657,10506658,10506659,10506660,10506661,10506662,10506663,10505855,10505856,10505857,10505858,10505859,10505860,10505861,10505862,10505863,10505864,10505865,10505866,10505867,10505868,10505869,10505870,10505871,10425045,10421069,10488109,10488110,10477300,10490328,10490329,10490339,10490340,10490375,10490376,10481480,10494570,10490590,10473700,10473701,10473702,10473709,10473710,10487181,10487182,10487201,10487202,10489274,10489297,10489298,10493493,10493494,10480494,10480495,10480496,10480497,10480498,10480499,10472621,10472627,10472628,10472629,10472630,10495786) 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'