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(7074032,8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067490,8067491,8067492,8067493,8067494,8067495,8067496,8067497,8067498,8067499,8067500,8067501,8067502,8067503,11026500,11026501,11026502,11026503,11026504,11026505,11026506,11026507,11026508,11026509,11026510,11026511,11026512,11026513,11026514,11026515,11026516,11026517,11026518,11026519,11026520,11026521,11026522,11026523,11026524,11026525,11026526,11026527,11026528,11026529,11026530,11026531,11026532,11026533,11026534,11026535,11026536,11026537,11026538,11026539,11026540,11026541,11026542,11026543,11026544,11026545,11026546,11026547,11026548,11026549,11026550,11026551,11026552,11026553,11026554,11026555,11026556,11026557,11026558,11026559,11026560,11026561,11026562,11026563,11026564,11026565,11026566,11026567,11026568,11026569,11026570,11026571,11026572,11026573,11026574,11026575,11026576,11026577,11026578,11026579,10918651,10918652,10918653,10918654,10918655,10918656,10918657,10918658,10918659,10918660,10918661,10918662,10918663,10918664,10918665,10918666,10918667,10918668,10918669,10918670,10918671,10918672,10918673,10918674,10918675,10918676,10918677,10918678,10918679,10918680,10918681,10918682,10918683,10918684,10918685,10918686,10918687,10918688,10918689,10918690,10918691,10918692,10918693,10918694,10918695,10918696,10918746,10918747,10918748,10918749,10918750,10918751,10918752,10918753,10918754,10918755,10918756,10918757,10918758,10918759,10918760,10918761,10918762,10918763,10918764,10918765,10918766,10918767,10918768,10918769,10918770,10918771,10918772,10918773,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10918783,10918784,10918785,10918786,10918787,10918788,10918789,10918790,10918791,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10918801,10918802,10918803,10918804,10918805,10918806,10918807,10918808,10918809,10918810,10918811,10918812,10918813,10918814,10918815,10918816,10918817,10918818,10918819,10918820,10918821,10918822,10918823,10918824,10918825,10918826,10918827,10918828,10918829,10918830,10918831,10918832,10918833,10918834,10918835,10918836,10918837,10918838,10918839,10918840,10918841,10918842,10918843,10918844,10918845,10918846,10918847,10918848,10918849,10918850,10918851,10918852,10918853,10918854,10918855,10918856,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,10918867,10918868,10918869,10918870,10918871,10918872,10918873,10918874,10918875,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10918884,10918885,10918886,10918887,10918888,10918889,10918890,10918891,10918892,10918893,10918894,10918895,10918896,10918897,10918898,10918899,10918900,10918901,10918902,10918903,10918904,10918905,10918906,10918907,10918908,10918909,10918910,10918911,10918912,10918913,10918914,10918915,10918916,10918917,10918918,10918919,10918920,10918921,10918922,10918923,10918924,10918925,10918926,10918927,10918928,10918929,10918930,10918931,10918932,10918933,10918934,10918935,10918936,10918937,10918938,10918939,10918940,10918941,10918942,10918943,10918944,10918945,10918946,10918947,10918948,10918949,10918950,10918951,10918952,10918953,10918954,10918955,10918956,10918957,10918958,10918959,10918960,10918961,10918962,10918963,10918964,10918965,10918966,10918967,10918968,10918969,10918970,10918971,10918972,10918973,10918974,10918975,10918976,10918977,10918978,10918979,10918980,10918981,10918982,10918983,10918984,10918985,10918986,10918987,10918988,10918989,10918990,10918991,10918992,10918993,10918994,10918995,10918996,10918997,10918998,10918999,10919000,10919001,10919002,10919003,10919004,10919005,10919006,10919007,10919008,10919009,10919010,10919011,10919012,10919013,10919014,10919015,10919016,10919017,10919018,10919019,10919020,10919021,10919022,10919023,10919024,10919025,10919026,10919027,10919028,10919029,10919030,10919031,10919032,10919033,10919034,10919035,10919036,10919037,10919038,10919039,10919040,10919041,10919042,10919043,10919044,10919045,10919046,10919047,10919048,10919049,10919050,10919051,10919052,10919053,10919054,10919055,10919056,10919057,10919058,10919059,10919060,10919061,10919062,10919063,10919064,10919065,10919066,10919067,10919068,10919069,10919070,10919071,10919072,10919073,10919074,10919075,10919076,10919077,10919078,10919079,10919080,10919081,10919082,10919083,10919084,10919085,10919086,10919087,10919088,10919089,10919090,10919091,10919092,10919093,10919094,10919095,10919096,10919097,10919098,10919099,10919100,10919101,10919102,10919103,10919104,10919105,10919106,10919107,10919108,10919109,10919110,10919111,10919112,10919113,10919114,10919115,10919116,10919117,10919118,10919119,10919120,10919121,10919122,10919123,10919124,10919125,10919126,10919127,10919128,10919129,10919130,10919131,10919132,10919133,10919134,10919135,10919136,10919137,10919138,10919139,10919140,10919141,10919142,10919143,10919144,10919145,10919146,10919147,10919148,10919149,10919150,10919151,10919152,10919153,10919154,10919155,10919156,10919157,10919158,10919159,10919160,10919161,10919162,10919163,10919164,10919165,10919166,10919167,10919168,10919169,10919170,10919171,10919172,10919173,10919174,10919175,10919176,10919177,10919178,10919179,10919180,10919181,10919182,10919945,10917991,10917992,10917993,10917994,10917995,10917996,10917997,10917998,10917999,10918000,10918001,10918002,10918003,10918004,10918005,10918006,10918007,10918008,10918009,10918010,10918011,10918012,10918013,10918014,10918015,10918016,10918017,10918018,10918019,10918020,10918021,10918022,10918023,10918024,10918025,10918026,10918027,10918028,10918029,10918030,10918031,10918032,10918033,10918034,10918035,10918036,10918037,10918038,10918039,10918040,10918041,10918042,10918043,10918044,10918045,10918046,10918047,10918048,10918049,10918050,10918051,10918052,10918053,10918054,10918055,10918056,10918057,10918058,10918059,10918060,10918061,10918062,10918063,10918064,10918065,10918066,10918067,10918068,10918069,10918070,10918071,10918072,10918073,10918074,10918075,10918076,10918077,10918078,10918079,10918080,10918081,10918082,10918083,10918084,10918085,10918086,10918087,10918088,10918089,10918090,10918091,10918092,10918093,10918094,10918095,10918096,10918097,10918098,10918099,10918100,10918101,10918102,10918103,10918104,10918105,10918106,10918107,10918108,10918109,10918110,10918111,10918112,10918113,10918114,10918115,10629531,10629532,10629547,10629548,10574734,10574735,10574736,10574737,10574738,10574739,10574740,10574741,10574742,10574743,10574744,10574745,10574746,10574747,10574748,10574749,10574750,10574751,10574752,10574753,10574754,10574841,10574842,10574843,10574844,10574845,10574846,10574847,10574848,10574849,10574850,10574851,10574852,10574853,10574854,10574855,10574856,10574857,10574858,10574859,10574860,10574861,10574862,10574863,10574864,10574865,10574866,10574867,10574868,10574869,10574870,10574871,10574872,10574873,10574874,10574875,10574876,10574877,10574878,10574879,10574880,10574881,10574882,10574883,10574884,10574885,10574886,10574887,10574888,10574889,10574890,10574891,10574892,10574893,10574894,10574895,10574896,10574897,10574898,10574899,10574900,10574901,10574902,10574903,10574904,10574905,10574906,10574907,10574908,10574909,10574910,10574911,10574912,10574913,10574914,10574915,10574916,10574917,10574918,10574919,10574920,10574921,10574922,10574923,10574924,10574925,10574926,10574927,10574928,10574929,10574930,10574931,10574932,10574933,10574934,10574935,10574936,10574937,10574938,10574939,10574940,10574941,10574942,10574943,10574944,10574945,10574946,10574947,10574948,10574949,10574950,10574951,10574952,10574953,10574954,10574955,10574956,10574957,10574958,10574959,10574960,10574961,10574962,10574963,10574964,10574965,10574966,10574967,10574968,10574969,10574970,10574971,10574972,10574973,10574974,10574975,10574976,10574977,10574978,10574979,10574980,10574981,10574982,10574983,10574984,10574985,10574986,10574987,10574988,10574989,10574990,10574991,10574992,10574993,10574994,10574995,10574996,10574997,10574998,10574999,10575000,10575001,10575002,10575003,10575004,10575005,10575006,10575007,10575008,10575009,10575010,10575011,10575012,10575013,10575014,10575015,10575016,10575017,10575018,10575019,10575020,10575021,10575022,10575023,10575024,10575025,10575026,10575027,10575028,10575029,10575030,10575031,10575032,10575033,10575034,10575035,10575036,10575037,10575038,10575039,10575040,10575041,10575042,10575043,10575044,10575045,10575046,10575047,10575048,10575049,10575050,10575051,10575052,10575053,10575054,10575055,10575056,10575057,10575058,10575059,10575060,10575061,10575062,10575063,10575064,10575065,10575066,10575067,10575068,10575069,10575070,10575071,10575072,10575073,10575074,10575075,10575076,10575077,10575078,10575079,10575080,10575081,10575082,10575083,10575084,10575085,10575086,10575087,10575088,10575089,10575090,10575091,10575092,10575093,10575094,10575095,10575096,10575097,10575098,10575099,10575100,10575101) 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'