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(4970775,4970776,4970777,4970778,4970779,4970780,4970781,4970782,4970783,4970784,4970785,4970786,4970787,4970788,4970789,4970790,4970791,4970792,4970793,4970794,4970795,4970796,4970797,4970798,4970799,4970800,4970801,4970802,4970803,4970804,4970805,4970806,4970807,4970808,4970809,4970810,4970811,4970812,4970813,4970814,4970815,4970816,4970817,4970818,4970819,4970820,4970821,4970822,4970823,4970824,4970825,4970826,4970827,4970828,4970829,4970830,4970831,4970832,4970833,4970834,4970835,4970836,4970837,4970838,4970839,4970840,4970841,4970842,4970843,4970844,4970845,4970846,4970847,4970848,4970849,4970850,4970851,4970852,4971019,4971022,4971032,4971062,4971083,4968188,4968189,4968190,4968191,4968192,4968193,4968194,4968195,4968196,4968197,4968198,4968199,4968200,4968201,4968202,4968203,4968204,4968205,4968206,4968207,4968208,4968209,4968210,4968211,4968212,4968213,4968214,4968215,4968216,4968217,4968218,4968219,4968220,4968221,4968222,4968223,4968224,4968225,4968226,4968227,4968228,4968229,4968230,4968231,4968232,4968233,4968234,4968235,4968236,4968237,4968238,4968239,4968240,4968241,4968242,4968243,4968244,4968245,4968246,4968247,4968248,4968249,4968250,4968251,4968252,4968253,4968254,4969177,4969300,4969301,4969302,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,4969312,4969313,4969314,4969315,4969316,4969317,4969318,4969319,4969320,4969321,4969322,4969323,4969324,4969325,4969326,4969327,4969328,4969329,4969330,4969331,4969332,4969333,4969334,4969335,4969336,4969337,4969338,4969339,4969340,4969341,4969342,4969343,4969344,4969345,4969346,4969347,4969348,4969349,4969350,4969351,4969352,4969353,4969354,4969355,4969356,4969357,4969358,4969359,4969360,4969361,4969362,4969363,8074671,8074672,8074673,8074679,8074684,8074689,8074694,8074699,8074706,8074711,8074716,8074722,8074727,8074732,8074737,8074742,8074748,8074753,8074758,8074759,8074760,8074767,8074772,8074777,8074782,8074787,8074792,8074797,8074802,8074803,8074808,8074814,8074819,8074824,8074829,8074834,8074839,8074844,8074850,8074856,8074861,8074866,8074871,8074877,8074884,8074890,8074891,8074897,8074902,8074907,8074912,8074917,8074922,8074923,8074929,8074934,8074940,8074946,8074951,8074956,8074961,8074962,8074967,8074973,8074978,8074985,8074990,8074995,8075000,8075005,8075011,8075017,8075022,8075028,8075034,8075040,8075046,8075051,8075052,8075058,8075064,8075069,8075074,8075080,8075086,8075092,8075098,8075099,8075105,8075111,8075116,8075117,8075122,8075128,8075133,8075138,8075143,8075149,8075155,8075160,8075161,8075166,8075171,8075176,8075181,8075186,8075192,8075197,8075202,8075203,8075209,8075225,4967982,4967983,4967984,8073675,8073681,8073686,8073696,8073702,8073708,8073713,8073720,8073729,8073735,8073740,8073741,8073749,8073756,8073762,8073767,8073774,8073780,8073781,8073787,8073792,8073799,8073805,8073811,8073816,8073823,8073830,8073836,8073841,8073842,8073848,8073849,8073855,8073860,8073865,8073871,8073877,8073883,8073888,8073895,8073900,8073905,8073910,8073916,8073922,8073928,8073933,8073941,8073947,8073952,8073957,8073962,8073968,8073974,8073979,8073986,8073991,8073997,8074002,8074008,8074014,8074020,8074025,8074031,8074037,8074042,8074048,8074053,8074059,8074064,8074070,8074076,8074081,8074086,8074091,8074096,8074102,8074107,8074112,8074118,8074123,8074128,8074133,8074138,8074144,8074150,8074155,8074161,8074166,8074171,8074177,8074182,8074189,8074195,8074200,8074206,8074212,8074217,8074223,8074230,8074236,8074237,8074242,8074247,8074248,8074253,8074259,8074265,8074271,8074277,8074283,8074289,8074294,8074295,8074301,8074307,8074312,8074317,8074322,8074323,8074329,8074330,8074336,8074341,8074342,8074343,8074353,8074354,8074360,8074365,8074370,8074375,8074382,8074388,8074393,8074394,8074395,8074403,8074404,8074411,8074416,8074422,8074427,8074434,8074440,8074445,8074450,8074455,8074460,8074465,8074470,8074476,8074483,8074488,8074494,8074499,8074505,8074511,8074517,8074523,8074529,8074534,8074541,8074547,8074553,8074559,8074565,8074572,8074578,8074583,8074590,8074596,8074601,8074606,8074611,8074617,8074618,8074624,8074629,8074635,8074640,8074645,8074650,8074655,8074660,8074666,8073550,8073553,8073558,8073563,8073569,8073575,8073581,8073586,8073594,8073600,8073605,8073612,8073619,8073624,8073630,8073635,8073642,8073648,8073654,8073660,8073668,10622967,10623063,10623252,10623582,10623768,10623959,10623965,10624335,10624336,10624337,10622141,10622142,10622143,10622144,10622145,10622146,10622147,10622148,10622149,10622150,10622151,10622152,10622153,10622154,10622155,10622156,10622157,10622158,10622159,10622160,10622161,10622162,10622163,10622164,10622165,10622166,10622167,10622168,10622169,10622170,10622171,10622172,10622173,10622174,10622175,10622176,10622177,10622178,10622179,10622180,10622181,10622182,10622183,10622184,10622185,10622186,10622187,10622188,10622189,10622190,10622191,10622192,10622193,10622194,10622195,10622196,10622197,10622540,10622541,10622542,10622543,10622937,10620112,10620113,10620114,10620115,10620116,10620117,10620118,10620123,10620124,10620125,10620126,10620127,10620128,10620129,10620130,10620131,10620132,10620133,10620134,10620135,10620136,10620791,10565186,10565187,10565188,10517614,10517615,10517616,10517617,10517618,10517657,10517658,10517659,10517753,10517805,10517806,10517807,10517808,10419882,10419883,10419884,10419885,10419886,10419887,10419888,10419889,10419890,10419891,10419892,10419893,10419894,10419895,10419896,10419897,10419898,10419899,10419900,10419901,10419902,10419903,10419904,10419905,10419906,10419907,10419908,10419909,10419910,10419911,10419912,10419913,10419914,10419915,10419916,10419917,10419918,10419919,10419920,10419921,10419922,10419923,10419924,10419925,10419926,10419927,10419928,10419929,10419930,10419931,10419932,10419933,10419934,10419935,10419936,10419937,10419938,10419939,10419940,10419941,10419942,10419943,10419944,10419945,10419946,10419947,10419948,10419949,10419950,10419951,10419952,10419953,10419954,10419955,10419956,10419957,10419958,10419959,10419960,10419961,10419962,10419963,10419964,10419965,10419966,10419967,10419968,10419969,10419970,10419971,10419972,10419973,10419974,10419975,10419976,10419977,10419978,10419979,10419980,10419981,10419982,10419983,10419984,10419985,10419986,10419987,10419988,10419989,10419990,10419991,10419992,10419993,10419994,10419995,10419996,10419997,10419998,10419999,10420000,10420001,10420002,10420003,10420004,10420005,10420006,10420007,10420008,10420009,10420010,10420011,10420012,10420013,10420014,10420015,10420016,10420017,10420018,10420019,10420020,10420021,10420022,10420023,10420024,10420025,10420026,10420027,10420028,10420029,10420030,10420031,10420032,10420033,10420034,10420035,10420036,10420037,10420038,10420039,10420040,10420041,10420042,10420043,10420044,10420045,10420046,10420047,10420048,10420049,10420050,10420051,10420052,10420053,10420054,10420055,10420056,10420057,10420058,10420059,10420060,10420061,10420062,10420149,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10471277,10471278,10471279,10471280,10471281,10471282,10471283,10471284,10471285,10471286,10471287,10471288,10471289,10471290,10471291,10471292,10471293,10471294,10471295,10471296,10471297,10471298,10471299,10471300,10471301,10471302,10471303,10471304,10471305,10471306,10471307,10471308,10471309,10471310,10471311,10471312,10471313,10471314,10471315,10471316,10471317,10471318,10471319,10471320,10471321,10471322,10471323,10471324,10471325,10471326,10471327,10471328,10471329,10471330,10471331,10471332,10471333,10471334,10471335,10471336,10471337,10471338,10471339,10471340,10471341,10471342,10471343,10471344,10471345,10471346,10471347,10471348,10471349,10471350,10471351,10471352,10471353,10471354,10471355,10471356,10471357,10471358,10471359,10471360,10471361,10471362,10471363,10471364,10471365,10471366,10471367,10471368,10471369,10471370,10471371,10471372,10471373,10471374,10471375,10471376,10471377,10471378,10471379,10471380,10471381) 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'