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(8068885,7068155,10943754,10943766,10943767,7068398,10943861,10943862,4970728,4970744,4970758,10963319,10944055,10944056,10940343,10940344,10940345,10940346,8569752,10976497,10976498,8569902,8067169,4968423,4968424,4968425,4968426,4968427,10437080,10437081,10437082,10976973,10976974,10976975,10976976,10976977,10976978,10976979,10437180,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968636,4968637,10437418,10990330,10990331,10990332,10990333,10990334,10990335,10990336,10437639,10990547,7074921,7075012,7075051,7067056,8067967,8067988,10974793,10974800,10974808,10974840,10974846,10974854,10938841,10938842,10938843,10974918,10974920,10974933,10974952,10974953,8068163,10974961,8068281,10975098,10975103,10975110,7067429,8068333,8068334,8068554,8068557,10939299,7075798,7075935,10931386,10931387,10931388,10931389,10959820,10931530,7064226,7064253,10931627,10959980,10931729,8065398,7064497,10931935,8065567,10960334,10960335,8065670,7064727,7064728,7064729,7064730,8065796,8065797,7064840,10932278,10932279,7064975,10973817,10973827,10973828,10973843,10973856,10973857,10973870,8066171,10973912,10973942,10986948,10973977,10973990,7073311,7073319,7073323,7073324,10932671,10932672,7065453,10932813,7065540,10932903,7073634,7073635,10932984,10933034,10933044,10933234,10933252,7070936,10971622,11049806,10942600,10971689,10971798,10958820,10958821,10958822,7071150,10942806,10942807,10942808,10942818,10958942,11049159,10958986,10959006,10972013,11049376,11049399,7071573,10943264,10959535,10959537,10959541,10959570,10931233,10931234,10931235,10931236,10931278,7068994,10940916,3656053,10944928,10944930,11047678,11047752,11047753,11047754,11047755,11047756,11047757,11047758,11047759,11047760,11047761,11047762,11047763,11047764,11047765,11047808,11047809,10941850,11048134,11048135,11048136,11048137,11048138,11048139,11048140,11048141,11048142,11048143,11048144,11048145,11048146,11048147,11048148,11048149,11048150,11048151,11048152,11048153,11048154,11048155,11048156,11048157,11048158,11048159,11048160,11048161,11048162,11048163,11048164,11048165,3656944,10971235,10971262,10971307,11049614,10942510,10918710,10954931,10954932,10954933,8070118,8070119,8070120,8070121,8070122,8070123,10623415,8070124,8070126,8070127,8070128,8070129,8070130,8070132,8070215,8070216,8070217,8070218,10919039,10955293,10955294,10955295,10955296,10955297,10955298,10955299,10955300,10955301,10955302,10955303,10955304,10955305,10955306,10955307,10955308,10955309,10955310,10955311,10955312,10955313,10955314,10955315,10955316,10955317,10955318,10955319,10955320,10955321,10955322,10955323,10955324,10955325,10955326,10955327,10955328,10955329,10955330,10955331,10955332,10955333,10955334,10955335,10955336,10955337,10955338,10955339,10955340,10955341,10955342,10955343,10955344,10955345,10955346,10955347,10955348,10955349,10955350,10955351,10955352,8070413,8070414,10919326,10955481,8070630,8070631,8070632,8070633,8070634,8070635,8070636,8070637,8070638,8070639,8070640,10981799,10619175,10955999,10956183,10956184,10956185,10956186,10956187,10956188,10956189,10956190,10956191,10956192,10956193,10956194,10956195,10956196,10956197,10956198,10956199,10956200,10956201,10956202,10956203,10956204,10956205,10956206,10956207,10956208,10956209,10956210,10956211,10956212,10956213,10956214,10956215,10956216,10956217,10956218,10956219,10956220,10956221,10956222,10956223,10956224,10956225,10956226,10956227,10956228,10922494,10966688,10966689,10966690,10966691,10966692,10922834,10922835,10922836,10927840,10927874,10922877,10922878,10922879,10622440,10622441,10622442,10622443,10622444,10622771,8570017,10615215,10615370,10615456,8570492,10965396,10965397,10921299,10621013,10930952,10621046,10616387,10616394,10616415,10616420,10926987,10926988,10926989,10926990,10926991,10922043,10922301,10922344,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,9165377,7059546,10562246,7059667,10559332,10559333,7059687,10559334,10559335,10559395,10614336,10559520,10559521,10559522,10559523,10559524,10559525,10559558,10559602,10559603,10559604,10559605,10559606,10559607,10559608,10559615,8864351,8864378,6665867,10559713,6665919,6665920,10611591,10611650,10611651,9166027,9166028,9166088,7057465,8861960,7057614,7057615,7057718,10612247,7057770,7057777,7057787,10612342,10612344,8862261,7057939,10612487,8862536,10612680,7058194,10612699,10609707,9164044,9164045,9164046,9164047,9164048,9164049,10609712,9164050,9164051,9164052,9164053,9164054,10609717,9164055,9164056,9164057,9164058,9164059,9164060,9164061,9164062,9164063,9164064,9164065,9164066,9164067,9164068,9164069,9164070,9164071,9164072,9164073,9164074,9164075,9164076,9164077,9164078,9164079,9164080,9164081,9164082,9164083,9164084,9164085,9164086,9164087,9164088,9164089,9164090,9164091,9164092,9164093,9164094,9164095,9164096,9164097,9164098,9164099,9164100,9164101,9164102,9164103,9164104,10612931,8862910,9164557,8863131,10558478,7058836,7058894,10613468,8863343,10564684,10564685,10564686,10564687,10564688,10564689,10564690,10564691,10564692,10564693,10564694,10564695,10564696,10564697,10564698,7059089,10613683,10610739,10613925,10613926,7055524,7055577,7055578,7055579,7055580,7055638,7055835,7055927,7056000,10515765,10515766,10515767,10515801,10515819,7056233,7056277,7056284,9162128,9162314,9162315,9162316,9162317,9162318,9162319,4975233,4975234,4975235,9162657,9162658,9162659,9162660,9162661,9162662,9162663,9162664,9162665,9162666,9162668,9162669,9162670,9162671,9162672,9162673,9162674,9162675,9162676,9162677,9162678,9162679,9162681,9162682,9162683,9162684,9162685,9162686,9162687,9162688,9162689,9162690,9162691,9162692,9162693,9162694,9162695,9162696,9162697,9162698,9162699,9162701,9162702,9162703,9162704,9162705,9162706,2809375,7056963,9162982,9162983,9162984,9162985,9162986,8861647,8917946,10417237,10415247,10418292,10419309,10417335,10417458,10418490,10418496,4973432,10419582,10419586,10418618,10415632,10419651,10419652,7054912,10419673,10419674,4973625,4973626,4973627,4973628,10416713,10419723,9160814,10418739,9160819,9160828,9160836,7055010,7055011,7055012,7055013,7055014,7055015,7055016,7055017,7055018,7055019,7055020,7055054,7055072,7055138,7055139,7055140,9161106,10417146,7055412,7055413,9161257,9161258,9161259,9161260,10462947,10469005,10463017,10469126,10463256,10467280,8916487,8916488,8916489,8916490,8916491,8916492,8916493,4971847,4971848,4971855,4971856,10471595,10471596,10471597,10471598,10471599,10471600,6667191,6667192,8563308,8563316,8917195,4972525,4972526,10468576,10468577,10468578,10468613,10468614,10464808,10464809,10464810,10154508,10154528,10154539,10154546,10154556,10154572,10154585,10154601,10154722,10628263,10628264,10159866,10159885,10628390,10628391,10628392,10628393,10159934,10159936,10159937,10155091,10155092,10155243,10155244,10155245,10155246,10628790,10160419,10155612,10155616,10155645,10155685,10160711,10160738,10160778,10155817,10160843,10160911,10160912,10160913,10156111,10156112,10156113,10156114,10156115,10156116,10156117,10156118,10156119,10161219,10156255,10156256,10156431,10158645,10154145,10159247,10154282,10627787,10627788,10154383,10154400,10154408,10154415,10154448,10154477,10156525,10156526,10156527,10156528,10156529,10156530,10156531,10156532,10156533,10156649,10156650,10156651,10630281,10626092,10626093,10626094,10626102,10157710,10157711,10157712,10157713,10157714,10157715,10157716,10157717,10157718,10157719,10157720,10157721,10157722,10157723,10157724,10157725,10157726,10157727,10157728,10157729,10157730,10157731,10157732,10157733,10157734,10157735,10157736,10157737,10157738,10157739,10157740,10157741,10157742,10157743,10157744,10157745,10157746,10157747,10157748,10157749,10157750,10626269,10626270,10626271,10626272,10626273,10626274,10631497,10631498,10568818,10568819,10566133,10567647,10567648,10567649,10522268,10522269,10520958,10520959,10520960,10520961,10520962,10520963,10520964,10520965,10421355,10421356,10420601,10420999,10422089,10472876,10472877,10472878,10472879,10472912,10472924,10472925,10472948,10472998,10472999,10473073,10475236,10475264,10475285,10475287,10475299,10475321,10475333,10473369,10473370,10473371,10473372,10473373,10473374,10473375,10473376,10473377,10473378,10473379,10473380,10473381,10473382,10473383,10473384,10473385,10473386,10473387,10475532,10473709,10473710,10475738,10473891,10472029,10472030,10472031,10472032,10472033,10472034,10472035,10472036,10472037,10472038,10472039,10472040,10472041,10474231,10472235,10474264,10474265,10474315,10474406,10474407,10474408,10474409,10474410,10474411,10474412,10474413,10474414,10474415,10472736,10472757,10472758,10472759,10472873,10472874,10472875) 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'