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(8068800,8068821,8068843,8068844,8068845,8068873,8068874,8068875,8068876,8068877,8068878,8068879,8068880,10943661,10943662,10943663,10943664,10943665,10943666,10943667,10943668,10943669,10943670,10939894,10939916,4970738,4968255,4968256,4968257,4968258,10933362,4968259,4968260,10933363,4968261,4968262,4968263,4968264,4968265,4968266,4968267,4968268,4968269,4968270,4968271,4968272,4968273,10933376,10933377,4968274,4968275,4968276,4968277,4968278,4968279,4968280,4968281,4968282,4968283,4968284,4968285,4968286,4968287,4968288,4968289,4968290,4968291,4968292,4968293,4968294,4968295,4968296,4968297,4968298,4968299,4968300,4968301,4968302,4968303,4968304,4968305,4968306,4968307,4968308,4968309,8067188,8067189,8067191,10437215,10437216,10437223,8067388,10437305,10437312,10437313,10437315,10437318,10437319,10437320,8067542,8067663,8067664,8067665,8067666,8067667,8067668,8067669,8067670,8067671,8067672,8067673,8067674,8067675,8067676,8067677,8067678,8067679,8067680,8067681,10437558,8067682,8067683,10437560,10437561,8067684,8067685,10437562,10437563,8067686,8067687,8067688,8067689,8067690,10437571,10437572,10437574,10437597,10938769,10938770,10938771,10938772,8068468,8068469,8068470,8068471,8068472,8068794,8068796,8068797,8068798,10931748,10931749,10931862,10931863,10931869,8075295,10931916,10931940,10931947,10931948,10931949,10931995,10931997,10932004,10932161,10932177,10932182,10932236,10932238,10932242,10932260,10932265,10932266,8065929,10932494,10932495,10932497,10932498,10932502,10932518,10932527,10932534,10932544,10932551,10932560,10932564,10932622,10932624,10932637,10932641,10932663,10932671,10932677,10932685,10932784,10932785,10932789,10932790,10932792,10932793,10932795,10932796,10932803,10932806,10932807,10932808,10932810,10932811,10932812,10932813,10932814,10932815,10932816,10932818,10932824,10932826,10932827,8066469,8066470,10932840,8066471,8066472,8066473,8066474,10932848,10932908,10932909,10932910,10932913,10932915,10932916,10932963,10932965,10932968,10932970,10932975,10932981,10932982,10932983,10932984,10932987,10932989,10932990,10932991,10932992,10932993,10932996,10932997,10932999,10933003,10933009,10933033,10942599,10942778,10943016,10943017,10943018,10943019,10943020,10943021,10943022,10943023,10943024,10943025,10943026,10943027,10943028,10943029,10943030,10943031,10943032,10943033,10943034,10943035,10943036,10943037,10943038,10943039,10943040,8064778,8064779,8064780,8064781,10931205,10931206,10931207,10931208,10931209,10931210,3655550,3655563,8072309,8072310,8072538,8072539,8072542,8072544,8072546,3656384,3656385,3656386,8072551,8072557,8072558,3656395,3656398,3656399,3656400,8072565,8072575,8072576,8072578,8072580,3656480,8072748,8072749,8072750,8072751,8072752,8072984,8072985,8072986,8072990,8072994,3656865,3656866,10941918,10941960,10942127,10942203,10942306,8073530,8073532,8073536,8073540,8073544,10924771,10924772,10924773,10924774,10924775,10924776,10924777,10924778,10924779,10924780,10924781,10924782,10924783,10924784,10924785,10924786,10924787,10924788,10924789,10924790,10924791,10924792,10924793,10924794,10924795,10924796,10924797,10924798,10924799,10924800,10924801,10924802,10924803,10621373,10621374,10563134,10563135,10609557,10610351,10564623,10564631,10564649,10564686,10564693,10564694,10564695,10564696,10564697,10564698,10564727,10564728,10564729,10564730,10564731,10564732,10564733,10564734,10564749,10564750,10564751,10564752,10564753,10564754,10564755,10564756,10564757,10564789,10564790,10564791,10564792,10564793,10564794,10564795,10564829,10610832,10610833,10517612,10517822,10517826,10517827,10517828,10517829,10517830,10517831,10517832,10517833,10517834,10517835,10517836,10517837,10517838,10517839,10517840,10517841,10517842,10517843,10517844,10517845,10517846,10517847,10517848,10517849,10517850,10517851,10517852,10517853,10517854,10517855,10517856,10517857,10517858,10517859,10517860,10517861,10517862,10517866,10517867,10517868,10517869,10517870,10517871,10517872,10517873,10517874,10517875,10517876,10517877,10517878,10517879,10517880,10517881,10517882,10517883,10517884,10517885,10517886,10517887,10517888,10517889,10517890,10517891,10517892,10517893,10517894,10517895,10517896,10517897,10517898,10517899,10517900,10517901,10517902,10517903,10517904,10517905,10517906,10517907,10517908,10517909,10517910,10517911,10517912,10517913,10517914,10517915,10517916,10517917,10517918,10517919,10517920,10517921,10517922,10517923,10517924,10517925,10517926,10517927,10517928,10517929,10517930,10517931,10517932,10517933,10517934,10517935,10517936,10517937,10517938,10517939,10517940,10517941,10517942,10517943,10517944,10517945,10517946,10517947,10517948,10517949,10517950,10517951,10517952,10517953,10517954,10517955,10517956,10517957,10517958,10517959,10517960,10517961,10517966,10517967,10517968,10517969,10517970,10517971,10517972,10517973,10517974,10517975,10517976,10517977,10517978,10517979,10517980,10517981,10517982,10517985,10517986,10517987,10517988,10517989,10517990,10517991,10517992,10517993,10517994,10517995,10517996,10517998,10517999,10518000,10518001,10518002,10518003,10518004,10518005,10518006,10518007,10518008,10518009,10518010,10518011,10518012,10518013,10518014,10518015,10518016,10518017,10518018,10518019,10518020,10518021,10518022,10518023,10518024,10518025,10518026,10518027,10518028,10518029,10518030,10518031,10518032,10518033,10518034,10518035,10518036,10518037,10518038,10518039,10518040,10518041,10518042,10518043,10518044,10518045,10518046,10518047,10518048,10518049,10518050,10518051,10518052,10518053,10518054,10518055,10518056,10518057,10518058,10518059,10518060,10518061,10518062,10518063,10518064,10518065,10518066,10518067,10518068,10518069,10518070,10518071,10518072,10518073,10518074,10518148,10518149,10518157,10518158,10518159,10518160,10518161,10518162,10518163,10518164,10518165,10518166,10518167,10518168,10518169,10518170,10518171,10518172,10518173,10518174,10518175,10518176,10518177,10518178,10518179,10518180,10518181,10518182,10518183,10518184,10518185,10518186,10518187,10518188,10518189,10518190,10518191,10518192,10518193,10518194,10518195,10518196,10518197,10518198,10518199,10518200,10518201,10518202,10518203,10518232,10518233,10518234,10518235,10518236,10518237,10518238,10518239,10518240,10518241,10518242,10518243,10518244,10518245,10518246,10518247,10518248,10518249,10518250,10518251,10518252,10518253,10518254,10518255,10518256,10518257,10518258,10518259,10518260,10518261,10518262,10518263,10518264,10518265,10518266,10518267,10518268,10518269,10518270,10518271,10518272,10518273,10518274,10518275,10518276,10518277,10518278,10518279,10518280,10518281,10518282,10518283,10518284,10518285,10518286,10518287,10518288,10518289,10518312,10518313,10518314,10518315,10518316,10518317,10518318,10518319,10518320,10518321,10518322,10518323,10518324,10518325,10518326,10518327,10518328,10518329,10518330,10518331,10518332,10518333,10518334,10518335,10518336,10518338,10518339,10518340,10518341,10518342,10518343,10518344,10518345,10518346,10518347,10518348,10518349,10518350,10518351,10518352,10518353,10518354,10518355,10518356,10518357,10518358,10518359,10518360,10518361,10518362,10518363,10518364,10518365,10518366,10518367,10518368,10518369,10518370,10518371,10518372,10518373,10518374,10518375,10518376,10518377,10518378,10518379,10518380,10518381,10518382,10518383,10518384,10518385,10518386,10518387,10518388,10518389,10518390,10518391,10518392,10518393,10518394,10518395,10518396,10518397,10518398,10518399,10518400,10518401,10518402,10518403,10518404,10518405,10518412,10518413,10518414,10518415,10518416,10518417,10518418,10518419,10518420,10518421,10518422,10518423,10518426,10518427,10518428,10518429,10518430,10518431,10518432,10518433,10518434,10518435,10518436,10518437,10518438,10518439,10518440,10518441,10518442,10518443,10518444,10518445,10518446,10518447,10518448,10518449,10518450,10518451,10518452,10518453,10518454,10518455,10518456,10518457,10518458,10518459,10518460,10518461,10518462,10518463,10518464,10518465,10518466,10518467,10518468,10518469,10518470,10518471,10518472,10518473,10518474,10518475,10518476,10518477,10518478,10518479,10518480,10518481,10518482,10518483,10518484,10518485,10518486,10518487,10518488,10518489,10518490,10518491,10518492,10518493,10518494,10518495,10518496,10518497,10518498,10518499,10518500,10518501,10518502,10518503,10518504,10518505,10518506,10518507,10518508,10518509,10518510,10518511,10518512,10518513,10518514,10518515,10518516,10518517,10518518,10518519,10518520,10518521,10518522,10518524,10518525,10518526,10518527,10518528,10518529,10518530,10518531,10518532,10518533,10518534,10518535,10518585,10518586,10518587,10518588,10518589,10518590,10518591,10518592,10518593,10518594,10518595,10518596,10518597,10463692,8563211,10469936,10469938,10469940,8563393,8563394,8563395,8563396,8563397,8563398,10470086,8563469) 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'