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,4970155,4970163,4970165,4970166,4970167,4970168,4970169,4970170,4970171,4970172,4970173,4970181,4970182,4970184,4970188,4970189,4970190,4970191,4970192,4970202,4970203,4970215,4970262,4970263,4970264,4970426,4970427,4970428,4970485,4970650,4970711,4970719,4970720,4970721,4970722,4970723,4970729,4970736,4970770,4970782,4970804,4970805,4970806,4970807,4970808,4970809,4970810,4970836,4970837,4970838,4970839,4970840,4970852,4970895,4970899,4970903,4970904,4970913,4970915,4970941,4970946,4970947,4970948,4970951,4970956,4970957,4970960,4970961,4970962,4970971,4970980,4970981,4970988,4970992,4970993,4970994,4970996,4970997,4970998,4971006,4971015,4971024,4971025,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971098,4971099,4971100,4971104,4971105,4971106,4968187,4968232,4968377,4968378,4968379,4968380,4968381,4968382,4968383,4968384,4968385,4968386,4968387,4968388,4968389,4968390,4968391,4968392,4968393,4968394,4968395,4968396,4968397,4968398,4968399,4968400,4968401,4968402,4968403,4968404,4968472,4968473,4968481,4968488,4968489,4968490,4968491,4968492,4968493,4968494,4968495,4968496,4968497,4968498,4968499,4968500,4968501,4968502,4968503,4968504,4968505,4968506,4968507,4968508,4968509,4968510,4968511,4968512,4968513,4968514,4968515,4968516,4968517,4968518,4968519,4968520,4968521,4968522,4968523,4968524,4968525,4968526,4968527,4968528,4968529,4968530,4968531,4968532,4968533,4968534,4968535,4968536,4968537,4968538,4968539,4968540,4968541,4968542,4968543,4968544,4968545,4968546,4968547,4968548,4968549,4968550,4968551,4968552,4968553,4968554,4968555,4968556,4968557,4968558,4968559,4968560,4968561,4968562,4968563,4968564,4968633,4968634,4968636,4968637,4968638,4968639,4968640,4968641,4968642,4968643,4968651,4968872,4968873,4968874,4968888,4968889,4968890,4968891,4968892,4968893,4968894,4968895,4968896,4968897,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,4968926,4968927,4968928,4968929,4968930,4968931,4968932,4968933,4968934,4968935,4968936,4968937,4968938,4968939,4968940,4968941,4968942,4968943,4968944,4968945,4968946,4968947,4968996,4968997,4968998,4968999,4969125,4969157,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969184,4969252,4969257,4969258,4969262,4969270,4969273,4969279,4969282,4969285,4969286,4969287,4969288,4969289,4969290,4969291,4969292,4969293,4969299,4969302,4969312,4969313,4969317,4969326,4969330,4969331,4969332,4969337,4969339,4969342,4969348,4969349,4969350,4969351,4969352,4969353,4969354,4969355,4969356,4969362,4969363,4969364,4969371,4969372,4969373,4969374,4969387,4969388,4969389,4969390,4969399,4969416,4969422,4969434,4969435,4969436,4969437,4969438,4969439,4969440,4969441,4969442,4969443,4969444,4969445,4969446,4969447,4969448,4969452,4969455,4969468,4969471,4969472,4969473,4969474,4969475,4969476,4969477,4969478,4969479,4969480,4969481,4969482,4969483,4969484,4969485,4969486,4969487,4969488,4969489,4969490,4969495,4969499,4969500,4969501,4969502,4969503,4969504,4969506,4969507,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,4969524,4969525,4969526,4969527,4969528,4969529,4969530,4969531,4969532,4969533,4969534,4969535,4969536,4969537,4969538,4969539,4969540,4969541,4969542,4969543,4969544,4969545,4969546,4969550,4969551,4969552,4969553,4969570,4969628,4969631,4969634,4969649,4969656,4969658,4969663,4969670,4969671,4969672,4969680,4969690,4969691,4969692,4969693,4969697,4969698,4969699,4969701,4969705,4969712,4969719,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969728,4969729,4969730,4969738,4969746,4969749,4969759,4969762,4969768,4969772,4969778,4969789,4969793,4969800,4969814,4969816,4969817,4969824,4969832,4969835,4969841,4969842,4969843,4969844,4969845,4969852,4969856,4969870,4969873,4969876,4969890,4969893,4969903,4969917,4969921,4969930,4969933,4969947,4969975,4969979,4969980,4969981,4969982,4969983,4969984,4969985,4969986,4969987,4969988,4969989,4969990,4969991,4969992,4969993,4969994,4969995,4969996,4969997,4969998,4969999,4970000,4970001,4970002,4970006,4970010,4970017,4970022,4970023,4970024,4970025,4970026,4970027,4970028,4970033,4970035,4970046,4970050,4970051,4970059,4970060,4970061,4970062,4970063,4970064,4970066,4970067,4970068,4970069,4970070,4970071,4970072,4970075,4970088,4970095,4970096,4970103,4970105,4970109,4970117,4970118,4970120,4970121,4970122,4970123,4970124,4970125,4970130,4970133,4970141,8074670,8074671,8074672,8074673,8074674,8074675,8074676,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) 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'