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(7075881,7067924,7067925,7067926,7067927,7067928,7067929,10962674,10943557,7076049,10943655,10939897,10939898,10939901,10939936,10939937,10939938,10939939,10939940,10939941,10939942,10943835,10943855,4970738,10944006,10944007,10944008,10944009,10944010,10989202,10989203,10989204,10944037,8569561,10944136,10963471,7073945,8067159,7066147,7066148,10437248,10437254,10437255,8067432,8067460,7074409,7074565,7074566,7074567,7074568,8067882,4969270,4969271,4969272,4969273,4969274,4969275,4969276,4969277,4969278,4969279,4969280,4969281,10938723,10938724,7067057,10987850,10987863,10987864,10987865,10987866,10987879,10987880,10987881,10987882,10987883,10987884,10987885,10987886,10987902,10987903,10987915,10987916,4969571,4969572,4969573,4969574,4969575,4969576,4969577,4969578,4969579,4969580,4969581,4969582,4969583,4969584,4969585,4969586,4969587,10987947,10987948,10987960,10987961,10987968,10987971,10987972,10939194,10939195,7067581,10988300,7075648,10988346,7067710,7067717,7067720,7067729,7067730,7067768,7071817,7071828,6000274,6000298,7064033,7064034,7064035,7064036,7064037,7064038,7064039,7064056,7072084,7072091,7072095,8065184,8065185,8065509,7064466,7064467,7064468,7064469,8075327,10986260,10960403,10960627,8066137,10932665,7065458,7065459,7065460,7065461,7073530,7073547,7073590,7073621,7073688,7073799,8970190,10942676,10942720,7071126,7071222,10959117,8861399,10959190,10959191,10959192,10959193,10959194,6000075,10944419,7068988,7069242,3656073,3656074,3656075,10944984,10945001,3656190,3656199,3656202,8859495,8072647,8072652,8072657,8072662,8072667,8072672,8072677,7069827,8072682,8072687,8072692,8072697,8072702,8072707,8072712,8072717,8072722,8072727,8072732,8072737,8072742,8072747,8072752,8072757,8072762,8072767,8072772,8072777,8072782,8072787,8072792,8072800,8072808,8072816,8072824,8072832,8072840,8072852,8072860,8072872,8072880,8072890,8072896,8072908,8072916,8072924,8072931,8072942,8072949,8072957,8072965,8072973,8072981,3656906,7070452,8860361,10942188,10942189,10942190,10942191,10942192,10942193,10958259,10958260,10958261,10958262,10958263,10958264,10958265,10958266,10958267,10958268,10958269,10958270,10958271,10958272,10958273,10958274,10958275,10958276,10958277,10958278,10958279,10958280,10958281,10958282,8073468,8860607,7070719,7070722,10623057,10623058,10928586,10928587,10967963,10618615,10618828,10618829,10619031,10968571,10968580,10968581,10968582,10619104,10619173,10624204,10619589,10624731,10624732,10619897,10966527,10966531,10966532,10966533,10966534,10966535,10966536,10922629,10922630,10922631,10922632,10922633,10922634,10922635,10922636,10966716,10927892,10927899,10927916,10927917,10953959,10953962,10953963,10953964,10953965,10953966,10953967,10953968,10953969,10953970,10953971,10953972,10953973,10953974,10953975,10953976,10953977,10953978,10953979,10927964,10928123,10928124,10928126,10928128,10622892,10622893,10622894,10622895,10622896,10920519,10620061,10620122,10620283,10620284,10620285,10620286,10620287,10620288,10615288,10620289,10620290,10620291,10620292,10964834,10964835,8570192,8570213,8570225,10926029,8570361,10926056,10926066,10926067,10926068,10926088,10926095,8570419,10926130,10926131,10926181,10615672,10926184,10926246,10926319,10926320,10926339,10926340,10926354,10965392,10930714,10616005,10926632,10930974,10952766,10952767,10952768,10952769,10952770,10952771,10952772,10952773,10952774,10952775,10952776,10952777,10952778,10952779,10952780,10952781,10926755,10926756,10926758,10926761,10616794,10616795,10927425,10927426,10927427,10927428,10927429,10927461,10927465,10927466,10565199,10565200,9165403,9165404,9165405,9165406,9165407,9165408,9165409,9165410,10559232,10559296,10559323,9165557,10562442,10562443,10562444,10562445,10562446,10562447,10611305,10562459,10562460,10562461,10562462,10562463,10562464,10562465,10562466,10562467,10562468,10562469,10562470,10562471,10611322,10562485,10562490,10562494,10562495,10562496,10562497,10562529,10562549,6665751,10562596,10562597,10562603,10562604,10562605,10562606,10562614,10562615,10562616,10562617,10562618,10562619,10611470,10562651,10562652,10562653,10611523,10565772,10565773,10565774,10565775,10565776,10565777,10565778,10565779,10565780,10565781,10565782,10565783,10565784,10565785,10565786,10565787,10565788,10565789,10565790,10562790,10565791,10562791,10565792,10562792,10565793,10562793,10562794,10565794,10565795,10562795,10562796,10562797,10562798,10562799,10562800,10562801,10562802,10562803,10562804,10562805,10562806,10562807,10562808,10562809,10562810,10562811,10562812,10562813,10562814,10562815,10562816,10562817,10562818,10562819,10562820,10562821,10562822,10562823,10562824,10562825,10562826,10562827,10562828,10562829,10562830,10562831,10562832,10562833,10562834,10562835,10562836,10562837,10562838,10562839,10562840,10562841,10562842,10562843,10562844,10562845,10562846,10562847,10562848,10562849,10562850,10562852,10562853,10562854,10562855,10562856,10562857,10562858,10562859,10562860,10562861,10562862,10562863,10562864,10562865,10562866,10562867,8864593,8864612,10611758,10565943,8864658,8864665,8864689,8864716,10566010,10614870,10614871,10614872,9166210,10614873,9166211,10614880,10614881,10614882,10614883,10614884,10614885,10614890,10614893,10614894,10614895,10614896,10614904,10614905,10566058,10614910,10614918,10614919,10614923,10614933,10614940,10614941,10614942,10611944,10614944,10614946,7057589,10609238,10609240,8862147,8862148,9163646,10557513,10563531,8862252,10612507,10612508,10612509,10612510,8862868,7058562,7058572,7058603,7058621,8862978,7058625,10610124,8862990,8863003,8863011,8863017,8863024,8863057,10561539,10561540,10558597,10561612,10561813,10561814,10561815,10561816,8863535,9161483,9161484,10515309,9161528,9161529,9161530,9161531,9161532,9161683,10517519,4974663,7056078,7056079,7056080,7056081,7056082,7056115,7056116,7056117,7056118,7056119,7056120,7056121,7056122,7056135,10515950,10515951,10515952,10515953,10515954,10515955,10515956,10515957,10515958,7056455,4975237,4975267,2809240,10514487,10518616,10514725,10514726,10514727,10514728,10514729,10514730,10514731,10514732,10514733,10514734,10514746,10514747,10514748,10514749,10514750,10514751,10514752,10514753,10512846,10516884,10516885,10516886,10516887,10516888,7057256,7057257,7057260,7057292,7057294,7057321,7057327,9160376,10415309,10415310,10415314,10416325,10416330,10419399,10419430,10419431,10416471,10415474,10419507,10419512,10419518,10419531,10419534,10418536,10419558,10417559,10419572,10419573,10418677,9160785,4973666,10419763,10415807,9160950,10415875,10418901,10418902,10418903,10418904,10418906,10417005,4973939,4974069,4974070,4974071,4974072,4974073,4974074,4974075,4974076,10417166,4974105,4974106,10416190,8864988,4971341,4971342,4971343,4971344,4971374,4971375,4971376,6666641,6666879,6666883,10463686,10463687,10469695,10465730,10465731,10465732,10465733,10467771,10469773,10469774,8916859,10469857,10469859,10469860,10469863,10469865,10469866,10469867,10469868,8563258,8917045,8917055,8563503,10462349,10462350,10462351,10462352,10462353,10462354,10462355,10462356,10462357,10462358,10462359,10462360,10462361,10462362,10462363,10462364,10462365,10462366,10462367,10462368,10462369,10462370,10462371,10462372,10462373,10462374,10462375,10462376,10462377,10462378,10462379,10462380,10462381,10462382,10462383,10462384,10462385,10462386,10462387,10462388,10462389,10462390,10462391,10466487,10466488,10466489,10466490,10466491,10466492,10466493,10466494,10462551,10462552,10462553,10462554,8917690,8917745,8917754,8917755,8917756,8917776,8917779,8917780,9160268,9160274,9160275,9160276,9160277,9160278,9160279,9160280,9160281,9160282,9160283,9160284,9160285,9160286,9160287,9160288,9160289,9160290,9160291,9160292,9160293,9160294,9160295,9160296,9160297,10159544,10628154,10628293,10628294,10628295,10159946,10628553,10628664,10628697,10628839,10628875,10628876,10628877,10628927,10628928,10629014,10155591,10629131,10160760,10629412,10629457,10632070,10632071,10632072,10632092,10627116,10627117,10627118,10627134,10627135,10627136,10627138,10627665,10630026,10630027,10630028,10630100,10630152,10626443,10158459,10568395,10568396,10568484,10568502,10568503,10568504,10568505,10568506,10566137,10566138,10566139,10567320,10567546,10568014,10568066,10521564,10522078,10522079,10522085,10522087,10522196,10522197,10522232,10522233,10522234,10522524,10520924,10520925,10523036,10523037,10420349,10420350,10420385,10420419,10420906,10422043,10423090,10423095,10477340,10477353,10477354,10477360,10477456,10477460,10477461,10477856,10477857,10477858,10477859,10477860,10477861,10477862,10477863,10477864,10477865,10477866,10477867,10477868,10477869,10477870,10477871,10477872,10477873,10477874,10477875,10476254,10476341) 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'