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(10224323,10224324,10224325,10263327,10263328,10263536,10263537,10263538,10263539,10263540,10263567,10224567,10263568,10263569,10263570,10263571,10263572,10263573,10263574,10263575,10263576,10263577,10263578,10263579,10263580,10263581,10263582,10263583,10263584,10263585,7068358,4970895,10104301,8569752,7074116,8619513,10277531,10277532,10251798,8620000,8837702,10437648,10498046,10498047,10498048,10212995,10437721,8620147,10197124,10197125,8617304,10262184,8067930,7074954,8617379,8617421,10262340,10262341,10262342,8617474,7075123,7075124,10197364,8617596,8910892,8835356,8617723,8617762,7075468,8835496,8835497,8068552,8068553,7071867,8908807,10260572,10260573,10260574,10260575,10260576,10260577,10260578,10260579,10260590,10260591,10260592,10260593,10260594,10260595,10260596,10260597,10260598,10260599,10260600,10260601,8615735,10273751,7064525,8909178,8909179,7072719,8909308,8909309,8909329,8909330,8909331,8909332,8909333,8909334,8909335,7072765,7072818,7072864,7072950,10235189,10235191,10235192,10235193,7072970,7072976,7072977,8909587,8909588,10235307,10235308,10235309,7073075,10209326,10209411,8909786,8909787,10261499,10261500,10261501,10261502,10235510,10101930,10235511,10235512,10235513,10235514,8909949,10102167,8616886,10102217,10261806,10261807,10261808,10261809,10261832,8617013,8617014,10261983,8617135,8617140,10272065,10272149,10272173,8614302,10272194,10272211,10272212,10207225,10207226,10207227,10207228,10272228,10942739,10942750,10942753,8907651,10272327,10272400,10272405,8861097,10272442,8614578,10207511,8614919,10272884,10272885,10272886,10272887,8970195,7071714,8970220,10205176,10205177,10205178,10244198,10244199,10244210,10205310,10205311,10205312,10205313,10205314,10244410,10270530,10270531,10270532,10270533,10270534,10244593,10244594,10244595,8579073,10244640,10244641,10244642,10244643,10944955,10944956,8906077,8906078,10205762,10205763,10205764,10205765,10205766,10205767,10205768,10205769,10205770,10205771,10205772,10205773,10205774,10205775,10205776,10205777,10270818,10270822,8906188,10941328,8906200,8906201,10244899,10244900,8906365,8906383,8906384,8906385,10245056,10271101,10271102,10271103,10271104,10271105,10271203,10206438,10271455,10232486,10232487,10206506,10206507,10232590,10232591,10206631,10271711,10271712,10258715,10258756,10258757,10258758,10258763,10258764,10258765,10258766,10258767,10258768,10206796,10206875,10271878,10271879,10271880,10271881,10271882,10271883,10245896,10271925,10942438,10258968,8576637,8576638,8576639,10190187,10242242,8576808,10268363,10268386,10242394,10242395,10242396,10433343,10242526,10242527,8577043,10268611,8577160,8577161,8577252,8904236,8904292,8577422,10242965,10242966,8577438,8577439,8577440,10618915,10618916,10618917,10618918,10269013,10269014,10269015,10269016,10269017,10269018,10269019,10269020,10269021,10230059,10243154,10243273,10243274,10243275,10243276,8577753,10269288,10269289,10269290,10269291,8577770,10269323,8577813,10243368,10243369,10243414,10243415,10243519,10204577,10204578,10243679,10243680,10243681,10243684,10243685,10243818,10243819,10243894,10243896,10243897,8612086,8612116,8575755,8584055,10241305,10241306,8584102,10267447,10267448,10241512,10241513,10241514,10267552,10267553,10267571,10267572,10267573,10267574,10267575,10215630,10215631,10215632,10241745,10241746,10241896,10241897,10242034,10213071,10213072,10213073,10213074,10213075,10920601,10920602,8573660,8837965,8837978,10920676,8573739,10920702,10920703,10920764,8573817,8573818,8573819,8573820,10265353,10265354,10265355,10265356,10265357,10265358,8838138,8838139,10620305,10620346,10620348,10278465,10620423,8574022,8574023,10265566,10265567,10265568,10265569,10265570,10265571,8574058,8574059,10265617,10265618,10265619,10265620,10265621,10265622,10265623,10265624,10265625,10265626,10265627,10265628,10265629,10265630,10265631,10265632,10265633,8574114,10447843,10278677,10278678,10278679,10278680,10278681,10921101,10921102,8574168,10921268,10921269,10448039,10615831,10615832,10615845,8838707,8838708,8838709,8838710,8838711,8838755,10921484,10921485,10921534,10448297,10240140,10921600,10921645,10921646,10921647,10921648,10921772,10921773,10921774,10188362,10253485,10253486,10253487,10253488,10253489,10253492,10253493,10253494,10253495,10253496,10253497,10253498,10240668,10253688,10922192,10253790,10279906,8583678,10279945,10279946,10279947,10279948,10279959,10279963,10279964,10240989,10241036,10241037,10241038,10241039,10559289,10614205,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,9189138,9205206,9193393,9193405,7055761,9193613,4974658,4974659,10515724,10515725,10515726,10515727,10515728,10515729,10515730,9194118,9194133,9194134,9202135,9194135,9202183,9194362,9202430,9162431,9202442,9202619,9202620,10514458,9194734,9194735,9202758,9202759,9202760,9202761,9202762,9194776,9170889,9194901,9194902,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,8550197,8550198,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,8593821,8593822,8593823,8593879,10179891,10164989,10164990,10165072,10180161,10180162,10180163,10180202,10180203,10180205,10180206,10180207,10165236,10165237,8594535,10180564,10180565,10180566,10165569,10165570,10165571,10180613,10180614,10180615,10180616,10180617,10180618,10165726,10165727,10165728,10170817,10170818,10165868,10180946,10874950,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,7000926,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,10949338,10949339,10949340,10949341,10949342,10949343,10949344,10949345,10949346,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,10539534,10539535,10539536,10539637,10539775,10519872,10519873,10521901,10536086,10536087,10536088,10536089,10536090,10536419,10536420,10536421,10534669,10534670,10534671,10534672,10534673,10534674,10534675,10534676,10534677,10534678,10528724,10530751,10540772,10534950,10534951,10534952,10534953,10534954,10534955,10534956,10534957,10534958,10534959,10534960,10423930,10424066,10487939,10488022,10477916,10478075,10478076,10478126,10478127,10478128,10478251,10489717) 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'