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(8574224,8574480,8574483,8574485,8574501,8574504,8574505,8574506,8574512,8574523,4970684,10940064,8574527,8574528,4970688,4970700,4970715,4970716,4970717,4970767,8569481,8583132,8583133,8583135,8583159,10950389,8583297,8583305,8583306,8583376,7065912,8583382,8583386,7065919,7065920,7065924,7065926,8583405,8583408,8583434,7065980,7066004,7066022,8583529,7066061,10950709,8583569,7066161,7066190,8575407,7066258,7066260,11029223,10990263,10990264,10990265,10990267,10951422,8573027,10938592,10938644,8573262,10938958,10939151,8573638,10939271,10939358,10939382,8835964,8835967,7064551,10932008,10932009,8911786,8911946,8911947,8572101,8572117,8572153,8572172,8572192,8572193,8572199,8572245,10933053,10933055,8572830,8572834,8572841,8572853,8572854,8572855,8572859,8572860,8572861,8572862,8572863,8572864,8572865,8572866,8572885,8572896,8572898,8572979,8910050,8910052,8910054,8910681,10102769,8908495,8908496,8908523,8908770,10100934,10100936,10100937,10101158,8909097,10101172,10101205,10101231,10101449,10101451,10101452,10101459,10101460,10101463,8860265,8860266,10101499,10101523,10101567,10101572,8860406,8860408,10101937,8905895,8905971,8905975,8905976,10618265,10618266,10618268,10618269,10618271,10618274,10618275,10618276,10618292,10623314,10618318,10618323,10623404,8906605,8906606,8906701,8906852,8906901,8906909,8907065,8907066,8907090,10619207,10619208,10619209,10619210,8907410,8907411,8907436,10619862,8577999,10927510,8904911,8904922,10617031,10617033,10617037,10617044,8904971,10617061,10617062,8904987,8904988,10617079,10617080,10617081,8904996,8905002,8905003,8905006,8905015,8905023,8905027,8905039,10617163,10617172,10622185,8905201,8905251,8905252,8905253,8905288,8905302,8905351,8905380,8905391,8905542,8905555,8905556,8905565,10954399,8905809,8905811,8905837,10615002,10615007,10615019,10615042,10615219,10615220,10615268,10615307,10615317,10615328,10615329,10615330,10615335,10615343,10615408,10615417,10615418,10615419,10615420,10615421,10615425,10615565,10615568,10615569,10615576,10615597,10615601,10615602,10615629,10615630,10615663,10615664,10615684,10615711,10615818,10615820,10615867,10615870,10615871,10615962,10616044,10616045,10616053,10616054,10616089,10616094,10616095,8904309,8904324,8904325,10616499,10616506,10616518,10616530,10616542,10616576,8904493,10616683,10616684,10616701,10616727,10616728,10616850,10616851,10616858,10616859,8904791,10616905,10616940,10616941,10616943,10613973,10613974,10613988,10611007,10611028,10614039,10611052,10611053,10614054,10611054,10611057,10611061,9205435,10611123,10611125,10614199,9165550,10614221,10614282,10614316,10611323,10611337,10611341,10611352,10611363,10614378,10614422,10614423,10614447,10614464,10614517,10614538,10614547,10614552,10614553,10614554,10565704,10565706,10614617,10614619,10614620,10614629,10614648,10614664,10614669,10614678,10614716,10614759,9166126,10611800,10611802,10611823,10611861,10611862,9166267,9166276,10611989,10612030,10612039,10612053,10609075,10612095,10612135,10612136,10612137,10609141,9163505,10609188,10609189,10609190,10609191,10612199,10612200,10612201,10612204,10612205,10612228,10612233,10609258,10609259,10609260,10609261,10612314,10609339,10609347,10609348,10612348,10609349,10609350,10609351,10609352,10609353,10609354,10609381,7017375,7017376,10609388,10609389,7017381,7017382,7017385,7017386,7017387,10609397,7017388,10609398,7017393,7017394,7017399,7017400,10612417,10609463,10612482,10612484,10612521,10612522,10609527,10612528,10612531,10612534,10612535,10609544,10612555,10609559,10609573,10609588,10609590,10609592,10609593,10609607,10609609,10609616,10609617,10609621,10609625,10612625,10609626,10609630,10609636,10612652,10609666,10609668,10612679,10609683,10612683,10612688,10609707,10609708,10609715,10609716,10609721,10612727,10609730,10609731,10609732,10612732,10612737,10612738,10609744,10609745,10612746,10609747,10612752,10609757,10612757,10609758,10609763,10612765,10609769,10609770,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612786,10612791,10612794,10609799,10612806,10612811,10612812,10612813,10609814,10612815,10612816,10612821,10609824,10609827,10609830,10612836,10609841,10609842,10609843,10609845,10612846,10612856,10609875,10609876,10609877,10609878,10609898,10609902,10609903,10612904,10609904,10612905,10609916,10609917,10609918,10612921,7017939,10612952,10609954,10609955,10612958,7017959,10609974,10609983,10612984,10612987,7017979,10612988,10609988,10612989,10609989,10612990,10609994,10613023,10610030,10610045,10610046,10610054,10613096,10610104,10610106,10610119,10610120,10610121,10610151,10610236,10613261,10613276,10613278,10613292,10610295,10613306,10610316,10613356,10613357,10613363,10613373,10610390,10610405,10610406,10610440,7018449,7018450,10610466,10610469,10610493,10610499,9164846,9164847,9164848,9164850,9164851,9164852,9164858,10613562,10613630,10610671,10610687,10610688,10610689,10610693,10610695,10610704,10610705,10610725,10613797,10613802,10613812,10613813,10613814,10613815,10610862,9165202,10613889,10613890,10613898,10613922,10613923,10610933,9169324,9177364,9169437,9169498,10515335,7015179,7015200,7015221,7015242,7015263,7015283,7015303,7015323,9169698,9169700,7015356,7015357,9169713,9169714,9161786,9161792,9169804,9169870,9169871,9169926,9169985,2809285,9168377,10416313,9168395,10416318,10415342,10416359,10415362,10416363,10419371,10419440,10416441,10415448,9160527,10417450,10418478,10416478,10416488,9168567,9168568,9160586,9168668,10417591,10417592,9184672,10415646,10415656,10417657,10417658,10417659,10415661,10415662,10415665,10415666,10415671,10415673,10415674,10418676,10415684,10417716,10417717,9168798,9160812,9168815,10415746,10415747,10415748,10415761,10415762,9168849,9168854,9168855,10415782,10415783,9168861,10415784,9168862,10415785,10415786,10415787,10415788,9168868,9160871,10416801,10416802,10416803,10416804,10416805,7014555,7014565,7014575,7014585,10415856,7014595,10415869,7014605,7014615,7014625,10418918,9169031,9161038,10418967,9161051,9169052,9169055,9169066,10418991,10416028,9169114,9161157,10420106,10420107,10419116,7014918,9169264,7014919,7014920,7014921,7014922,7014923,7014924,7014925,8549463,10468902,9166351,9166358,10468941,10468954,10468955,9166383,8549540,10468972,10468996,10468997,10469062,10471106,10471108,10471114,10471117,10469131,8549751,9166599,8549792,8549817,8549831,8549838,10469328,10463361,8549942,8549944,8549945,8549946,8549947,8549949,8550030,8550031,8550045,8550046,10469481,8550070,8550080,10467504,10469529,8550123,10467556,10467559,10467562,8550154,10467583,8550167,8550168,8550169,8550172,8550173,8550174,8550175,8550176,8550177,8550186,10467610,10467613,10467617,10467618,10467619,10467620,10467621,10467627,8550207,10467631,10469636,10467637,10469638,10467646,10467648,10467667,10467670,10467681,10467745,10467844,10467845,10467846,10469957,10469965,10469966,10469972,10469973,10469974,10469975,10469976,10469977,10467981,10467982,10467983,8550688,10466249,9167672,9167673,9167674,10468252,9167681,9167699,10468300,10468304,9183753,9167775,9167785,9183791,9167799,9167820,9167822,9167824,9167827,9167828,9167830,9167834,9167835,9167836,9167837,9167838,9167839,9167840,9167842,9167843,9167844,9167852,9167856,9167857,10468445,9167918,10468568,9208010,9168013,9168014,10468623,9168101,9168119,10470770,9168195,10468795,10468796,10468797,10470799,10470800,10470822,10468832,10184540,10184545,10946350,10946386,10946388,10946404,10946423,10946434,10628157,10946479,10946482,10946848,10946865,10946882,10628611,10947051,10947062,10947078,10947083,10947101,10947142,10947144,10947145,10947146,10947147,10947150,10947151,10947173,10628918,10947251,10947267,10947370,10947378,10947452,10947602,10947657,10947714,10947721,10874951,10947929,10947930,10947947,10947952,10947953,10947981,10947990,10948001,10948005,10948028,10948057,10948065,10948098,10948103,10948108,10948138,10948143,10948150,10948151,10948182,10948183,10948184,10948216,10948261,10948264,10945286,10945288,10945349,10945436,7000824,10945447,7000849,10945577,10945578,10945579,10945618,10945721,10945723,10945728,10945798,7001393,10946019,10946030,10627712,10946085,10946107,10946109,10946112,10946117,10946140,10946165,10946177,10946216,10946223,10946241,10946254,10946260,10946261,10946263,10946268,10946278,10948306,10948384,10161773,10161784,10161826,10161827,10161830,10161834,10162168,10625646,10626211,10162851,10945138,10945161,10945193,10945225,10626926,10626945,10626954,10590577,10579823,10521879,10521880,10425228,10424390,10424395,10424399,10424401,10424407,10424413,10424415,10424417,10424424,10424433,10483191,10486547,10486553,10486622,10486623,10486661,10486662,10477680,10477681,10474267,10474297,10476458,10476464) 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'