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(8068831,8068834,8068836,8068847,10939584,8068870,8068884,8068886,10943430,7068020,7068041,7076050,7076054,7076084,7068108,7076185,7076186,10943607,10962874,4970409,10943616,10962896,10943634,10943635,10962902,10943637,10943641,4970457,7068244,4970461,10943696,4970528,4970529,4970530,4970531,4970532,4970533,4970534,4970535,4970536,4970537,4970538,4970539,4970540,4970541,4970542,4970543,4970544,4970545,4970546,4970547,4970548,4970549,4970550,4970551,4970552,4970553,4970554,10943757,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970564,4970565,4970566,4970567,4970568,7068420,8569408,8569431,10963160,4970700,4970715,10943932,4970763,7068550,10944022,10963292,10963331,10944071,4970870,10963340,10963349,10944097,4970896,10963371,7068697,7068701,4970918,4970919,4970930,4970933,10963401,4970934,4970935,4970944,10963434,4970969,8569730,4970973,4970979,10963466,10944231,10944232,10944233,10944234,10944235,10944236,10944237,10944238,10944239,10944240,10944241,10944242,7068840,10963535,10944276,10963548,10963549,8569860,8569863,4971133,4971134,4971135,4968168,8066956,10933343,4968217,10933353,4968269,7074058,7074100,7074104,7074106,10963793,4968327,8067114,7074147,4968469,8067258,7066308,7066318,4968537,4968581,7066448,4968670,10437359,7074584,7066658,10964346,7066666,7066669,8067658,10437539,4968959,7066790,10964490,10964491,4969052,10437691,7074843,7074860,7066862,7074868,10938535,7066928,7074941,7074945,4969281,7067075,7075159,10961843,10961845,10938821,4969418,10961890,10961892,7067245,4969552,10962062,7067394,10939046,4969661,7075456,7075467,10962160,10962161,4969796,10962275,10962276,7067596,8068488,10939288,10939354,10939355,10939356,10939357,4969958,4969968,4969992,4970041,8068782,4970127,8068812,8068813,8064954,7072055,7072059,7064086,10931583,7072243,10959930,10959931,10959932,10959933,10959934,10959935,10959936,10959937,10959938,10959939,10959940,10959941,10959942,10959943,10959944,10959945,10959946,10959947,10959948,10959949,10959950,10959951,10959952,10959953,10959954,10959955,10959956,10959957,10959958,10959959,10959960,7064280,7072320,7072321,7072326,7064347,7072359,7072392,10931784,10931794,10960154,10960167,7064558,7072594,7072611,7072613,10960299,7072625,7064633,7072639,10960351,10960381,7072716,7072737,7072746,8065734,8065735,8065736,8065737,8065738,7072762,8065739,7072763,8065740,8065741,8065742,8065743,7072774,7072796,7072800,7072813,7064821,4967046,7072873,7072874,4967094,7072891,7072897,7072913,7072919,7072920,7072928,7072939,7072958,7072961,7072983,8065961,8065964,8065973,8065981,8065982,7073011,7073022,7073025,7073027,7073030,7073031,4967247,7073032,7073035,10960724,10932391,7073044,7073045,7073047,7073054,4967272,4967284,4967306,7073091,4967351,7073153,8066140,10960856,7065218,7065237,4967483,7065268,7065285,10960980,4967590,7073489,7065559,7065560,7065561,7065562,7065563,10961297,10961317,7073642,10961423,4967958,7073746,10961432,4967964,10961445,10961475,4968118,10933251,10933268,10933274,7070965,7070981,8063972,8063994,10958736,10958763,10958764,10942717,8064116,7071170,7071335,10942960,10942973,10942983,10943033,10943039,10943076,10943081,10943094,10943112,7071584,7071585,7071587,7071606,8064600,7071643,8064631,7071659,7071694,7071700,7071723,7071752,7071756,7071757,7071762,7071767,7071769,7071844,8064839,7071862,7068989,7068991,7069006,7069007,7069008,7069021,3655628,10944524,7069113,10944593,10944642,3655831,3655848,10940937,10957073,10944830,7069446,10941180,10945068,7069689,7069821,7069837,10941503,3656529,3656574,7070054,7070062,3656653,7070097,10941725,10941792,10941816,10941837,7070294,7070376,7070408,3656978,7070517,7070571,7070611,10958311,10958314,10958325,7070678,7070688,10958425,10958429,7070760,7070818,10918506,10618000,10918577,10918611,10928620,10618115,10618116,10618130,10618133,10928645,10918693,10918822,10618360,10618363,10918877,10618404,10618410,10618421,10618427,10618436,10618456,10618497,10618535,10618553,10618680,10919244,10919245,10618775,10618780,10618799,10618803,10618858,10618887,10618907,10618912,10618937,10624028,10619036,10619053,10619056,10624075,10619300,10619303,10619307,10919954,10919965,10919975,10619477,10919988,10920013,10920023,10920030,10920035,10920064,10920088,10925111,10624607,10920121,10925135,10920142,10920180,10920184,10920191,10920209,10920212,10619706,10920229,10920233,10920255,10920300,10920304,10920356,10920368,10925369,10920384,10920390,10920396,10920398,10619935,10920453,10619945,10624953,10624957,10917504,10917511,10953663,10953664,10953669,10917588,10917633,10917643,10917651,10917665,10917679,10917767,10917824,10917827,10917870,10927885,10917958,10917961,10927994,10927995,10918105,10918117,10918119,10928179,10918182,10918183,10918205,10918211,10928224,10928291,10954440,10918300,10928312,10954480,10954523,10928400,10920489,10920490,10920491,10920492,10920493,10920495,10920499,10915503,10915504,10915509,10620001,10915513,10915556,10915558,10915572,10915573,10915574,8570042,10915646,10920651,10920653,10920654,10915666,10925712,10915733,10915749,10920758,10915762,10915764,8570215,10925815,10920864,10915877,10920902,10920913,10920925,10920940,10920949,10920953,10915968,10915977,10915999,10916072,10916087,10916088,10930525,10916108,10916109,10916110,10916118,10916120,10916131,10916135,10916190,10916204,10921211,10916216,10921221,10921228,10921232,10930710,10921331,10916334,10921358,10916360,10620857,10921377,10930799,10916399,10916410,10916416,10916438,10916449,10930885,10930897,10620982,10916505,10916508,10921514,10916537,10921545,10921561,10921562,10916563,10921573,10916576,10921577,10616067,10921578,10921581,10921582,10921583,10916591,10916608,10921622,10621116,10916632,10921633,10916637,10916638,10921648,10916651,10916668,10916669,10921676,10916686,10921689,10916690,10921702,10921718,10921723,10921733,10916735,10916740,10916741,10916742,10916755,10916756,10921757,10921765,10916767,10916785,10921792,10916801,10952959,10921819,10916825,10916831,10926836,10952991,10921845,10916847,10921850,10916860,10921873,10916874,10916876,10916877,10921898,10916915,10916916,10916917,10916918,10916919,10916920,10916921,10916930,10926932,10916937,10921945,10916949,10916951,10916954,10916965,10916974,10916975,10926992,10922017,10922024,10927051,10922100,10922104,10922106,10922112,10922114,10922116,10922120,10917143,10922155,10917176,10953326,10927184,10917199,10616776,10917300,10917330,10917365,10953534,10917387,10917401,10917415,10917431,10917432,10616927,10917446,10917466,10917468,10621960,10559134,8863958,8863959,8863960,8864148,8864173,8864257,10611423,10614922,8864805,8861845,10560144,10560147,8861904,8861938,10557333,10612217,10612218,10612219,8862092,10609264,10557432,10609287,10563474,8862188,10560513,10560519,8862255,8862357,8862358,8862359,8862360,8862361,8862362,8862363,8862364,8862365,8862366,8862367,8862368,8862369,8862370,8862371,8862372,8862373,8862374,8862375,8862376,8862377,8862378,8862379,8862380,8862381,8862382,8862599,10609818,10609819,8862730,8862781,10612987,10612988,10612989,10610020,8862892,8862893,10610096,10613154,10613225,8863095,10564589,10564590,10564603,10564605,10613563,8863475,10558766,10558943,10558944,10558951,8863669,8863695,8863696,8863697,8863698,8863699,10559019,10610930,10555216,4974259,10517228,10555313,10511317,4974418,4974439,4974443,4974459,4974464,10513427,4974468,4974470,10555440,4974483,4974503,4974511,4974522,4974541,4974548,4974551,4974559,4974574,4974581,4974583,4974588,4974590,4974592,4974598,4974633,10513643,10517673,4974796,4974803,4974822,4974863,4974873,4974880,10555852,4974974,4975032,4975109,4975235,4975278,10556349,2809281,10518679,10556813,10512819,10556835,10556883,8861763,8861794,10417247,4973224,4973382,4973537,4973539,10419745,4973692,4973948,4974132,4974133,4971158,10470897,4971197,4971198,4971200,4971204,4971262,4971263,10470998,10467006,10467007,10467008,10467009,10467010,10467011,10467012,10467013,10467014,10467015,10467016,10467017,10467018,10467019,10467020,10467021,10467022,10467023,10467024,10467025,10467026,10467027,10467028,10467029,10467030,10467031,10467032,10467033,10467034,4971395,10469139,10463195,10463198,10467223,10463458,10463843,8563247,10466089,8563428,8563435,8563446,4972407,4972430,10464160,10464179,4972461,4972477,4972543,8563604,10468285,10464321,4972635,4972656,4972657,10464502,4972852,4972882,4972918,4972919,4972920,4972921,4972922,4972923,4972924,4972925,4972926,4972927,4972928,4972929,4972930,4972931,4972932,4972933,4972934,4972935,4972936,10462661,4972937,4972938,4972939,4972940,4972941,4972942,4972943,4972944,10464850,10464853) 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'