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(10939588,10939591,8068869,10939602,8068870,8068871,10939603,10939604,8068872,10939605,10939606,10939607,10939608,10939609,10939610,10939611,10939612,10939613,10939614,10939615,10939616,10943619,10943620,10943621,10943622,10943623,10943624,10943625,10943626,10943627,10939874,10939875,10939876,10939877,10939878,10939879,10939880,10939881,10939882,10939883,10939884,10939885,10939924,10939925,10939926,10939928,10939930,4970636,4970637,4970638,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,10944018,4970815,10944019,4970816,10944020,4970817,4970818,10944021,10944022,4970819,10944023,4970820,4970821,10944024,4970822,10944025,10944026,4970823,10944027,10944028,10944029,10944030,10944031,10944032,10944033,10944034,10944035,10944036,10944037,10944038,10944039,10944040,10944041,10944042,10944043,10944044,10944069,10944070,10940354,4971022,4971023,4971024,4971025,4971026,4971027,4971028,4971030,4971031,4971032,4971033,10944261,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971097,10944317,10944318,10944319,10944320,10944321,10944322,10944323,10944324,10944325,10944326,10944327,10944328,10944329,10944330,10944331,10944332,10944333,10944334,10944335,10944354,7065949,8066993,10933512,8067150,8067151,8067152,8067153,8067154,8067155,8067156,8067157,8067158,8067159,8067160,8067161,8067162,8067163,8067164,8067165,8067166,8067167,8067168,8067169,8067170,8067171,8067179,8067185,8067195,8067196,8067197,8067198,8067199,8067200,8067201,8067202,8067203,8067204,8067205,8067206,8067207,8067208,8067209,8067210,8067211,8067212,8067213,8067214,8067215,8067216,8067217,7066241,8067218,8067219,8067220,8067221,8067222,8067223,8067224,8067319,8067320,8067364,10437265,7066486,7066487,7066488,7066489,7066490,7066491,7066492,7066493,7066494,7066495,7066496,7066497,7066498,7066499,7066500,7066501,7066502,7066503,7066504,7066505,7066506,7066507,7066508,7066509,7066510,7066511,7066512,7066513,7066514,7066515,7066516,7066517,7066605,7066696,7066697,7066698,7066699,7066700,7066701,7066702,7066703,7066704,7066705,7066706,7066707,8067776,7066816,7066817,7066818,7066819,7066820,7066821,7066822,7066823,7066824,7066825,8067859,8067880,7066995,7066996,7066997,7066998,7066999,7067015,8067944,8067945,8067946,4969371,4969372,4969373,4969374,4969375,4969376,4969377,4969378,4969379,4969380,4969381,4969382,4969383,4969384,4969385,4969386,4969387,4969388,4969389,4969390,4969391,4969392,4969393,4969394,4969395,4969396,4969397,4969398,4969399,4969400,4969401,4969402,4969403,4969404,4969405,4969406,4969407,4969408,4969409,4969410,4969411,4969412,4969413,4969414,4969415,4969416,4969417,4969418,4969419,4969420,4969421,4969422,4969423,4969424,4969425,4969426,4969427,4969428,4969429,4969430,4969431,4969432,4969433,4969434,4969435,4969436,4969437,4969438,4969439,4969440,4969441,4969442,4969443,4969444,4969445,4969446,4969447,4969448,4969449,4969450,4969451,4969452,4969453,4969454,4969455,4969456,4969457,4969458,4969459,4969460,4969461,4969462,4969463,4969464,4969465,4969466,4969467,4969468,4969469,4969470,4969471,4969472,4969473,4969474,4969475,4969476,4969477,4969478,4969479,4969480,4969481,4969482,4969483,4969484,4969485,4969486,4969487,4969488,4969489,4969490,4969491,4969492,10939126,10939127,10939128,10939129,10939130,10939131,10939132,10939133,10939134,10939135,10939136,10939137,10939138,10939139,10939140,10939141,10939142,10939143,10939144,10939145,10939184,7067633,7067634,7067635,7067636,7067637,7067638,7067639,7067640,7067641,7067642,7067643,7067644,7067645,7067646,7067782,7067783,10939458,7067844,10939476,10939477,10939478,10939479,10939480,10939481,10939482,10939483,10939484,10939485,10939486,10939487,10939488,10939489,10939490,10939491,10939492,10939493,10939494,10939495,10939496,10939497,10939498,10939499,10939500,10939501,10939502,10939503,10939504,10939505,10939506,10939507,10939508,10939509,10939510,10939511,10939512,10939513,10939514,10939515,10939516,10939517,10939518,10939519,10939520,10939521,8068812,8068813,8064994,8065124,8065125,8065126,8065127,8065128,8065129,8065130,8065131,8065132,8065133,8065134,8065135,8065136,8065137,8065138,8065139,8065140,8065141,8065142,8065143,8065144,8065145,8065146,8065147,8065148,8065149,8065150,7064365,7064394,7064459,10931835,10931836,10931837,10931839,10931840,10931842,7064526,8065503,7064683,8065702,8065734,8075493,8065762,8065764,8075522,8065880,8065881,8065882,8065883,8065884,8065885,8065886,8065887,8065888,8065889,8065890,8065891,8065892,8065893,8065894,8065895,8065896,8065897,8065898,8065899,8065900,8065901,8065938,10932346,10932347,10932348,10932349,8066069,8066070,10932469,8066127,8066128,8066129,8066130,8066147,7065178,7065379,7065380,7065381,7065382,7065383,7065384,7065385,7065386,7065387,7065388,7065389,7065390,7065391,7065392,7065393,7065447,7065573,7065574,10932994,7065691,7065692,7065693,4967996,4968029,7065868,7065869,7065881,7065882,7065883,7065884,7065885,7065886,7065887,7065888,7065889,11049086,11049164,11049165,11049166,11049174,11049175,11049178,11049179,11049180,11049181,10943217,10943218,10943219,10943220,10943269,10943270,8970205,8970206,8064909,3655634,3655659,3655664,3655666,10944519,10944520,10944521,3655682,3655685,3655686,3655687,3655739,10944607,10944608,10944764,3656297,3656389,11047888,11047903,11047905,11047911,11047915,11047920,10941687,10941854,3656816,3656817,3656818,3656819,3656820,3656821,3656822,3656823,3656824,8073015,8073016,8073017,8073018,8073022,8073037,10942090,11049719,11049720,11049721,11049722,11049723,11049724,11049725,11049726,11049727,11049728,11049729,10942524,10622962,10622993,10622994,10622995,10623056,10623057,10623058,10623059,10623060,10623061,10623062,10623063,10623064,10623065,10623066,10623067,10623068,10623180,10623490,10924312,10924313,10924314,10924315,10924316,10924317,10924318,10924324,10622692,10622718,10622719,10622720,10622924,10622932,10622938,10622940,10622954,10620108,10620216,10620217,10620218,10620219,10620220,10620221,10620222,10620223,10620224,10620225,10922083,10922084,10922085,10922127,10922128,10922129,10922130,10922131,10922132,10922133,10922134,10922135,10922136,10922137,10922138,10922139,10922140,10922141,10922142,10922143,10621774,10614517,10614532,10614563,10614772,10614773,10614774,10614775,10614776,10614777,10614778,10614779,10614780,10614781,10614783,10614785,10614786,10614787,10614788,10614789,10614790,10614791,10614792,10614793,10614794,10614795,10614796,10614797,10614798,10614799,10614800,10614801,10614802,10614803,10614804,10614805,10614806,10614807,10614808,10614809,10614810,10614811,10614812,10614813,10614815,10614816,10614817,10612253,10612291,10609311,10609401,10613194,10613195,10613220,10613221,10613335,10613548,10517333,10517334,10517335,10517336,10517337,10517338,10517339,10517340,10517341,10517342,10517343,10517344,10517345,10517346,10517347,10517348,10517349,10517350,10517351,10517352,10517353,10517354,10517355,10517356,10517357,10517358,10517359,10517360,10517361,10517362,10517363,10517364,10517365,10517366,10517367,10517368,10517369,10517370,10517371,10517372,10517373,10517374,10517375,10517376,10517377,10517378,10517379,10517380,10517381,10517382,10517383,10517384,10517385,10517386,10517387,10517388,10517389,10517390,10517391,10517392,10517393,10517394,10517395,10517396,10517397,10517402,10517403,10517404,10517405,10517406,10517407,10517408,10517409,10517410,10517411,10517412,10517413,10517414,10517415,10517416,10517417,10517418,10517419,10517420,10517421,10517422,10517423,10517424,10517425,10517426,10517427,10517428,10517429,10517430,10517431,10517432,10517433,10517434,10517435,10517436,10517437,10517438,10517439,10517440,10517441,10517442,10517443,10517444,10517445,10517446,10517447,10517448,10517449,10517450,10517515,10517516,10517517,10517518,10517519,10517520,10517521,10517522,10517523,10517524,10517525,10517526,10517527,10512113,10512114,10512121,10512122,10512123,10512124,10512125,10512126,10512127,10512128,10512129,10512130,10512131,10512132,10512133,10512134,10512135,10512136,10512137,10512138,10512139,10512140,10512598,10512603,10512612,10518613,10512618,10512737,10512738,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10419974,10419975,10419976,10419977,10419978,10419979,10419980,10419981,10419982,10419983,10419984,10419985,10419986,10419987,10419988,10419989,10419990,10419991,10419992,10420079,10420080,10420081,10420132,10420133,8563209,8563536,8563565) 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'