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(8559459,10871833,10871834,10871835,10871836,8618384,10871837,10871838,10871839,10871840,10871841,10871842,10871843,10871844,10871845,10871846,10871847,10858918,10858920,10858924,10103766,10858925,10858926,10858927,10858930,10858933,10858935,10103927,8618966,8569616,10872461,10872462,10872463,10872464,10872465,10872466,10872467,10872468,10872469,10250908,10250909,10250910,10250911,10250912,5654537,10250921,8836768,8836769,8836770,8836771,8836772,8836773,8836774,8836775,8836776,8836777,8836778,8836779,8619192,8619193,8619194,8619195,8619196,8619197,8619198,8619199,8619200,8619201,7065900,7073964,7073965,7073966,7073967,7073968,3227115,3227116,3227117,3227118,3227128,10844531,10844532,10844533,10844534,10844535,10844536,10844537,10844538,10844539,10844540,10844685,10251721,10251722,10251723,10251724,10251725,10251726,10251727,10844942,8558362,3927819,8558407,10249311,10249312,10249313,10249314,8617935,8617950,8559063,10250010,6000118,10195093,6000272,6000273,6000274,6000275,6000276,6000277,6000278,8625561,8625563,8625569,10932038,8625836,8625837,8625840,8625842,8625843,8625850,8625852,8625856,8625862,10195933,10196291,10196378,7073187,7073188,7073192,7073193,7073194,7073328,7073435,10248740,7073700,7073701,7073702,7073704,7073756,10194089,10942634,10942657,8624414,7198107,10246593,10246594,10246595,10246596,10246597,10246598,10246599,10246600,10246601,10246602,10246603,10246604,10246605,10246606,10246608,10246609,10246610,10246611,10246612,10246613,10246614,10246615,10246616,10246617,10246618,10246626,10246627,10246628,10246629,10246630,10246631,10246632,10246633,10246634,3925385,10194856,10194857,10194858,10194859,10194860,3922814,8542210,8542211,8542212,8542213,7069183,7069184,7069185,10944751,10944753,10837668,3923320,7196194,7196195,7196196,7196197,7196198,7196199,7196200,7196201,7196202,7196203,7196204,7196205,7196206,10837727,8073001,8073002,8906904,10942501,10433219,10618295,9217439,9217440,9217441,9217442,9217443,9217444,9217445,9217446,9217447,9217448,9217449,9217450,9217451,9217452,9217453,9217454,9217455,9217456,9217457,9217458,9217459,9217460,9217461,9217462,9217463,9217464,9217465,9217466,9217467,9217468,9217469,9217470,9217471,9217472,9217473,9217474,9217475,9217476,9217477,9217478,9217479,9217480,9217481,9217482,9217483,9217484,9217485,9217486,9217487,9217488,9217527,9217528,9217529,7154422,7154423,9217606,9217607,9217608,9217611,8540526,9217668,8540527,9217669,9217670,9217671,9217672,9217673,9217674,9217675,9217676,9217677,9217678,9217679,9217680,9217681,9217682,9217683,9217684,9217685,9217686,9217687,9217688,9217689,9217690,9217691,9217692,9217693,9217694,9217695,9217696,9217697,9217698,9217699,9217700,9217701,9217702,9217703,9217704,9217705,9217706,9217707,9217708,9217709,9217710,9217711,9217712,9217713,9217714,9217715,9217716,9217717,9217718,9217719,9217720,9217721,9217722,9217723,9217724,9217725,3231708,7155100,7155101,7155241,8904919,8634590,8634597,8631991,8631993,8631994,8632001,8632003,8632004,8632006,8632007,8632010,8632011,8632013,8632040,8632042,8632044,8632046,8632048,8632049,8632051,8632053,8632055,8632057,8632059,8632061,8632063,8632065,8632067,8632068,8632069,8632072,8632075,8632077,8632079,8632081,8632083,8632084,8632086,8632087,8632089,8632091,8632093,8632095,8632096,8632097,8632149,8632151,8632155,8632157,8632159,8632160,8632162,8632165,8632167,8632169,8632172,8632173,8632174,8632176,8632177,8632180,8632182,9216580,10425348,10425349,10425350,10425351,10425352,10425353,10848033,10848034,10615183,10615184,10615185,10615186,10615187,10615188,10615189,10615190,10615191,10615192,10615193,10615194,10615203,10615204,10615205,10615209,10615210,10615212,10615213,10615214,10615215,10615216,10615223,10615224,10615262,10615263,10845417,8570160,8570161,10930137,10845905,10845906,10845907,10930929,10926840,10926841,10926842,10188456,10849488,10849489,10849490,10849491,10849492,10849493,9215901,9215902,9215903,9215906,9215907,10849555,10849556,8631926,8631929,8631933,8631936,8631938,8631948,8631950,8631954,8631956,8631975,8631978,8631981,8631984,8631986,8631988,9189550,10614284,10614285,10614417,9205758,8864465,8864564,8864566,8864724,8861861,10612051,8542622,8542623,8542624,8542625,8542626,10612138,10612139,10612140,10612142,10612144,10612148,10612149,10612151,10612154,10612156,8542691,8542692,8542693,9172312,9196485,9196486,9196487,9196488,9196489,9196490,9196491,9196492,9196751,9196752,10558597,10558598,10558599,10558600,10558601,10558602,10558603,10558604,10558605,10561605,10558606,10558607,10561612,10561616,10561622,10561631,10561635,10561636,10561637,10561642,10561643,10561666,10561667,10561672,10561673,10561674,10561694,10561695,10561696,10561700,10561701,10561712,10561713,10561719,10561720,10561721,10561722,10561723,10561724,10561730,10561732,10561733,10561734,10561735,10561736,10561737,10561742,10561745,9912258,9170375,10512578,10512579,10512580,10512581,10512582,10512583,10512584,8552452,10515078,10515079,10515080,6672560,6672561,9160361,9160400,9168435,9168436,6673026,4973677,4973678,6673037,8848702,9168930,9168931,9168932,9168934,9168935,9168936,9168937,9168938,9168939,9168940,9168941,4973898,6673324,10117385,10117386,10117395,4974118,4974119,3655612,9182568,8549914,3655987,3655988,3655991,3655992,3655993,8550078,8550083,3656177,3656178,3656179,9167264,10123513,10123514,10123515,10123517,10123518,10123519,10123520,9183349,9183350,9167512,976484,10468330,10468331,9167828,8917518,10468462,10468464,10468468,10468469,9167893,9167894,8917571,8551245,8917779,8917780,8917781,8917782,8917783,8917784,8917785,8917786,8917787,8917788,10628218,10628219,10628220,10628292,10628293,10628294,10174947,10174977,10174978,10628872,10628873,10628874,10884890,10884895,10884909,10884913,10910066,10910067,10910068,10910078,10910079,10875091,10890168,10882662,10912797,10912798,10912799,10912800,10912801,10912802,10912803,10912804,10912805,10912806,10912807,10912808,10912809,10912810,10912811,10912812,10912813,10184189,10184190,10176700,10176701,10176702,10176703,10176704,10176705,10176706,10176707,10910904,10910905,10910906,10875954,10886028,10177145,10177146,10177147,10177148,10177149,10177150,10177151,10177152,10177153,10177154,10177155,10177156,10177157,10177158,10177159,10177160,10177161,10177162,10177163,10177164,10177165,10177166,10177167,10177168,10177169,10177170,10177171,10177172,10177173,10177174,10177175,10177176,10177177,10177178,10177179,10177180,10177181,10177182,10177183,10177184,10177185,10177186,10177187,10177188,10177189,10177190,10881536,10631315,10911863,10911864,10911865,10911866,10877103,10877200,10877201,10877202,10877203,10882242,10882243,10882434,10892439,10601243,10608603,10589886,10589887,10603217,10590500,10603653,10603654,10603656,10603657,10603658,10590888,10607412,10607413,10591754,10607639,10525147,10525148,10525149,10525150,10525151,10525152,10525153,10525154,10525155,10525285,10525286,10525287,10525288,10525289,10525290,10525364,10525365,10525366,10525367,10525368,10525369,10525370,10525371,10525374,10525376,10525377,10525378,10525379,10525380,10525381,10525382,10525392,10525393,10525394,10525395,10525396,10525397,10525398,10525400,10525401,10549580,10527882,10527883,10527884,10527885,10527886,10527887,10527888,10527889,10527890,10527891,10527892,10527893,10527894,10527895,10527896,10527897,10527898,10527899,10527900,10527920,10527921,10527924,10527926,10527927,10527928,10527929,10527930,10527931,10527932,10527933,10527934,10527935,10527936,10527937,10527938,10527939,10527940,10527941,10527942,10527943,10527944,10527945,10528269,10528270,10528271,10528272,10528273,10528274,10528275,10528276,10528277,10528278,10528279,10528280,10528281,10528282,10528283,10528284,10528285,10528363,10528364,10528381,10528382,10528383,10528638,10528639,10528640,10528641,10540715,10540716,10540717,10540718,10520818,10507112,10507113,10510117,10510118,10510119,10510120,10510121,10510399,10510400,10509466,10509467,10423576,10509468,10423577,10509469,10423578,10509470,10423579,10509471,10423580,10509472,10423581,10509473,10423582,10509474,10509475,10509476,10509477,10509478,10509479,10509480,10509481,10509482,10509483,10509484,10509485,10509486,10509487,10509504,10509505,10509506,10509507,10509508,10509509,10509510,10509511,10509512,10509528,10509529,10509530,10509531,10509596,10509751,10509752,10509753,10509754,10509755,10509756,10509757,10509833,10509834,10509853,10509875,10509896,10510946,10510947,10510948,10510949,10510950,10510951,10510952,10510953,10510954,10510955,10510956,10510957,10510958,10510959,10510960,10423136,10413444,10413447,8562990,10476142,10715141,10715142,10407075,10407076,10407077,10407078,10407079) 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'