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(8620779,8620780,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,4970228,4970229,11028069,11028070,8838899,11015215,10963378,10963379,10950378,10944172,10944173,11041476,11041477,10846630,10846631,10846632,10846633,10846634,10846635,10846636,8583605,8583606,8583607,8583608,7074296,8622170,8067381,8067382,8067383,8622296,8622297,8622298,7074577,10437442,10437443,10437444,10437445,10437446,8622439,8622440,8622441,8622442,10437469,10437470,10437471,10437472,10437473,10437474,10437475,10437476,10437477,10437478,10437479,10951265,10990350,7074739,11042447,7066773,8837519,11013798,7067423,8620460,10962313,10962314,10962315,10962316,10962317,10962318,10939267,10939268,10939269,10939270,8838368,8838369,8838370,8838371,8838372,10962574,8911266,8911267,8911268,8911269,8911270,8911271,8911272,8911273,8911274,8911275,8911276,8911277,8911278,8911279,8911280,8911281,8911282,7072298,7064304,11037998,11037999,11038000,11038001,11038002,11038003,11038004,11038005,11038006,11038007,11038008,11038009,11038010,11038011,11038012,11038013,11038014,11038015,11038016,11038017,11038018,11038019,11038020,11038021,11038022,11038023,11038024,11038025,11038026,11038027,11038028,11038029,11038030,11038031,11038032,11038033,11038034,11038035,11038036,11038037,11038038,11038039,11038040,11038041,11038042,11038043,10103602,10103603,10103604,10103605,10103606,10103611,10103612,10103613,10103614,10103615,10103616,10103617,7072622,8618465,8618466,8618467,10960333,10932115,10999571,11025573,11025574,11025575,11025576,11012638,11012639,11012640,11012641,8618810,10104137,10104138,10932445,10932446,10932447,10932448,10932458,10932459,10932460,10932461,10932462,10932463,10932567,10932568,10104350,8836871,8836872,7073470,7073471,7065489,10932867,10932868,8837212,10104856,10974481,10942833,10942834,10942835,10942836,10942837,10942838,10942839,10942840,10942841,10942842,10942843,10942844,10942845,10942846,10942847,10942848,10942849,10942850,10942851,10942852,10942853,10958959,11049207,11049208,11049329,11049330,11049331,11049332,11049333,8910775,8910914,11022052,11009422,11009423,11009424,11009425,11009426,11009427,11009450,11009451,11009452,11009453,11009454,11009455,11009456,11009457,11009458,11009459,11009460,11009461,11009462,11009463,8615756,11009749,11009750,8565127,8565128,11048477,11036386,11006630,11006631,11045875,11045876,10623342,11046047,10623436,8613687,8613688,8613689,8613690,8613691,8613692,10968546,10618949,10618950,10618951,10618952,10619103,8907433,8611901,8578250,8578251,11005815,10622269,11005936,8612088,11005937,11005938,11044993,11044994,10622424,11019082,10622430,10622441,8612262,8612263,10922966,10922967,10922968,10922969,10922970,10922971,10922972,10922973,10922974,10922975,10922976,10922977,10922978,10922979,10922980,10922981,10922982,10922983,10922984,10922985,10922986,10922987,10922988,10922989,10922990,10922991,10922992,10922993,10922994,10922995,10922996,10922997,10922998,10922999,10923000,10923001,10923002,10923003,10923004,10923005,10923006,10923007,10923008,10923009,10923010,10923011,10923012,10923013,10923014,10923015,10923016,10923017,10622508,10923018,10923019,10923020,10923021,10923022,10928136,11006298,10928241,10928242,8612679,11032572,11032573,8570161,11042887,10615232,8570182,8570183,11042915,11042916,8570349,8570350,8570351,10615471,10615474,10925989,10925990,10925991,11030153,11030154,11030155,11030156,10952105,10952106,8570487,10916219,10916220,10916221,10916222,10916223,10916224,10916225,10916226,10916227,10916228,10916229,10916230,10916231,11004380,10916232,10916233,11017446,11017447,11017448,11017449,10978538,10978539,10978540,10978541,10978542,10978543,10978544,10978545,10978546,10978547,10978548,10978549,10978550,10978551,10978552,10978553,10978554,10952535,10930960,10930961,10991855,10991856,10991857,10991858,10991859,10991860,10953075,10953076,10953077,10953078,10953079,10953080,8611447,8611451,10927246,10927247,10927248,10927249,10927250,10927251,11005597,7018979,9181385,10565224,10565348,7019223,7019406,7019494,10562684,10562685,10562686,10562687,10562688,9197876,7019530,10562689,9197877,10562690,9197878,10562691,9197879,10562692,9197880,10562693,10562694,10562695,10562696,10562697,9197885,10562698,9197886,10562699,9197887,10562700,9197888,10562701,9197889,10562702,10562703,10562704,10562705,10562706,10614567,10614568,10562749,10562750,10562751,10614629,7019627,10614654,7019695,7019705,9206086,9206087,9206088,9206089,9206090,9206091,9206092,9206093,9206094,9206095,9206096,9206097,9206098,9206099,9206100,9206101,9206102,9206103,9206104,9206105,9206106,9206107,9206108,9206109,7019776,10611788,7019800,8864815,7025001,7025009,7025017,10563313,10563314,10563315,10563316,10563317,10563318,10563319,10563320,10563321,10609285,9211787,9211788,9211789,9211790,9211795,10612585,9211980,9211981,10612645,9172086,7058412,7058413,9212280,7018062,7018106,7018138,9196650,9172744,7058938,7058939,7058940,7058941,7058942,9172777,7058943,9172778,7058944,7058945,7058946,7058947,7058948,7058949,7058950,7058951,7058952,7058953,7058954,10558634,10558635,9196831,9204905,9204906,9172907,7018731,9205139,9205140,9205141,10610937,10511143,10511144,10511145,7014986,10511146,10511147,10511148,7055534,7015035,7015107,7015136,9209485,7055834,4974769,10515737,10515738,10515739,10515740,10515741,10513754,10513755,10513976,10514024,7056469,9178546,9178547,9178548,9178549,9178550,9178551,9178552,9178553,9178554,9178555,9178556,9178557,9178558,9178559,9178560,9178561,9178562,9178563,9178564,9170669,10516651,10516652,10516653,7024645,7024743,7024803,7024804,7024857,7024917,10416405,10417466,10417467,10417468,10417469,10417470,10417471,10417472,7022256,10416561,4973536,9160752,9160753,9160754,10419677,10419678,9168777,9168785,9176793,9208855,10416921,9201057,7014794,10416105,10416106,7014866,9161229,7014921,8864828,10462902,10462903,10462904,10462905,10462906,9166476,9182490,10467085,10467086,4971425,7020292,9174667,7020416,9174763,9198976,9199015,8916796,8916797,8916889,10469843,7021006,7021120,8563553,8563559,6667715,6667716,6667717,6667718,6667719,6667720,6667786,6667787,6667788,8917583,8917584,8917585,8917586,9207957,6668153,10466740,10466741,10466742,10466743,8917813,10466744,10466745,10466746,10174972,10174973,10628584,10175110,10175111,10175270,10175271,10175272,10175273,10175274,10175275,10175276,10175277,10175403,10186279,10186280,10186281,10186282,10186283,10186284,10186285,10186286,10186287,10186288,10186289,10186290,10186291,10186292,10186293,10186294,10186295,10186296,10166474,10166475,10183876,7001291,7001292,7001293,10184196,10184198,10184199,10184200,10184201,10627707,10627708,10946223,10948337,10630076,10630103,10181689,10181690,10630287,10177107,10630660,10630661,10630662,10630663,10630664,10630665,10630666,10630667,10630668,10630669,10630670,10630671,10187999,10168052,10168085,10168086,10571255,10571256,10571257,10583474,10583475,10583476,10586560,10586561,10586562,10586582,10586583,10586584,10598678,10589799,10586861,10586862,10586863,10586864,10586865,10572013,10581106,10581107,10581108,10581109,10581110,10581111,10581112,10581113,10581114,10581115,10581116,10581117,10581118,10581119,10581120,10581121,10581122,10581123,10581124,10581125,10581126,10581127,10581128,10581129,10581130,10581131,10581132,10581133,10581134,10581135,10581136,10581137,10581138,10581139,10581140,10581141,10581142,10581143,10581144,10581145,10581146,10581147,10581148,10581149,10581150,10581151,10581152,10581153,10581154,10581155,10581156,10581157,10581158,10581159,10581160,10581161,10581162,10581163,10581164,10581165,10581166,10581167,10581168,10581169,10581170,10581171,10581172,10581173,10581174,10581175,10581176,10581177,10581178,10581179,10581180,10581181,10581182,10581183,10581184,10581185,10581186,10581187,10581188,10581189,10581190,10581191,10581192,10581193,10581194,10581195,10581196,10581197,10581198,10581199,10581200,10581201,10581202,10581203,10581204,10581205,10581206,10581207,10581208,10581209,10581210,10581211,10581212,10581213,10581214,10569365,10569366,10569367,10590595,10569597,10569598,10572704,10572705,10572706,10572707,10572708,10585141,10585142,10585143,10585144,10585145,10585146,10585147,10585148,10585149,10585150,10585151,10585152,10585153,10585154,10585155,10585156,10585157,10585444,10585445,10579758,10579877,10574064,10574065,10574066,10574067,10574068,10574069,10574070,10574071,10574072,10520078,10520079,10520080,10520081,10520082,10520083,10520084,10520085,10520086,10520087,10520214,10520215,10528240,10424450,10423808,10423809,10423810,10479106,10473149,10473150,10473151,10473152,10473153,10473160,10473161,10473162,10473216,10490510,10490515,10490516,10490654,10473875,10474010,10493484,10493485,10493486,10489853,10489854,10489855,10489858) 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'