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(7067855,10939592,10939626,10939627,10939628,10943461,10939715,10939719,10939720,7076012,10939728,10943535,10939739,7076095,10943666,7068159,10939878,10939879,10939880,10943687,10939910,10943724,7068284,7068285,7068286,7068287,7068288,7068289,7068290,7068291,7068292,7076369,4970745,8569404,10940181,10940182,10940183,10940184,10944017,10944068,10944071,10944072,10944073,10944074,10944075,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,8569564,4970925,4970926,4970927,4970928,4970929,10940510,10940511,10940512,10940513,10940514,10940515,10940516,10940517,10940518,4971143,10933292,7065967,7073981,7073982,7073983,7073984,7073985,7073986,4968323,7073987,4968333,4968334,7074051,7074052,7074053,7074054,7074055,7074056,7066180,8067279,8067280,8067281,10437195,4968607,8067340,4968608,4968609,4968610,4968611,4968612,4968613,4968614,8067359,10437250,8067414,10437407,8067541,7074488,10437435,7066524,7074604,7074634,7074658,7074681,7066855,7074861,7074867,7074868,7074869,8067910,8067911,8067912,7074964,7075142,7075163,7075186,7067223,7075245,7067247,7067253,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,7067265,4969602,4969603,7067268,4969604,4969605,7067272,7075276,7067278,7067281,7075290,10939196,10939197,10939198,7075532,7067646,7071829,7071831,7071969,7071970,7064075,8065191,8065192,8065193,8065194,8065195,8065196,8065197,8065198,8065199,8065200,8065201,8065202,8065203,8065204,8065205,8065206,8065207,10931666,10931681,10931714,10931715,10931716,8065349,7064298,8065510,7072484,8065554,8065827,10932258,10932302,10932323,7064941,10932469,8066119,10932496,10932497,10932498,10932499,10932500,10932501,8066165,7065152,10932600,7073223,10932672,10932678,10932687,7073278,7073279,7073280,10932738,7073302,10932756,10932759,10932762,7073381,7073382,10932847,10932852,10932853,7065462,7065463,7065464,10932907,8066564,10932945,10932946,10932951,10932955,7073643,10942544,7070869,7070870,7070905,7070906,7070907,7070908,7070950,7071011,7071012,10942912,10942913,10942914,10942915,10942916,10942917,10942918,10942919,10942920,10942921,10942922,10942923,10942924,10942925,10942972,10942973,8064354,8064355,8861192,8064359,8064486,8064497,8861410,8861411,8861413,7071572,7071583,8970223,6000087,7071813,10944353,10944388,10944395,10944398,10944400,10944412,10944443,10944535,7069027,7069028,7069029,7069030,7069031,7069032,7069033,10944716,10944719,10944725,10944728,10944729,10944730,10944732,10944735,10944736,10944738,7069232,3655939,10944847,10944920,8072307,10944969,3656156,10944986,10945013,10945014,10945018,10945025,10945026,10945028,10945029,8072373,8072374,10945036,10945039,10945041,10945044,10945048,10945050,10945058,8072451,8072465,8072466,7069691,8072663,8072664,8072665,8072666,8072667,7069849,3656635,3656641,3656649,3656667,3656706,10941737,10941738,10941739,10941740,10941741,8072998,8072999,8073001,3656884,3656885,10942142,10942145,10942185,8860374,10942186,8860484,8860490,8073457,10942318,8860506,8860560,8860567,8860604,8970129,8970130,10618002,10618003,10918558,10918559,10618050,10618066,10923623,10923624,10923625,10923626,10923627,10923628,10923629,10923630,10923631,10923632,10923633,10923634,10618240,10618241,10618242,10618243,10618244,10618245,10618250,10618251,10618253,10618254,10623296,10623297,10623298,10623299,10623300,10623301,10623302,10623316,10923849,10923850,10623410,10618477,10618478,10618479,10618480,10618481,10618482,10618483,10618484,10618485,10618486,10623493,10924086,10924087,10924088,10924089,10618830,10618831,10618889,10924513,10924514,10924515,10924516,10924517,10924518,10924519,10924520,10924521,10924522,10924523,10924524,10924525,10619016,10619017,10619018,10619019,10619020,10619021,10924701,10924702,10924703,10924704,10924705,10924706,10619341,10619351,10619356,10619357,10619358,10619359,10919882,8071112,8071113,10619458,10919971,10920054,10920055,10920056,10920057,10920058,10920059,10920060,10920061,10920062,10925175,10619875,10619880,10619923,10619927,10619928,10617052,10917791,10917792,10917793,10917794,10917795,10917796,10917797,10917798,10917799,10622305,10622306,10622307,10622308,10622309,10622310,10622311,10622312,10622313,10622314,10622315,10622316,10622317,10622318,10622319,10622320,10622321,10622322,10622323,10622324,10622325,10622326,10622327,10622328,10622329,10622330,10622331,10622332,10622333,10622334,10622335,10622336,10622337,10622338,10622339,10622340,10622341,10622342,10622343,10922930,10617426,10622536,10622539,10617803,10928355,10928356,10928357,10920520,10920521,10920522,10920523,10920524,10920525,10920526,10920527,10920528,10920529,10920530,10920531,10920532,10920533,10920534,10920535,10920536,10920537,10920538,10920539,10920540,10915541,10920541,10915542,10920542,10915543,10920543,10915544,10920544,10915545,10920545,10915546,10920546,10915547,10920547,10915548,10920548,10920549,10915549,10920550,10915550,10920551,10915551,10920552,10915552,10920553,10915553,10920554,10915554,10920555,10915555,10920556,10920557,10915557,10915558,10920558,10915559,10920559,10915560,10920560,10915561,10920561,10915562,10920562,10915563,10920563,10915564,10920564,10915565,10920565,10915566,10920566,10915567,10920567,10915568,10920568,10915569,10920569,10915570,10920570,10915571,10920571,10915572,10920572,10915573,10920573,10915574,10920574,10915575,10920575,10915576,10920576,10915577,10920577,10915578,10920578,10915579,10920579,10915580,10920580,10915581,10920581,10915582,10920582,10915583,10920583,10915584,10920584,10920585,10920586,10920587,10920588,10920589,10920590,10920591,10920592,10920593,10615091,10615170,10615171,10615172,10615225,10615226,10615227,10615228,10615364,10615365,10615366,10615367,10615368,10615369,10615521,10926093,10926111,10926112,10926113,10926114,10926115,10926116,10926117,10926118,10926119,10926120,10620637,10620638,10620639,10620640,10620641,10620642,10620643,10620644,10620645,10620646,10620647,10620648,10620649,10620650,10926161,10926162,10926163,10926164,10926206,10926277,10926334,10926335,10926336,10926337,10615941,10616048,10616049,10921656,10921810,10921811,10921812,10621432,10621433,10621434,10917015,10917046,10917047,10917048,10917049,10922218,10922219,10927278,10927280,10927282,10927283,10927284,10927285,10927286,10927287,10922460,10559215,10559216,10559217,10611153,10611154,10611156,10559324,10559325,10559326,10611351,10559632,10614765,10611870,10563136,10563137,10612040,10612166,10612167,10609269,10609339,10609340,10609341,10609342,10609379,10557614,10557615,10557616,10609500,10609501,10609512,10609513,10612565,10612618,10612642,10612646,10612658,10609999,10613017,10558400,10558401,10558402,10558403,10558404,10558405,10558406,10558407,10558408,10610302,10613367,10613368,10610373,10561527,10561528,10561529,10561530,10561554,10558598,10558618,10558619,10558620,10558621,10558622,10558623,10558624,10558625,10558626,10558627,10558628,10558629,10558630,10558631,10558632,10558633,10558634,10558635,10558636,10558637,10558638,10558639,10558640,10558641,10558642,10558643,10558644,10558645,10558646,10558647,10558648,10558649,10558650,10558651,10558652,10558653,10558654,10558655,10558656,10558657,10558658,10558659,10558660,10558661,10558662,10558663,10558664,10558683,10564687,10564712,10564820,10564821,10564822,10564823,10564824,10613721,10610939,10515146,10513150,10513176,10513205,10513206,10511446,10517609,10517610,10517611,10513909,10513910,10513913,10513914,10513915,10513948,10513984,10513989,10513998,10518142,10518143,10514166,10514167,10514168,10514169,10514170,10514171,10514172,10514173,10514174,10514175,10514176,10514177,10514178,10514179,10514180,10514181,10514182,10514183,10514184,10514185,10514186,10514187,10514188,10514189,10514190,10514191,10514192,10514193,10514194,10514195,10514196,10514197,10514198,10514199,10514200,10514201,10516202,10514202,10516203,10514203,10516204,10514204,10516205,10514205,10516206,10514206,10516207,10514207,10514208,10518553,10518554,10518555,10514899,10514900,10514901,10514902,10514903,10514904,10514905,10514906,10514907,10514908,10514909,10514910,10514911,10514912,10514913,10514914,10514915,10514916,10514917,10514918,10514919,10514920,10514921,10514922,10514923,10514924,10514925,10514926,10514927,10514928,10514929,10514930,10514931,10519004,10513089,10415278,10415279,10415280,10419303,10417362,10417370,10417380,10417388,10419436,10419493,10416515,10416540,10416556,10419581,10418625,10418626,10419719,10415739,10415784,10415812,10415829,10415861,10415862,10415863,10417009,10416087,10416088,10416130,10416131,10417143,10416159,10416160,10463001,10463002,10471129,8563309,10470077,8563409,8563417,10466500,10462689,10462690,10462691,10462692,10462693,10462694,10462695,10462696,10462697,10462698,10462699,10462700,10462701,10462702,10462703,10462704,10462705,10462706,10462707,10462708,10462729) 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'