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(3228431,3228577,4970668,4970719,8569484,8569490,3228983,3229002,3229003,3229004,3229005,10950303,8583147,10950304,8583162,10950344,8583189,10950362,10950363,10950364,10950365,10950366,10950367,10950368,10846501,8583294,8583310,10950517,7065975,7065978,8575177,8575178,8575179,8575180,8575181,8575182,8575183,7066025,8575388,7066214,7066221,7066255,8575441,8583974,3229946,3230230,10951493,10844690,8573136,8573160,3227406,8573171,3227499,3227511,8573273,3227525,8573333,3227574,10938807,10938810,10938811,10938818,8573395,10938937,10938938,10938939,10938944,10447315,10939168,10939169,8620650,10447737,7201203,7201204,10103098,7201224,7201225,7201229,7201231,7201232,7201233,7201238,7201376,10103654,8911586,7201958,7201959,7201974,8065794,7202117,8911952,8911953,8911954,8911955,10104070,8572165,8572202,7202316,8572252,10843855,8572311,8572320,7065193,7065194,7202737,7065563,8572825,8572826,8572827,8572828,8572863,10933039,3227124,8572901,8573002,8573077,7065910,7065920,7065923,8616833,8616838,8910237,7200428,7200429,7200430,7200433,7200434,7200461,7200472,8834765,7200524,10102486,7200625,7200626,10102661,10102662,10959258,7200897,7200937,7200949,10100165,10100255,7198454,10941001,10941010,7198663,7198693,7198703,7198758,7198767,7198782,7198783,7198785,10941361,10941362,10941366,10941368,7199011,10101060,10101063,10941638,10101221,7199376,10101267,10101268,7070218,7199465,7199467,7199480,10101462,10101518,11048413,11048419,11048434,7199785,11048450,7199833,7199913,10958390,8906004,10837746,10837764,10623064,10837851,10837852,10837853,10837854,10837855,10837856,10837857,10837858,10837859,10837860,7196491,10623510,10623511,10623512,10623515,8906552,8906553,8906554,8906591,8906599,8906601,8906602,8906603,8906605,8906606,8906607,8906610,8906611,8906613,8906614,8906615,8906642,7196890,8906829,8906830,8906833,8906834,8906835,7197027,7197028,7197163,7197213,7197218,10838756,10838758,7197291,7197300,10838808,10838833,10838898,10838906,7197779,8614447,7197918,7197924,7197943,7197944,7197945,11047400,7198080,10619864,10619865,8905004,10616974,10616978,10616979,10616980,10616983,8905021,8905022,8905024,8905025,8905026,8905027,8905029,8905034,8905036,8905037,8905038,8905040,8905042,8905044,8905045,8905046,8905047,8905048,8905049,8905050,8905053,8905055,8905056,8905057,10617027,8905059,8905060,8905061,10617038,10617041,8905093,10617143,10617154,10617197,8905282,8905285,8905286,10836997,10836999,10837014,10837032,8905338,8905389,8905390,8905465,8905466,10617471,8905536,8905538,8905540,8905542,8905543,8905545,8905546,8905548,8905564,8905565,8905602,8905604,8905608,8905609,8905610,8905615,8905616,8905617,8905618,8905620,8905623,8905624,8905625,8905627,8905629,8905630,8905631,8905632,8905636,8905638,8905639,8905640,8905652,8905725,8905729,8905732,8905734,8905735,8905743,8905744,8905755,8905769,8905779,8905797,10837497,8905980,8569937,8569938,8569939,8569940,8609799,8569941,8569942,8569975,10925633,10925635,10925636,8570082,8570083,8570085,8570086,10425487,10615150,10615183,10615188,10620191,10615193,10615200,10615201,10620203,10620204,10620205,10620206,10620208,10615232,10615247,10615268,10615405,10615406,10615417,10615418,10615419,10615420,10615421,10615426,10620467,10620487,10620488,10620491,10620598,10615603,10615713,10615720,10615862,10426202,10426203,10426210,10615881,10426242,8610786,10616004,10616044,10616045,10426386,10616203,10616207,10616208,10616221,8904316,10616294,8904413,10616429,8611341,8611368,8611369,8611370,8611371,8611372,8611375,8577869,10616787,8904848,8611647,10616887,8904927,8904929,8904933,8904944,8904945,8904954,8904955,8904956,8904957,8904958,8904960,8904961,8904962,8904963,8904964,8904965,8904966,8904967,8904969,8904970,8904971,8904972,8904973,8904974,8904976,8904977,8904979,8904980,8904989,10613964,10613971,10613972,10613994,9205332,10614008,10614015,10611017,10611018,10611019,10611020,10614030,10614031,9205432,10611106,10611109,10611115,9165459,10611123,10614281,6669825,6669832,6669833,6669834,6669835,6669836,6669837,6669838,6669839,6669840,6669841,6669842,6669843,6669844,6669845,6669846,6669847,6669848,6669849,6669850,10614307,6669851,6669852,10614309,6669853,6669854,6669855,6669856,6669857,6669858,6669859,6669860,6669861,6669862,6669863,6669864,6669865,6669866,6669867,6669868,6669869,6669870,6669871,6669872,6669873,6669874,6669875,6669876,6669877,6669878,6669879,6669880,6669881,6669882,6669883,6669884,6669885,6669886,6669887,6669888,6669889,6669890,6669891,9165783,10614516,10614530,6665946,10611667,10614716,10614730,10611780,9166136,10611862,10614864,9166293,10612135,8862005,8862006,10612168,10612169,10612170,10612344,10609377,10609381,10609387,10609390,10612398,10612399,10612400,10612401,10563556,10563557,10563558,10612410,10612424,10609435,10609446,10609449,10609455,10609474,10609479,10609491,10609498,10609505,10609506,10609507,10609508,10609509,10609511,10609519,10609570,10609577,10609578,10609583,10609590,10609602,10609628,9163968,10609694,10609706,10609711,10609722,10609725,7058247,7058248,7058249,7058250,10609770,10609772,10609787,10609798,10609823,10612839,10609859,10609868,10609880,10612886,10609889,10612915,10612929,10609977,10612979,10612980,10609982,10612984,10612987,10612988,10612989,10612992,10610044,10613084,10610098,10610113,10610114,10610115,10610183,10613260,10613350,10613380,10564549,10564550,10564551,10610415,10610416,10610435,10610447,9164790,9164791,9164792,10613517,9164953,10610678,10613746,10613798,10613804,10613825,10613939,9205277,9205278,9205279,9205280,9169300,9169444,10117767,10117769,10117770,10117804,9169637,9169676,10117936,9169868,9169869,9169881,9169897,9169905,9169907,10118165,10118350,10118560,9162447,10118674,9170930,9170931,10419227,10419228,10419229,10419230,10419231,10419234,9160338,9160339,9160340,9160341,9160343,9160348,10419283,10419292,10417293,10417294,10417295,10416304,9168403,10416375,10416376,10416377,9168485,10417427,10416446,10416447,10416450,9184532,9184533,10416455,9184534,9184535,9184536,10416461,10416470,9168564,10419501,10415502,10417505,10419506,10419511,10419517,10419536,10419537,10419544,10419546,10419548,10419550,10419558,10419559,10419560,10419561,9160733,9184835,10419760,9160873,9160880,9160900,10415855,10418916,9169028,9169064,9169065,10418048,10117378,10117411,10117426,10117432,10117446,9169252,10117473,7055451,10117483,10117489,8549471,10469035,10471154,10471155,10471156,10471159,9166603,8549789,8549796,10469349,10469357,10467507,8550170,10467615,10467634,10467635,10467637,10467665,8916787,8916788,8916789,8916790,8916791,10467764,10467766,10467774,9183371,10469964,9183414,10470088,9167634,9167683,9167684,8550858,10468280,10468310,9167812,9167830,9168021,10468619,10468621,10470654,9168127,9168153,10470736,10470737,9168194,10468826,10470863,10946337,10946345,10946347,10946348,10946352,10883564,10883587,10628312,10946773,10946774,10946775,10946777,10946778,10946784,10946785,10946788,10946790,10946793,10946794,10946795,10946797,10946878,10946879,10946915,10628602,10628603,10628607,10884127,10884168,10884176,10947059,10947060,10947061,10947062,10947063,10947064,10947067,10947068,10947070,10947071,10947073,10947110,10947271,10884823,10947651,10947658,10947707,10947711,10947723,10947724,10875012,10875049,10947881,10875071,10875084,10885087,10947920,10947988,10948018,10885313,10948126,10885369,10885381,10885386,10945311,10945314,10945324,10882514,10882520,10882530,10882544,10882548,10882555,10882561,10945383,10882573,10882575,10945386,10945391,10882588,10882593,10945405,10882599,10945446,10945467,10882677,10882684,10945497,10882689,10882711,10882714,10882725,10882729,10882735,10882738,10882739,10882749,10882765,10882767,10882782,10882860,10882896,10882910,10882919,10882922,10882925,10882936,10882958,10882974,10945788,10882983,10882999,10883000,10883011,10883012,10945826,10945828,10883022,10883039,10945856,10883125,10883142,10883146,10883175,10883188,10946001,10946012,10946013,10946014,10946018,10883213,10883214,10946034,10946179,10946185,10946188,10946237,10946260,10946265,10946269,10946271,10948431,10948533,10948534,10948577,10161786,10161787,10161792,10161808,10161824,10948697,10625455,10625487,10948814,10162051,10948876,10948877,10162082,10162084,10948940,10625651,10625678,10625681,10625706,10162230,10162231,10876661,10626215,10626473,10626481,10626488,10626498,10626499,10877051,10949863,10949873,10949874,10877212,10945105,10945140,10945178,10882394,10945231,10882421,10882423,10945234,10626914,10626928,10626935,10882455,10882464,10882465,10945281,10580334,10580348,10580477,10580478,10498743,10420879,10420880,10489181,10489182,10489183) 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'