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(10939575,10939576,10939603,10939743,10939744,10939876,10939885,10939912,10939924,4970580,4970636,4970637,4970638,10940061,4971024,4971025,4971063,4971064,4971065,4971066,4971067,4971068,4971069,8066934,8067157,8067160,8067161,8067162,8067163,8067164,8067165,8067166,8067167,8067168,8067185,4968488,4968489,4968490,4968491,4968492,4968493,4968494,8067292,8067437,8067467,8067468,8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067490,8067491,8067492,8067493,8067494,8067495,8067496,8067497,8067498,8067499,8067500,8067501,8067502,8067503,4968888,8067692,8067702,8067716,4969177,4969178,4969179,4969252,4969253,4969254,4969255,4969256,4969257,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969266,4969267,4969268,4969269,4969364,4969493,4969547,4969570,4969614,10939098,10939099,10939116,10939117,10939118,10939119,10939120,10939121,10939122,10939146,10939147,10939148,10939149,10939150,10939153,10939168,10939253,4969938,10939380,10939381,10939384,10939471,10939472,10939473,8065081,8065087,8065088,8065089,8065091,8065094,8065123,8065151,8065155,8065175,8065176,8065185,8065829,8065879,8065938,8066033,8066034,8066035,8066036,8066037,8066038,8066039,8066095,8066101,4967371,4967406,4967553,8066347,4967752,4967753,4967768,4968029,8066850,8064015,8064482,3655553,3655564,3655791,3655968,3655971,3655972,3655973,3655979,3656040,3656041,3656042,3656094,3656112,3656125,8072754,8072759,3656635,3656636,3656637,8072805,8072821,3656668,8072837,3656677,8072857,3656702,8072869,3656706,3656707,8072877,8072893,8072913,8072928,8072946,8072962,8072978,3656843,3656888,3656920,3656930,3656951,3657152,11049728,11049730,10622993,10623061,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,10623256,10918766,10623257,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,10623524,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,10919196,10919279,10623769,10623770,10919333,10623858,10623859,10623860,10919372,10919373,10919524,10919526,10919560,10624100,10919663,10919664,10919665,10919682,10919700,10919732,10919783,10919836,10919837,10919844,10919920,10919923,10919945,10919946,10919947,10919948,10919949,10919950,10919951,10919952,10919953,10919954,10919955,10919956,10919957,10919958,10919959,10919960,10919961,10919962,10919963,10919964,10919965,10919966,10919967,10919968,10919969,10919970,10919971,10919972,10919973,10919974,10919975,10624499,10622094,10622132,10622145,10622198,10622363,10622424,10622904,10622941,10620014,10620015,10620050,10620165,10620238,10620303,10620457,10620572,10620579,10620580,10620581,10620631,10620996,10621059,10621060,10621061,10621062,10621063,10621064,10621065,10621163,10621164,10621165,10621535,10621536,10621777,10621778,10621779,10565129,10565130,10565329,10565330,10565929,10563450,10563452,10563453,10563454,10563457,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10563795,10563796,10563813,10563827,10563828,10563829,10564989,10564991,10517117,10517118,10517119,10517120,10517121,10517122,10517123,10517124,10517125,10517126,10517127,10517128,10517129,10517130,10517131,10517132,10517133,10517134,10517135,10517136,10517137,10517138,10517139,10517140,10517141,10517272,10517276,10517329,10517330,10517331,10517333,10517334,10517335,10517336,10517337,10517338,10517339,10517340,10517341,10517342,10517343,10517344,10517345,10517346,10517347,10517348,10517349,10517350,10517351,10517352,10517353,10517354,10517355,10517356,10517357,10517358,10517359,10517360,10517361,10517362,10517363,10517364,10517365,10517366,10517367,10517368,10517369,10517370,10517371,10517372,10517373,10517374,10517375,10517376,10517377,10517378,10517379,10517380,10517381,10517382,10517383,10517384,10517385,10517386,10517387,10517388,10517389,10517390,10517391,10517392,10517393,10517394,10517395,10517396,10517397,10517402,10517403,10517404,10517405,10517406,10517407,10517408,10517409,10517410,10517411,10517412,10517413,10517414,10517415,10517416,10517417,10517418,10517419,10517420,10517421,10517422,10517423,10517424,10517425,10517426,10517427,10517428,10517429,10517430,10517431,10517432,10517433,10517434,10517435,10517436,10517437,10517438,10517439,10517440,10517441,10517442,10517443,10517444,10517445,10517446,10517447,10517448,10517449,10517450,10517515,10517516,10517517,10517518,10517519,10517520,10517521,10517522,10517523,10517524,10517525,10517526,10517527,10517534,10517656,10518202,10419223,10419232,10419524,10419525,10419526,10419527,10419630,10419631,10471249,10471250,10471360,10471361,10471362,10471363,10469911,10469912,10469913,10469915,10469917,10469922,10469923,10469939,10469943,10469960,10470007,10470008,10470641,10470664) 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'