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(10939574,10939581,4970176,10939591,10939611,10939614,4970213,4970214,4970215,4970216,4970217,10939653,4970254,4970279,10939686,4970286,4970287,4970288,4970289,10939697,4970291,10939741,4970334,4970339,4970341,10939770,10939775,10939776,10939790,4970384,10939794,4970451,4970452,4970463,4970477,10939909,10939921,10939952,10939953,10939961,10939980,10939981,10939982,4970576,10939983,4970584,10940000,10940001,4970597,4970598,4970604,4970618,4970625,4970627,4970628,4970629,4970630,4970631,4970632,10940040,4970633,4970634,10940041,4970635,10940049,10940050,10940052,10940053,10940056,4970651,10940074,4970667,4970668,4970671,4970673,4970677,10940091,10940096,10940097,4970698,4970764,4970771,10940180,4970786,4970787,4970791,4970801,4970802,4970817,4970818,4970842,4970843,4970844,10940253,10940257,10940292,4970894,4970901,4970903,4970907,4970909,4970910,4970913,10940363,10940436,10940461,4971070,4971089,4971092,4971120,4971140,4971148,8066925,4968164,8066926,8066927,4968176,4968178,8066939,4968179,4968180,4968182,4968185,4968186,8066954,4968205,4968237,8067025,8067054,8067055,8067061,8067074,8067083,8067097,8067131,8067132,8067133,8067134,4968437,4968454,8067231,8067232,4968474,8067242,4968485,4968488,4968531,8067303,4968545,4968583,4968584,4968643,4968674,4968687,4968693,4968694,4968695,4968697,4968705,4968765,8067542,8067552,4968796,4968817,4968819,4968820,4968821,4968851,4968852,4968854,4968880,8067646,4968921,8067691,4968941,8067734,4968996,4969007,4969061,4969062,4969066,10938491,10938499,4969098,4969099,4969107,10938515,10938518,4969117,4969118,4969126,4969139,10938557,10938567,4969163,10938570,4969166,4969167,10938578,4969172,10938580,4969173,4969174,10938581,4969175,4969182,4969183,10938597,4969204,4969214,10938633,10938642,10938655,10938657,10938665,10938672,4969265,4969271,4969287,10938716,4969318,10938743,10938749,4969355,10938776,10938777,4969376,4969377,10938798,4969429,4969430,4969433,10938840,10938877,10938885,4969504,10938919,4969517,4969521,10938932,10938942,10938947,10938968,10938976,10938986,4969593,10939008,10939014,10939019,10939021,4969624,10939038,4969639,10939047,4969641,10939048,10939050,4969649,4969651,10939060,10939061,10939062,10939063,10939064,10939065,10939066,10939067,4969693,4969694,4969695,10939108,4969709,4969718,4969719,10939127,10939185,10939218,10939220,10939230,10939240,4969860,10939290,4969899,4969900,4969901,4969903,4969904,10939337,10939351,4969946,10939357,4969963,4969964,10939375,10939391,10939392,4969988,4969998,4970000,4970001,4970025,4970053,4970054,10939466,10939469,10939480,10939481,4970087,10939494,10939551,8064967,8064995,8065004,8065031,8065036,8065037,8065038,8065039,8065040,8065075,8065103,8065240,8065241,8065251,8065346,8065353,8065381,8065382,8065478,8065479,8065480,8065536,8065611,8065640,8065678,8075464,8075465,8075466,8075467,8075468,8075469,8075470,8075471,8075472,8065717,8065718,8075501,8075503,8075505,8075507,8065754,8065755,8065756,8065757,8065758,8065759,8075517,8065760,8065761,8075519,8065762,8065763,8065764,8065855,8065857,4967097,8065859,8065872,8065881,8065883,8065887,4967126,8065888,8065889,4967153,4967156,8065920,8065938,4967198,4967221,4967233,8066005,8066010,8066025,8066026,8066029,8066030,8066031,4967289,4967293,8066056,4967329,4967330,4967335,4967342,4967361,8066138,8066139,4967389,8066152,4967401,8066170,8066176,8066193,4967436,8066210,8066211,8066213,4967550,4967551,8066318,4967561,4967562,4967564,4967566,4967574,4967575,4967576,4967578,4967579,4967580,4967597,4967598,4967615,4967618,4967647,4967655,4967659,4967679,4967680,4967723,4967731,8066499,4967743,8066525,4967770,8066537,8066539,8066540,8066541,4967782,4967785,4967786,8066555,8066556,4967898,4967899,4967942,4967944,4967962,4967968,4967969,4967975,4967976,8066793,4968075,4968080,4968096,8063948,8063970,8063975,8064030,8064045,8064046,8064067,8064082,8064149,8064150,8064268,8064288,8064301,8064385,8064390,8064405,8064427,8064555,8064621,8064633,8064634,8064635,8064636,8064637,8064642,8064708,8064815,8064818,8064859,8064873,8064883,3655613,3655614,3655629,3655630,3655631,3655676,3655678,3655679,3655688,3655731,3655791,3655800,3655912,3655917,3655921,3655922,3655926,3655944,3655999,3656052,3656053,3656149,8072317,3656171,3656280,8072788,8072789,8072790,8072791,8072792,8072966,8072967,8072968,8072969,8072970,8072971,8072972,8072973,8072974,8072975,8072976,8072977,8072978,8072979,8072980,8072981,8072982,8072983,8073095,8073529,10622967,10622979,10622981,10622983,10623051,10623054,10623079,10623080,10623111,10623128,10623141,10623175,10623187,10623300,10623319,10623330,10623341,10623352,10623363,10623374,10623377,10623383,10623385,10623392,10623401,10623413,10623424,10623435,10623446,10623465,10623469,10623504,10623547,10623548,10623549,10623550,10623552,10623557,10623595,10623596,10623597,10623598,10623650,10623672,10623673,10623674,10623686,10623687,10623688,10623689,10623690,10623691,10623697,10623702,10623730,10623733,10623743,10623799,10623813,10623816,10623832,10623933,10623934,10623935,10623936,10623937,10623938,10623939,10623940,10623951,10624125,10624126,10624128,10624129,10624135,10624136,10624137,10624159,10624199,10624229,10624237,10624335,10624336,10624337,10624387,10624426,10624429,10624432,10624433,10624457,10624458,10624459,10624464,10624508,10624511,10624513,10624514,10624528,10624529,10624530,10624531,10624532,10624642,10624676,10624685,10624698,10624711,10624713,10624719,10624762,10624765,10624766,10624768,10624838,10624839,10624902,10624903,10624904,10622105,10622156,10622157,10622206,10622312,10622313,10622320,10622416,10622417,10622418,10622533,10622542,10622662,10622676,10622687,10622694,10622696,10622704,10622705,10622707,10622709,10622711,10622712,10622713,10622714,10622718,10622719,10622720,10622721,10622723,10622724,10622726,10622727,10622730,10622731,10622753,10622769,10622770,10622832,10622908,10620057,10620152,10620172,10620177,10620178,10620179,10620181,10620182,10620185,10620224,10620225,10620241,10620254,10620289,10620292,10620307,10620332,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620370,10620371,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620389,10620390,10620391,10620392,10620393,10620394,10620395,10620396,10620397,10620398,10620399,10620400,10620401,10620402,10620403,10620404,10620405,10620406,10620407,10620408,10620409,10620410,10620411,10620412,10620413,10620414,10620415,10620416,10620417,10620418,10620449,10620460,10620461,10620462,10620464,10620694,10620754,10620789,10620799,10620808,10620856,10620915,10620939,10620940,10621074,10621157,10621158,10621197,10621228,10621380,10621386,10621387,10621388,10621397,10621400,10621408,10621411,10621413,10621420,10621792,10621794,10621800,10621801,10621802,10621803,10621833,10621854,10621881,10621882,10621883,10621884,10621944,10565138,10565149,10565152,10565183,10565782,10565794,10565886,10565946,10565947,10565951,10565967,10566029,10566068,10566069,10566070,10563142,10563270,10563306,10563311,10563524,10563525,10563526,10563527,10563573,10563575,10563580,10563623,10563698,10563700,10564128,10564431,10564462,10564559,10564641,10564657,10564674,10564778,10564839,10564840,10564903,10564912,10564915,10564927,10564950,10564955,10564961,10565017,10517401,10517509,10517512,10517513,10517550,10517553,10517554,10517562,10517575,10517576,10517577,10517578,10517579,10517580,10517581,10517582,10517583,10517584,10517585,10517586,10517587,10517588,10517589,10517590,10517591,10517598,10517599,10517600,10517601,10517602,10517603,10517604,10517634,10517636,10517637,10517638,10517847,10517915,10517926,10517927,10517929,10517932,10517935,10517942,10517945,10517948,10517949,10517993,10518026,10518031,10518034,10518039,10518084,10518263,10518268,10518329,10518494,10518536,10518563,10518615,10518621,10518622,10518624,10518626,10518627,10518629,10518630,10518649,10518682,10518701,10518720,10518726,10518736,10518752,10518841,10518884,10518885,10518886,10518887,10518889,10518890,10518903,10518955,10518956,10518957,10518958,10518960,10518961,10518962,10518963,10518964,10518965,10518966,10518973,10518974,10518975,10519092,10519095,10519097,10419562,10419563,10419733,10419882,10419904,10419982,10419986,10420016,10470945,10471316,10471331,10471391,10471393,10471396,10471398,10471559,10471789,10471790,10471796,10471797,10471798,10471839,10471875,10470018,10470618,10470619,10470620,10470715,10470716,10470829,10470843) 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'