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(10962502,10939604,7076163,7076248,7076253,7076269,7076270,7076273,7076278,7076281,7076314,7076361,7076362,7076382,11002066,11002067,11002275,11002276,11002277,11002278,10976287,4970963,10989315,7068748,10940504,7068795,7068796,7068797,11002487,11002488,11002642,11002643,11002644,11002645,11002646,8067153,8067154,8067155,8067156,7074120,11002824,11002825,10963825,7066165,7066170,7074272,7074281,11002977,11003036,8067512,7066715,10977433,10977434,10977435,10961530,10961531,7066909,10961677,10961678,10961770,10961771,10961772,10961773,10961774,10961775,10961776,10987842,8068458,8068468,8068477,8068486,10939437,10939438,11001444,11001445,11001446,11001447,7067797,7067798,7071864,7071865,7072166,7072167,7072168,7072169,10972870,10972952,7072280,10986007,10986085,7072626,7072771,7072823,7072866,10986556,10986557,10986558,10986559,7072920,8066035,7072980,7073020,7073078,7073114,8066193,8066194,8066195,7065376,8066451,7065394,8066482,8066491,10961324,10961325,7070838,7070842,7070852,7070878,10958563,10958564,7070886,7070890,7070894,7070899,7070904,7070906,7070920,7070926,7070930,7070935,7070937,7070942,7070971,7070972,7070973,7070974,7070975,7070976,7070977,8860903,8860912,8860914,7071076,7071077,10943129,10972108,10959184,8861420,10943326,8861534,10943370,10943372,10943403,10943404,10943411,7071717,7071720,7068855,7068861,7068987,7068988,7068989,7068990,10970024,10970025,10970026,10970027,10970409,10970410,10941790,10941798,10970768,10941802,10941811,10941814,10941847,10941848,10941876,10941885,10941890,10941891,10941898,10941919,10941934,10941961,10941985,10941986,10941987,10941991,10941992,10970964,10970965,10942026,10942036,10942039,10997009,10971046,10971096,10971097,10997104,10958205,10958206,10958208,10997229,7070637,10997324,10997325,8860655,10942474,7070763,7070776,7070813,10993521,10993522,10993523,10993524,10993525,10993526,10993527,10993528,10993564,10993565,10993577,10918550,10928579,10928582,10993653,10993654,10993655,10928634,10928635,10928636,10928637,10928638,10993676,10918706,10918707,10993736,10993737,10993738,10993739,10993740,10993741,10993742,10993743,10993744,10993745,10993746,10993747,10928818,10618329,10993884,10993885,10993886,10993887,10993888,10993889,10993890,10993891,10993892,10993893,10993894,10993895,10993896,10993897,10993898,10993899,10993900,10993901,10993902,10993903,10993904,10993905,10993906,10993907,10993908,10993909,10993910,10993911,10993912,10993913,10918996,10918997,10919333,10919334,10994598,10919675,10919676,10919677,10919678,10919679,10968824,10994832,10995069,10995070,10995071,10969322,10969323,10969324,10969325,10969326,10969327,10969328,10969329,10969330,10969331,10969332,10969333,10969334,10992530,10992531,10992532,10992533,10992534,10992535,10992536,10992537,10992538,10992539,10992596,10992599,10992625,10992626,10992650,10992672,10992673,10992674,10992675,10992676,10992677,10992678,10992679,10617151,10617154,10992755,10992784,10992785,10992786,10992787,10992793,10992794,10992808,10992809,10992810,10992811,10992812,10992813,10992814,10992857,10992907,10992908,10992909,10992910,10992911,10992912,10992913,10992914,10992915,10992916,10992952,10992953,10992954,10992955,10992956,10992957,10622491,10993047,10993048,10918051,10993082,10993083,10993084,10993103,10993164,10993174,10993181,10993185,10993186,10993201,10918189,10918190,10993224,10993229,10993256,10993260,10993295,10993304,10993317,10993319,10993320,10993333,10617795,10993338,10993353,10993354,10918392,10918393,10918394,10993450,10993451,10993476,10993477,10993478,10993479,10622941,10622942,10622943,10622944,10615002,8569850,10615046,10920571,10977615,10977616,10977617,10977618,10977619,10990623,8570018,10920706,10990804,10990805,10964888,10977893,10977894,10615483,10920998,10926006,10615504,10991129,10991130,10921106,10921107,10921108,10921109,10921110,10978239,10978240,10978241,10978242,10978243,10978244,10978245,10978246,10978247,10978248,10978249,10978250,10978251,10978252,10978253,10978254,10978255,10978256,10978257,10978258,10978259,10978260,10978261,10978262,10978263,10978264,10978265,10965281,10965282,10965457,10991460,10991479,10921487,10615983,10615989,10991530,10921511,10991541,10991558,10616050,10616052,10921612,10921652,10965700,10921678,10978790,10921796,10921797,10621367,10921912,10992026,10992027,10992028,10992046,10992047,10922034,10992108,10992132,10992133,10992134,10992135,10992136,10992137,10992138,10922113,10922114,10922115,10992182,10992203,10992215,10992216,10992217,10992218,10992248,10992334,10992335,10992388,10992389,10992407,10992412,10992452,7059485,9165376,7059546,10559252,10559253,10559254,10559255,10559256,10559257,10559258,10559259,10559260,10559268,10559269,10559270,10559279,10559280,10559281,10559282,10611161,7059683,9165556,8864208,10614405,10614413,9165823,10614555,10565707,10565708,8864535,10611857,8864751,7057487,10557139,10557140,10557141,10557142,7057497,7057507,7057512,7057530,7057539,7057544,10612094,10612105,10612152,10612186,10612290,7057824,7057825,7057826,9171686,9171687,10609375,9171919,9171921,10612585,10612594,10612645,10612651,10557803,10557804,9172003,10609757,7058304,10609983,10613055,10613084,9172466,7058664,9172525,10610197,7058730,7058731,10610235,10610273,10610274,10610283,10610284,10610285,10610299,10558580,10558581,10558582,10558617,8863454,8863455,8863456,8863501,10610736,9173092,9173093,8863730,8863731,9173254,9161372,9161373,9161375,9161377,9161398,10513241,10513242,10513243,10513244,4974398,10515417,10515418,10515419,10515420,10515421,10515422,10515423,10515424,10515425,10515426,10515427,10515428,10513486,10513487,10513488,10513489,10513490,10513491,10513492,10513493,10513494,10513495,10513496,10513497,10513498,10513499,10513500,10513501,10513502,10513503,10513504,10513505,10513506,10513507,10513508,10513509,10513510,10513511,10513512,10513513,10513514,10513515,10513516,10513517,10513518,10513519,10513520,10513521,10513522,10513523,10513524,10513525,10513526,10513527,10555579,10555580,10555581,10555582,10555583,10555584,10555618,10555619,10555620,10555621,9161857,10515750,10515752,10515753,10515754,10515755,10515756,10515757,10515758,10515759,10515760,10515761,10515762,10515763,7056162,10514001,7056421,7056435,7056436,10512141,10556346,10556347,10556348,10556349,10556350,10556359,10512549,10512550,10512551,10556571,10556572,10512758,10512759,10512780,7057179,9171110,9171111,10556932,10556933,10556934,10556935,10516967,10513075,9171288,7057462,10418265,10418266,10417273,10417274,10417275,10417276,10415311,10415463,10418510,10415547,10419598,9168711,10419812,10419890,10419894,10419938,10418982,10420004,7055284,10417060,10417078,10417135,6666484,6666559,10471198,4971494,4971616,10467340,4971617,10467358,10467360,10467361,10465712,6667165,10465770,10465771,10465772,10465773,10465774,10465775,10465776,10465777,10465778,10465779,10465780,10465781,10465782,10465783,10465784,10465785,10465786,10465787,10465788,10465789,10465790,10465791,10465792,10465793,10465794,10465795,4972102,4972103,4972114,9167452,9167453,9167454,9167465,9167466,9167468,6667490,6667491,10468146,10468147,10468149,10468151,10468154,10468157,10468158,10468159,10468160,10470245,8563605,8917522,8917523,10468466,10468493,10470515,6668182,6668183,6668184,10628073,10164605,10164606,10164607,10628154,10164791,10164792,10164793,10628309,10164991,10164992,10165016,10165076,10628797,10628798,10628800,10628804,10165577,10165578,10165579,10165580,10165581,10165582,10165735,10165736,10165737,10165738,10165739,10165740,10629820,10629840,10632055,10627284,10627286,10153854,10627600,10164261,10164262,10627911,10627912,10627913,10631237,10626311,10626319,10571500,10571501,10571502,10571503,10571507,10577583,10577584,10577585,10577586,10577587,10568720,10568721,10568722,10568723,10574745,10574746,10577777,10577778,10577779,10577945,10568955,10568956,10568957,10571957,10571958,10574971,10574972,10574973,10578102,10578103,10575237,10575238,10575239,10575240,10575241,10572318,10572319,10572323,10572324,10566443,10566444,10566445,10575476,10575477,10575478,10566581,10566582,10566583,10575583,10575584,10575585,10575586,10575587,10566592,10566593,10566594,10566595,10566596,10566638,10566639,10566640,10566641,10566642,10566643,10566644,10566645,10566646,10575981,10576206,10576207,10567557,10567558,10576770,10576771,10576772,10576773,10576774,10576775,10521153,10521258,10521264,10521266,10521267,10521282,10521283,10521284,10521312,10521313,10521314,10521315,10521483,10521484,10521553,10521554,10523576,10523577,10523578,10523579,10523580,10523581,10523582,10521863,10521864,10521865,10521869,10521870,10522098,10522228,10522527,10522528,10522529,10522860,10420227,10420229,10420232,10420235,10421976,10422019,10422030,10422033,10422042,10422074,10423089,10423094,10422105,10422125,10422127,10422146,10422168,10422169,10422173,10473053,10473065,10473102,10473634) 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'