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(4970673,4970674,4970675,4970678,4970679,4970685,4970686,4970705,4970725,4970726,4970727,4970728,4970736,4970758,4970774,4971026,4971027,4971030,4971031,4971032,4971033,4971060,4971061,4971062,4971076,4971081,4968443,4968634,4968672,4968673,4968674,4968675,4968676,4968677,4968678,4968679,4968680,4968681,4968682,4968683,4968684,4968685,4968686,4968687,4968688,4968689,4968690,4968691,4968692,4968693,4968694,4968695,4968696,4968697,4968698,4968699,4968700,4968701,4968702,4968703,4968704,4968705,4968706,4968707,4968708,4968709,4968710,4968711,4968712,4968713,4968714,4968715,4968716,4968717,4968718,4968719,4968720,4968721,4968722,4968723,4968724,4968725,4968726,4968727,4968728,4968729,4968730,4968731,4968732,4968733,4968734,4968735,4968736,4968737,4968738,4968739,4968740,4968741,4968742,4968743,4968744,4968745,4968746,4968747,4968748,4968749,4968750,4968751,4968752,4968753,4968754,4968755,4968756,4968757,4968758,4968759,4968760,4968761,4968762,4968763,4968764,4968765,4968766,4968767,4968768,4968769,4968770,4968771,4968772,4968773,4968774,4968775,4968776,4968777,4968778,4968779,4968780,4968781,4968782,4968783,4968784,4968785,4968786,4968787,4968788,4968789,4968790,4968791,4968792,4968793,4968794,4968795,4968796,4968797,4968798,4968799,4968800,4968801,4968802,4968803,4968804,4968805,4968806,4968807,4968808,4968809,4968810,4968811,4968812,4968813,4968814,4968815,4968816,4968817,4968818,4968819,4968820,4968821,4968822,4968823,4968824,4968825,4968826,4968827,4968828,4968829,4968830,4968831,4968832,4968833,4968834,4968835,4968836,4968837,4968838,4968839,4968840,4968841,4968842,4968843,4968844,4968845,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074706,8074707,8074708,8074709,8074710,8074711,8074712,8074713,8074714,8074715,8074716,8074717,8074718,8074719,8074720,8074721,8074722,8074723,8074724,8074725,8074726,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074748,8074749,8074750,8074751,8074752,8074753,8074754,8074755,8074756,8074757,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8074767,8074768,8074769,8074770,8074771,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074792,8074793,8074794,8074795,8074796,8074797,8074798,8074799,8074800,8074801,8074802,8074803,8074804,8074805,8074806,8074807,8074808,8074809,8074810,8074811,8074812,8074813,8074814,8074815,8074816,8074817,8074818,8074819,8074820,8074821,8074822,8074823,8074824,8074825,8074826,8074827,8074828,8074829,8074830,8074831,8074832,8074833,8074834,8074835,8074836,8074837,8074838,8074839,8074840,8074841,8074842,8074843,8074844,8074845,8074846,8074847,8074848,8074849,8074850,8074851,8074852,8074853,8074854,8074855,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074877,8074878,8074879,8074880,8074881,8074882,8074883,8074884,8074885,8074886,8074887,8074888,8074889,8074890,8074891,8074892,8074893,8074894,8074895,8074896,8074897,8074898,8074899,8074900,8074901,8074902,8074903,8074904,8074905,8074906,8074907,8074908,8074909,8074910,8074911,8074912,8074913,8074914,8074915,8074916,8074917,8074918,8074919,8074920,8074921,8074922,8074923,8074924,8074925,8074926,8074927,8074928,8074929,8074930,8074931,8074932,8074933,8074934,8074935,8074936,8074937,8074938,8074939,8074940,8074941,8074942,8074943,8074944,8074945,8074946,8074947,8074948,8074949,8074950,8074951,8074952,8074953,8074954,8074955,8074956,8074957,8074958,8074959,8074960,8074961,8074962,8074963,8074964,8074965,8074966,8074967,8074968,8074969,8074970,8074971,8074972,8074973,8074974,8074975,8074976,8074977,8074978,8074979,8074980,8074981,8074982,8074983,8074984,8074985,8074986,8074987,8074988,8074989,8074990,8074991,8074992,8074993,8074994,8074995,8074996,8074997,8074998,8074999,8075000,8075001,8075002,8075003,8075004,8075005,8075006,8075007,8075008,8075009,8075010,8075011,8075012,8075013,8075014,8075015,8075016,8075017,8075018,8075019,8075020,8075021,8075022,8075023,8075024,8075025,8075026,8075027,8075028,8075029,8075030,8075031,8075032,8075033,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075058,8075059,8075060,8075061,8075062,8075063,8075064,8075065,8075066,8075067,8075068,8075069,8075070,8075071,8075072,8075073,8075074,8075075,8075076,8075077,8075078,8075079,8075080,8075081,8075082,8075083,8075084,8075085,8075086,8075087,8075088,8075089,8075090,8075091,8075092,8075093,8075094,8075095,8075096,8075097,8075098,8075099,8075100,8075101,8075102,8075103,8075104,8075105,8075106,8075107,8075108,8075109,8075110,8075111,8075112,8075113,8075114,8075115,8075116,8075117,8075118,8075119,8075120,8075121,8075122,8075123,8075124,8075125,8075126,8075127,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075149,8075150,8075151,8075152,8075153,8075154,8075155,8075156,8075157,8075158,8075159,8075160,8075161,8075162,8075163,8075164,8075165,8075166,8075167,8075168,8075169,8075170,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,8075191,8075192,8075193,8075194,8075195,8075196,8075197,8075198,8075199,8075200,8075201,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8075209,8075210,8075211,8075212,8075213,8075214,8075215,8075216,8075217,8075218,8075219,8075220,8075221,8075222,8075223,8075224,8075225,8075226,8075227,8075228,8075229,8075230,8075231,8075232,8075233,8075234,8075235,8075236,8075237,8075238,8075239,8075240,8075241,8075242,8075243,8075244,8075245,8075246,8075247,8075248,8075249,8075250,8075251,8075252,8075253,8075254,8075255,8075256,8075257,8075258,8075259,8075260,8075261,8075262,8075263,8075264,8075265,8075266,8075267,8075268,8075269,8075270,8075271,8075272,8075273,8075274,8075275,8075276,8075277,8075278,8075279,8075280,8075281,8075282,8075283,8075291,8075292,8075296,8075297,8075303,8075304,8075305,8075306,8075310,8075314,8075318,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,4968029,4968121,8073677,8073678,8073679,8073680,8073681,8073682,8073683,8073684,8073685,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073696,8073697,8073698,8073699,8073700,8073701,8073702,8073703,8073704,8073705,8073706,8073707,8073708,8073709,8073710,8073711,8073712,8073713,8073714,8073715,8073716,8073717,8073718,8073719,8073720,8073721,8073722,8073723,8073724,8073725,8073726,8073727,8073728,8073729,8073730,8073731,8073732,8073733,8073734,8073735,8073736,8073737,8073738,8073739,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073749,8073750,8073751,8073752,8073753,8073754,8073755,8073756,8073757,8073758,8073759,8073760,8073761,8073762,8073763,8073764,8073765,8073766,8073767,8073768,8073769,8073770,8073771,8073772,8073773,8073774,8073775,8073776,8073777,8073778,8073779,8073780,8073781,8073782,8073783,8073784,8073785,8073786,8073787,8073788,8073789,8073790,8073791,8073792,8073793,8073794,8073795,8073796,8073797,8073798,8073799,8073800,8073801,8073802,8073803,8073804,8073805,8073806,8073807,8073808,8073809,8073810,8073811,8073812,8073813,8073814,8073815,8073816,8073817,8073818,8073819,8073820,8073821,8073822,8073823,8073824,8073825,8073826,8073827,8073828,8073829,8073830,8073831,8073832,8073833,8073834,8073835,8073836,8073837,8073838,8073839,8073840,8073841,8073842,8073843,8073844,8073845,8073846) 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'