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(8574114,11027628,11027629,11027630,11027631,11027632,11027633,11027634,11027635,11027636,11027637,11027638,11027639,11027640,11027641,11027642,11027643,11027644,11027645,11027646,11001646,11001647,11027647,11027648,11001648,11001649,11027649,11027650,11001650,11001651,11027651,11001652,11001653,11001654,11001655,11001656,8574168,8838707,8838708,8838709,8838710,8838711,8838755,11040954,7068358,10939986,11002052,11002053,11002054,11041159,11041160,11041161,11041162,11002259,11002260,4970895,8569752,11002475,11002476,11002477,10976513,10940499,10940500,10940501,10940502,10976588,10976589,10976590,10976591,10976592,11002629,11002630,7074116,11002928,11002976,11003176,11003177,11003178,11003179,11003180,8575755,11003375,10437648,11003500,11003501,11003502,10437721,11003598,11003599,11003600,11003601,11003602,7074954,10961660,10961661,10961662,10961663,8067930,7075123,7075124,10987839,10987840,10987841,8837702,11013990,11013991,11013992,11013993,11013994,11013995,11013996,11013997,11013998,11013999,11014000,11014001,10988062,11040110,7075468,8837965,8573660,8837978,8573739,8573817,8573818,8573819,8573820,8838138,8838139,8068552,8068553,11001443,8574022,8574023,8574058,8574059,8835496,8835497,10972865,10972950,11025163,11025164,11025165,11025166,11025167,11025168,11025169,11025170,11025171,11025172,11025173,11025174,11025175,11025176,11025177,11025178,11025179,7064525,7072719,7072765,7072818,7072864,7072950,7072970,7072976,7072977,8066034,7073075,10961082,10961083,8066459,8066460,8066461,8066462,8066463,8066464,10961517,10961518,11023677,11023678,11023679,11023680,11023681,10942739,10942750,10942753,11049119,11024039,7071714,8970195,8970220,8910892,7071867,8835356,3655581,3655591,11034706,11021853,11021854,11021855,11021856,11021857,11021858,11034859,11021859,11021860,11034860,11021861,11021862,11021863,11021864,11021865,11021866,11021867,11021868,10969936,10970019,10970020,11035024,11035025,11035026,11035027,11035028,11035113,11035114,11035138,10970166,11035220,10944955,10944956,11035221,11035222,11035286,11035287,11035288,11035289,10970329,10941328,10970408,8908807,11022591,11022592,11022593,11022594,11022595,11022596,3656590,11035742,11035743,10970756,10970757,10970758,10970759,11022796,11022797,11022798,8909178,8909179,11035826,3656725,3656727,11022931,8909308,8909309,8909329,8909330,8909331,8909332,8909333,8909334,8909335,10971043,10997082,10997083,10997084,10997085,10997086,8909587,8909588,10997216,10997360,10997361,8909786,8909787,10942438,11023502,11036537,8909949,10918531,10918532,8906077,8906078,10918613,10918614,11032788,10918661,8906188,8906200,8906201,11019975,11019976,11019977,8906365,8906383,8906384,8906385,10918938,10918939,10918941,10918942,10918943,10918944,10918945,10918946,10918947,10919299,10919300,10919301,10919302,10919303,10919304,10919305,10919307,10919308,10919309,10919310,10919311,10919312,10919313,10618915,11033573,10618916,10618917,10618918,10994589,10994590,10994591,10994592,11033621,10968688,10968689,10968690,10994695,11033768,10919644,10919645,10919646,10919647,10919648,10919649,10968815,10968816,10968817,10968818,10968819,10994828,11020840,11020841,11020842,11020843,11020844,11020845,11020846,11020847,11020848,11020849,11020850,11020851,11020852,11020853,11020854,11020855,11020856,11034009,10969261,10969262,10969263,10969264,10969265,10969266,10969267,10969268,10969269,10969270,10969271,10969272,10969273,10969274,10969275,10969276,8907651,11034447,11034448,11034449,11034450,11034451,11034452,11034453,11034454,11031722,11031723,11031724,11031725,11031726,11031727,11031728,10918042,10954281,10918173,10918174,10918175,10918176,10918177,10918178,10918179,10918362,10918363,10918364,10918365,10918366,10918367,10918368,10918369,10918370,10918371,10918372,11006557,10920601,10920602,10920676,10920702,10920703,11003853,11003854,11003855,11003856,11029892,11029893,11029894,11029895,11029896,11029897,11029898,11029899,11029900,11029901,11029902,11029903,11029904,11029905,11029906,11029907,11029908,11029909,11029910,11029911,11029912,10920764,11029913,11029914,11003950,11003951,10620305,10620346,10620348,10620423,10921101,10921102,11004342,11004343,11004344,11004345,11004346,10921268,10921269,10952405,10615831,10615832,10615845,11004554,11004555,10921484,10921485,10921534,10921600,10921645,10921646,10921647,10921648,11004861,11004862,8904236,11004863,11004864,11004865,11004866,11004867,11004868,8904292,10921772,10921773,10921774,11030981,11030982,11030983,11030984,11030985,10979047,10979048,10979049,11005072,11005295,11005296,10922192,11031462,11005581,10559289,10614205,10611519,10565703,10565704,10565705,10565706,10557123,10557124,10557125,10557126,10557127,10557128,9203325,9171354,9195452,9203500,9203501,9203502,9203503,9195566,9195567,10557458,10557459,10557460,9195648,10557461,9195649,9195650,9203684,9195723,9195724,9195797,9195798,9195799,9195800,9195801,9187804,9187805,9187819,9187820,9187821,9187822,9203845,9203846,9203847,9203848,9203849,10557721,10557722,10557723,10557724,10557725,9203952,10612639,9196045,7058293,9188129,9204137,9196156,9188260,9204275,10612966,9204350,9204351,9204455,7058727,9204592,9204601,9204708,9172771,9172906,8863472,8863473,8863474,8863475,8863476,8863477,8863478,8863479,8863480,8863481,9189033,9189067,9189068,10610734,10610765,10610766,9189138,9205206,9193393,9193405,7055761,9193613,10555494,10555565,10555566,10555567,10555568,10555569,10555570,4974658,4974659,10515724,10515725,10515726,10515727,10515728,10515729,10515730,9194118,9194133,9194134,9202135,9194135,9202183,9194362,9202430,9162431,9202442,10556341,10556342,10556343,10556344,10556345,9202619,9202620,10514458,9194734,9194735,9202758,9202759,9202760,9202761,9202762,9194776,9170889,9194901,9194902,10556751,10556752,10556753,10556754,10556755,10556756,10556757,10556758,9179058,9179059,9179060,9179061,9179062,9179063,9179064,9195120,9195143,9203154,9203173,9203174,9171258,9211271,10416233,8918031,8918084,9192464,9176472,9200486,9200487,9176565,9184594,9176607,10417548,9200743,9200744,9168786,9200845,9200846,9176964,9185085,10417128,4974130,4974131,4974132,9174584,10471196,10471197,9206849,9206975,10469577,10469593,9207225,9207226,4972106,4972107,4972108,4972109,4972110,4972111,4972112,10470004,10464046,10464047,8917224,10470243,8917450,10470392,10470396,10470505,10470512,10470599,9192102,9200267,10174504,10174505,10164572,10164573,10164574,10164575,10164576,10164577,10164578,10628076,10628083,10179891,10164989,10164990,10165072,10180161,10180162,10180163,10180202,10180203,10180205,10180206,10180207,10165236,10165237,10180564,10180565,10180566,10165569,10165570,10165571,10180613,10180614,10180615,10180616,10180617,10180618,10165726,10165727,10165728,10170817,10170818,10165868,10180946,10180975,10180976,10180977,10166119,10181224,10181246,10181247,10181248,10629732,10629733,10629764,10629765,10183540,10183639,10183640,10183641,10183642,10183656,10183657,10168679,10168680,10168681,10168682,10168683,10168684,10183722,10168750,10168751,10168752,10183816,10183898,10183899,10183982,10164256,10164257,10174437,10174454,10181513,10181514,10181515,10181516,10181517,10181739,10166861,10167030,10182046,10182061,10182062,10187176,10182213,10182229,10167230,10167293,10177353,10177354,10177355,10177356,10182376,10177419,10182479,10182488,10182645,10182646,10187718,10187719,10187753,10187754,10182809,10182810,10182819,10631377,10631378,10631379,10182994,10183000,10183076,10183083,10183145,10183155,10163254,10183256,10183327,10183334,10183450,10183480,10577123,10571477,10571478,10577547,10577548,10577549,10577550,10577551,10577552,10577553,10577554,10577555,10577556,10577557,10577558,10580674,10568692,10568693,10568694,10574741,10574742,10574743,10574744,10574761,10574823,10577925,10577926,10571930,10571931,10571932,10571933,10571934,10571935,10574952,10574953,10574954,10574955,10574956,10574957,10574958,10574959,10574960,10578080,10578081,10578082,10575180,10575201,10575202,10575203,10575204,10575205,10575206,10575207,10578208,10578209,10578210,10578219,10578220,10572311,10572314,10572370,10578400,10578401,10575463,10578524,10578573,10578574,10578650,10578651,10575693,10575694,10575695,10578767,10587880,10587881,10587882,10582062,10579391,10579563,10579564,10576764,10576765,10576766,10576767,10576768,10576769,10521268,10523386,10523387,10535463,10535464,10535465,10535466,10535467,10535468,10535469,10535470,10535471,10535472,10535473,10535474,10535475,10535476,10535477,10535478,10535479,10535480,10519872,10519873,10521901,10536086,10534669,10534670,10534671,10534672,10534673,10534674,10534675,10534676,10534677,10534678,10528724,10530751,10534950,10534951,10534952,10534953,10534954,10534955,10534956,10534957,10534958,10534959,10534960,10423930,10424066,10477916,10478075,10478076,10478126,10478127,10478128,10478251) 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'