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(10930095,3229171,3229172,3229177,3229182,8583517,8583566,7066266,8575733,8575734,8575735,8067918,8067927,8067942,8067943,8573316,10939439,7201336,7201377,7201390,7201453,7201454,7201590,7201591,7201592,7201593,7201594,7201595,7201596,7201600,7201605,7201607,7201730,7201741,7201742,7201959,7201974,7202257,7202285,7202439,7202445,7202446,7202447,7202448,7202449,7202450,7202451,7202452,7202453,7202454,7202455,7202456,7202457,7202458,7202459,7202460,7202461,7202462,7202463,7202464,7202465,7202466,7202467,7202468,7202469,7202470,7202471,7202472,7202473,7202474,7202475,7202476,7202477,7202478,7202479,7202480,7202481,7202482,7202483,7202484,7202485,7202486,7202487,7202488,7202489,7202490,7202491,7202492,7202493,7202494,7202495,7202496,7202497,7202498,7202499,7202500,7202501,7202502,7202503,7202504,7202505,7202506,7202507,7202508,7202509,7202510,7202511,7202512,7202513,7202514,7202515,7202516,7202517,7202518,7202519,7202520,7202521,7202522,7202523,5654620,5654621,7202585,5654676,5654677,5654683,7202643,7202667,7202672,7202680,9794578,9794579,9794580,9794588,7202767,9794592,9794594,3227190,7200087,7200091,7200094,7200105,7200106,7200107,7200108,7200109,7200110,7200111,7200115,7200120,7200121,7200123,7200124,7200125,7200126,7200127,7200128,7200129,3237362,3237393,3237394,3237395,3237398,7200231,7200232,7200233,7200234,8616849,7200382,7200527,7200528,7200529,7200550,7200551,7200553,7200555,7200558,7200559,7200562,7200563,8910452,8910453,8910454,8910455,8910456,8910457,8910458,8910459,8910460,8910461,8910462,8910463,8910464,8910575,7200922,7200923,7198396,7198399,7198400,7198678,7198679,7198680,7198681,7198682,7198683,7198684,7198685,7198687,7198688,7198690,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198726,7198727,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198740,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198759,7198760,7198762,7198763,7198764,7198765,7198766,7198767,7198768,7198769,7198770,7198772,7198781,7198782,7198890,7198891,7199006,7199395,7199396,7199397,7199449,7199508,7199545,7199569,7199570,7199571,7199573,7199574,7199575,10101504,10101551,7199739,7199740,7199741,7199742,7199743,7199768,7199844,7199877,7199878,7199881,10958379,7200030,7196220,8613064,8906635,8906644,8906650,8906651,8906658,8906659,8906683,8906704,7196979,7197052,7197077,7197103,7197259,7197260,10838919,10838920,10838921,10838922,10838923,10838924,7197417,7197433,7197437,7197446,7197456,7197473,7197479,3234660,3234661,7197503,7197505,7197516,7197518,10619844,8541459,3232382,10617118,8905149,10617332,10622365,10617426,10617427,10617454,10617461,10617509,10617510,3232798,3232913,3232914,3232915,8905719,8905720,8905721,8542254,8905822,8612632,8905862,10615024,10615329,10615330,10951828,10615363,10615721,10615722,10615727,3231052,10930631,10615933,10615938,10615939,10615950,10615953,10615956,10615962,10426193,10426204,10616016,10616019,10616023,10616030,10616033,10616044,10616045,8540418,10616056,10616058,10616059,10616060,10616075,10616076,10616077,10616097,10616103,10616105,10616118,10616119,10616123,10616124,10616126,10616127,10616131,10616132,10616134,10616147,10426372,10616173,10616175,10616181,10616182,10616210,10616211,10616219,10616220,10426445,10616228,10616229,10426448,10426449,10426450,10426451,10426452,8540604,8540605,10616243,10616245,10616248,10616252,10616253,10616254,10616258,10616265,8540632,8540633,10616267,10616268,8540638,8540642,10616287,10616295,10616298,10616302,10616303,10616311,10616323,10616324,10616329,10616332,10616333,10616341,10616342,10616348,10616350,10616351,10616353,10616370,10616375,10616387,10616389,10616393,10616394,10616395,10616397,10616400,10616401,10616404,10616407,10616410,10616411,10616412,10616416,10616417,10616423,10616426,10616430,10616431,10616440,10616441,10616443,10616453,10616454,10616459,10616475,10616476,10616479,10616542,10616543,10616544,10616553,10616644,10616648,10616649,10616655,8611391,10616790,10616856,10616862,10616872,10616873,10616874,10616875,10616876,10616877,10616880,10616888,10616898,10616905,10616906,10616907,10616910,10610978,7059524,10614054,10614057,10565319,9165550,10614220,6669828,6669907,10614376,10611423,10611655,10611789,10611830,10611831,10611832,10611833,10611834,10611892,10609285,10609313,10609354,10609355,10609366,10609844,10609913,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10612941,10609942,10612942,10609943,10612943,10609944,10609945,10609946,10609947,10609948,10609949,10609950,10609971,10609988,10613034,10610044,9172407,10613127,10613133,10613137,10613157,10610233,10610310,10610311,10610418,10613504,10613513,10613514,10613527,10613531,10610666,10613695,10613696,10613697,10613698,10613699,10613721,10613722,10613739,10613740,10613858,10613859,10613860,10610901,10610947,10610954,9169318,6673527,6673528,6673529,6673530,6673531,6673532,6673534,6673535,6673536,6673537,6673538,6673540,6673541,6673542,6673543,6673544,6673546,6673549,6673550,6673552,6673563,7055541,7055546,9169428,9169453,9169472,9169473,6673685,6673688,6673692,10117683,7055656,9161492,6673700,7055722,9169586,6673808,9169669,9169727,9169748,10515609,10515610,10515611,10515612,10515613,9169822,10517681,9169964,6674175,10118171,6674215,6674216,6674217,6674222,6674227,6674229,6674230,6674232,6674233,6674236,6674237,6674238,10118516,10118606,10118607,10118608,10118609,10118610,8552191,8552192,8552193,8552194,10512852,10419256,10419306,10419307,10415342,10416362,10416363,10419370,10419469,10416481,10419493,10419494,10419495,10419496,10419497,10419498,10418676,10418689,10418691,10418692,10418701,10418702,10418703,10418704,10418707,10418708,10418709,10418710,10416718,10416719,9168799,9168804,10418734,10418735,10418736,10418737,10418795,10418796,10418797,10418798,10418799,10418800,10418801,10418802,10418803,10418804,10418805,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,9168941,10418863,9168969,10418914,10418915,10418916,10418917,10418918,10418919,10418961,10418048,9161147,10419108,10419109,10419110,10419111,10419112,10419113,10419114,9169233,10419165,10419166,10419167,10419168,10419169,10419170,10419171,10419172,10419173,10419174,10419175,10419176,10419177,10471122,10471175,10469277,10469278,8549957,10123006,8550015,8550097,8550247,8550267,10467831,10467838,9167554,9167850,9167851,9168103,10470724,10888487,10888524,10888565,10888566,10888607,10946563,10946564,10946565,10888936,10889019,10889020,10889021,10884041,10884042,10889066,10889068,10884068,10884075,10889162,10889172,10889201,10889202,10889210,10889213,10889224,10889225,10889226,10889231,10884324,10884420,10884421,10889449,10889451,10889490,10889583,10889584,10889585,10889622,10884631,10889699,10889707,10889711,10889718,10889756,10889757,10889774,10889775,10889776,10889777,10884799,10884800,10879931,10889943,10889944,10884950,10889997,10890007,10885074,10885166,10890168,10890169,10890170,10890171,10890246,10890247,10880304,10880305,10885313,10632012,10887553,10887554,10882596,10877606,7000826,10882916,10882927,10887965,10887966,10882979,10882987,10882988,10882989,10882990,10883044,10883067,10883143,10888362,10883406,10161842,10885867,10885956,10885957,10885958,10885959,10886061,10162201,10949013,10187807,10626299,10626300,10626301,10886818,10886878,10886910,10631455,10631456,10167992,10887052,10877068,10887072,10882359,10882396,10598535,10598867,10579878,10579879,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529385,10529386,10529387,10529388,10529389,10529390,10529391,10529392,10529393,10529394,10529395,10529396,10529397,10529398,10529399,10529410,10529411,10544310,10528350,10543041,10543042,10498367,10498499,10505583,10483044,10483045,10483046,10483047,10483048) 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'