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,10943557,7076049,10224334,10224346,10224347,10224348,10224349,10224362,10224363,10224364,10224365,10224366,10224367,10224368,10224369,10943655,10224385,10224386,10224398,10224399,10224430,10224431,10224443,10224444,10224451,10224454,10224455,10943835,10943855,4970738,10944006,10944007,10944008,10944009,10944010,10944037,10198782,10224812,8569561,10224858,10944136,10237912,10237913,10237914,7073945,7066147,7066148,10238492,10437248,10199544,10437254,10437255,7074409,10225741,10225742,10225743,7074565,7074566,7074567,7074568,8067882,4969270,4969271,4969272,4969273,4969274,4969275,4969276,4969277,4969278,4969279,4969280,4969281,7067057,4969571,4969572,4969573,4969574,4969575,4969576,4969577,4969578,4969579,4969580,4969581,4969582,4969583,4969584,4969585,4969586,4969587,10236683,10236684,10236685,7067581,7075648,7067710,7067717,7067720,7067729,7067730,7067768,7071828,10195100,10195101,10195102,10195103,6000274,6000298,7064033,7064034,7064035,7064036,7064037,7064038,7064039,7064056,7072084,7072091,7072095,10234392,10234395,10234497,10234498,10234499,7064466,7064467,7064468,7064469,8075327,10234907,10196415,10932665,10196656,10235676,7065458,7065459,7065460,7065461,10222702,7073530,7073547,7073590,7073621,7073688,7073799,10194145,10194146,10194147,10194148,10194149,10194150,10194151,10194152,10194153,10194154,10194155,10194156,10194157,10194158,10194159,10194160,10194161,10194162,10194163,10194164,10194165,10194166,10194167,10194168,10942676,10942720,7071126,7071222,8861399,10234014,10195027,6000075,7071817,10205078,10205089,10205090,10205091,10944419,7068988,7069242,10944984,10945001,8859495,8072647,8072652,8072657,8072662,8072667,8072672,8072677,7069827,8072682,8072687,8072692,8072697,8072702,8072707,8072712,8072717,8072722,8072727,8072732,10232118,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,7070452,8860361,10942188,10942189,10942190,10942191,10942192,10942193,8073468,8860607,7070719,7070722,10623057,10623058,10928586,10928587,10203300,10618615,10203909,10203910,10203911,10618828,10618829,10619031,10619104,10619173,10230275,10230276,10230277,10624204,10204387,10619589,10230690,10624731,10624732,10619897,10228096,10922629,10922630,10922631,10922632,10922633,10922634,10922635,10922636,10927892,10927899,10927916,10927917,10927964,10928123,10928124,10928126,10928128,10202847,10202851,10202852,10202853,10202854,10202855,10202856,10189857,10189860,10189861,10189862,10189863,10189864,10189865,10189866,10189867,10189868,10189869,10189870,10189871,10189872,10189873,10189874,10189875,10189876,10189877,10189878,10189879,10189880,10189881,10189882,10189883,10189884,10189885,10189886,10228958,10622892,10622893,10622894,10622895,10622896,10203037,10920519,10620061,10620122,10620283,10620284,10620285,10620286,10620287,10615288,10620288,10620289,10620290,10620291,10620292,8570192,8570213,8570225,10926029,8570361,10926056,10926066,10926067,10926068,10926088,10926095,8570419,10926130,10926131,10200759,10926181,10926184,10615672,10926246,10926319,10926320,10926339,10926340,10926354,10930714,10201073,10201074,10616005,10926632,10930974,10188332,10188333,10188334,10188335,10188336,10188337,10926755,10188338,10926756,10188339,10188340,10926758,10188341,10188342,10188343,10926761,10188344,10188345,10188346,10188347,10188348,10188514,10188609,10201709,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,10562459,10562460,10562461,10562462,10562463,10562464,10562465,10562466,10562467,10562468,10562469,10562470,10562471,10562485,10562490,10562494,10562495,10562496,10562497,10562529,10562549,6665751,10562596,10562597,10562603,10562604,10562605,10562606,10562614,10562615,10562616,10562617,10562618,10562619,10562651,10562652,10562653,10565772,10565773,10565774,10565775,10565776,10565777,10565778,10565779,10565780,10565781,10565782,10565783,10565784,10565785,10565786,10565787,10565788,10565789,10562790,10565790,10562791,10565791,10562792,10565792,10562793,10565793,10562794,10565794,10562795,10565795,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,9174131,8864658,10565943,8864665,8864689,9174192,9174194,8864716,9174197,10566010,9166210,9166211,10614870,10614871,10614872,10614873,10614880,10614881,10614882,10614883,10614884,10614885,10614890,10614893,10614894,10614895,10614896,10614904,10614905,10566058,10614910,10614918,10614919,10614923,10614933,10614940,10614941,10614942,10614944,10614946,7057589,8862147,8862148,9163646,10557513,10563531,8862252,10612507,10612508,10612509,10612510,9171946,8862868,7058562,7058572,7058603,7058621,8862978,7058625,8862990,8863003,8863011,8863017,9172498,8863024,8863057,9172729,10561539,10561540,10558597,10561612,10561813,10561814,10561815,10561816,8863535,9173019,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,9170177,9170178,7056455,4975237,4975267,2809240,10514487,10518616,9170827,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,10416325,10416330,10419399,9168494,10419430,10419431,10416471,10419507,10419512,10419518,10419531,10419534,10418536,10419558,10417559,10419572,10419573,9168761,10418677,9160785,4973666,10419763,9160950,10418901,10418902,10418903,10418904,10418906,9169008,4973939,10417005,9169171,9169188,4974069,4974070,4974071,4974072,4974073,4974074,4974075,4974076,10417166,4974105,4974106,9169273,9166422,8864988,4971341,4971342,4971343,4971344,9166514,4971374,4971375,4971376,9166568,9166632,6666641,9166667,9166764,9166765,6666879,6666883,10469695,10465730,10465731,10465732,10465733,10467771,10469773,10469774,8916859,9167280,9167281,9167282,9167283,9167284,9167285,9167286,9167287,10469857,9167288,9167289,10469859,9167290,10469860,9167291,9167292,9167293,10469863,9167294,9167295,10469865,10469866,10469867,10469868,8917045,8917055,10466487,10466488,10466489,10466490,10466491,10466492,10466493,10466494,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,10165343,10628839,10628875,10628876,10628877,10628927,10628928,10629014,10155591,10629131,10160760,10629412,10629457,10632070,10632071,10632072,10632092,10627116,10627117,10627118,10627134,10627135,10627136,10627138,10163721,10163805,10163837,10163838,10163839,10163840,10163841,10163842,10163843,10163844,10163845,10163846,10163847,10163848,10163849,10163850,10163851,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'