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(4970153,4970156,4970160,4970173,4970178,4970186,4970190,4970199,4970206,4970208,4970214,4970221,4970226,4970231,4970232,4970234,4970237,4970244,4970253,4970257,4970259,4970265,4970271,4970278,4970282,4970286,4970291,4970298,4970305,4970307,4970313,4970317,4970328,4970329,4970332,4970335,4970336,4970337,4970338,4970345,4970351,4970352,4970356,4970364,4970374,4970380,4970389,4970410,4970411,4970417,4970423,4970426,4970433,4970435,4970442,4970451,4970458,4970463,4970466,4970467,4970470,4970474,4970480,4970483,4970520,4970530,4970532,4970535,4970542,4970546,4970562,4970566,4970569,4970570,4970571,4970572,4970573,4970574,4970575,4970576,4970577,4970578,4970579,4970580,4970581,4970582,4970583,4970584,4970585,4970586,4970587,4970588,4970589,4970590,4970591,4970592,4970593,4970594,4970595,4970596,4970597,4970598,4970599,4970600,4970601,4970602,4970603,4970604,4970605,4970606,4970615,4970622,4970632,4970633,4970635,4970636,4970639,4970661,4970666,4970667,4970668,4970669,4970673,4970677,4970690,4970692,4970693,4970694,4970695,4970696,4970697,4970698,4970726,4970737,4970739,4970771,4970774,4970777,4970780,4970786,4970787,4970801,4970809,4970811,4970812,4970814,4970820,4970824,4970825,4970828,4970830,4970832,4970840,4970842,4970846,4970852,4970857,4970875,4970898,4970907,4970923,4970929,4970935,4970937,4970939,4970945,4970947,4970950,4970953,4970993,4970996,4971003,4971009,4971012,4971013,4971015,4971016,4971017,4971018,4971037,4971039,4971042,4971045,4971048,4971050,4971051,4971053,4971054,4971055,4971056,4971057,4971058,4971099,4971101,4971107,4971124,4971126,4971127,4971137,4971138,4971139,4971142,4971143,4971147,4968154,4968158,4968174,4968184,4968186,4968195,4968196,4968205,4968206,4968207,4968209,4968220,4968223,4968226,4968228,4968229,4968231,4968232,4968239,4968242,4968245,4968246,4968247,4968250,4968256,4968274,4968275,4968276,4968279,4968281,4968283,4968285,4968286,4968287,4968289,4968294,4968307,4968312,4968316,4968322,4968337,4968344,4968349,4968354,4968357,4968358,4968365,4968378,4968381,4968383,4968385,4968387,4968390,4968391,4968393,4968394,4968398,4968399,4968400,4968402,4968403,4968404,4968407,4968419,4968421,4968425,4968428,4968430,4968431,4968437,4968438,4968439,4968440,4968441,4968446,4968447,4968457,4968480,4968486,4968500,4968513,4968515,4968518,4968523,4968530,4968534,4968541,4968548,4968557,4968560,4968561,4968565,4968566,4968567,4968568,4968569,4968570,4968571,4968572,4968573,4968574,4968575,4968576,4968577,4968578,4968579,4968580,4968581,4968582,4968583,4968584,4968585,4968586,4968587,4968588,4968589,4968590,4968591,4968592,4968593,4968594,4968600,4968604,4968607,4968608,4968611,4968623,4968626,4968634,4968638,4968644,4968655,4968659,4968665,4968679,4968689,4968695,4968698,4968703,4968713,4968719,4968729,4968730,4968731,4968732,4968733,4968734,4968735,4968736,4968737,4968738,4968739,4968740,4968741,4968749,4968753,4968763,4968766,4968767,4968770,4968771,4968781,4968787,4968789,4968794,4968797,4968809,4968812,4968817,4968823,4968832,4968833,4968835,4968837,4968838,4968854,4968872,4968878,4968882,4968892,4968903,4968904,4968907,4968909,4968917,4968932,4968936,4968942,4968957,4968961,4968966,4968967,4968974,4968981,4968986,4968987,4968988,4968989,4968990,4968991,4968992,4968993,4968994,4968995,4969004,4969011,4969016,4969017,4969027,4969028,4969030,4969031,4969040,4969043,4969053,4969066,4969071,4969076,4969077,4969078,4969079,4969080,4969081,4969082,4969083,4969085,4969086,4969087,4969088,4969093,4969099,4969110,4969115,4969116,4969117,4969118,4969119,4969120,4969121,4969122,4969124,4969132,4969135,4969136,4969137,4969138,4969139,4969148,4969152,4969153,4969155,4969168,4969169,4969178,4969179,4969188,4969191,4969193,4969198,4969207,4969214,4969217,4969253,4969259,4969260,4969261,4969265,4969268,4969282,4969283,4969295,4969301,4969304,4969308,4969313,4969315,4969318,4969319,4969323,4969329,4969333,4969343,4969347,4969352,4969353,4969360,4969365,4969376,4969381,4969384,4969389,4969392,4969393,4969401,4969408,4969415,4969416,4969417,4969429,4969434,4969436,4969439,4969451,4969459,4969471,4969476,4969480,4969481,4969483,4969485,4969488,4969494,4969495,4969496,4969497,4969498,4969505,4969506,4969507,4969508,4969516,4969517,4969527,4969534,4969537,4969538,4969546,4969547,4969554,4969556,4969560,4969566,4969568,4969573,4969574,4969578,4969583,4969601,4969604,4969620,4969627,4969630,4969639,4969647,4969652,4969667,4969669,4969670,4969671,4969678,4969684,4969689,4969694,4969700,4969704,4969718,4969728,4969740,4969748,4969751,4969752,4969753,4969754,4969764,4969783,4969786,4969787,4969801,4969808,4969809,4969810,4969811,4969812,4969813,4969814,4969815,4969817,4969821,4969823,4969826,4969836,4969837,4969838,4969839,4969844,4969848,4969853,4969854,4969855,4969856,4969857,4969858,4969859,4969864,4969867,4969871,4969875,4969880,4969882,4969883,4969884,4969891,4969899,4969901,4969906,4969908,4969909,4969911,4969914,4969920,4969927,4969939,4969946,4969948,4969950,4969959,4969963,4969969,4969978,4969980,4970000,4970004,4970012,4970019,4970024,4970037,4970042,4970048,4970051,4970053,4970057,4970058,4970060,4970067,4970078,4970082,4970084,4970087,4970114,4970120,4970126,4970135,4970136,4970137,4970150,8075331,8075466,8075467,8075468,8075469,8075471,4967036,4967042,4967045,4967049,4967052,4967053,4967055,4967056,4967057,4967058,4967059,4967060,4967065,4967070,4967074,4967076,4967078,4967081,4967082,4967084,4967088,4967091,4967092,4967093,4967094,4967095,4967096,4967097,4967100,4967105,4967107,4967110,4967121,4967133,4967137,4967152,4967159,4967162,4967166,4967168,4967171,4967178,4967180,4967201,4967219,4967221,4967225,4967233,4967236,4967238,4967248,4967259,4967265,4967266,4967271,4967289,4967299,4967301,4967302,4967309,4967313,4967322,4967329,4967336,4967343,4967346,4967348,4967349,4967365,4967373,4967378,4967385,4967394,4967414,4967429,4967433,4967437,4967451,4967452,4967455,4967457,4967458,4967459,4967461,4967470,4967471,4967475,4967481,4967482,4967487,4967494,4967497,4967512,4967518,4967526,4967534,4967550,4967555,4967566,4967568,4967571,4967580,4967587,4967588,4967592,4967594,4967597,4967599,4967600,4967611,4967615,4967622,4967625,4967628,4967633,4967635,4967639,4967643,4967647,4967655,4967661,4967671,4967674,4967681,4967688,4967690,4967692,4967701,4967708,4967712,4967713,4967716,4967722,4967729,4967736,4967750,4967760,4967764,4967765,4967770,4967777,4967778,4967785,4967788,4967791,4967804,4967819,4967828,4967833,4967837,4967842,4967848,4967851,4967866,4967867,4967870,4967881,4967889,4967891,4967896,4967902,4967903,4967910,4967911,4967913,4967919,4967926,4967929,4967934,4967936,4967942,4967943,4967947,4967952,4967953,4967955,4967970,4967972,4967974,4967979,4967983,4967985,4967991,4968000,4968005,4968006,4968010,4968012,4968017,4968020,4968022,4968026,4968028,4968040,4968045,4968051,4968061,4968062,4968063,4968065,4968068,4968069,4968071,4968072,4968078,4968080,4968087,4968104,4968109,4968113,4968115,4968119,4968123,4968145,4968149,4968151,8072623,8072624,8072625,8072626,8072627,8072628,8072629,8072630,8072631,8072632,8072643,8072644,8072645,8072646,8072647,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072698,8072699,8072700,8072701,8072702,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,8072753,8072754,8072755,8072756,8072757,8072758,8072759,8072760,8072761,8072762,8072763,8072764,8072765,8072766,8072767,8072778,8072779,8072780,8072781,8072782,8072783,8072784,8072785,8072786,8072787,8072788,8072789,8072790,8072791,8072792,8072969,8072970,8072971,8072972,8072973,8072977,8072978,8072979,8072980,8072981,8073137,8073140,8073141,8073142,8073144,8073145,8073146,8073147,8073148,8073149,8073152,8073153,8073154,8073155,8073156,8073159,8073160,8073162,8073163) 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'