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(11014682,11014774,10939713,11014877,10989335,7068771,7068772,7068800,10963491,4971053,10940520,7068898,7068899,7068900,7068901,7068902,7068903,7068904,7068915,10940550,10940551,10963727,7074085,7074086,7074087,7074088,7074089,7074090,7074091,7074092,4968315,4968319,7074105,4968321,4968330,4968331,7074131,7074132,7074138,11015872,7074192,4968413,7074308,11016140,11016230,7074557,11016251,11016306,10437500,11016333,7074685,7074686,7074687,7074688,7074689,11016394,7074713,7074715,10977401,10977402,10977403,10977404,10977405,10437575,10977406,10437582,11016423,10977446,8067754,11016579,11016598,11016599,10962057,7075460,10962153,7067541,7067542,11001303,11001375,8068597,8068711,8068712,8068713,8068714,8068727,8068728,10962532,11014533,10962533,10962534,11014592,10973039,10973040,10973041,10973042,10973043,10973044,10973045,7072487,10931893,7064672,10960408,10932439,10932616,10932633,10932651,10932653,8066291,10932666,10932673,10932683,7073359,7073421,10932918,10932919,7073580,10932947,10932966,10932971,10933018,10933033,8066755,8066880,10942598,10997875,10997876,7071239,7071423,10998222,10943381,10943400,10940559,10940560,3655532,3655544,3655545,3655546,11008679,11008680,11008681,11008682,11008683,11008684,11008685,11008686,11008699,11008700,11008701,11008702,11008703,7069027,7069028,7069052,7069055,7069318,8072303,11009289,11009290,3656306,3656332,8072548,8072549,8072582,8072583,8072643,8072644,8072645,8072646,8072647,3656989,3656995,11010198,11010199,11010200,11010201,11010202,11010238,11010239,11010273,11010287,7070653,7070735,7070769,8073546,10997549,10980633,10980634,10980635,10980636,10980637,10980638,10980639,10980640,10980641,10980642,10980643,10980644,10980645,10980646,10980647,10980648,10980649,10928510,10928511,10980672,10980673,10980674,10980675,10980676,10980677,10980678,10980679,10980696,10980698,10928671,10980870,10980886,10980887,10980888,10980889,10618333,10955052,10981108,10981109,10981113,10981230,10981231,10981250,10981258,10981277,10981284,10981285,10981286,10618874,10619337,10619338,10619339,8071095,8071307,8071325,8071341,8071353,10922520,10922521,10922522,10922523,10922545,10922580,10922581,10922582,10617100,10617101,10617102,10617103,10617104,10617105,10617106,10622116,10622117,10622118,10622119,10622120,10917640,10992801,10992802,10992803,10992804,10917670,10917671,10917673,10917675,10917676,10917698,10922699,10917741,10917745,10917750,10917751,10917778,10992935,10992936,10992937,10992938,10992939,10979970,10979971,10979972,10979973,10979974,10979975,10992976,10979976,10992977,10992978,10992979,10993042,10917908,10917959,10917960,10993108,10622515,10980436,10980437,10980438,10980439,10980474,10980475,10980476,10980477,10980478,10980479,10980480,10980481,10980482,10980483,10980484,10980485,10980486,10980487,10980488,10980489,10980490,10980491,10980492,10980493,10980494,10980495,10980496,10980497,10980498,10980499,10980500,10980501,10980502,10980503,10980504,10980505,10980506,10980507,10980614,10980615,10980616,10915476,10915495,10915561,10915576,10915619,10915785,10990948,10990949,10990950,10990951,10990952,10990953,10990954,10990955,10990956,10990957,10990958,10990959,10990960,10990961,10990962,10990963,10990964,10990965,10990966,10990967,10990968,10990969,10915823,10991009,10915867,10620370,10620371,10915925,10915969,10916045,10916052,10916055,10916062,10916063,10991249,10991250,10991251,10991252,10991253,10991254,10991255,10991256,10991257,10991258,10991266,10991267,10991289,10991299,10916178,10916204,10916227,10916241,10615829,10615830,10615831,10615832,10930765,10991522,10991523,10991529,10916409,10978585,10978586,10978587,10978588,10978589,10978590,10978591,10991592,10930888,10930889,10916468,10930895,10930896,10916511,10916516,10916523,10916535,10916556,10991776,10916649,10621275,10621276,10916790,10616306,10916843,10916879,10916920,10916922,10621421,10916933,10621439,10916978,10979134,10621510,10917031,10917034,10979204,10979205,10979206,10979207,10979208,10979209,10979210,10979211,10979212,10979213,10979214,10979215,10979216,10979217,10979218,10966218,10979219,10966219,10979220,10979221,10979222,10979223,10979224,10979225,10979226,10979227,10979228,10979229,10979230,10621572,10979231,10979232,10979233,10979234,10979235,10979236,10979237,10979238,10621580,10979239,10979240,10979241,10979242,10979243,10621585,10979244,10979245,10979246,10979247,10979248,10979249,10979250,10979251,10979252,10979253,10979254,10979255,10979256,10979257,10979258,10979259,10979260,10979261,10979262,10979263,10979264,10979265,10979266,10979267,10979268,10979269,10979270,10979271,10979272,10979273,10979274,10621631,10917141,10917142,10621632,10621633,10917155,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621656,10621657,10917195,10621689,10621690,10621691,10917203,10917209,10917210,10621701,10621702,10621703,10621704,10621742,10621743,10979401,10979402,10979403,10979404,10979405,10979406,10979407,10979408,10979409,10979410,10979411,10992416,10917384,10922456,10917458,10917461,10917462,10565195,10611053,10611054,7059683,9181673,9181674,9181675,9181676,9181677,9181678,9181679,9181680,9181681,9181682,9181683,9181684,9181685,9181686,9181687,9181688,9181689,9181690,9181691,9181692,9181693,9181694,9181695,9181696,9181697,9181698,9181699,8864221,9181700,9181701,9181702,9181703,9181704,9181705,9181706,9181707,9181708,9181709,9181710,6665728,10559772,10559773,9174009,9174281,9174283,9179325,9179326,9179563,9179572,9179573,9179574,9179575,9179576,9179593,9179606,9179608,7057837,9179703,10560539,10560540,10560541,10560542,10560543,10560544,10560545,10560546,10560605,10560606,9171877,7058762,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,7058808,10613365,10613366,10564610,10564611,10564612,10564613,10564645,10564646,10564670,10564735,10564736,10564737,10564738,10564739,10564806,10564807,8863588,8863589,8863590,8863591,8863592,8863593,8863594,8863595,8863596,8863597,10565043,10565044,10565045,9161375,9169641,9169642,10515500,10515501,10515502,10515503,10513730,9178018,9178019,9178020,9178021,9178022,9178023,9178024,9162124,9162125,9162126,9162139,9178208,7056507,7056508,7056509,7056510,7056511,7056512,7056513,7056514,7056515,7056516,7056517,9178388,9178389,9178390,9178391,9178392,9178393,7056570,7056571,7056572,7056573,7056578,9178601,9178602,9178603,9178604,9178605,9178606,9178607,9178608,9178609,9178610,9178611,9178612,9178613,9178614,9178615,9178616,9178617,9178618,7056801,7056802,7056826,2809396,2809409,10518990,9179212,9179213,9179214,10415269,10415275,10415276,9160404,9160406,9160407,9160408,9160412,10419378,10419379,10419380,9168462,8918211,8918314,10415617,7054877,4973604,4973606,4973607,10415848,10415849,10417025,10416128,10416152,4971152,4971153,4971154,4971155,10463005,10463024,10463025,10463026,10463042,10467108,10467109,10467126,10467147,10463392,10463393,10463394,10463395,10467433,10467434,4971932,4971949,10463745,10463746,10465771,10463772,10465772,10463773,10465773,10463774,10465774,10463775,10465775,10463776,10463777,10463778,10463779,10465801,10465802,10465861,10465862,10465863,10465864,10463878,10463879,10463880,10465910,4972208,4972209,4972210,4972211,4972212,4972213,4972214,4972215,4972216,4972228,10464040,6667470,8563591,8917363,10466313,10466314,10466315,10466316,10466317,10466318,10466347,10466348,10466349,10466350,10466351,10466352,10466406,10466407,10466408,10462409,10466409,10466410,10466411,10462429,10462430,10462431,10462474,10462475,10462476,10462477,10462478,10462479,10462480,10462481,10462482,10462483,10462569,10462584,9168018,10462723,10466851,10628569,10155832,10155846,10155849,10155941,10156205,10156208,10156211,10156215,10629820,10629821,10629841,10629842,10629843,10629844,10629845,10629846,10629847,10629848,10629849,10629850,10629851,10163501,10163546,10158703,10630180,10630181,10630182,10630248,10630987,10631029,10626046,10626047,10626048,10626710,10626711,10163481,10566951,10566962,10521341,10523675,10523680,10523749,10523750,10523751,10523752,10523753,10523754,10523755,10523816,10524600,10524601,10524602,10524603,10524604,10524605,10524606,10524607,10524608,10524609,10524610,10524611,10524612,10524613,10524614,10524615,10524616,10524617,10524618,10524619,10524620,10524621,10524622,10524623,10524624,10524625,10524626,10524627,10420313,10421391,10422035,10423042,10422060,10421105,10421106,10421121,10421122,10421129,10421130,10421131,10421132,10473343,10473344,10473420,10473421,10473422,10473423,10473424,10473485,10473497,10473498,10473499,10473500,10479741,10479781,10479786,10473893,10473894,10473895,10473896,10473897,10473968,10473969,10473970,10473971,10474012,10474013,10474014,10474032,10474033,10474039,10474040,10474041,10474052,10474064,10474065,10476168,10472851) 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'