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(4970714,4970750,10989239,7065978,10950754,10950755,10950768,10950769,7066185,7066209,7066243,7066244,7066260,10990218,8575739,10990262,10990263,10990264,10990265,10990266,10990279,10990280,10990281,10990282,10990283,10990286,10990287,10990288,10990289,10990290,10990291,10990292,10990293,10990299,10990300,10990301,10990302,10990303,10990304,10990305,10990313,10990316,10990317,10990318,10990319,10990320,10990321,10990322,10990323,10990326,10990327,10990328,10990329,10990338,10990339,10990342,10990343,8609655,10990618,8067913,8067916,8573251,8573253,8573320,8573321,8573322,8573324,8573325,10939432,10960084,7065917,8910061,8910062,8910072,8910256,8910257,8834765,10959114,8910629,10998402,10998403,3655651,3655652,3655653,3655654,3655655,3655656,3655657,3655658,8908498,8908499,8908500,8908501,3656308,3656310,3656314,3656317,3656323,3656324,3656325,3656326,3656337,8908897,8909071,10101456,10101477,10101480,3656992,10101561,10101584,10101585,11048460,11048478,8906010,8906016,8906042,8906057,8906058,8906059,8906143,8906144,8906171,8906172,8906173,8906222,8906315,8906316,10618287,10618289,8906339,8906340,8906341,8906342,8906367,8906398,8906507,8906509,8906510,8906511,8906512,8906515,8906516,8906517,8906518,8906519,8906520,8906521,8906522,8906523,10623492,8906524,8906525,8906526,8906527,8906528,8906529,8906530,8906531,8906550,8906563,8906850,8906853,8906859,8905041,10617013,10617072,10617107,10617109,10617118,10617119,10617132,10617133,10617135,10617148,10617149,10617151,10617209,10617235,8905269,10617260,8905298,8905299,10617272,10617273,8905310,10617301,10622312,10954104,10954105,10954106,10954107,10954108,10954109,10954110,10954111,10617471,10622539,10954226,10954227,10954401,8905815,8905915,8905921,8905927,8905932,8905977,10990635,10615045,10615047,10615048,10615063,10615073,10615078,10615079,10615080,10615145,10615147,10615151,10615152,10615153,10990820,10990821,10990822,10990823,10990824,10990825,10990826,10990827,10620195,10620196,10620197,10620198,10620199,11042883,11042884,10990948,10990949,10990970,10990971,10615314,10615318,10615321,10615322,10990986,10990987,10990988,10990989,10990990,10990993,10990994,10991000,10991001,10991002,10991003,10991004,10991005,10991009,10991015,10615357,10991023,10615365,10991024,10991025,10991026,10615380,10991039,10991040,10615391,10615392,10615393,10991061,10991062,10991063,10991064,10615411,10615412,10615413,10615430,10615440,10615441,10615447,10615452,10615453,10615454,10615455,10615456,10615457,10615458,10615466,10615471,10615472,10615511,10991171,10615521,10615522,10615523,10615528,10991198,10991199,10991200,10615551,10615582,10615603,10615633,10615634,10615644,10615665,10615666,10615680,10615710,10615723,10615734,10615743,10615744,10615747,10615768,10615771,10615778,10615779,10615780,10615803,10615810,10615820,10615823,10615833,10615834,10615840,10615855,10615862,10615873,10615897,10615898,10615905,10615934,10615947,10615959,10615964,10615968,10615974,10615987,10615989,10615990,10615994,10616201,10616281,8904489,8904496,10616475,8904510,8904511,8904515,8904522,8904523,8904556,8904568,8904569,10616568,10616697,10616698,8904852,8904854,8904857,8904859,10616858,10616866,10616884,10616886,10613962,10613980,10610981,10613981,10611045,10611046,10611047,10611062,10611067,10611127,10611180,10614244,10611245,10614248,10614254,10614270,10614274,10611299,10611303,10611314,10611315,10611316,10611317,10611335,10611336,10611346,10614425,10611454,10611456,10614570,10611675,10611679,10614711,10611711,10614743,10614777,10614795,10614796,10614797,10614798,10611800,10611812,10614849,10614921,10611955,7016981,7016982,7016983,7016984,7016985,7016986,7016987,7016988,10612020,10612033,10609053,10609054,10612055,10609055,10609056,10612069,7017077,7017078,7017079,7017080,7017081,7017082,7017083,7017084,7017085,7017086,7017087,7017088,7017089,7017090,7017091,7017092,7017093,7017094,7017095,7017096,7017097,7017098,7017099,7017100,10612112,10612113,10612124,10612263,10612267,7017277,7017278,10612294,7017297,7017298,7017299,7017300,10612335,10612337,7017331,7017332,7017333,7017334,7017335,7017336,10609356,10609360,7017381,7017382,7017383,7017384,7017437,7017438,7017439,7017440,10612518,10612589,10612604,10612633,10612641,10612647,10612648,10612655,10612658,7017661,7017662,7017663,7017664,7017665,7017666,10612675,7017667,7017668,7017669,7017670,10612684,10612685,10612689,10612690,10612701,10609719,10609764,10609765,10609770,7017787,7017792,10612831,10612853,10612872,10612884,10609894,10612922,10612923,10612933,10612938,10612943,7017942,7017962,10609975,10612987,10612988,10612989,7017982,10613058,10613079,10613083,10613085,10613087,10613091,10613092,10610093,10613097,10613098,10613099,10613100,10613106,10613107,10610122,10613193,10613247,10613261,10610298,10610363,10610372,10610486,10613514,10613524,10613525,10610691,10610704,10613707,10613708,10613709,10613883,10610942,10610943,10610945,7055475,7055476,9185360,7055569,7055570,9169430,9169443,9169464,9169467,9169479,9169480,9169506,9161527,7015182,9169528,9169541,7015203,9209553,9169553,9209554,7015224,9209574,9209575,7015245,9169596,7015266,9169633,9169643,9169661,9169674,9169675,9169801,9169830,9169831,9169917,9170027,9170028,7015712,7015713,7015714,7015715,7015776,7015777,7015778,7015779,7015780,7015781,7015782,7015783,7015784,7015785,7016196,7016235,7016236,7016237,7016238,7016265,7016266,7016267,7016268,7016333,7016334,7016335,7016336,7016337,7016338,10417242,10417243,10417244,10417245,10417246,10417247,10417248,10417249,10417250,10417255,10417257,10419259,10419260,10418260,10418261,10418262,10419271,10418282,10418283,10418307,10418317,10418319,10418322,10418324,10418325,10418328,10418329,10417349,10417351,10417357,10419381,10419385,10419392,10419393,10417394,10417395,10417396,10419396,10417397,10417398,10417399,10417400,10417401,9168483,10415419,10415426,10418426,10418427,10418428,10418429,10418430,10417433,10417434,10418439,10418440,10418441,10418442,10417452,10415461,10417462,10417467,10418471,10417498,10418507,10417509,10417510,10418521,10418522,10418523,10418524,10417529,10417531,10417532,10417533,10417535,10418537,10417544,10418546,10417553,10417560,10417595,10417596,10417599,10415621,10415625,10417633,10418633,10417634,10418634,10417644,10415650,10415651,10415656,10417664,10417665,10417666,10415674,10417712,10417713,10417718,10417719,10417739,10417754,10417759,10417760,10417761,10417762,10417763,10415763,10417764,10415764,10417766,10417775,10417788,10417790,10419797,10417817,10417818,10418829,10418830,10418831,10418832,10417836,10417837,10416843,10416844,10416849,10416850,10416851,10417853,10417854,10416858,10416861,10415864,10415865,10417871,10417872,10417884,10417885,10417886,10417887,10417888,10417889,10417890,10417891,10416891,10417892,10416892,10417893,10417894,10417895,10417896,10417897,10417898,10417899,10417900,10417901,10417906,10417907,10417933,10417934,10417935,10416943,10416944,10416945,10415955,10415972,10415991,10418007,10418008,10416043,10416047,10418083,10418084,10417088,10418095,10417103,10418116,10418118,10418124,10418131,10419149,10417149,10419150,10419151,10419152,10417155,7055401,10418158,7055402,7055403,7055404,10417165,10417175,10417182,10417187,10417190,10417198,7055464,10469245,10469305,10469509,10467603,10467614,10469726,10469727,10469728,10469729,10469803,10469804,10469805,10469806,9183395,10469978,10469979,10469980,10469981,10469982,10469983,10470087,10470107,10470108,10470109,10470170,10470171,10470202,10464205,10470212,10470213,10464215,10464216,10464217,10464218,10470233,10470235,10464262,6667688,6667691,10468271,10470271,10470272,6667693,10470273,6667694,6667695,10470274,10470275,10468275,10470276,10468276,10470277,10470278,6667700,10470279,10470280,10470281,10470282,10470283,10470284,10470285,10470286,10470287,6667708,10470288,6667709,10470289,6667710,10470290,6667711,10470291,6667712,10470292,6667713,10470293,6667714,10470294,10470295,10468295,10470296,10470297,10470298,10470299,10470300,10470301,10470302,10470303,10470304,10470305,6667727,10470306,10470307,10470308,10470309,10470310,10470311,10470317,10470320,10464326,10464342,10464343,10464344,10464345,10470346,10464346,10464347,10464348,10464349,10470357,10468361,10470376,10470377,10470378,10470379,10470380,10470381,10470385,10464396,9167821,9167823,9167825,10468430,10468431,9167859,9167860,9167867,10470448,10470481,10470482,10470483,10470487,10470490,10468526,10468527,10470589,10470590,10470593,10470642,10470663,10470666,6668088,6668089,9168093,9168155,10468782,10468783,9168212,10468799,10468872,10468873,10170914,10170915,10627321,10627415,10627774,10627793,10630050,10162115,10162183,10162184,10162185,10162266,10162269,10586552,10582560,10529725,10425092,10482906,10482962,10489209,10482856) 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'