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(8620778,7076143,8574360,8574394,10458873,8631076,8631077,3228901,3228902,11041171,11041172,11041173,11041174,11041175,11041176,11041177,11041178,11041179,11041180,11041181,11041182,11041183,11041184,11041185,11041186,11041187,11041188,11041189,11041191,11041192,11041193,11041194,11041195,11041196,11041197,9215283,9215284,10940412,7068749,10963468,7068798,3229269,7065978,7066225,10846997,10846998,10846999,10847000,10847001,10847002,10847003,10847004,7074267,7074277,7074278,7074279,7074280,7074281,7074282,7074283,7074284,7074285,7074286,7074287,7074289,10951241,10863028,10977436,10977437,10977438,8573255,7075135,7075136,10961935,10961936,10961937,10961938,10961939,10961940,10961944,10961949,10961954,10961960,8630259,7067762,10447664,10447665,10447666,10998505,8617853,7201404,8628370,3899240,8618618,10932228,10960474,8628490,7202131,7202133,7202134,7202135,7202170,8066190,7073145,7073548,10844416,10844417,8629313,8629314,8629315,8629316,10844465,10844466,10844467,3927210,3927211,3927212,3927213,3927214,3927215,3927216,3927217,3927218,3927219,3927220,3927221,3927222,3927223,3927224,3927225,3927337,10942760,10102333,10102334,10102378,10102391,8558316,7071446,10972182,10972183,10972184,10972185,7071586,10842376,7068856,7068862,8907955,7068937,8908005,8624911,10856060,11035870,11036009,11036010,11036011,11036012,10841331,10841352,10864975,10864976,10958379,3927201,3927202,3927203,3927204,3927205,3927206,3927207,3927208,3927209,10853124,11006530,11006531,11006532,11006533,11006534,11006535,11006536,11006537,11006538,11006539,11006540,11006541,11006542,11006543,11006544,11006545,11006546,11006547,11006548,11006549,7156443,10928603,10928667,10928668,10928669,10928670,11045742,10853506,10853507,11006917,11006918,11006919,11006920,11006921,8554266,8613425,8554556,8554557,8613612,8613651,8613679,11046607,3234364,3234365,3924387,10854349,10838918,11046869,11046870,11046871,3234660,3234738,7197815,8907748,8907791,8907797,8907822,8907844,8907845,8907855,8634463,8634878,10922950,10922951,10922952,10922953,8635023,8635024,8635025,8635030,8635031,8635032,8635033,8635034,10622718,10617957,10951511,9216589,10977620,10977621,10977622,10977895,10977896,10977897,10977898,10977905,11043014,8632989,8632990,8632991,8632992,8632993,8632994,8633057,8633087,8633088,3581931,3581932,10978269,10978270,10978271,10978272,10978273,10978274,10978275,10978276,10978277,10978392,8633389,10952434,10952435,10952436,10952512,9217575,10978646,10978647,10978648,10978649,10621138,10978791,8633853,8633854,8633855,8633856,8633857,8633858,8633859,3231703,10426705,10922030,10922031,10426750,10616559,8611309,8611310,3232168,7059516,8853324,8853361,9213552,8853395,3654877,10614371,9214007,9214008,9214009,9214011,9206083,9206084,9214258,10611969,10612030,10612031,10612032,10612033,10612034,10612061,7057927,7057928,9211814,10557663,10557664,9195899,10557870,10557871,10557872,10557873,10557874,10120357,10120368,10120369,10120370,10120371,6676389,10120380,6676397,9914413,9196229,9196230,9196231,9196232,10612954,10610096,10610279,10613305,10613359,10613363,10610374,10613622,3654180,10117621,8592578,10517271,10117727,10117728,9169700,10118095,9177954,9177955,8849887,7015826,7015827,10513988,9186182,9186183,7056404,9178265,9178266,9178267,9178268,9178269,9178270,9178271,9178272,9178273,9178274,7056452,7056453,9178314,9178315,9178371,9178375,9178464,9178465,9178466,9178836,9913083,7057178,9171020,9171021,9171022,9171025,9171026,7057329,10418267,10418268,9176434,10116797,10466955,10463030,10467151,10463400,10463433,10467441,10467456,10463657,10463658,10465691,10465692,4971978,4971979,10465784,9191219,9191220,10463800,10463801,10463802,10463803,9207241,9207242,9207243,9207244,9207245,10465828,10123487,10465886,10465887,10463905,9183387,9183388,9183390,9191493,10468147,10468148,10466220,8917492,10466432,10466433,10466434,10466435,10462517,10462518,10462519,9175974,9208010,9168025,9168027,10462607,10462608,976074,10462726,10464803,10464804,10628109,10628110,10628111,10628112,10628113,10628114,10628115,10893707,10888894,10174909,10909938,10909939,10909969,10910024,10885212,10885213,10156287,10910320,10887545,10627285,10627287,10883358,10883359,10171741,10166965,10891038,10896478,10896530,10167628,10167695,10167696,10167697,10162822,10162823,10162824,10162825,10162826,10162827,10162828,10167846,10167847,10167848,10167849,10167850,10167851,10167852,10167853,10167854,10167855,10167856,10167857,10896873,10896941,10896950,10168022,10168023,10168024,10897135,10168179,10168180,10168181,10168207,10168208,10168209,10168210,10897238,10631740,10643490,10643506,10649535,10649584,10602393,10598927,10598928,10598929,10581105,10653439,10590533,10590534,10590535,10590536,10590538,10647638,10648028,10604033,10591389,10591390,10591391,10591449,10591450,10591451,10604394,10604395,10579551,10579552,10579553,10579554,10579555,10579578,10579579,10579580,10579581,10579582,10579583,10579584,10579585,10579586,10579587,10579588,10579589,10579590,10579591,10579592,10579593,10579594,10579595,10579596,10579597,10579598,10579599,10579600,10579601,10579602,10579603,10579604,10579605,10579606,10579607,10579608,10579609,10579610,10579611,10579612,10579613,10579614,10579615,10579616,10579617,10579618,10579619,10579620,10579621,10579622,10579623,10579624,10579625,10579626,10579627,10579628,10579629,10579630,10579631,10579632,10579633,10579634,10579635,10579636,10579637,10579638,10579639,10579640,10579641,10579642,10579643,10579644,10579645,10579646,10579647,10579648,10579649,10579650,10579651,10579652,10579653,10579654,10579655,10579656,10579657,10579658,10579659,10579660,10579661,10579662,10579663,10579664,10579665,10579666,10579667,10579668,10579669,10579670,10579671,10579672,10579673,10579674,10579675,10579676,10579677,10579678,10579679,10579680,10579681,10579682,10579683,10579684,10579685,10579686,10579687,10579688,10579689,10579690,10579691,10579692,10579693,10579694,10579695,10579696,10579697,10579698,10579699,10579700,10579701,10579702,10579703,10579704,10579705,10579706,10579707,10579708,10579709,10579710,10579711,10579712,10579713,10579714,10579715,10579716,10579717,10579718,10579719,10579720,10579721,10579722,10600904,10527332,10527333,10549689,10523700,10523701,10523702,10523703,10523705,10544024,10548345,10522514,10522515,10522516,10522517,10522518,10522519,10522520,10522521,10522522,10522523,10522524,10522525,10522526,10522527,10522528,10522529,10522530,10522755,10522756,10522906,10522907,10522908,10542908,10542958,10424716,10424717,10505821,10409338,8562359,10483163,10483164,10479242,10479276,10479297,10483365,10483366,10483367,10479446,10479451,10479458,10479459,10479460,10479467,10479480,10479483,10479484,10479485,10479486,10479487,10479532,10479563,10479567,10479576,10479581,10410086,10494991,10714837,10409063,10411203) 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'