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(10939561,10939983,4970718,10940098,10940099,10940100,10940101,10940102,10940103,10940104,10940105,10940106,10940107,10940108,10940109,10940110,10940111,10940112,10940113,10940114,10940115,4970750,10940150,10940151,10940152,10940153,10940154,10940155,10940156,10940157,10940158,10940159,10940160,10940161,10940162,10940163,10940164,10940165,10940166,10940167,10940168,10940169,10940170,10940171,10940172,10940173,10940174,10940175,10940176,10940177,10940178,10940179,10940180,10940181,10940182,10940183,10940184,10940185,10940186,10940187,10940188,10940189,10940190,10940191,10940192,10940193,10940194,10940195,10940196,10940197,10940198,10940199,10940200,4970859,4970916,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970939,4970976,10940399,10940490,10940491,10940514,8066887,8066892,8066893,8066905,8066906,8066907,8066911,8066916,8066938,8067334,8067335,4968602,4968603,8067360,8067368,8067390,8067504,8067536,8067537,8067538,8067539,8067545,8067598,8067599,8067600,8067601,8067602,8067639,8067640,8067668,8067669,8067670,8067691,8067696,8067712,8067739,4969285,4969286,4969287,4969288,10938794,10939410,10939424,10939444,8065133,8065366,4967032,8065903,8065904,8065981,8066007,8066012,8066015,8066083,8066165,8066166,8066218,8066255,8066256,8066268,8066269,8066270,8066286,8066287,8066288,8066310,8066311,8066318,8066345,8066346,8066380,8066400,8066442,8066443,8066444,8066445,8066446,8066447,8066448,8066449,8066450,8066459,8066460,8066461,8066462,8066463,8066464,8066469,8066470,8066471,8066473,8066474,8066477,8066482,8066483,8066489,8066491,8066498,8066499,8066500,8066501,8066507,8066520,8066521,8066522,8066523,8066524,8066525,8066526,8066527,8066528,8066557,8066558,8066565,8066575,8066577,8066593,8066594,8066595,8066630,8066637,8066638,8066661,8066662,8066684,8066692,8066694,8066695,8066696,8066697,8066698,8066713,8066714,8066719,8066720,8066758,8066774,8066775,8066776,8066777,8066778,8066789,8066790,8066800,8066803,8066804,8066820,8066838,8066850,8066851,8066852,8066853,8066866,8066867,8066868,8066869,8064487,3655506,3655507,3655646,3655647,3655648,3655683,3655684,3655685,3655686,3655687,3655688,3655769,3655770,3655771,3655796,3655801,3655969,3655984,3655988,3656102,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,3656209,8072375,8072376,3656212,8072377,8072378,8072379,8072380,8072381,8072382,3656218,3656219,8072383,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,8072397,8072398,8072399,8072400,8072401,8072402,8072403,8072404,8072405,8072406,8072407,8072408,8072409,8072410,8072411,8072412,8072413,8072414,8072415,8072416,8072417,8072418,8072419,8072420,8072421,8072422,8072423,8072424,8072425,8072426,8072427,8072429,8072430,8072431,8072432,8072433,3656270,8072434,8072435,8072436,8072437,8072438,8072439,8072440,8072441,8072442,8072443,8072444,8072445,8072446,8072447,8072448,8072449,8072450,8072451,8072452,8072453,8072454,8072455,8072456,8072457,8072458,8072459,8072460,8072461,8072462,8072470,8072471,3656307,3656308,3656315,3656316,3656317,3656331,3656480,8072668,8072669,8072670,8072671,8072672,3656592,3656642,3656653,3656654,3656655,3656656,3656662,3656707,8073022,8073023,8073076,8073083,8073440,10918485,10918504,10918505,10918561,10918562,10918563,10918651,10918652,10918654,10918655,10918697,10918698,10918763,10623317,10918831,10918832,10918833,10918834,10918835,10623411,10919201,10919202,10919203,10919204,10919205,10919206,10919233,10919556,10919557,10919558,10624056,10624057,10919840,10919841,10919842,10919973,10919974,10919975,10919976,10919977,10919978,10919979,10920069,10920070,10920071,10920072,10920073,10920074,10920075,10920076,10920077,10624802,10621985,10621989,10622011,10622014,10622055,10622060,10622071,10622115,10917727,10917728,10917729,10917813,10917814,10917815,10917816,10917817,10917818,10917819,10917820,10917821,10917822,10917823,10622344,10917999,10918000,10918014,10918015,10918016,10918017,10622543,10918118,10918282,10918283,10918318,10918319,10918320,10918321,10918322,10918323,10915606,10915607,10915608,10915609,10915610,10915611,10915612,10915613,10915614,10915615,10915616,10915617,10915618,10915619,10620183,10620186,10620187,10620188,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620207,10620208,10620307,10620351,10620381,10620382,10620384,10620385,10620386,10620387,10620414,10620491,10620653,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620661,10620662,10620663,10620664,10620665,10620666,10620667,10620668,10620669,10620670,10621109,10621273,10621274,10621294,10621310,10621323,10621341,10621345,10621346,10621347,10621348,10621352,10621353,10621354,10621355,10621360,10621361,10621375,10621381,10621382,10621400,10621401,10621402,10621403,10621404,10621405,10621422,10621426,10621428,10621429,10621435,10621436,10621445,10621446,10621447,10621453,10621456,10621461,10621465,10621529,10917051,10917053,10917054,10917055,10621564,10621572,10621595,10621601,10621615,10621620,10621631,10621632,10621637,10621639,10621641,10621649,10621655,10621668,10621672,10621675,10621717,10621724,10621732,10917464,10917465,10917466,10917467,10621958,10610980,10610991,10611036,10611040,10611041,10611042,10611043,10611044,10611045,10611046,10611047,10611062,10611063,10611073,10611074,10611077,10611078,10611127,10611135,10611141,10611180,10611182,10611183,10611245,10565445,10565446,10565447,10565448,10565449,10611372,10611563,10611641,10611679,10611747,10611807,10611863,10611865,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611936,10609141,10563370,10563371,10563372,10563373,10563377,10563378,10563379,10563380,10563381,10609339,10609340,10609341,10609342,10609764,10609765,10609834,10609879,10609919,10609920,10609921,10609984,10610261,10610262,10610263,10610264,10610265,10610298,10610310,10610311,10610312,10610372,10610390,10610486,10610488,10564653,10564654,10564713,10564714,10564766,10564767,10564768,10564769,10564825,10610811,10517259,10517260,10555261,10555327,10555328,10555329,10555330,10555331,10555332,10555333,10555334,10555335,10555336,10555337,10555338,10555339,10555340,10555341,10555342,10555343,10517634,10517635,10517677,10517678,10517679,10555799,10555800,10555801,10555802,10555803,10555804,10555805,10555806,10555807,10555823,10555824,10555947,10555962,10555963,10518077,10518078,10518079,10518080,10518081,10518082,10556423,10556424,10556425,10556426,10556427,10556428,10556429,10556430,10556431,10556432,10556433,10556434,10556435,10556436,10556437,10556438,10556439,10556440,10556441,10556442,10556443,10556444,10556445,10556446,10556447,10556448,10556449,10556450,10556451,10556452,10556453,10556454,10556455,10556456,10556457,10556458,10556459,10556460,10556461,10556462,10556463,10556464,10556465,10556466,10556467,10556468,10556469,10556470,10556471,10556472,10556473,10556474,10556475,10556476,10556477,10556478,10556479,10556480,10556481,10556482,10556483,10556484,10556485,10556486,10556487,10556488,10556489,10556490,10556491,10556492,10556493,10556494,10556495,10556496,10556497,10556498,10556499,10556500,10556501,10556502,10556991,10556992,10556993,10556994,10556995,10556996,10556997,10556998,10556999,10557000,10557001,10557002,10557003,10557004,10557005,10557006,10557007,10557008,10557009,10557010,10557011,10557012,10557013,10557014,10557015,10557016,10557017,10557020,10519052,10519089,10419242,10419271,10415333,10415339,10415340,10415373,10415374,10419385,10415515,10415536,10419543,10419556,10419562,10419563,10415611,10415614,10415615,10415621,10415622,10415624,10415625,10415646,10415650,10415651,10415674,10419693,10419694,10419695,10419696,10419697,10419698,10419699,10419700,10419701,10419702,10415729,10415783,10419796,10419797,10419823,10419824,10419825,10419826,10419827,10415845,10415846,10415864,10415865,10419882,10419884,10415898,10415923,10415945,10415955,10415972,10415991,10416043,10420102,10420108,10420142,10420171,10420172,10471083,10463311,10463312,10463313,10463314,10463315,10463316,10463317,10471482,10471483,10463695,10469911,10469920,8563393,8563394,8563467,10470212,10470213,10470233,10470271,10470272,10470273,10470274,10470275,10470276,10470277,10470278,10470279,10470280,10470281,10470282,10470283,10470284,10470285,10470286,10470287,10470288,10470289,10470290,10470291,10470292,10470293,10470294,10470295,10470296,10470297,10470298,10470299,10470300,10470301,10470302,10470303,10470304,10470305,10470306,10470307,10470308,10470309,10470310,10470311,10470378,10470379,10470482,10470487,10470666) 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'