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(8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630647,8630649,8630650,8630651,8630652,8630653,8630654,8630657,8630658,8630659,8630660,8630661,8630662,8630663,8630664,8630665,8630666,8630667,8630668,8630669,8630670,8630671,8630672,8630673,8630674,8630675,8630676,8630677,8630678,8630679,8630680,8630681,8630682,8630683,8630684,8630685,8630686,8630687,8630688,8630689,8630690,8630691,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630710,8630711,8630712,8630713,8630714,8630715,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630736,8630737,8630738,8630739,8630740,8630741,8630742,8630744,8630745,8630747,8630748,8630749,8630750,8630751,8630752,8630753,8630754,8630755,8630756,8630757,8630758,8630759,8630760,8630765,8630766,8630767,8630768,8630769,8630770,8630771,8630772,7076128,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630786,8630787,8630789,8630791,8630792,8630793,8630794,8630795,8630796,8630797,8630798,8630799,8630800,8630801,8630802,8630803,8630804,8630805,8630806,8630807,8630810,8630811,8630812,8630813,8630814,8630815,8630816,8630818,8630820,8630821,8630823,8630825,8630827,8630829,8630831,8630832,8630833,8630834,8630835,8630836,8630837,8630838,8630839,8630840,8630843,8630845,8583517,8583522,7066266,8575733,8575734,8575735,8067927,8067942,8067943,8573316,10939439,10930095,7201319,7201377,7201390,7201605,7201607,7201730,7201741,7201742,7201959,7201974,7202211,7202212,7202213,7202257,7202285,7202319,7202329,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,5654683,7202643,7202672,7202683,7202684,7202687,7202689,7202690,7202691,9794578,9794579,9794580,9794588,9794592,9794594,3237362,3237393,3237394,3237395,3237398,7200231,7200232,7200233,7200234,8616849,8834762,8834763,7200527,7200528,7200529,8910452,8910453,8910454,8910455,8910456,8910457,8910458,8910459,8910460,8910461,8910462,8910463,8910464,7200901,7200906,7200907,7200908,7201153,7201154,7201155,7198386,7198394,7198678,7198679,7198688,7198695,7198696,7198697,7198698,7198700,7198701,7198702,7198703,7198704,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198721,7198722,7198723,7198725,7198730,7198731,7198736,7198744,7198745,7198747,7198750,7198752,7198760,7198763,7198764,7198765,7198766,7198769,7198770,7198772,7198781,7198782,7199006,7199135,7199508,7199545,7199739,7199740,7199741,7199742,7199743,7199768,10958379,7200030,7200091,7200111,7200120,7200121,7196220,8613064,7196979,7197052,7197077,8906900,8906901,7197103,7197417,7197456,3234660,3234661,10619844,8541459,3232382,10617118,10617323,10617324,10617332,10617343,10617345,10622365,10617373,10617374,10617403,10617404,10617405,3232798,10617409,10617421,10617422,10617423,10617426,10617427,10617437,10617441,10617442,10617443,10617454,10617455,10617461,10617509,10617510,3232913,3232914,3232915,8905719,8905720,8905721,8542254,8905822,8905862,10425386,10425387,10425388,10425389,10425392,10425551,10425554,10425556,10951828,10425576,10425579,10425580,10425582,10425583,10425585,10620303,10615343,10615363,10425911,10930631,10615721,10615722,10615727,10426193,10426204,10615896,8540418,10615939,10426338,10426372,10616058,8540633,10616332,10616417,10616426,8611391,10616644,10616905,10616906,10616910,10610978,10610984,10610985,7059524,10614054,10614057,10565319,10614220,6669818,6669828,6669907,10614376,10614499,10614501,10614502,10611655,10611782,10611789,9166129,10611892,10609285,10612293,10612294,10609313,10609354,10609355,10609366,10609369,10612381,10609844,10609917,10609918,10609919,10609920,10609922,10609923,7017914,10609924,7017915,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10612936,10609937,10612937,10612938,10609939,10612939,10609940,10612940,10612941,10609942,10612942,10609943,10612943,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,10609971,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,10609988,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,9172407,10613133,10613135,10613137,10613157,10610233,10613369,10610480,10610481,10613504,10613513,10613514,10613527,10613531,10610666,10613695,10613739,10613740,10613858,10613859,10613860,10610901,6673523,9169318,6673527,6673528,6673529,6673530,6673531,6673532,6673534,6673535,6673536,6673537,10117529,6673538,6673540,6673541,6673542,6673543,6673544,6673546,6673549,6673550,6673552,6673563,7055541,7055546,9169428,9169453,9169472,9169473,6673685,6673688,10117683,6673692,7055656,9161492,7055722,9169586,6673808,9169695,9169748,10515609,10515610,10515611,10515612,10515613,10517681,9169948,9169951,9169955,9169964,6674175,10118171,6674249,6674256,6674276,6674278,6674280,6674281,6674326,6674329,6674330,10118606,10118607,10118608,10118609,10118610,8552191,8552192,8552193,8552194,10512852,6672592,6672604,10415342,10416362,10416363,10419370,10419468,10419469,10419470,10416481,10419493,10419494,10419495,10419496,10419497,10419498,6672802,6672896,6672897,6672898,6672899,6672900,6672901,10416718,10416719,9168804,6673064,6673085,6673088,6673089,9168941,9168969,10418914,10418915,10418916,10418917,10418918,10418919,6673287,6673300,10418048,9161147,9169233,10419165,10419166,10419167,10419168,10419169,10419170,10419171,10419172,10419173,10419174,10419175,10419176,10419177,6670727,6670729,10471175,10469277,10469278,8549957,10123006,8550015,8550063,8550064,8550247,8550266,8550267,9167554,9167779,9167850,9167988,9168103,9168121,10888487,10888524,10888565,10888566,10883587,10883588,10883624,10883629,10946563,10946564,10946565,10893984,10893985,10893986,10893987,10893988,10889019,10889020,10889021,10889052,10884075,10884086,10889231,10884324,10884420,10884421,10889449,10889583,10889584,10889585,10884631,10889707,10889756,10889757,10889774,10889775,10889776,10889777,10884799,10884800,10884950,10889997,10890007,10885074,10890104,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890132,10890149,10890154,10890159,10890161,10890162,10890163,10885166,10890168,10890169,10890170,10890171,10890173,10890174,10890175,10890246,10890247,10880304,10880305,10885313,10887472,10632012,10882596,7000826,10627319,10883044,10883067,10883143,10888362,10883406,10161842,10885867,10885956,10885957,10885958,10885959,10886061,10162113,10891654,10891655,10626299,10626300,10626301,10886818,10886878,10886910,10167992,10887052,10877068,10887072,10882359,10882396,10887464,10887465,10598535,10598867,10647535,10647552,10647714,10579878,10579879,10545324,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,10541444,10544310,10528350,10543041,10543042,10498367,10422598,10498499,10506819,10506823,10506824,10483044,10483045,10483046,10483047,10483048,10408025,10408707) 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'