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(8068854,8068855,8068856,11014674,11014675,7076123,10989090,11015231,11015261,11015262,11015263,11015264,11015265,11015266,11015268,11028375,11028376,11028377,11028378,10950362,10950363,10950364,10950365,10950366,10950367,10950368,3229191,3229192,3229193,3229194,3229195,3229205,10847081,10847454,3230155,3227423,8837550,8837551,7075323,8620487,11014472,10447679,10447680,10962577,8911062,7201335,7201336,8911153,8911154,10843011,7201659,8618287,8618288,10931898,10931899,7202044,10104047,11012688,11012689,11012690,11012691,11012692,11012693,11012694,11012695,11012696,11012697,11012698,10843776,10843777,8066127,10843914,10843915,11025897,11025898,11025899,11025900,11025901,11025902,8619058,8619065,8619066,8619067,8836746,7202627,7202628,7202703,7202704,11013156,11013157,11013158,11013159,10104616,8619408,8619413,10932970,10932985,10932986,10932987,10844432,10844433,10844434,11013388,11013389,11013434,7065817,10841724,10841725,11036768,10942761,7071139,7071141,7071145,7071151,10958948,11049183,10959033,7200602,10959057,10959064,8910566,11037235,10842369,10842371,10943263,8910718,10102837,8064731,10972454,8910833,6000171,6000172,6000173,6000174,6000175,6000176,6000177,6000178,6000179,6000180,6000181,6000182,6000183,10940590,10940591,10940592,7069098,7069099,8615037,11008972,11008975,11008976,11008977,11008978,10940975,10840137,10840138,8615270,7198692,7198715,7198761,7198772,8072298,8072299,8072300,8072301,8072302,7069650,7198983,7198987,7198991,7199012,8615754,8615758,7069926,11009767,7199417,11035871,11035872,10101373,10942002,10942003,7199636,11036176,11048427,11048428,11048429,11048430,7070567,10971303,7199960,7199961,7199962,7199963,10971434,10997528,10837713,11006673,11045716,7196295,7196302,7196331,10623209,10623210,10623211,10623212,10623213,10623214,7196544,7196545,10618327,7196546,8906665,8906666,8906667,10981394,10981395,10981396,10994405,10994406,7197118,7197119,7197348,7197349,10981799,10838919,10838923,10919727,7197444,4938037,4938038,4938039,4938040,4938041,11008212,8614543,10920274,10920275,10920276,10922511,10922512,10922513,10922514,10617047,8541543,8541544,8541546,11005817,11005822,11005823,11005824,11005825,10836991,11005941,11005948,11005949,8541818,10953992,10953993,10953994,11006014,11045085,11006122,11019139,11019140,10928002,8542054,8905614,10993284,10993285,8542127,8542128,11006308,11006309,11006328,8905879,11019544,11032593,11032594,10837664,10837665,10837666,11032616,11032617,11032618,11032619,10990687,10990688,10990689,10990690,10990691,10990692,10990693,10951650,10990810,10990811,10990812,10620172,8576458,10615312,10615329,10615330,10848134,10848169,10952086,10952087,11004227,10848385,11030338,11030339,11030340,11030341,11004407,10916313,10916314,10916315,10916316,10916317,10916324,10615820,10615910,10916428,10916429,10916430,10916431,10916432,11017580,11017583,11017585,11017587,11017588,11017589,11017590,11017595,10952618,10616088,11017751,11017752,11017753,11017754,11017755,11017756,11017757,11017758,11017759,11017760,11017761,11017762,11017763,11017764,11017765,11017766,8540638,11004967,11004968,10991972,10926847,8904424,8904425,8540885,8540886,8540887,8577621,8611286,8611287,10616479,10616481,10616503,10992165,10992166,10992167,10992168,10992169,10992170,10616512,10992171,10992172,10616518,10616519,10616520,10922031,8611342,8541078,10427055,8541206,11005392,10621755,10621756,10621757,10621758,10621759,10621760,10621761,10621762,10922272,10922273,10922274,10922275,10922282,10917303,10917304,10917305,10917306,10917307,10917308,10917309,8578015,8578018,8904936,9205378,9197436,9197437,9197438,9197439,10614208,9173551,7059732,10611325,10559628,9197862,10122101,10122202,10122203,10122204,9166031,9166032,10614737,6670292,6670293,9166090,9166091,9166092,9166095,10122305,9166113,9166115,9166116,9166119,9198211,8864738,10122425,9190243,9198248,9190254,9171418,7017077,7017078,7017079,7017080,7017081,7017082,7017083,7017084,7017085,7017086,7017087,7017088,7017117,7017118,7017119,7017120,7017121,7017122,7017123,7017124,7017125,7017126,7017127,7017128,9211529,10612203,9171611,10609331,10612344,10612359,10612381,9171732,10612426,10612427,9179850,9179851,9179852,9179853,9179854,10609618,10609619,10609620,10609637,10609638,10609639,10612673,10612720,10612721,10612722,10609750,10612782,9172128,9172164,10609840,10561004,10561005,10561006,7058390,7058391,7058392,10558067,10558090,10558095,9196292,9212309,9212310,9212311,9212313,10609979,10613022,9220342,9212377,10120601,10613079,7058585,9212477,10613271,7058776,7058836,10613368,10120972,10610480,10610481,10613482,10613483,9196821,10561910,8863644,9205272,9205273,10613951,10613952,9201357,4974224,4974233,4974234,4974235,4974236,7015088,7015090,7015095,7015096,7015097,9193476,10117692,9209585,4974521,4974522,4974535,4974536,9161695,9161696,9161697,10117944,4974685,9185872,9185958,9193974,9185983,10515820,10515821,10515822,10513834,10513835,10513836,10513837,10513838,10513839,10513840,10513841,10513842,10513843,10513844,10513845,10513846,10513847,10513848,10513849,10513850,10513854,10513855,10513856,10513857,10513858,10513859,10513860,10513861,10513862,10513863,10513864,10118293,9186701,10118910,10118911,7056964,7016539,7016540,7016541,7016542,7016543,7016544,8552225,7016607,7016608,7016609,7016610,7016611,7016612,7016613,7016614,7016615,7016616,7016617,7016618,7016619,7016620,9202977,7057184,9168309,4973162,10418303,10418304,10418305,10418306,10419363,10124751,10124759,10124790,10124794,10416630,10416631,10416695,10416914,10416915,10416916,10416917,10416918,9169007,10416955,10416956,10420010,10420012,10125312,7055297,10418078,10418079,10117438,9185251,10117456,10117468,10117469,10470888,10470889,10470890,10470891,8549510,10122699,10469143,10122827,10122828,10122829,10122837,10122838,10122839,8550006,10467529,10467530,10467542,6667163,9183185,9183186,9183187,9183188,9183189,10123473,10123474,10123475,10123476,10123477,10463953,10463954,10463955,10123587,10123588,10123589,10123590,10123591,10123592,10123593,10123594,10123595,10123596,10123597,10123598,4972285,4972286,4972287,9183473,9183474,9183475,9183486,9207508,9167545,8917284,10468299,10464346,9167783,9167784,9167785,9167786,10116079,9167922,9167923,10468511,9167945,9167988,9175995,10470659,10154594,10154595,10946438,10179708,10888753,10888754,10888755,10888756,10888820,10888821,10883838,10174901,10628423,10888957,10888958,10628472,10628473,10628474,10628475,10628476,10628477,10889034,10175162,10889232,10889275,10889276,10884354,10889360,10889361,10889372,10889373,10889374,10889375,10889376,10889385,10175412,10889412,10889413,10889414,10889415,10155550,10884615,10884630,10884741,10884742,10884803,10884873,10884941,10882565,10178596,10178598,10178600,10882591,10178603,10158662,10882692,10882694,10178735,10178736,10178737,10178738,10178739,10178740,10178741,10178742,10178743,10178744,10178745,10178746,10178747,10178748,10178749,10882777,10882778,10184048,10184049,10184050,10883252,10184335,10184336,10184388,10184390,10630104,10630244,10630245,10176826,10176830,10176835,10176842,10176844,10176845,10176846,10176853,10176866,10176872,10176878,10176879,10176880,10176881,10176882,10176883,10176884,10176885,10176890,10176900,10176901,10176902,10176906,10176911,10176912,10176913,10176914,10176915,10176916,10176917,10176918,10176919,10176921,10176923,10176924,10166925,10176925,10176926,10176927,10875954,10875955,10172027,10172028,10172085,10172291,10172292,10172293,10172294,10177377,10626143,10626144,10172793,10172794,10172795,10876818,10876824,10876827,10172894,10882041,10882081,10882082,10877101,10877229,10877230,10877231,10631911,10631922,10571149,10571150,10580271,10580272,10580273,10580274,10580275,10580276,10580277,10580278,10580279,10580280,10580281,10580405,10571539,10598755,10589827,10586942,10586943,10586944,10586945,10586946,10586947,10572056,10569162,10569429,10569430,10569431,10569432,10569433,10590619,10569624,10572721,10575920,10570189,10570190,10585191,10570191,10570192,10588614,10588618,10579700,10579701,10579702,10570772,10570773,10570774,10570775,10570776,10570810,10570811,10570812,10570813,10570814,10568007,10568008,10568009,10568010,10568011,10568012,10568013,10568014,10568015,10568016,10568017,10568018,10568019,10568020,10568021,10568022,10568023,10568024,10568025,10527129,10527130,10527131,10527132,10527133,10527134,10527135,10527136,10529443,10521647,10528356,10522524,10532695,10532696,10532697,10532698,10532699,10532700,10532701,10522984,10420316,10420325,10421431,10423746,10422155,10485877,10485878,10485879,10488202,10490351,10490352,10490353,10490362,10490363,10479588,10490717,10490718,10490723,10492757,10492758,10492759,10492760,10492761,10489450,10493495,10495582,10495583,10493584,10480591,10480592,10480593,10472764) 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'