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(10939742,7076128,10943628,7076353,8574534,10448383,8839040,10963653,10963660,10963668,11041671,11041672,10950639,10950673,10950748,7066348,8575735,10951339,8609676,7067253,7067254,10962439,10962464,8911036,11011910,11011911,7072286,10960066,10960067,10103845,10986451,10103965,10960547,10960548,10960549,10960550,10960551,10960552,10960553,10960554,10960555,10960556,10960557,10960558,10960559,10960560,10960561,10960562,10960568,10960569,10999659,10999660,10999661,10999662,10999663,10999664,10999800,7073327,4967985,8837283,8837325,8837420,10958629,10958963,8910449,8910450,8910574,10102651,8835039,8835189,11011425,11011426,11011427,10998480,10998481,11037510,11037511,6000119,6000194,6000195,6000196,6000197,6000198,6000199,8908517,8908519,11009280,11009411,10957649,8564723,8909082,8909083,8909084,8909085,8909086,10941693,10101497,10958379,10101902,10984537,10984538,10984539,10984540,10984560,10984561,10984562,10984563,10984564,10984565,10984566,10984567,10984568,10984569,10984570,10984571,10984572,10984573,10984574,10984575,10984576,11010585,11010586,10942532,10984603,10984604,10984605,10984606,10984607,11045716,10623064,11045727,10967832,10967833,10618277,10618278,10618279,10618286,11045945,10618287,11045953,10967968,10623508,10968429,10968430,10968431,10968432,10968433,10968434,10968435,10968436,10968437,10968438,10968457,8906891,10968544,10968545,11046769,11046813,10619193,8907290,8907300,11046967,11008052,11047059,8907435,8907463,11047096,11047097,11047098,11047099,11047100,11047101,11047103,8907497,11047169,8907591,8907592,8907593,8907596,8907601,8907602,8907612,8907613,8907616,8907618,8907619,8907622,8907623,8907624,8907628,8907637,8907640,8907641,8907644,8907645,8907649,8907650,8907654,8907658,8907662,8907665,8907668,8907670,8907673,8907674,8907682,8907685,8907686,8907691,8907694,8907695,8907699,8907703,8907704,8907708,11047506,10619864,10619865,10619866,8907904,8907905,8907906,10619889,10619894,10619901,10619902,10619905,8905210,8905213,8905214,8905215,8905216,8905217,8905218,8905219,8905262,8905263,10992905,10992906,10617332,10617344,10617345,10617346,10617353,10617354,10617373,10617374,10617446,10617452,10617457,10617458,10622460,10993204,8905720,11045522,11045523,11045524,10617955,10617957,8576142,10615109,10620302,10615338,10930721,10930728,10930729,10930730,10930732,10930734,10930735,10930736,10930738,10930752,10930755,10616023,10926653,8904210,8904222,8904224,8904226,8904232,8904234,8904236,8904242,8904254,8904260,8904267,8904269,8904271,8904272,8904277,8904278,8904280,8904282,8904284,8904288,8904289,8904290,8904292,8904297,8904299,8904300,8904302,8904334,8904337,8904339,8904341,8904344,8904346,8904351,8904354,8904358,8904364,8904370,8904375,8904382,8904390,8904403,8904420,10922135,10922136,10922137,10922138,10922139,10922140,10922141,10922142,10922143,10992315,10992316,8904798,10992584,10610965,10611014,10565252,9165550,9189663,7019321,7019322,7019323,7019324,7019325,7019326,7019327,7019328,7019329,7019330,7019331,7019332,7019333,7019334,7019335,7019336,7019337,7059859,7059868,9205754,10611428,10614500,10614501,9181892,9181893,10559706,9181894,9181895,9181896,9181900,10559722,10559723,10559724,10559725,10559726,10559744,9213947,10611615,9214000,6666004,9174069,9174070,9214180,9214240,10611912,10611919,9214259,10611929,9214286,10611969,10612025,9211551,9211552,9211556,9211558,9211560,9211561,9211562,9211563,9211564,9211565,9211566,8862099,10612295,10609307,9211938,9211939,9172147,8862672,10612938,10612943,10612961,8862835,9212320,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,7058533,7058534,9196371,9196372,9196373,10610061,10613106,7058620,9196484,9172507,9172513,9172514,9188641,10613369,10610479,9172840,9196844,9172887,9172890,9172924,9172925,9172926,9196960,9197029,9205065,10613738,9197133,9197135,7018818,7018819,7018820,7018821,7018822,7018823,7018824,7018825,7018826,7018827,7018828,7018829,7018830,7018831,7018832,7018833,7018834,10610947,10610954,10613958,10613959,10613960,10613961,10515327,10515328,10515329,7055690,7055723,9193598,7015320,7015321,7015322,7015323,7015324,7015325,7015326,7015327,7015328,7015329,7015330,7015331,7015332,7015333,7015334,7015335,7015336,7015337,7015338,7015339,10513561,9169748,9185757,10513619,10513620,10517670,9169942,9169944,9186013,9170074,9162137,9162289,9162290,10516137,10516138,10512530,9178723,9178789,9186797,9186798,9178828,9178847,10518695,10518696,10518697,9171077,9168305,9168306,9168307,9168309,9160319,9160335,10417282,9192378,9192379,9168394,9176404,9176408,10416364,10415392,9184492,10416435,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419538,10419568,9168669,9168728,10415676,10415677,10415678,10419679,10419681,10419682,10418689,10419690,10418692,10419694,10418702,10419707,10419720,10415735,9168818,10418804,10416806,10416807,10416808,10416809,10417812,10417818,10417822,10416826,10417828,10418829,10419834,10419835,10419836,10417837,10417841,10417847,10417854,10417858,9168940,10417864,10417872,10417876,10417881,10419888,10419889,10417889,10419892,10419893,10417893,10419896,10419897,10419898,10417899,10419900,10419906,10417907,10417911,10417917,10417922,10417927,10417932,9169064,9169065,10420040,9193119,9193120,9193121,10420045,7055300,10417057,10420058,10417058,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417086,10417093,10417106,10417107,10417108,10417109,7055456,8549456,10463009,10463010,10463012,10467121,10467123,10467124,10467131,10467137,10467138,10467139,10467140,9190818,10467431,10467441,9198977,9198978,9198979,9198980,9198981,9198982,9198983,9198985,9198986,9198987,10463731,10463734,10463735,10463739,10463741,10463743,10465762,10465764,10465766,10463801,9175224,10463808,10463809,10465832,10465833,10465837,9175260,10465839,9191499,9167533,10468239,10466307,10466310,8550898,10466340,10466367,10466379,10466381,10466385,10466386,10466388,10466389,10462407,10462417,10462418,10462421,10462425,10462426,9175851,9167851,9167892,9175922,9192026,9176117,9192129,9192130,10470724,10466857,9168281,10466863,10466864,10466865,8594166,8594167,8594168,8594169,8594170,8594171,8594172,8594173,10155844,10155845,10171178,10171179,10171180,10171181,10171182,10171183,10163536,10632053,10632056,10632163,10632164,10632165,10627319,10153863,10627670,10161842,10162089,10162090,10162244,10162245,10162246,10162247,10626145,10631239,10631240,10631915,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568126,10568127,10568128,10568129,10568130,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10590269,10590270,10590271,10590276,10590278,10590279,10590285,10590286,10590287,10590288,10590290,10590291,10590292,10590293,10590294,10590295,10590296,10590297,10590887,10567621,10567622,10567623,10567624,10567625,10591937,10591938,10591939,10591940,10591941,10568110,10568111,10529141,10529398,10529399,10527911,10532143,10532144,10532145,10532146,10532147,10532148,10532149,10532150,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10528163,10532164,10532165,10528181,10528185,10528186,10528187,10528188,10528189,10528190,10522287,10522341,10522342,10522343,10522373,10522374,10522375,10522376,10522387,10524422,10522462,10522463,10522642,10520791,10520792,10520793,10520794,10522889,10520891,10520892,10520893,10520894,10520895,10520901,10520904,10520905,10520909,10527020,10521024,10521025,10420288,10422315,10422316,10422317,10422318,10422319,10422321,10422354,10422383,10421486,10421487,10421489,10421490,10423583,10420592,10422598,10420643,10423738,10423740,10422821,10422824,10424875,10424884,10424886,10424888,10420899,10423921,10423924,10421947,10421948,10421949,10421950,10424997,10424998,10422999,10423005,10423012,10425030,10424033,10425042,10425046,10425051,10425053,10423125,10423150,10423153,10423158,10422167,10483117,10483118,10483119,10486567,10486571,10477784,10478003,10478005,10478006,10478007,10478008,10478010,10478011,10478012,10478013,10478014,10478015,10478016,10478017,10478018,10478019,10478020,10478021,10478022,10478023,10478024,10478025,10478027,10478028,10478029,10478030,10478031,10478032,10478033,10487110,10476272,10476274,10476275,10476276,10476459,10476462,10476580) 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'