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(10939664,4970443,4970447,4970449,10939943,10939977,10939978,10939979,10940037,10940051,4970651,4970653,4970677,4970681,4970700,4970733,4970741,4970747,4970771,10940203,10940264,4970908,4970963,4970967,10940473,4971070,4971072,10940495,10940499,4971113,8066918,8066937,8066939,8066954,8066963,4968202,4968203,8066975,8067170,8067171,8067179,8067180,4968433,4968436,8067198,4968437,4968459,4968615,8067394,4968648,4968649,4968672,4968692,4968706,4968720,4968801,4968930,8067734,8067796,8067806,8067820,8067821,8067822,10938480,10938494,4969130,10938564,10938565,10938577,10938579,10938600,10938672,10938673,4969298,10938721,4969318,10938846,10938847,10938849,10938852,10938870,10938871,10938872,10938874,10938875,10938890,4969500,10938932,10938952,10939066,10939083,10939084,10939119,10939375,8065039,8065123,8075256,8075267,8065693,8075463,4967062,4967115,4967127,8066004,8066067,4967344,4967396,8066417,8066418,8066419,8066439,8066440,4967739,4967986,4968024,4968080,8066896,8066898,8066901,8066902,8066903,8066905,8066907,8066909,8066910,8066912,8063945,8063946,8064547,8064550,8064553,8064555,8064556,8064559,8064565,8064650,8064854,3655562,3655573,3655613,3655680,3655735,3655741,3655787,3655810,3655812,3655912,3655980,3655990,3656052,3656143,3656144,3656148,3656150,8072315,3656297,3656418,3656511,3656514,3656541,3656554,3656555,3656560,3656569,8072778,8072779,8072780,8072781,8072782,3656629,3656655,3656696,3656734,8072935,8072936,8072937,8072938,3656774,8072939,8072940,8072941,8072942,8072943,8072944,8072945,8072946,8072947,8072948,8072949,3657043,3657082,3657090,3657091,3657103,3657104,3657109,3657110,3657111,3657112,3657122,3657182,3657262,10623185,10623186,10623187,10623383,10623494,10919132,10623623,10623624,10623625,10919138,10919144,10919898,10919899,10920418,10624914,10920429,10920434,10920441,10920444,10920448,10920452,10920453,10920454,10920455,10621986,10621993,10621994,10621995,10622006,10622007,10622012,10622013,10622014,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622026,10622027,10622028,10622029,10622030,10622031,10622032,10622033,10622034,10622035,10622036,10622037,10622038,10622039,10622040,10622041,10622042,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622053,10622054,10622055,10622056,10622057,10622058,10622059,10622060,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622070,10622071,10622072,10622073,10622074,10622075,10622076,10622077,10622078,10622079,10622080,10622081,10622082,10622083,10622084,10622085,10622086,10622087,10622088,10622089,10622090,10622091,10622092,10622093,10622095,10622096,10622099,10622100,10622101,10622102,10622105,10622106,10622108,10622110,10622115,10622122,10622124,10622125,10622126,10917650,10917660,10917661,10622155,10622156,10622157,10622369,10622370,10917889,10917890,10917891,10917892,10917893,10917894,10917895,10917896,10917897,10622402,10622412,10622519,10622521,10622536,10622542,10918101,10620085,10915677,10915754,10620301,10620302,10620303,10620346,10620347,10620348,10620349,10620350,10620360,10620374,10620376,10620377,10620379,10620394,10620407,10620412,10620416,10620422,10620423,10620424,10620425,10915957,10915958,10915959,10916734,10916757,10916758,10916759,10916760,10916761,10916762,10916763,10916764,10916765,10916766,10916767,10916768,10621263,10916782,10916784,10916792,10916803,10916804,10916805,10916806,10916807,10916808,10916809,10916810,10916811,10916812,10917117,10917118,10917119,10917120,10621748,10621750,10917352,10917360,10917364,10917365,10917366,10917367,10917368,10917369,10565152,10565156,10565177,10565178,10565182,10565203,10565217,10565218,10565233,10611083,10565290,10565295,10611176,10611295,10611615,10611633,10611634,10611659,10608962,10608963,10608964,10608965,10608966,10608967,10608968,10608970,10608976,10608977,10608978,10608980,10608981,10608982,10608984,10608985,10608988,10608990,10608992,10608994,10608997,10608998,10608999,10609000,10609001,10563152,10609002,10609006,10609008,10609009,10609010,10609011,10609012,10609013,10609014,10609015,10609016,10609017,10609018,10609019,10609020,10609022,10609023,10609024,10609025,10609027,10609028,10609029,10609030,10609031,10609032,10609033,10609034,10609038,10609039,10609040,10609041,10609042,10609044,10609045,10609046,10609047,10609048,10609049,10609050,10609051,10609052,10609053,10609054,10609055,10609056,10609057,10609058,10609059,10609060,10609061,10609062,10609063,10609064,10609065,10609066,10609067,10609068,10609069,10609072,10609073,10609074,10609076,10609077,10609079,10609080,10609081,10609082,10609083,10609084,10609085,10609086,10609087,10609088,10609089,10609090,10609091,10609092,10609093,10609094,10609095,10609098,10609100,10609102,10609103,10609105,10609106,10609112,10609113,10609115,10609116,10609117,10609130,10609133,10609134,10609135,10609136,10609137,10609138,10609139,10609140,10609141,10609142,10609143,10609146,10609147,10609148,10609149,10609151,10609152,10609153,10609154,10609155,10609157,10609158,10609164,10609165,10609166,10609167,10609169,10609170,10609171,10609172,10609181,10609186,10609187,10609188,10609189,10609190,10609191,10609193,10609194,10609195,10609197,10609198,10609201,10609202,10609203,10609204,10609205,10609206,10609207,10609209,10609210,10609211,10609212,10609213,10609214,10609215,10609219,10609221,10609223,10609224,10609227,10609228,10609229,10609230,10609231,10609232,10609236,10609237,10609240,10609243,10609244,10609245,10609246,10609247,10609250,10609253,10609257,10609258,10609259,10609260,10609261,10609262,10609263,10609265,10563421,10609305,10609310,10609346,10563507,10609392,10563547,10609472,10609473,10609474,10609475,10563679,10609575,10609576,10609577,10609578,10609579,10609580,10609581,10609582,10609583,10609584,10609585,10609586,10609684,10563885,10609760,10609812,10609882,10610068,10610070,10610072,10610087,10610088,10610089,10610090,10610091,10610266,10610267,10610306,10610307,10564558,10610441,10564600,10610502,10564672,10610671,10564835,10564857,10564873,10564875,10610730,10564885,10564891,10564897,10564901,10565047,10610912,10610942,10555209,10555210,10555212,10555213,10555217,10555219,10555222,10555224,10555226,10555227,10555228,10555262,10555264,10555271,10555273,10555279,10555281,10555282,10555289,10555298,10555300,10555301,10555302,10555303,10555305,10555307,10555308,10555312,10555316,10555317,10555319,10555322,10555325,10517332,10555333,10555334,10555344,10555345,10555359,10555362,10555363,10555368,10555369,10555371,10555376,10555383,10555384,10555385,10555386,10555394,10555400,10555402,10555403,10555406,10555407,10555409,10555414,10555427,10555430,10555432,10555442,10555444,10555445,10555446,10555448,10555449,10555452,10555454,10555456,10555457,10555463,10555467,10555470,10555474,10555477,10555481,10555491,10555492,10555493,10555494,10555495,10555501,10555502,10555503,10555504,10555506,10555507,10555510,10555511,10517513,10555514,10555517,10555519,10555520,10555522,10555523,10555525,10555527,10555535,10555538,10555543,10517552,10555552,10517553,10517554,10555554,10555558,10555563,10517564,10555565,10555566,10555567,10555568,10555569,10555570,10555571,10555572,10555573,10555574,10555575,10555576,10555577,10555580,10555581,10555584,10555586,10555591,10517598,10555603,10555604,10555607,10555608,10555609,10555618,10555619,10555621,10555623,10555624,10555634,10555635,10555640,10517641,10555642,10517644,10517645,10555658,10555665,10555666,10555667,10555672,10555673,10555674,10555675,10555676,10555679,10555680,10555682,10555683,10555684,10555685,10555686,10555687,10555688,10555696,10555698,10555709,10555711,10555712,10555725,10555727,10555728,10555730,10555731,10555744,10555745,10555746,10555747,10555748,10517776,10517777,10517778,10517820,10517821,10517822,10518025,10518625,10518749,10518762,10518785,10518884,10518887,10519099,10519100,10519101,10519105,10519109,10419418,10419461,10419465,10419556,10419557,10470944,10471064,10471245,10471462,10471463,10471464,10471465,10471466,10471467,10471468,10471469,10471470,10471557,10471570,10471571,10471615,10471616,10471620,10471623,10471697,10471698,10471701,10471704,10471705,10471770,10471833,10471840,10471841,10471843,10471844,10471850,10471851,10471852,10471856,10470041,10470042,10470043,10470044,10470045,10470046,10470047,10470048,10470049,10470196,10470575,10470576,10470577,10470578,10470579,10470580,10470581,10470582,10470583,10470584,10470585,10470586,10470587,10470588,10470589,10470590,10470591,10470592,10470593,10470594,10470595,10470596,10470597,10470598,10470599,10470600,10470601,10470602,10470603,10470604,10470605,10470606,10470607,10470608,10470609,10470610,10470611,10470612,10470613,10470614,10470615,10470616,10470617,10470618,10470619,10470620,10470730,10470762,10470763,10470764,10470765,10470766,10470767,10470797,10470798) 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'