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(7067857,7075898,7075899,10845671,10845774,8574227,10939776,11014750,8574297,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970494,4970495,4970496,10448035,4970497,4970498,4970499,4970500,4970501,4970502,4970503,7076167,4970504,4970505,4970506,4970507,4970508,4970509,4970510,4970511,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,4970520,4970521,7068193,8838709,10845982,7068231,10943750,7076243,10846010,10943787,8574469,8574470,8574471,8574476,8574477,8574479,7068302,8574481,8838793,8621140,8574482,8574483,8574484,8574485,8574486,8574487,8574488,8574489,8574491,8574492,8574494,10448193,8574496,8574497,8574499,8574500,8574505,8574507,8838820,8574508,8574510,8574511,8574512,4970672,8574513,8574514,8574515,8574518,8574520,8574523,8574524,8574525,8574526,8574527,8574528,8574529,8574530,8574531,8574532,8574533,8574534,8621195,10448273,4970738,10846212,8838977,7068507,7068508,4970852,8839011,7068536,8839027,10448421,4970904,4970912,10944100,8621448,10963321,10963322,10846403,10944222,10944223,10944224,8583183,10944225,10944226,10944227,10944228,10944229,10944230,8583198,10944300,10846581,10846582,8575027,7073867,7065883,10950540,10933378,10933379,7065968,10950661,8575270,10846859,7066166,7066167,7066168,11002890,10847038,8622142,10950981,10950994,10951006,7066441,7066510,8584002,10847306,8622457,7066663,7066668,10951299,8609565,8609566,8609568,8609569,10847503,7066751,8609602,8609633,7066817,7066820,7066837,7066840,7066845,7066851,7066904,7066957,7074961,10938680,7067060,7075083,7067103,7067129,7067150,7067157,7075175,10844934,10844935,10844936,7067246,7067247,10845016,10845017,7067294,7067350,7067364,7075372,11001063,10447329,10447332,10447333,10447343,7067481,7075488,7075518,10447400,7067533,10447428,10845312,7067582,10845367,7067688,10447599,8620569,7075759,7075761,7075815,10931258,8835334,8835340,10842612,10931310,10103030,7071904,7071935,7071936,7071937,7071940,7071943,7071944,7071946,7071947,10842714,10842726,7071996,7072025,7064026,8835582,10842879,10842881,10842883,7064180,7064197,10959908,10959909,10959910,10959911,10959912,10959913,10959914,10959915,10959916,10959917,10959918,7072234,10959919,10959920,10959921,10959922,10959923,10959924,10959925,10959926,10959927,10931691,10843041,7072325,8065475,10103539,7072433,7064460,7064466,7072535,7072538,10843290,10843325,10843328,10843332,10843339,10843343,7072592,7072596,7072600,7072626,7072643,8065724,7072655,8065725,8065726,8065727,8065728,8065729,7072661,8065730,8065731,8065732,7072728,7072730,7064733,7064749,7072750,7072759,7064787,7064792,10843549,7072819,10843578,7064828,7072839,8618691,7072870,7064887,8065975,7072910,8065979,7072916,10986620,7072944,8066016,7072952,7064973,8836474,7072985,8618831,8618863,8836573,7065092,10104221,7073108,10843863,7073280,10104465,7073400,7073402,7073483,8836998,7073526,7073541,7073553,7065558,4967931,4967932,4967933,4967934,4967935,4967936,4967937,4967938,4967939,7065610,7065614,10961300,7065663,7065681,7065691,7073719,7073730,8837248,7065759,7073789,7065813,7070873,7070892,8834382,7070908,8616755,7070937,7071042,8834608,8834673,8834701,10102357,7071258,7071282,7071284,7071321,7071323,7071324,7071326,7071331,7071363,7071372,7071373,7071382,7071394,7071405,10959092,7071420,10985139,8064589,8064590,8064591,8064592,8064593,8835111,8835233,7071795,7068868,7068869,7068870,7068873,7068885,7068886,7068923,7068960,10944534,7069095,10944640,7069172,8615026,8563990,8563997,3655982,3656017,8615170,3656043,8615194,7069404,10945010,10945032,11009216,10945051,7069563,10945081,7069629,7069696,10996423,10996424,3656431,7069747,8564652,8564653,8564654,8564655,8564707,8615876,8564751,8564756,8564757,7070113,8564908,8564909,7070281,3656982,8616127,3656983,3656984,3656985,3656986,8565017,10101487,8616214,7070404,8616328,7070616,8834285,8612918,10967835,11032876,10623391,10967953,10967954,10967955,8613320,8613359,8613517,10981557,8613732,8613792,8613793,11007750,10619893,8614616,10622140,10617165,10617166,10966840,10917918,10917919,10917920,10917921,10917922,10917923,10966952,11045047,11045048,10622541,10954367,8609676,8609677,8609684,8576186,8609946,8609963,11042857,11042858,10615533,8570365,10952046,8570410,8570452,8610403,10952209,10952281,10921489,10615989,10616066,10930890,10930988,10931021,10965872,10965873,10965874,10916908,8611356,10966297,10966298,10966299,10616790,10616791,10917378,10917379,11018426,11018427,10966431,10966432,10966433,8611628,10616943,8863845,7059494,7059514,9197354,9173354,10611035,7059544,7059583,7059586,7059599,7059614,7059615,10565297,10565298,7059652,10565299,10565300,7059655,7059750,8864123,9189625,9189626,8864149,9197654,9197655,10614323,10611376,10611377,10611378,10611380,10611383,10611384,10611392,10611398,10611404,10611408,10611432,10611440,10611441,10611443,10611445,10611451,10611452,10611459,10611461,9173799,10611464,10611467,10611481,10611482,10611485,10611489,10611492,10611493,10611498,10611500,10611501,10611505,6665841,10611520,10611522,10611526,10611527,10611530,10611538,10611539,10611549,10614552,10611552,10614553,6665889,10614554,10611555,10611564,10611569,10611573,10611575,10611577,10611579,10611580,10611582,10611586,10611587,10611589,10611590,10611607,10611612,10611613,10611640,10611643,10611649,10611659,10611660,6666016,8864633,10566061,10566062,10566083,8861830,8861831,7057541,8861948,8862052,8862092,10609285,7057808,10609307,8862182,10557517,10557518,7057941,8862318,8862341,10612485,8862354,8862355,8862356,7058054,9171901,7058089,7058093,8862477,9195956,7058123,10612738,10612741,10612845,10612883,7058413,8862805,9212290,9196350,10613115,7058639,10558300,7058817,10613349,10561557,10561558,9204809,9196873,8863631,8863635,10515116,4974227,7015058,7015066,4974265,9185543,9185544,7055974,7056012,7056013,4974760,7056099,7056134,9169992,9210144,9178374,9178380,9178391,9178426,9178435,9178438,9178439,9178452,9178461,9178462,9178465,9178474,9178477,7056644,7056663,9178509,9178524,9178528,7056725,9170943,7057115,9210976,7057167,7057178,7057223,7057336,9195234,7014067,7014068,7014069,7014070,7014071,7014072,7014073,7014074,7014075,7014076,9168462,10416443,8918272,7054911,10415796,10415797,10420118,7055363,4974079,9161243,9174388,10466994,10466995,10466996,10466997,10466998,10466999,10467000,10467001,10467002,10467003,10467004,10467005,6666430,4971326,9174602,6666603,8865197,9166762,9166763,6666808,10463446,10463447,10463448,10463449,10463450,10463451,10467466,9174988,9167003,9175006,9175007,9175008,9175009,9175010,9175011,9175012,9175013,9199036,6667038,4972006,4972022,6667193,6667292,9183397,9175408,9175422,8917092,9175483,8563496,8563510,4972502,9175657,8550834,9175826,9175855,6667883,8551066,9208027,9208028,7013851,7013852,9168203,9168206,10470805,9176257,10946379,10946380,10946381,10946382,10946383,10946384,10946385,10174897,10174898,10174899,10174900,10174901,10174902,10160271,10155485,10155486,8594486,10155487,10155488,10175600,10170726,10170727,10170728,10155752,10166388,10156428,10161430,10161431,10161432,10161433,10161434,10161435,10161436,10161437,10161438,10158489,10178503,7000693,7000694,10178551,10173584,7000765,7000815,7000816,10178639,10627277,10178801,10183819,10627328,10178867,10163873,10183900,10178908,7001117,10178955,10178956,10163968,10169025,10159030,10179034,10179339,10179363,10174446,10166522,10176774,10171945,10948870,10948871,10948872,10948873,10948874,10948875,10948876,10948877,10948878,10948879,10948880,10187209,10162281,10172454,10177496,10177551,10177596,10876667,10876668,10876669,10876670,10876671,10876672,10876673,10876674,10876675,10876676,10876677,10177731,10626253,10876769,10876770,10876771,10876773,10187814,10167922,10167927,10167931,10167942,10167947,10167953,10167960,10167961,10167966,10187969,10167973,10167976,10167977,10167978,10167979,10167982,10167985,10167986,10167990,10167993,10167998,10168004,10168013,10168020,10168024,10168029,10168032,10168033,10168039,10168040,10168043,10168044,10168047,10168054,10168055,10168057,10168059,10168061,10168062,10168066,10168072,10178096,10178155,10158155,10188172,10168211,10173238,10178343,10626828,10877364,10877365,10877366,10877367,10877368,10877369,10877370,10877371,10586166,10586167,10574319,10574320,10574321,10574322,10574323,10574324,10568549,10589800,10589823,10590027,10590028,10590029,10590030,10590031,10590064,10590065,10590066,10590087,10590090,10590093,10590094,10590095,10590121,10575765,10588720,10588721,10521286,10521287,10521288,10521289,10521290,10527806,10522061,10536669,10421279,10424457) 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'