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(8630658,8630659,8630687,8630689,8630690,8630692,8630693,8630694,8630695,8630696,8630697,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630705,8630706,8630707,8630708,8630709,8630710,8630711,8630712,8630713,8630714,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630743,8630744,8630745,8630746,8630747,8630748,8630861,8630938,8630939,8630943,8630944,8630952,8630965,8630984,8630985,8630986,8631004,8631038,8631046,8631047,8631048,8631050,8631052,8631057,8631071,8631115,8631116,8631118,8631119,8631121,8631150,8631151,8631152,8631157,8631158,8631159,8631160,8631176,8631179,8631183,8631187,8631196,8631211,8631212,8631219,3229188,3229199,3229200,8631482,8631498,8631499,8631500,8631501,8631502,8631512,8631516,8631593,8631594,8631595,8631596,8631597,8631598,8631599,7065955,7065956,7065957,8631606,8631607,8631608,8631609,8631610,8631618,8631619,8631620,8631656,8631857,8631858,8631874,7066239,7066240,7066241,8632358,8632381,8632424,8632425,8632426,8632427,8632428,8632429,8632430,8632446,8632447,8632448,8576049,8632552,8632561,8629630,8629642,8067930,8629693,8629717,8629725,8629748,8629779,8629797,8629851,8629852,8629882,8629883,8629904,8630195,8630268,8630271,8630272,8630273,8630275,8630276,8630277,8630278,8630280,8630282,8630283,8630286,8630287,8630311,8630312,8630419,8630420,8630424,8630443,8630444,8630445,8630471,8630473,8630475,8630477,8627862,8627870,7201500,8627907,8627912,8627913,8627995,8627996,7201604,8628018,8628019,8628020,8628033,8628052,8628053,7201655,7201664,7201665,7201667,8628081,8628093,10960192,8628220,7201840,7201897,8628353,8628424,7202112,7202113,7202114,7202115,7202122,7202125,7202126,7202127,7202132,7202136,7202138,7202161,8628569,7202196,7202197,8628599,8628600,8628601,8628602,8628603,8628604,8628605,7202205,7202206,8628630,8628655,8628659,8628689,8628690,8628737,8628738,8628741,8628747,8628748,8628783,8628787,8628802,8628838,8628839,8628842,8628843,5654590,8628997,8628999,8629000,8629001,8629002,8629003,8629004,8629007,8629029,8629031,8629041,8629056,8629057,8629095,8629109,8629110,8629137,9794588,8629189,8629193,8629196,8629203,8629229,8629242,8629262,8629263,8629282,3227090,8629358,8629364,8629371,8629378,8629395,8629397,8629398,8629440,8629445,8629483,8629484,8629485,8629486,8629487,8629518,8629544,8629569,8629570,8629573,8629574,7200184,8626595,7200208,7200244,8626697,8626698,7200384,7200402,8626816,8626845,8626846,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,8626902,8626903,8626904,8626905,8626906,7200527,8626940,8627006,7200634,8627062,8627063,10985136,8627118,8627119,7200735,10959184,8627221,8627222,8627223,8627224,8627225,8627226,8627227,8627228,8627229,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627239,8627240,8627241,8627242,8627243,8627244,8627246,8627247,8627248,8627249,8627250,8627251,8627252,8627253,8627254,8627255,8627256,8627257,8627258,8627259,8627260,8627261,8627262,8627265,8627266,8627267,8627269,8627270,8627271,8627272,8627273,8627278,8627279,8627280,8627282,8627283,8627284,8627285,8627286,8627287,8627288,8627289,8627290,8627291,8627292,8627293,8627294,8627295,8627296,8627297,8627298,8627299,8627300,8627301,8627302,8627303,8627306,8627310,8627311,8627312,8627313,8627330,8627360,8627373,8627374,8627375,8627383,8627384,8627385,8627386,8627387,8627388,8627389,8627393,8627394,8627396,8627397,7201076,7201097,7201107,7201141,7201151,7198323,7198664,7198693,7198696,7198702,7198710,7198714,7198716,7198726,7198731,7198736,7198750,7198752,7199096,8909147,8909148,7199594,10101579,7199767,11048488,7199919,7200158,7196346,7196347,8613064,8906552,8906673,7196898,7196900,7196901,7196903,7196904,7196906,7196908,7196909,7196912,7196913,8906773,8906795,8906796,8906853,8906854,10968547,10838810,10838921,10838922,10838923,10838924,3234720,7197641,7197851,7198040,7198041,7198043,7198056,7198057,7198058,7198059,7198060,7198061,7198062,7198063,10619897,10617005,10617072,10617088,10617097,10617144,10617145,10617146,10617147,10617148,10617149,10617150,10617151,10617152,10617154,10617159,10622363,8905409,8905410,8905473,10617509,10622525,10622537,8905733,8905785,8905869,8905958,8905959,8905977,10615228,10615290,10615325,10615326,10615334,10615483,10425911,10615583,10425938,10425940,10425941,10615631,10615645,10426012,10615732,10615924,10615925,10615951,10615954,10615969,10615970,10615983,10615984,10426356,10426386,10426416,10426417,10426418,10426423,10426452,10616486,10616487,10616488,10616489,10616562,10616578,8611449,10616665,10616683,10616684,10616779,10616780,10616781,10616782,10616880,10616943,10613987,9165377,10614066,10614094,10614316,6669872,6669892,10614464,10614587,10611655,10611737,10611801,10611802,9166251,10609002,10609003,10612051,7017141,7017142,7017143,7017144,7017145,7017146,7017147,7017148,7017149,7017150,7017151,7017152,7017153,7017154,10612264,10609368,10612411,10612493,10612502,10612503,10612507,10612508,10612509,10612510,10612520,10612524,10612525,10612526,10612527,10612528,10612531,10612532,10612538,10612547,10612551,10612552,10612554,10612555,10612556,10612557,10612558,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612579,10612580,10612585,10612594,10612595,10612596,10612597,10612608,10612609,10612618,10612619,10612624,10612644,10612645,10612651,10609676,10609677,10612697,10612716,10612724,10612725,10612730,10612731,10612732,7017723,7017724,7017725,7017726,10612740,10612755,7017751,7017752,7017753,7017754,10612804,7017796,7017797,10612809,10612836,10612837,10612838,10612839,10612841,10612844,10612845,10612846,10612848,10612853,10612865,10612874,10612875,10612876,10612879,10612880,10612883,10609928,10609930,10609931,10609932,10609933,10609978,10610045,10613055,10613079,10610197,10610274,10610296,10613342,10610362,10610364,10610372,10610373,10613678,10613679,10613680,10613681,10613710,10610793,10613801,10610836,10610862,6673514,6673515,9169357,6673568,6673641,6673708,6673727,9169534,10117752,10117753,9169561,7015418,7015419,7015420,7015421,7015454,7015455,7015474,7015475,7015486,7015487,9169837,7015498,7015499,7015504,7015505,7015516,7015517,7015534,7015535,7015548,7015549,7015550,7015551,7015574,7015575,6674133,7015598,7015599,7015606,7015607,7015622,7015623,6674175,7015646,7015647,6674226,6674227,7056193,6674275,10118289,6674318,6674319,10118325,10118326,10118327,10118517,10516159,7016010,7016011,7016012,7016013,7016020,7016021,7016022,7016023,7016044,7016045,7016046,7016047,7016048,7016049,7016080,7016081,7016082,7016083,7016104,7016105,7016106,7016107,7016120,7016121,7016132,7016133,7016144,7016145,7016152,7016153,9168303,10416256,10417273,10417274,10417275,10417276,6672589,10419388,10419389,10416389,10419390,10416391,10416393,6672689,10415424,6672728,10418473,10415482,10415514,10415642,10418681,7014419,7014444,7014445,7014446,7014447,7014454,7014455,7014462,7014463,7014472,7014473,10418751,10418752,7014504,7014505,7014506,7014507,7014508,7014509,10419780,10419781,10415785,9168869,7014526,7014527,7014528,7014529,7014542,7014543,7014544,7014545,9168895,10418872,10418967,10416971,10416973,10416983,10416984,10419014,10419015,10419016,10419017,9169100,6673333,10117426,9169232,10419165,10470898,10471037,10471097,10471098,10469263,8550015,8550123,10467553,10465711,10465712,10465736,9167390,9167681,9167759,10468499,10462516,10462729,10470847,10888670,10888684,10888922,10888925,10888926,10888929,10888931,10888933,10888938,10889000,10889011,10889012,10889013,10889020,10889021,10889026,10889253,10889332,10889339,10889377,10889378,10889379,10889380,10889381,10889382,10889383,10889384,10889385,10884424,10889470,10889484,10889485,10884503,10884504,10889556,10889565,10889593,10889637,10889638,10889639,10889653,10889765,10884799,10884800,10884822,10889908,10879920,10879931,10889937,10889938,10889940,10889945,10889947,10889948,10889951,10889964,10889977,10890024,10890104,10880220,10885256,10885292,10880304,10885321,10885341,10887522,10882533,10882534,10887551,10882621,10882659,10882888,10882893,10882894,10887908,10887963,10887995,10883022,10888268,10888305,10893369,10888449,10885925,10885926,10885946,10885947,10885956,10886136,10162279,10886601,10886876,10886881,10886903,10887268,10887436,10647352,10647674,10647677,10645873,10527750,10506823,10506824,10407446,10407948,10496641,10408766,10408767,10408771,10409092,10409095) 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'