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,10939580,10939581,4970176,10939611,10939614,4970213,4970214,4970215,4970216,4970217,10939653,4970254,4970279,10939686,4970286,4970287,4970288,4970289,10939697,4970291,4970334,4970339,4970341,10939770,10939775,10939776,10939790,4970384,10939794,4970402,4970403,4970404,4970405,4970406,4970410,4970411,4970412,4970413,4970414,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970425,4970426,4970427,4970428,4970429,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970440,4970442,4970444,4970446,4970448,4970451,4970452,4970463,4970477,10939921,10939952,10939953,10939961,10939980,10939981,10939982,10939983,10940000,10940001,4970598,4970627,4970628,4970629,4970630,4970631,4970632,10940040,4970633,10940041,4970634,4970635,10940049,10940050,10940052,10940053,4970647,10940056,4970649,4970650,4970651,4970652,4970653,4970654,4970658,10940074,4970671,4970673,4970681,4970683,10940091,4970686,10940096,10940097,4970698,4970764,4970768,4970771,10940180,4970787,4970791,4970801,4970802,4970817,4970818,4970842,4970843,4970844,10940253,10940257,4970879,4970880,10940292,4970894,4970901,4970903,4970907,4970909,4970910,4970913,4970954,4970955,10940363,10940436,10940461,10940473,4971070,4971089,4971092,10940500,10940501,4971120,4971140,4971148,8066914,8066915,8066916,8066917,8066918,8066919,8066920,8066925,4968164,8066926,8066927,8066937,4968176,8066939,8066940,8066941,8066942,8066943,8066944,8066945,8066946,4968186,8066947,8066948,8066949,8066950,8066951,8066952,8066953,8066954,8066957,8066958,8066959,8066962,8066963,8066964,8066965,4968205,8066967,8066968,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,8067407,8067408,4968648,4968649,8067412,8067413,4968674,4968687,4968693,4968694,4968695,8067457,4968697,4968705,4968765,8067542,4968796,4968817,4968819,4968820,4968821,4968851,4968852,4968854,4968880,8067646,4968921,8067691,4968941,8067732,8067733,4968996,4969007,4969061,4969062,4969066,10938491,10938499,4969098,4969099,4969107,10938515,10938518,4969117,4969118,4969126,4969139,10938557,10938567,4969163,10938570,4969166,4969167,10938578,4969172,4969173,10938580,10938581,4969174,4969175,4969182,4969183,10938597,4969204,4969214,10938633,10938642,10938655,10938657,10938665,10938669,10938670,10938671,10938672,4969265,10938673,10938674,10938675,4969271,4969287,10938716,4969318,10938743,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,4969693,4969694,4969695,4969709,4969718,4969719,4969860,4969899,4969900,4969901,4969903,4969904,4969946,4969963,4969964,4969988,4969998,4970000,4970001,4970025,4970053,4970054,4970087,8075464,8075465,8075466,8075467,8075468,8075469,8075470,8075471,8075472,8075501,8075503,8075505,8075507,8075517,8075519,4967097,4967126,4967153,4967156,4967198,4967221,4967233,4967289,4967293,4967329,4967330,4967335,4967342,4967361,4967389,4967401,4967436,4967550,4967551,4967561,4967562,4967564,4967566,4967574,4967575,4967576,4967578,4967579,4967580,4967597,4967598,4967615,4967618,4967647,4967655,4967659,4967679,4967680,4967723,4967731,4967743,4967770,4967782,4967785,4967786,4967863,4967864,4967865,4967866,4967867,4967868,4967869,4967870,4967871,4967872,4967873,4967874,4967875,4967877,4967878,4967879,4967880,4967881,4967882,4967883,4967884,4967898,4967899,4968075,4968080,4968096,8072317,8072778,8072779,8072780,8072781,8072782,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,10623128,10623141,10623175,10623187,10623192,10623193,10623196,10623197,10623319,10623330,10623341,10623352,10623363,10623374,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623392,10623401,10623413,10623424,10623435,10623446,10623465,10623466,10623467,10623468,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,10623788,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,10624802,10624838,10624839,10624902,10624903,10624904,10621983,10621984,10621989,10621990,10621991,10622008,10622009,10622015,10622018,10622019,10622024,10622025,10622049,10622050,10622051,10622060,10622061,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622071,10622072,10622073,10622074,10622075,10622076,10622077,10622078,10622081,10622082,10622083,10622089,10622090,10622091,10622092,10622094,10622096,10622103,10622104,10622105,10622109,10622111,10622113,10622114,10622118,10622119,10622120,10622121,10622125,10622129,10622131,10622132,10622156,10622157,10622206,10622312,10622313,10622320,10622416,10622417,10622418,10622518,10622519,10622520,10622521,10622542,10622662,10622676,10622687,10622694,10622696,10622704,10622705,10622707,10622709,10622711,10622712,10622713,10622714,10622718,10622719,10622720,10622721,10622723,10622724,10622726,10622727,10622729,10622730,10622731,10622753,10622769,10622770,10622832,10622908,10620057,10620085,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,10620419,10620420,10620421,10620422,10620423,10620424,10620425,10620449,10620460,10620461,10620462,10620464,10620694,10620754,10620789,10620799,10620808,10620856,10620862,10620863,10620915,10620939,10620940,10621074,10621157,10621158,10621197,10621228,10621357,10621358,10621792,10621794,10621800,10621801,10621802,10621803,10621833,10621854,10621881,10621882,10621883,10621884,10621944,10565138,10565152,10565183,10565782,10565794,10565886,10565946,10565947,10565951,10565967,10566029,10566068,10566069,10566070,10563142,10563270,10563306,10563311,10563385,10563386,10563387,10563388,10563389,10563390,10563391,10563392,10563524,10563525,10563526,10563527,10563573,10563575,10563580,10563623,10563698,10563700,10564431,10564462,10564559,10564641,10564657,10564674,10564831,10564839,10564840,10564903,10564912,10564915,10564927,10564950,10564955,10564961,10565017,10517401,10517509,10517512,10517513,10517550,10517553,10517554,10517634,10517636,10517637,10517638,10517643,10517646,10517647,10517648,10517847,10517935,10517993,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,10419684,10419723,10419733,10419882,10419904,10419982,10419986,10420016,10420074,10470945,10471282,10471283,10471316,10471331,10471391,10471393,10471396,10471398,10471462,10471464,10471465,10471470,10471551,10471557,10471559,10471789,10471790,10471796,10471797,10471798,10471839,10471875,10470018,10470584,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'