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(10939916,10846179,10989242,10944069,10944070,11041369,7068725,7068726,7068727,7068728,7068729,7068730,7068731,7068732,7068733,7068851,7068853,7068859,7068864,7068866,7068868,7068870,7068877,7068880,10950661,4968322,4968332,8622042,10847075,8575536,8583901,10951064,8575733,3229976,10977288,10964355,10964356,7074691,8575911,7066742,8575923,8609614,3230232,3230233,3230243,3230244,10964573,10844945,10844946,10844948,3227611,10844950,10844951,10844953,10845000,10845006,10845007,10845008,10845012,10845014,10845016,10845017,10845020,10845023,11001134,10962198,10845290,10845301,10845302,10962234,10845306,10845313,10845314,10845319,10845331,10845332,10845335,10962291,10962292,11001377,10447720,10845602,8617785,10842777,8617994,10103302,8618050,8618053,8618058,10843071,8618397,10986248,10986249,10986250,8618409,8618413,8618414,8618421,8618422,8618423,8618426,8618427,8618435,8618436,8618438,8618448,8618449,10973366,10973367,10973368,8618688,8618690,10999552,8618721,8618722,8836498,10932598,10932655,10932671,10932675,10932677,7073332,7073333,10932685,8836928,7073466,7073467,10932832,10961233,7073555,7073602,10844386,10844395,10942594,10997806,10997809,10997810,10997811,7071127,10997812,7071131,10997817,10997818,11049202,11037010,11049279,11037154,10102645,10959242,5999942,8835150,5999954,5999957,5999983,5999985,5999987,5999989,5999991,5999994,5999997,5999999,6000001,6000003,6000012,6000015,6000018,6000019,6000020,8910811,8910825,8910826,8910832,6000103,8970228,3655555,3655567,3655663,3655782,10995916,10995932,8615258,8615270,8072305,10840367,10840368,10840375,11009354,11009355,11009356,11009357,11009358,11009359,11009360,11009361,11009362,11009365,11009368,11009369,11009370,11009372,11009375,11009376,11009377,11009378,11009379,11009380,11009381,11009382,11009383,11009390,11009391,11009392,11009393,7069710,11009394,11009395,11009399,3656286,8615668,8615669,8615670,8615672,11009540,8072653,8072654,8072655,8072656,8072657,11009752,10996783,11035976,3656867,8073080,8565085,11036159,11010214,11010243,11010244,11010245,11010274,11010275,11010283,11010288,11010361,11010429,10101877,8834298,10942537,10942539,10942540,10837716,10618018,7196254,8612862,8612907,10954778,4936893,8613065,8613066,10618287,4937060,4937072,4937084,10955053,4937096,10623488,10994203,8613418,8613419,8613431,10618883,8613695,8613696,8613697,8613707,11046636,10838897,10994881,4938044,8071107,10839282,10839283,10839284,10839285,10839286,10839287,10839288,10839289,10839290,10839291,10839292,10839293,8071310,8071327,8071343,8071355,4938357,4938358,4938359,4938360,4938361,8614589,8614592,8614593,10839551,10839557,10839558,11047517,10925451,8611819,10836829,10836905,8541725,10953906,10953907,10953908,10953909,8541743,8541786,8905425,8542072,8542115,10928200,8612629,8579088,8569918,8569919,8569921,8609827,8609883,10990753,10990754,10990755,10964884,10964885,10951839,8576424,10615475,10952100,10848311,10615597,10930891,10952759,8540598,8540620,10952914,10952915,10952916,8540877,8541007,10922076,10922077,8541055,8541161,8541221,8577914,8541254,8541266,8541267,8541268,8541272,8541306,8541312,8541315,8577980,8577981,8541316,8541317,8577982,8541318,8577983,8541325,8541331,8541335,8541347,8611691,8541394,8541397,10922452,10922457,10562125,10562149,10562185,10562186,10562187,10562188,10562189,10562190,10562191,10562192,10562193,10562194,10562195,10611053,10611054,10562360,10562361,10562362,10562420,10562426,10562427,10562428,10562429,10562430,10562431,10562432,10562433,10562434,10562435,10562436,10562441,10562442,10562443,10562444,10562445,10562446,10562448,10562449,10562450,10562459,10562460,10562461,10562462,10562463,10562464,10562465,10562466,10562472,10562475,10562476,10562477,10562478,10562479,10562480,10562481,10562482,10562483,10562484,10562485,10562486,10562487,10562488,10562489,10562491,10562492,10562493,10562498,10562500,10562501,10562502,10562503,10562507,10562508,10562509,10562512,8864222,10562513,8864223,10562514,10562515,10562516,10562517,10562518,10562519,10562522,9197710,10562523,10562527,9197718,10562535,10562539,10562540,10562546,10562547,10562551,10562552,10562553,10562554,10562571,10562572,10562573,10562584,10562585,10562586,10562590,10614441,10562607,10562608,10562609,10562614,10562615,10562616,10562617,10562618,10562619,10562622,10562627,9197825,9197829,9197832,9197833,9197843,9197844,9197846,9197847,9197848,9197853,9173868,9173871,9197871,10559698,9173944,10559758,8864497,8864498,8864505,8864508,8864520,9214039,8864668,8864686,10614857,9198225,9198242,9198262,9174280,9174282,9174284,9174290,10119654,8542632,8542635,9187502,9187511,9187512,9187523,9187524,9187531,9187532,9187538,9171568,9171569,9171755,10563573,10563575,10563580,10563584,10563587,10563590,10563591,10563605,9171801,9171802,9211821,9211883,9188073,10563934,10563935,9188228,9196374,9196375,9196376,10564205,10613077,10564261,10564262,10564316,10564317,10564318,10564319,10564386,10564387,10564388,10120923,10561582,10561598,9204797,9196808,9196809,9196810,10561623,9196811,10561624,9196812,9196813,9196814,9196815,10564631,10121025,10564649,10564686,10561701,10561702,10561703,10561704,10561705,10561738,10561739,10561740,10561741,10564749,10564750,10564751,10564752,10564753,10561753,9204941,10564754,10564755,10564756,10564757,10561766,9204974,10561806,10564808,10564809,10564855,10561873,10561874,10561875,10561876,10561877,10561878,10561879,10561880,10561881,10561882,10561883,10561884,10561885,10561886,10561887,10613766,9197124,10562033,10562034,10562035,10515139,10515140,9193328,10515141,10515142,10515143,9193351,9185360,9169403,9185405,9185406,9185407,10515243,10515244,9185432,9185456,9185457,9185458,9185459,9185460,9185461,9185464,10517328,10513344,10513345,10513346,9161534,10513347,10513348,10513349,10513350,10513351,10513352,10513353,10513354,10513355,10513356,10513357,10513358,10513359,10513360,10513361,10513362,10513363,10513364,10513365,10513366,10513367,10513368,10513369,10513370,10513371,10513372,10117853,10515499,10515511,10515512,10515513,10515514,9193750,9193752,4974643,10513625,10118095,10513723,10513724,10513725,9177930,9177931,9177932,9177933,9177966,9177967,9177968,9170015,9170016,9162119,9162143,9162165,9178369,10118688,9186548,10512576,10118980,10119076,10119087,9210913,9210914,9210922,9171154,9171198,9171199,9171200,9171201,9171202,9171203,10119480,10124546,9168353,10415285,8918178,9168721,9168758,9168847,10415857,10415858,10416993,10416156,9198327,9198475,9198502,9198510,9198525,9198526,9198544,9198549,9174619,9174620,9174623,9174626,9198647,9190649,9190664,9198704,9198747,9198748,9198798,3963467,3963584,3963585,9183314,9183321,9207326,9207332,10469932,8917005,10469965,9183437,8917089,10470091,10470137,10470146,9191574,8917251,8917254,8917255,8563544,8550806,9175727,9175728,9175776,9175802,8551001,8917532,8917534,8917539,9191907,8917577,10116159,9192066,10116289,10470723,9168189,10628549,10628553,10628555,10628556,10628557,10628558,10628559,10628562,10628566,10628570,10628576,10628577,10175133,10175136,10175198,10175201,10628910,10884532,10175797,10175798,10175799,10175800,10175801,10175802,10175810,10175811,10155833,10155836,10155843,10171124,10163487,10163502,10163503,10163547,10158704,10877721,10173855,10173856,10173857,10183997,10154005,10174212,10184235,10174292,10174293,10174294,10174295,10176624,10176628,10176629,10162168,10172284,10625926,10625927,10631247,10631248,10631249,10626378,10626379,10949911,10877179,10950037,10950038,10950041,10173363,10601119,10601120,10601124,10601140,10601141,10601305,10601306,10601307,10601308,10601309,10643472,10643474,10568553,10580749,10568942,10590973,10590974,10567473,10567531,10567532,10567541,10521328,10521329,10525402,10525403,10527829,10542107,10534278,10534351,10534398,10534399,10534400,10534454,10534455,10534456,10534457,10534458,10540885,10526964,10526965,10526993,10526994,10526995,10526996,10527085,10527086,10527087,10527088,10527089,10527090,10527091,10527092,10527093,10423223,10423226,10423228,10423231,10423234,10423239,10423378,10423380,10423384,10423393,10424572,10423627,10423660,10423662,10423667,10423672,10423673,10423674,10423676,10423678,10423681,10423075,10423173,10423217,10490047,10490055,10490057,10490071,10477080,10490096,10490120,10490121,10479183,10479184,10479196,10479197,10473275,10473279,10473287,10473288,10473303,10473304,10473305,10473306,10473326,10473327,10473345,10473374,10473397,10473426,10473427,10473432,10473433,10473434,10473435,10473436,10473437,10473459,10473475,10473476,10473477,10473486,10473488,10473502,10473503,10473504,10473505,10473506,10473507,10492803,10492804,10492807,10492810,10473899,10473900,10473901,10473902,10473903,10481933,10474015,10474042,10487187) 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'