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(7075868,7076104,10198379,7076150,7076151,7068160,10943690,7068232,7068266,7068267,7068268,7068296,7068329,10198633,10198634,10198635,10198636,10198637,10198638,10198639,10198640,10198641,4970918,8569565,4971026,8569705,7068800,7068801,7068802,7068803,7068804,7068805,7065857,7065954,7074010,7074085,7074148,10199505,10199506,10199507,4968615,10437405,7066598,7066599,7066698,7066793,7066800,10197114,10197115,10197116,10197121,10197122,10197123,7074990,7067044,10197316,10197317,10197318,10197319,10197320,10197321,10197322,10197323,10197324,10197325,10197326,10197327,10197328,10197329,10197330,10197333,10197334,7075138,7075139,7075143,7075144,7075145,7067171,7075232,7067239,7075273,7075274,7067282,7067283,7067284,7075284,7067285,7075291,10197637,7075501,7067541,7067542,8068603,8068604,8068605,8068606,8068607,8068608,8068609,8068610,8068611,8068612,8068613,8068614,8068615,8068616,8068617,8068618,8068619,8068620,8068621,8068622,8068623,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068635,8068636,8068637,8068638,8068639,8068640,8068641,8068642,8068643,8068644,8068645,8068646,8068647,8068648,8068649,8068650,8068651,8068652,8068653,8068654,8068655,8068656,8068657,8068658,8068659,8068660,8068661,8068662,8068663,8068664,8068665,8068666,8068667,8068668,8068669,8068670,8068671,8068672,8068673,8068674,8068675,8068676,8068677,8068678,8068679,7067814,7067815,6000112,6000113,7072186,7072188,7072281,10931720,7064341,7064342,7064477,7064478,7064479,7072500,7072593,10932072,7072701,10195949,7072793,10932244,10932290,10932291,10932292,10932293,10932294,10932295,10932296,10932297,10932298,10932299,10932300,10932301,10932302,10932303,10932304,10932319,10932320,10932321,10932323,10932324,10932326,10932327,10932328,10932329,7072958,10196346,10932579,7073171,7073174,7073191,10932644,10932645,10932681,10932690,10932733,10932741,7065351,7065352,10932803,10932820,10932821,10932822,10932834,10932835,7073584,7073585,7073587,4967941,7073639,4968048,4968049,4968050,4968051,4968052,4968053,4968054,4968055,4968056,4968057,4968058,4968059,10942638,10194181,10194182,10194183,10194184,10194185,10194186,10194187,10194188,10194189,10194190,10194191,10194192,10194193,10194194,10194195,10194196,10194197,10194198,10194199,10194200,10194201,10194202,10194203,10194204,10194205,10194206,10194207,10194208,10194209,10194210,10194211,10194212,10194213,10194214,10194215,10194216,10194217,10194218,10194219,10194220,10194221,10194222,10194241,10194361,7071173,8861253,8861312,10943148,10194718,10194719,7071562,7071693,6000025,6000026,6000027,6000028,7071803,7069034,7069035,10944926,8072411,8072412,8072420,8072422,8072454,8072683,8072684,8072685,8072686,8072687,8072996,8072997,8072998,8072999,8073000,10193600,10942151,7070461,8860401,8860406,8860407,8860408,8860409,8860474,8860475,8860476,8073439,7070624,8860540,10942409,8860658,10942498,10617986,10617987,10623042,10623044,10623045,10618086,10623320,10623414,10619033,10619034,10619035,10619036,10619037,10619038,10619039,10619040,10619041,8070811,8070854,10619343,10619344,8071124,8071125,10619895,10619896,10619940,10619941,10617033,10617079,10617080,10617081,10617086,10617087,10617088,10617089,10617090,10617091,10622191,10617209,10189351,10189352,10189353,10617255,10189354,10189355,10189356,10189357,10189358,10189359,10617261,10189360,10927805,10617311,10617312,10617313,10617314,10617316,10622371,10622372,10622373,10622374,10622375,10622548,10189970,10189971,10189972,10189973,10189974,10189975,10189976,10189977,10189978,10189979,10189980,10189981,10189982,10189983,10189984,10189985,10189986,10189987,10189988,10189989,10189990,10189991,10189992,10189993,10189994,10189995,10189996,10189997,10925487,10920520,10920521,10620033,8569889,8569890,10615315,10920856,10920857,10920858,10920859,8570199,8570280,10920966,10920967,10920981,10620488,10921044,10921045,10921046,10921047,10921048,10921049,10921050,10921051,10921052,10921053,10615604,10926167,10926168,10926169,10926202,10926203,10930530,10930531,10921241,10921242,10921243,10921244,10921245,10921246,10921247,10926253,10921259,10921260,10921261,10926284,10615824,10615829,10921397,10930749,10930750,10930751,10930753,10930760,10930761,10930762,10615981,10615990,10930855,10616046,10921568,10930900,10930901,10921621,10621110,10621111,10621112,10621113,10621114,10621115,10921698,10921736,10188358,10621284,10621285,10621286,10621287,10921862,10921863,10188484,10621439,10621440,10621441,10621442,10621443,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621454,10621455,10621456,10621457,10621458,10621459,10621460,10621461,10621462,10621463,10621464,10621465,10616465,10621466,10621467,10621468,10621469,10616469,10621470,10621471,10616471,10616472,10621472,10621473,10616473,10621474,10621475,10621476,10616476,10621477,10616477,10621478,10621479,10621480,10621481,10621482,10621483,10621484,10616484,10621485,10616485,10621486,10621487,10621488,10616488,10621489,10621490,10616490,10621491,10616491,10621492,10616492,10616493,10616494,10616497,10616498,10616499,10616500,10616501,10616511,10616512,10616513,10616522,10616525,10616526,10616527,10616528,10616529,10616530,10616533,10616534,10616546,10621716,10922259,10922260,10922261,10922285,10922286,10922287,10922288,10565335,10565336,10565337,10559392,10559471,10559472,10559473,10559474,10559475,10559486,10559492,10559493,10559494,10559495,10559496,10559497,10614357,10614403,10614404,10614405,10565608,10565609,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,8864411,10614572,8864457,10614634,10614636,10562872,10562879,10614730,10562910,10562911,10562912,10562913,10562914,10562915,10614778,10562933,10562934,10562935,10562936,10562937,10562938,10562939,10562940,10562941,10562942,10562943,10562944,10614799,10614800,10614849,10614857,10614862,8861866,10612260,10557639,10612513,10612586,10612677,10612683,10612713,10612908,8862840,8862845,8862876,10558322,10558324,10558325,10558326,10558327,10558328,10558329,10558330,10558331,10558332,10558333,10558334,10558335,10558336,10558337,10558338,10558339,10558340,10558341,10558342,10558343,10558344,10558345,10558346,10558347,10558348,10558349,10558350,10558351,10558352,10558353,10558354,10558355,10558356,10558357,10558358,10613210,10558366,10558367,10558368,10558369,10558370,10558371,10558372,8863094,10558400,10558401,10558402,10558403,10558404,10558405,10558406,10558407,10558408,10558415,10558416,10558417,10558418,8863135,10558419,10558420,10558421,10558422,10558423,10558424,10558425,10558426,10558427,10558428,10558429,10558430,10558431,10558432,10558433,10558434,10558435,10613384,10613386,10558612,10558613,10564634,10564635,10613488,10564655,8863374,10613551,10613569,10613613,10564774,10564775,10613665,10613669,10613671,10613674,10564826,10564827,8863620,8863621,8863622,8863623,8863624,8863704,10513120,4974182,4974449,4974452,10513810,10513811,10513812,10513813,10513953,10516059,10516060,10518144,10512577,2809400,2809401,10512789,10512790,10512791,10512802,10512822,10512823,10512824,10512825,10512826,10512827,10512828,10512829,10518996,10518997,10518998,10518999,10419272,10419274,10419275,10419276,10419278,10419279,10419280,10419281,10419282,10419284,10419293,10419294,10419299,10418316,10418330,10418331,10419339,10419340,10419341,10419370,10417390,10417394,10417396,10417398,10417402,10417406,10417410,10417413,10417415,10417417,10417420,10417422,4973416,10419539,10419540,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10416553,10419555,10419557,10416657,10419686,10419689,4973648,4973649,4973650,4973651,4973653,4973654,4973655,4973656,4973657,4973658,4973659,4973660,4973663,10417743,10419828,10419829,10419830,10419831,10418897,10416992,10417011,10420064,10420109,10418143,10417158,10417159,4974151,4974152,4971166,10466955,10467084,10467109,10467116,10467117,10467118,10467151,10467153,10467154,10467157,10469163,10467428,10471490,10471493,10471494,10469531,10469590,10469605,10467607,4971950,4971951,4971952,10469736,10469737,10465748,10465749,10465750,10465751,10465752,10465791,10465803,10465804,10465812,10465813,10469813,10469814,10469815,10469816,4972232,4972233,4972234,4972235,4972236,4972237,4972238,4972239,4972240,4972241,4972242,4972243,4972244,4972245,4972246,4972247,4972248,4972249,4972250,4972251,4972252,4972253,4972254,10469984,10469985,10467987,10468003,10468047,10470079,10468085,4972441,10466326,10466332,10466333,10466346,10466353,10466434,10466435,10466441,10470485,10466501,10466502,10466503,10466504,10470667,10628216,10628360,10628364,10628381,10628741,10629519,10627085,10627222,10627299,10627423,10627907,10627908,10627909,10627925,10627926,10626471) 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'