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(4970152,4970153,4970154,4970164,4970169,4970170,4970179,4970185,4970191,4970193,4970194,4970195,4970196,4970197,4970198,4970199,4970200,4970201,4970202,4970203,4970205,4970209,4970213,4970216,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,4970260,4970261,4970361,4970362,4970363,4970450,4970579,4970580,4970610,4970611,4970668,4970669,4970672,4970691,4970701,4970708,4970709,4970710,4970714,4970719,4970720,4970729,4970738,4970744,4970761,4970766,4970767,4970798,4970799,4970800,4970801,4970802,4970803,4970825,4970846,4970847,4970849,4970850,4970851,4970853,4970858,4970873,4970874,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970971,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970992,4970993,4970994,4970995,4971001,4971002,4971003,4971004,4971005,4971022,4971023,4971024,4971025,4971026,4971027,4971028,4971030,4971031,4971032,4971033,4971042,4971051,4971053,4971058,4971066,4971067,4971068,4971069,4971070,4971071,4971072,4971098,4971099,4971100,4971106,4971110,4971111,4971125,4971144,4971145,4971146,4971147,4971148,4971149,4971150,4971151,4968211,4968212,4968232,4968304,4968305,4968361,4968362,4968363,4968364,4968365,4968411,4968414,4968415,4968416,4968417,4968418,4968419,4968420,4968421,4968422,4968551,4968552,4968597,4968598,4968599,4968600,4968608,4968616,4968619,4968620,4968621,4968626,4968627,4968633,4968638,4968639,4968640,4968641,4968650,4968655,4968656,4968657,4968658,4968659,4968660,4968671,4968676,4968681,4968682,4968683,4968684,4968685,4968686,4968687,4968688,4968689,4968690,4968691,4968779,4968780,4968781,4968782,4968783,4968841,4968842,4968898,4968899,4968900,4968901,4968902,4968903,4968904,4968905,4968906,4968907,4968908,4968909,4968910,4968911,4968912,4968913,4968914,4968915,4968916,4968917,4968918,4968919,4968920,4968921,4968922,4968923,4968924,4968925,4969090,4969091,4969092,4969093,4969130,4969131,4969156,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969184,4969185,4969186,4969187,4969188,4969252,4969253,4969254,4969255,4969256,4969257,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969266,4969267,4969268,4969269,4969270,4969278,4969282,4969283,4969284,4969285,4969286,4969287,4969288,4969289,4969294,4969295,4969296,4969300,4969301,4969302,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,4969312,4969313,4969314,4969315,4969316,4969317,4969320,4969321,4969324,4969325,4969327,4969328,4969329,4969335,4969336,4969338,4969340,4969341,4969342,4969343,4969344,4969345,4969346,4969347,4969350,4969351,4969355,4969362,4969363,4969364,4969366,4969371,4969372,4969373,4969374,4969375,4969376,4969377,4969378,4969379,4969380,4969381,4969382,4969383,4969384,4969385,4969386,4969387,4969388,4969389,4969390,4969391,4969392,4969393,4969394,4969395,4969396,4969397,4969398,4969399,4969400,4969401,4969402,4969403,4969404,4969405,4969406,4969407,4969408,4969409,4969410,4969411,4969412,4969413,4969414,4969420,4969421,4969422,4969423,4969424,4969425,4969426,4969427,4969428,4969429,4969430,4969431,4969432,4969433,4969434,4969436,4969437,4969438,4969439,4969440,4969441,4969443,4969444,4969445,4969447,4969448,4969449,4969450,4969451,4969452,4969455,4969459,4969460,4969464,4969473,4969486,4969492,4969493,4969494,4969495,4969496,4969497,4969498,4969499,4969500,4969501,4969502,4969503,4969504,4969505,4969506,4969507,4969508,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,4969519,4969520,4969521,4969522,4969523,4969524,4969529,4969531,4969532,4969539,4969540,4969541,4969542,4969543,4969544,4969545,4969546,4969547,4969554,4969555,4969556,4969557,4969558,4969559,4969560,4969561,4969562,4969570,4969614,4969628,4969632,4969633,4969634,4969635,4969636,4969637,4969638,4969641,4969642,4969643,4969644,4969645,4969646,4969647,4969648,4969649,4969650,4969651,4969652,4969653,4969654,4969664,4969665,4969666,4969667,4969668,4969669,4969671,4969672,4969673,4969674,4969675,4969676,4969677,4969678,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969686,4969687,4969688,4969689,4969695,4969696,4969697,4969698,4969699,4969700,4969701,4969702,4969703,4969704,4969705,4969706,4969707,4969708,4969709,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,4969721,4969729,4969735,4969745,4969750,4969751,4969755,4969756,4969757,4969758,4969759,4969760,4969761,4969762,4969763,4969764,4969765,4969771,4969775,4969776,4969777,4969778,4969779,4969780,4969781,4969782,4969783,4969784,4969785,4969786,4969787,4969788,4969789,4969790,4969791,4969792,4969793,4969798,4969802,4969803,4969804,4969805,4969806,4969807,4969818,4969819,4969820,4969821,4969822,4969823,4969824,4969825,4969826,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969834,4969835,4969836,4969842,4969843,4969850,4969858,4969859,4969865,4969866,4969869,4969872,4969874,4969875,4969876,4969877,4969878,4969879,4969880,4969881,4969882,4969883,4969884,4969885,4969887,4969892,4969896,4969900,4969904,4969906,4969907,4969908,4969909,4969910,4969911,4969912,4969913,4969914,4969915,4969916,4969917,4969919,4969938,4969941,4969947,4969948,4969949,4969952,4969956,4969961,4969962,4969964,4969966,4969967,4969968,4969969,4969970,4969971,4969972,4969973,4969974,4969975,4969976,4969977,4969978,4969979,4969987,4969989,4969998,4970002,4970005,4970013,4970014,4970015,4970016,4970017,4970018,4970019,4970020,4970021,4970022,4970023,4970024,4970025,4970026,4970027,4970028,4970029,4970030,4970031,4970032,4970033,4970034,4970035,4970036,4970037,4970038,4970039,4970040,4970041,4970042,4970043,4970044,4970045,4970046,4970047,4970048,4970049,4970054,4970055,4970056,4970057,4970058,4970059,4970060,4970061,4970062,4970063,4970064,4970065,4970073,4970074,4970079,4970081,4970090,4970091,4970092,4970093,4970094,4970095,4970098,4970099,4970100,4970101,4970102,4970103,4970106,4970110,4970112,4970113,4970114,4970115,4970116,4970117,4970118,4970119,4970123,4970128,4970131,4970132,4970134,4970137,4970138,4970139,4970140,4970141,4970142,4970143,4970145,4970146,4970147,4970148,4970149,4970150,4970151,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8074694,8074695,8074696,8074697,8074698,8074737,8074738,8074739,8074740,8074741,8074782,8074783,8074784,8074785,8074786,8074824,8074825,8074826,8074827,8074828,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074902,8074903,8074904,8074905,8074906,8074907,8074908,8074909,8074910,8074911,8074912,8074913,8074914,8074915,8074916,8074917,8074918,8074919,8074920,8074921,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,8075046,8075047,8075048,8075049,8075050,8075092,8075093,8075094,8075095,8075096,8075097,8075138,8075139,8075140,8075141,8075142,8075181,8075182,8075183,8075184,8075185,8075218,8075219,8075225,8075227,8075228) 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'