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(7201631,8595055,8595056,8595092,8595093,8595109,8595112,8595113,8595115,8595116,8628258,8628259,10858945,10858946,10198399,7201959,7201961,10198534,7202104,4970670,7202149,7202150,7202173,7202184,7202219,7202224,7202229,7202237,7202257,7202258,7202273,7202274,7202275,7202277,7202295,7202367,7202371,7202373,7202375,7202378,7202381,7202386,7202388,7202390,7202392,7202402,7202404,7202406,7202413,7202421,5654537,5654555,5654577,5654578,5654579,5654580,5654581,5654627,10859594,10859595,10859596,10859597,5654657,5654658,5654660,5654661,5654683,7202673,7202691,9794588,7202769,8837128,3227094,10860087,10860327,8629770,8629771,8629772,8629773,8629786,10860598,10860602,10860604,8910444,8627051,8910464,8627053,8627059,8627060,8627061,8067931,7200753,7200765,7200778,7200779,7200780,7200807,7200817,7200829,7200847,7200861,7200869,7200906,7200907,7200908,8627370,8627372,8627375,8627376,7201152,7201153,7201154,7201155,7201201,8594636,7201319,8594729,7201434,7201453,7198678,7198679,7198680,7198681,7198683,7198684,7198685,7198688,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198727,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,8625140,7198742,7198743,8625143,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198757,7198759,7198760,7198762,7198763,7198764,7198765,8625166,7198766,8625167,8625168,7198769,7198770,7198772,8625251,8625256,8625265,10221588,7199130,10856184,8564678,7199402,7199403,10856768,8626145,8626146,8626147,8626261,10856979,10856980,8626379,7200087,7200111,7200120,7200121,8626914,8834762,8834763,8907591,8907592,8907593,8907596,8907601,8907602,8907612,8907613,8907616,8907618,8907619,8907622,8907623,8907624,8907628,8907637,8907640,8907641,8907644,8907645,8907649,8907650,8907654,7197843,8907658,7197849,8907662,8907665,7197854,7197855,8907668,7197856,8907670,8907673,8907674,8907682,8907685,8907686,8907691,8907694,8907695,8907699,8907703,8907704,8907708,8624442,10246592,8624589,10100083,7198392,8615017,8908278,10852642,10852643,10852644,10852662,10852663,10852664,10852666,10852667,10852668,10852669,10852670,10852672,10852673,10852674,10852680,10852681,10852686,10852687,10852690,10852691,10852692,10852693,10865848,8905735,8905844,10853132,10853229,10853230,10853231,10853232,10853233,10853234,10853235,10866373,10866374,10853485,10853486,10853487,10853488,10866535,10866537,10866549,3923673,10866619,10866628,10866629,10866630,10866631,10866632,10866633,10866634,10866643,10866644,10866645,10866646,10866647,10866648,10866649,10866653,10866654,10866657,10866658,10866659,10866663,10866664,10866666,10866667,10866668,7196892,8554717,8554718,8554723,8906892,3234730,10850648,10850650,10850658,10850788,10850789,10850790,10425910,8633272,8633273,8633274,8633280,8633281,8633286,8633287,8633288,8633290,8633291,8633295,8633296,8540605,8540612,8540613,8540626,3231700,3231701,3231702,3231703,3231704,8611319,8611454,8611466,8611467,10851967,10851968,10851969,8904798,10427112,10852187,10852188,10852189,10852190,10852191,10852192,10852193,10852194,10852195,10852196,10852197,10852198,10852199,10852200,10852201,10852202,10852203,10852204,10852205,10852206,10852207,10852208,10852209,10852210,10852212,10852213,10852214,10852215,10852216,10852217,10852218,10852219,10852220,3232382,10852371,10852372,10852373,8634789,8634790,8634792,8634794,8634795,8634796,8541668,10852503,10852504,10619864,10619865,10619866,10862785,10862786,10622257,10617322,10617323,10617324,10617339,10617347,10617348,10617349,10617350,10617351,10617352,10617353,10617354,10617355,10617378,10617381,10622402,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617426,10617427,10617428,10617429,3230230,10617431,10617432,10617433,10617434,10617435,10617438,10622445,10617446,10617447,8632559,8632560,8632616,8632617,8632618,8632626,8632628,3230564,3230565,3230566,10425575,10190017,10190018,10850614,10850615,10850616,10850619,10850621,10615229,10615344,10615363,10930095,8630635,8630637,10615711,10615721,8630845,8630849,8630857,8630870,8630872,8630887,8630893,8630901,8630905,10615896,10848600,10848605,10848608,10848610,10848612,10848616,10848621,10848625,8631133,3228956,3228957,10188367,3229077,3229078,10188377,10188378,10188379,10188380,10188381,10188382,10188383,10188384,10188385,10188386,3229109,10616332,3229177,3229182,3229203,10616417,10616426,10188657,10188658,10188659,10188665,8631611,10616644,10849341,10849556,10616905,10616906,10616910,10616955,10614064,10714020,10714023,10714024,6669783,6669817,6669819,6669820,6669821,6669822,6669823,6669824,6669825,6669826,6669827,6669902,6669905,6669906,6669907,6669908,6669909,6669910,6669911,6669912,6669914,6669915,6669916,6670036,6670040,10614552,10614553,10614554,6666259,10611969,10611970,10612086,10612102,10612106,10612107,10612294,9913846,9913864,10612381,10612909,10612936,10612937,10612938,10612939,10612940,10612941,10612942,10612943,8567066,8567072,8567073,8852774,10613732,10613733,10613736,10117516,10117517,6673527,6673528,6673529,6673530,6673531,6673532,6673534,6673535,6673536,6673537,6673538,10117529,6673540,6673541,6673542,6673543,6673544,6673545,6673546,6673548,6673549,6673550,10117645,10117646,9912060,9169945,9169965,6674229,6674230,6674232,6674233,6674236,6674237,6674238,6674240,6674241,6674242,6674243,6674248,6674261,6674283,6674284,6674285,6674286,6674287,6674308,6674309,6674310,6674311,6674312,6674313,6674327,6674328,6674331,10118358,10118364,10118365,10118366,10118367,10118368,10118369,10118370,10118371,10118372,10118373,10118374,10118375,8551565,9912521,10118606,10118607,10118608,10118609,10118610,10118674,9912888,9912938,8552227,9913354,9913365,9913366,9168366,9168367,9910593,6672598,10416348,10416349,10416350,10416351,10416352,10416353,10416354,10416355,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10419375,10419376,10419500,10419505,10419506,10419507,10419508,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419525,10419526,10419527,10419530,10419531,10419535,10419537,6672829,6672871,6672872,6672887,6672903,6672904,6673067,6673081,6673143,6673144,6673145,6673146,6673147,6673148,6673149,6673151,6670728,8550036,8550065,8550087,8550247,8916798,10467927,10467928,10467929,10467930,10467931,10467932,10467933,10467934,10467935,976355,976356,976357,976358,976360,976361,976362,976367,976495,10468327,10468328,10468329,976584,9168293,10883559,10883560,10883561,10883562,10883568,10883569,10883570,10883571,10883572,10883587,10883589,10883590,10883591,10883592,10883593,10883594,10883595,10883596,10883597,10883622,10883623,10883624,10883625,10883626,10883627,10883628,10883629,10883630,10883631,10883659,10883660,10883661,10883664,10946563,10946565,10884041,10884042,10884068,10884097,10894377,10894378,10894380,10884466,10884596,10889774,10884799,10884800,10889997,10875001,10890104,10890107,10890108,10890112,10890120,10890121,10890128,10890131,10890134,10890149,10890155,10890157,10890158,10890173,10890174,10890175,10171233,10880304,10880305,10877492,10912863,10883227,10883228,10888339,10885763,10886064,10886065,10162201,10881492,10626143,10626144,10626145,10626375,10626378,10626379,10887024,10887096,10887097,10882149,10882150,10882151,10882152,10882153,10887199,10887200,10887201,10887223,10887224,10887225,10887226,10887227,10887228,10887229,10887230,10887231,10887232,10626724,10626725,10882359,10887464,10602160,10602162,10602163,10602164,10602165,10602166,10602167,10602168,10602169,10602170,10602171,10602172,10602173,10602174,10602176,10602177,10602178,10602179,10602180,10602181,10602182,10602183,10602184,10602185,10602186,10602187,10602188,10602189,10602190,10602191,10602192,10602193,10602194,10602195,10602196,10602197,10602198,10602236,10602689,10602695,10602696,10602697,10602701,10602702,10602703,10602704,10602705,10602706,10602707,10602708,10602709,10602710,10602711,10602732,10602739,10590279,10590280,10590308,10590309,10590310,10590311,10603683,10603687,10603688,10603691,10603692,10603694,10603695,10603696,10603698,10603699,10603700,10604146,10601437,10601574,10601687,10601688,10601692,10601693,10601694,10601695,10601696,10601697,10601698,10601699,10601700,10601701,10601702,10601703,10601704,10601705,10601707,10601708,10601709,10508280,10508584,10506821,10507922,10411281,10483044,10483045,10483046,10483047,10483048,10413460,10413461,10411686,10411839,10411840,10408024,10408025,10408026,10414032,10414033,10414477,10414665,10414845,10414849) 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'