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(10871652,10871694,7201782,8559507,10263318,10263319,10263320,10263321,10263322,10263323,10263324,10263325,10263326,10224473,10859063,10859064,10859065,10859066,10859067,10859068,10859069,10859070,10859071,7202219,7202220,7202223,10237779,10237780,10237781,7202385,8836651,8595822,8595850,8595858,10872539,10872623,8619224,8596134,8596236,8619509,7074161,10277401,10277402,8619581,8619582,8619583,10277526,10277527,8619675,10277624,10277651,10277652,10277653,8619982,8620060,10929580,8620162,8617205,8617258,7066919,8910525,8067930,7074951,8910550,10262205,10262206,10262207,8617369,10262257,8617463,8617464,10197357,10197358,10197359,4430315,8617561,4430395,10262502,10262503,10262504,4430442,10197539,10197540,10197541,10858120,10197542,10197543,10197544,10197645,10262673,10197819,10197820,10197821,10197840,8835736,8835748,8835798,3925794,3925795,8615312,3925888,8615391,10868856,3925972,3925973,3926049,10260420,10260421,10260422,10260423,10260424,3926226,8625531,8625532,10234701,10221786,10221787,10221788,3926504,8909173,10221836,7072610,10234858,7072670,10221928,7072712,8909305,8909306,8909307,10222031,10101457,10101458,8557282,7072811,10209186,7072969,8909562,8909563,10261249,10261250,10261251,10261252,10261253,10261254,10261255,10261256,10261257,10261258,10261259,10261260,10261261,10261262,10261263,10261264,10261265,10235295,10209317,8909771,3927121,10235452,3927154,10261485,10261486,10261487,10261488,10261489,8626518,8626519,8909932,8626520,8626521,10261803,10261804,10261805,7157954,7157955,7197714,10272254,10942738,10839332,10854927,8861102,8861106,8861118,10259496,10259497,10259498,10259499,10259500,10259501,10259502,10259503,10259504,10259505,10259506,10259507,10259508,10207695,10207696,3925573,7071706,3925675,7071777,7071778,3925712,10244150,7156255,10244590,10244591,10244592,10205658,10205659,10205660,10205661,10205662,10205663,7069457,8906067,10244835,8906185,8906186,8906187,10244896,10244897,10244898,7156756,7156758,7156759,7156760,8906363,8906364,7156864,7156865,10271312,10206492,10206493,10232576,10232577,7157572,10245836,8073519,7157752,7157753,7157754,7157755,10942482,10617988,10617989,10617990,8576617,8576618,10242172,10242173,10242174,10242175,10268212,8576790,8576866,8577040,8577041,8577042,10426249,10268603,10268604,10268605,10268606,10268607,10268608,10268609,10268610,8577153,10242699,10242700,8577245,10426468,8904230,8577419,8577420,8577421,10268959,10268960,10268961,8904362,8577750,8904984,8904985,10243658,10243659,10243660,10269864,10243879,10243975,10622035,8575605,8575606,10241289,10241290,10241291,10267422,10267423,10267424,10267425,10267426,10267427,10267428,10267429,10267430,10267431,10267432,10267433,10267434,10267435,10267436,10267437,10267438,10267439,10267440,10267441,10267442,10267443,10267444,10267445,10267446,10241485,10241486,10241487,8576068,8632785,10241889,10241890,10622907,10622908,10863595,10242022,8837861,8837862,8837863,8569899,8569900,8838048,10265336,10265337,10265338,10265339,10265340,10265341,10265342,10265343,10265344,10920762,10265345,10920763,10265346,10265347,10265348,10265349,10265350,10265351,10265352,8574047,10447836,10447880,10921267,10448056,10921548,10240183,10921642,10921767,10921768,10921769,10921770,10921771,10253456,10253457,10253458,10921898,10921899,10921900,10188643,8583454,10240763,10240764,10240765,10847005,10240985,10240986,10240987,10240988,6677768,9189683,6677911,9190005,9190006,9190054,8853930,8853931,9190192,9190193,8854119,8854120,9203377,9203378,9203379,9203380,9195384,9195385,9195386,9195387,9195388,7057623,7057631,10557346,10557347,10557348,10557349,9187621,10557511,9187803,9203816,9203817,9203818,10612506,9187908,10612583,9187996,9914207,9204005,9204006,9196039,9196097,9914333,9914334,9204127,9204181,9204237,8852090,8852102,8566790,9204387,9204388,9204389,9204554,10558562,10558563,9189064,10117508,6673539,9911811,9911813,8849525,8849526,8849595,8849596,9193783,8593008,8593009,9193910,9193911,9193912,9193913,7023573,9201988,7056195,9194119,9202134,6674404,9202265,8850106,8850107,9194343,9194344,9202429,9194481,9194482,9202602,6674818,9194622,9194623,9194727,10118926,9202746,6675013,9194867,9202867,9194868,9202868,9194869,9194870,9194871,9171152,10516983,9195276,9195277,6675498,9200468,9200469,9200470,9200471,9200472,6680684,8848356,8848357,8848358,8848360,6680768,9200612,9200841,9208938,6673218,8848837,10428404,10428437,8064692,8849058,8849060,8849061,6678508,6678509,8568829,9916559,6678568,9916662,8854291,9916719,10122755,9916778,9916779,4971490,8854471,8854472,8549938,9182850,10469532,3656233,10467609,10467610,10467611,9199035,10467612,10467623,10467624,10467625,10123335,10123371,8550485,10115579,8847296,8847379,10468221,8847547,6679948,6679949,6679950,6679951,6679952,9191749,6680019,6680020,9167831,8847741,8847742,10124138,10124212,9200026,9200027,9200028,6680253,6680254,9168066,10470670,10124309,10124409,9200233,8848110,10174486,10918521,10918522,10918523,10918524,10918704,10174757,10883764,10174824,10174825,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10908909,10179935,10908923,10883927,10179962,10908969,10909029,10909030,10909031,10909032,10180158,10180159,10180160,10909161,10909162,10909163,10165209,10904204,10919268,10919269,10919270,10919271,10919272,10919273,10919274,10904329,10904330,8594457,10904467,10914468,10904468,10904469,10904470,10904471,10904472,10180560,10180561,10180562,10180563,10919601,10919602,10909626,10914643,10914644,10914645,10914646,10914647,10914648,10904711,10904712,10904713,10904714,10904715,10904716,10909829,10919851,10904910,10904911,10904912,10904913,10919914,10904914,10919915,10904915,10904916,10180943,10180944,10180945,10905012,10905013,10905014,10905015,10905063,10905064,10166184,10166185,10181223,10900360,10629926,10629927,10183628,10183629,10183630,10183631,10183632,10183633,10183634,10183635,10183636,10183637,10183638,10882905,10882906,10882910,10912937,10912938,10882983,10882984,10918029,10918160,10918161,10913170,10913171,10888184,10174380,10181493,10181494,10629979,10630062,10630102,10181705,10166867,10166868,10166869,10890870,10890871,10890946,10890955,10182045,10182212,10177317,10906360,10182374,10182375,10172382,10172383,10177401,10177402,10177403,10906465,10162545,10162595,10182620,10182621,10182622,10182623,10906627,10906628,10906794,10182807,10906795,10182808,10906796,10906797,10906798,10172842,10907041,10907042,10907043,10907110,10907111,10907112,10907113,10183143,10183144,10887300,10183326,10577220,10571440,10577474,10577475,10568653,10568654,10568655,10568656,10568657,10568658,10568659,10568660,10568661,10568662,10602559,10574739,10571850,10571851,10571852,10571853,10571854,10571855,10571856,10571857,10571858,10571859,10652945,10577899,10577900,10577901,10568904,10568905,10574913,10574914,10574915,10574916,10574917,10568925,10653166,10575177,10575178,10575179,10578257,10647350,10572308,10572309,10572310,10650389,10578343,10578344,10578345,10578346,10578347,10578348,10578349,10578350,10578351,10575436,10578646,10578647,10578648,10578649,10578793,10578794,10578795,10578796,10578797,10581828,10578876,10581884,10581925,10581926,10609859,10609860,10609861,10609862,10609863,10609864,10609867,10609868,10609869,10609870,10609874,10609914,10609915,10579098,10579099,10604182,10654414,10654415,10651535,10601555,10601556,10601557,10610657,10576968,10576969,10576970,10576971,10601860,10601861,10601866,10601867,10553221,10553222,10553223,10553224,10553225,10553226,10553227,10553228,10553229,10535409,10555493,10525562,10553575,10553576,10553577,10551591,10551592,10551593,10551594,10551595,10551596,10551597,10551598,10539706,10539707,10539708,10527798,10553964,10553965,10553966,10553967,10553968,10553969,10553970,10553971,10553972,10553973,10553974,10553975,10553976,10553977,10553978,10553979,10535998,10535999,10536000,10536001,10536002,10536003,10536004,10536005,10536006,10536007,10536008,10536009,10536010,10536011,10536012,10536013,10536014,10536410,10536411,10534479,10534480,10534481,10534482,10534483,10552483,10554515,10554516,10554517,10554518,10554519,10550547,10550548,10550549,10550550,10550551,10550552,10550553,10550554,10550555,10550556,10550557,10550558,10550559,10550560,10550561,10550562,10534647,10554749,10554750,10554751,10554752,10554753,10554754,10554755,10554756,10554757,10554758,10554759,10554760,10554761,10540769,10540820,10540821,10548899,10548913,10548914,10548915,10534928,10508311,10508312,10508358,10507940,10487930,10493935,10480996,10488013,10494020,10494021,10494132,10413564,10413565,10413566,10413567,10413568,10413569,10413570,10481226,10413571,8562549,10481227,10413572,8562550,10481228,10494265,10481448,10481449,10478123,10497246,10497329,10495517,10495518,10495519,10493745,10493845,10487856) 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'