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(8630461,8630462,8630463,8630464,8630465,8630466,8630467,8630468,10930095,8630470,8630471,8630472,8630473,8630474,8630475,8630476,8630477,8630478,8630479,8630480,8630482,8630483,8630484,8630485,8630486,8630487,8630488,8630489,8630490,8630491,8630492,8630493,8630494,8630495,8630496,8630497,8630498,8630499,8630500,8630501,8630502,8630503,8630504,8630505,8630506,8630507,8630508,8630509,8630512,8630514,8630515,8630516,8630517,8630518,8630519,8630520,8630521,8630522,8630523,8630524,8630525,8630526,8630527,8630528,8630529,8630530,8630531,8630532,8630533,8630534,8630535,8630536,8630537,8630538,8630539,8630540,8630541,8630542,8630543,8630544,8630545,8630546,8630547,8630548,8630549,8630550,8630551,8630552,8630553,8630554,8630555,8630556,8630557,8630558,8630559,8630560,8630561,8630562,8630563,8630564,8630565,8630566,8630567,8630568,8630569,8630570,8630571,8630572,8630573,8630574,8630575,8630576,8630577,8630578,8630579,8630580,8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,7076128,4970738,8569510,8569511,3228957,3229077,3229078,3229130,3229131,3229171,3229285,8583434,8583487,8583488,8583489,8583522,7066178,8575733,8575734,8575735,8067927,8067943,8573316,8573335,8573336,8573337,7201200,7201253,7201309,7201319,7201354,7201366,7201367,7201368,7201377,7201727,7201728,7201729,7201861,7201905,7201906,8911744,7201959,7201974,7201976,7201977,10960474,7202133,7202165,7202168,7202171,7202209,7202210,7202211,7202212,7202213,7202214,7202257,7202285,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,5654588,5654614,5654620,5654621,7202585,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202695,7202696,7202697,7202698,7065457,9794578,9794579,9794580,9794588,9794589,9794592,9794594,3227094,3227207,7200087,3237391,3237392,8616849,7200506,7200507,7200508,7200509,8834762,8834763,7200527,7200528,7200529,7200548,7200607,7200608,8910449,8910450,8910451,7200817,7200901,7200902,10944447,7198360,7198361,7198362,7198363,7198364,7198365,7198366,7198367,7198368,7198369,7198370,7198371,7198372,7198373,7198374,7198375,7198376,7198377,7198378,7198379,7198380,7198381,7198382,7198383,7198384,7198385,7198386,7198387,7198388,7198389,7198390,7198678,7198679,7198680,7198681,7198683,7198684,7198685,7198688,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198727,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198757,7198759,7198760,7198762,7198763,7198764,7198765,7198766,7198769,7198770,7198772,7198785,7199006,7199508,7199575,10101491,10101492,10101534,7200030,10618320,8906900,8906901,10838801,3234663,3234664,3234729,3234730,3235067,7197896,3232382,10617118,10617126,10617138,10617139,10617140,8541521,8541549,10617333,10617334,10617335,10617375,10617376,10617381,10617382,8905384,8612185,10617512,3232910,3232913,3232914,3232915,8542165,8905717,8905718,8905719,8905720,8905721,8542254,8569936,10425386,10425390,10425391,10425393,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10425555,10615339,10615340,10615341,10615342,10951828,10425575,10615363,10425937,10615726,10615727,10615728,10615892,10615896,10426197,10426204,8540418,8540589,8540591,8540612,8540613,8540631,8540633,10616417,10616426,10616644,8611390,8611454,8904798,10616888,10613971,10614048,10614054,10614057,10565319,10614220,10614376,10611377,10611378,10611381,10611396,10611406,10611407,10611408,10611422,10611426,10611432,10611434,10611442,10611443,10611444,10611449,10611457,10611462,10611464,10611466,10611469,10611476,10611477,10611485,10611495,10611498,10611499,10614501,10614502,10611514,10611517,10611521,10611526,10611539,10611544,10611555,10611563,10611578,10611583,10611586,10611605,10611611,10611623,10611640,10611643,10611646,10611647,10611648,10611655,10611658,10611660,10611778,10611782,10611856,6666259,8549450,10612060,10612191,10612192,10612194,10612201,10609285,10612294,10609355,7058247,7058248,7058249,7058250,7058251,7017848,7017849,10612916,10612936,10612937,10612938,10612939,10612941,10612942,10612943,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,10609971,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10613024,10613025,10613026,9172407,10613133,10613235,10613337,10610480,10610481,10613513,10613514,10613527,10613531,10610666,10610729,10610730,10613732,10613733,10613736,10610739,10613739,10613797,10613858,10613859,10613860,10610901,10610954,9169318,6673534,6673535,6673536,6673537,6673538,6673540,6673541,6673542,6673543,6673544,6673545,6673546,6673548,6673549,6673550,6673563,7055541,7055546,9169428,10117634,9169453,10515280,10515281,10515282,9169475,6673685,6673686,6673688,6673689,6673690,6673692,6673694,6673696,6673697,6673698,6673699,7055722,9169586,9169638,9169695,10117904,9169748,10515609,10515610,10515611,10515612,10515613,10118016,10517681,9169939,9169940,9169941,6674175,6674186,6674248,6674249,6674256,6674276,6674278,6674280,6674281,6674285,6674326,6674332,10118374,10118375,10118391,10118392,10514037,10514038,10516160,10516161,10516162,10516163,9178490,9178492,8552191,8552192,8552193,8552194,8552226,10512852,9168305,9168306,9168307,6672514,9168309,6672515,6672592,10419370,9168453,6672683,6672725,10419469,10419470,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419493,10419501,10419502,10419503,10419505,10419506,10419508,10419511,10419514,6672802,10419520,10419522,10419523,10419538,6672829,6672871,6672872,6672885,6672887,6672896,6672897,6672898,6672899,6672900,6672901,9168774,9168775,9168804,6673067,6673105,9168969,9161147,10419174,10419175,10419176,10419177,9169275,6670727,10471172,10123006,8550188,8550264,8550265,8916794,8916798,10469949,10469950,4972257,10470089,9167554,6671809,6671903,6671917,9167779,9167782,9167988,10470721,10470722,10888524,10888552,10888553,10883570,10883571,10883585,10883586,10883591,10883592,10883593,10883623,10893983,10893984,10893985,10893986,10893987,10893988,10889019,10889020,10889021,10884086,10884087,10889231,10889449,10884486,10884493,10884596,10884652,10884653,10874953,10874954,10889997,10890007,10890008,10890048,10885074,10890103,10890104,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890127,10890132,10890133,10890137,10890138,10890140,10890143,10890161,10890162,10890163,10885165,10885166,10885167,10890168,10890173,10890174,10890175,10880304,10880305,10880306,10880307,10880325,10880326,10885347,10885348,10885349,10885350,10885465,10885468,10885469,10632012,10632107,7000826,10627319,10888381,10888382,10883408,10883409,10883415,10883421,10161843,10885956,10885957,10885958,10885959,10886057,10886058,10886059,10886060,10162091,10949057,10891654,10891655,10626299,10626300,10626301,10886818,10886878,10886910,10167934,10167992,10168012,10882007,10882008,10882009,10882010,10887052,10887096,10887097,10877181,10887250,10882284,10882356,10882357,10882358,10882359,10887460,10887461,10643489,10643490,10643504,10598535,10598867,10644403,10647535,10648050,10648051,10579475,10579478,10579479,10582561,10545324,10529398,10529399,10521871,10521872,10521873,10544310,10528350,10543041,10543042,10498367,10421498,10498499,10506819,10506821,10506824,10506825,10407369,10407370,10408988,10409025) 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'