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,10939598,4970207,4970208,4970209,10939616,4970210,4970211,4970212,10939670,4970286,4970287,4970288,4970289,4970290,4970291,10939760,10939770,4970400,4970415,10939828,4970425,10939838,10940004,10940008,4970636,4970652,4970653,4970654,4970655,4970656,4970657,4970658,10940067,4970676,4970679,10940089,4970710,4970716,4970730,4970733,4970739,4970741,10940154,10940159,4970762,4970763,4970765,4970766,10940175,4970771,4970775,10940198,10940203,10940230,10940231,10940232,10940233,10940234,10940235,10940236,10940237,10940238,10940239,10940240,10940241,10940242,10940243,10940244,10940245,10940259,10940262,10940263,4970857,4970858,4970891,10940301,10940315,4970990,10940440,10940463,4971085,4971093,4971140,8066915,8066919,8066920,8066938,8066939,8066940,8066941,8066942,8066943,8066944,8066945,8066946,8066947,8066948,8066949,8066950,8066951,8066952,8066953,8066954,8066955,8066956,8066957,8066958,8066959,8066960,8066961,8066962,8066963,4968202,8066964,8066965,8066966,8066967,8067031,4968272,8067129,8067130,8067131,4968475,4968545,8067347,8067363,8067382,8067383,8067413,8067418,8067438,8067557,8067565,8067566,8067731,4969107,10938571,4969208,10938658,10938659,10938660,10938668,4969298,4969299,4969303,4969304,4969305,10938713,4969306,4969307,10938719,10938720,10938732,10938778,10938834,10938890,10938940,10938943,10938952,10938967,4969588,10939060,10939065,10939106,10939265,10939290,10939368,10939389,10939455,8064995,8064996,8075069,8075070,8075071,8075072,8075073,8075116,8075117,8075118,8075119,8075120,8075121,8075160,8075161,8075162,8075163,8075164,8075165,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8065477,8075242,8075246,8075254,8075255,8065523,8065524,8075306,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8065699,8065704,8065842,8065872,8065952,8065978,8066067,4967335,8066128,8066172,8066173,8066174,8066175,8066440,8066495,4967835,4967858,4967992,4967996,4968007,4968028,4968079,8066894,8066895,8066896,8066897,8066908,8066909,8066910,8063975,8073979,8073980,8073981,8073982,8073983,8073984,8073985,8074025,8074026,8074027,8074028,8074029,8074030,8064295,8064296,8064297,8064298,8064355,8074155,8074156,8074157,8074158,8074159,8074160,8074200,8074201,8074202,8074203,8074204,8074205,8064529,8064530,8064564,8074341,8074342,8074343,8074344,8074345,8074346,8074347,8074348,8074349,8074350,8074351,8074352,8074393,8074394,8074395,8074396,8074397,8074398,8074399,8074400,8074401,8074402,8064911,3655677,3655747,3655803,3655816,8072314,8072354,8072355,8072356,8072428,3656407,3656408,3656512,3656514,3656519,3656522,3656523,3656524,3656531,3656553,3656564,3656567,3656573,3656629,3656636,3656637,3656650,3656651,3656698,3656734,3656739,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072925,8072926,8072927,8072928,8072929,8072930,8072931,8072932,8072933,8072934,8072984,8072985,8072986,8072987,8072988,8072989,3656877,3656882,3656934,3656964,3657033,11049663,10918647,10918688,10623303,10623374,10623382,10919095,10919096,10623605,10623606,10919130,10919131,10623623,10919146,10623826,10623827,10919408,10623898,10919482,10919642,10919643,10919789,10919790,10919994,10920090,10624657,10624720,10624721,10920329,10920330,10920331,10920332,10920333,10920334,10920335,10920336,10920365,10920366,10920418,10920419,10920420,10920421,10920422,10920433,10920437,10920438,10920439,10920440,10920447,10920450,10920451,10920452,10621977,10621983,10621985,10621987,10621988,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622014,10622015,10622037,10622038,10622039,10622040,10622041,10622042,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622053,10622054,10622055,10622060,10622063,10622069,10622070,10622071,10622081,10622082,10622084,10622085,10622086,10622087,10622088,10622091,10622092,10622093,10622094,10622095,10622096,10622097,10917608,10622098,10917609,10622100,10622106,10622107,10622108,10622109,10622110,10622122,10622123,10622124,10622125,10622126,10622131,10917652,10622155,10622287,10917842,10917843,10917844,10917845,10917866,10622360,10622369,10917898,10917899,10917900,10917901,10917902,10917903,10917904,10622402,10622403,10622408,10622409,10622412,10917924,10917925,10917926,10917927,10622427,10622428,10622429,10622430,10917982,10622472,10622487,10622513,10622516,10622520,10918038,10918039,10622530,10622531,10622536,10622729,10620071,10915647,10915670,10915671,10915672,10915673,10915674,10915675,10915676,10915690,10620180,10620181,10620182,10620183,10620219,10620220,10915751,10915752,10915753,10620253,10620344,10620345,10620355,10620356,10620359,10620364,10620365,10620366,10620367,10620368,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620385,10620391,10620395,10620396,10620399,10620400,10620404,10620406,10620407,10620410,10620411,10620412,10620413,10620421,10915939,10915940,10915941,10915942,10915943,10915944,10915945,10915946,10915947,10915948,10620653,10620801,10620802,10620803,10620804,10620805,10620806,10620807,10620808,10620809,10620810,10620811,10620812,10620813,10620814,10620815,10620816,10620817,10620818,10620819,10620820,10620821,10620822,10620823,10620824,10620825,10620826,10620827,10620828,10620829,10620830,10620831,10620832,10620833,10620834,10620835,10620836,10620837,10620838,10620839,10620840,10620841,10620842,10620843,10620844,10620845,10620846,10620847,10620848,10620849,10620850,10620864,10916479,10916557,10916558,10916559,10916560,10916561,10916562,10916563,10916564,10916599,10916600,10916601,10916602,10916603,10916604,10916605,10916606,10916607,10916707,10916708,10916709,10916728,10916750,10916751,10916752,10916753,10916754,10916755,10916756,10916762,10916769,10916770,10916771,10916772,10916773,10621263,10916774,10916775,10916776,10916777,10916778,10916779,10916780,10621278,10621279,10916795,10916799,10916800,10916801,10916802,10916813,10916814,10916815,10916816,10916817,10916818,10916819,10916820,10916821,10916822,10916823,10916824,10916825,10916826,10916827,10916828,10916860,10916861,10916862,10916863,10916864,10916865,10916866,10916867,10916868,10916869,10916870,10916912,10916913,10916914,10916956,10916957,10916958,10916959,10916960,10916961,10916962,10916963,10916964,10916965,10916966,10917172,10917173,10917174,10621689,10621690,10621691,10621692,10621693,10621694,10621695,10621696,10621697,10621698,10621699,10621700,10621745,10621746,10621747,10917347,10917348,10917352,10917354,10917357,10917358,10917359,10917370,10917371,10917372,10917403,10917404,10917405,10917406,10917407,10610972,10610973,10610974,10565141,10565143,10610994,10565149,10565156,10565180,10611035,10565202,10611057,10565210,10565224,10565231,10611097,10611115,10565318,10611318,10611319,10611328,10611348,10611366,10611368,10611588,10611589,10611606,10611611,10611612,10611613,10611614,10611649,10611659,10611670,10611752,10611801,10611815,10611825,10611840,10611954,10608964,10608977,10608981,10608983,10608990,10608992,10608998,10563148,10609000,10609007,10609010,10609021,10609024,10609025,10609026,10609027,10609030,10609031,10609040,10609050,10609056,10609057,10609064,10609071,10609076,10609077,10609080,10609083,10609100,10609102,10609103,10609106,10609118,10609119,10609120,10609121,10609122,10609123,10609124,10609125,10609126,10563308,10563309,10563324,10563342,10563356,10563385,10563386,10563387,10563388,10563389,10563390,10563391,10563392,10563521,10563522,10563523,10563524,10563525,10563526,10563527,10563528,10563529,10563606,10564061,10564062,10564474,10564475,10564476,10564477,10564478,10564479,10564480,10564481,10564566,10564639,10564771,10564887,10564893,10564900,10564919,10564926,10564964,10564988,10517329,10517330,10517331,10517332,10517398,10517399,10517400,10517401,10517402,10517403,10517441,10517466,10517552,10517553,10517554,10517562,10517612,10517619,10517699,10517771,10517849,10517998,10518149,10518764,10518886,10518910,10518912,10518943,10518944,10518946,10518947,10519002,10519079,10519081,10519095,10519097,10519098,10419305,10419326,10419589,10419590,10419684,10419716,10419723,10419728,10419729,10419740,10419742,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10470882,10470883,10470930,10470968,10471000,10471055,10471086,10471098,10471102,10471103,10471126,10471166,10471169,10471475,10471551,10469925,10469946,10469955,10470034,10470037,10470205,10470581,10470582,10470606,10470607,10470608,10470609,10470610,10470611,10470699,10470754,10470755,10470756,10470757,10470758,10470759,10470760,10470761,10470766,10470798,10470830) 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'