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(8561977,8620900,8838682,8621077,8838743,8621153,3228880,8838959,3228890,4970700,3228903,3228904,10976287,7068641,7068666,10950302,7068727,10849014,10849015,7068728,10849016,10849017,7068750,11041460,11041461,11041462,7068807,7068812,10940446,10940447,7068858,11041668,11041669,10849313,10849314,10950709,11041778,11041854,11041920,11041926,8622119,11041973,8622127,11041991,11041992,11041998,8622154,11042013,11042064,11042075,11042080,11042090,11042091,11042097,11042108,11042109,11042153,3230034,10977304,10847493,10977446,7066888,10847680,8837626,7075332,7075388,7075854,9214516,11040587,10447786,11040598,4430593,10103435,10960048,7072399,10973171,10973174,10973175,10973176,10973179,10973182,10973183,10973188,10843316,8911640,8911647,10999277,8911670,10986386,8836224,3899241,7072801,7072899,7202167,7202218,7073112,8628818,8628819,8628820,8628821,8628822,8628823,10104376,11039006,11039021,10104541,7202737,11000372,8560705,7070943,7071021,7071032,7071043,11010769,3927562,10102311,7071393,7200689,8910534,8910537,8910538,10959213,10959214,10959215,10959232,4430390,7201037,8835329,10100098,3655568,3655578,8908184,3235664,7198703,3656249,7069693,3236154,3656451,8557210,8616108,10101593,7070660,7070670,8909799,8834279,7070917,7070922,11032712,11045808,8613205,8613217,10968186,11007213,10994347,8613503,8613522,10994505,10994513,10968549,10838683,3924365,10838733,10838734,10838735,11046720,10839049,8555580,8555711,10427373,10927596,10927597,10927613,3232499,10927641,10927754,10927756,10927765,10927773,10927779,10927786,10927802,10837045,10993427,10993428,10928320,8612767,10847705,10847750,3230433,10847790,10847800,10847807,10847847,10951781,11042966,11042989,11043018,11043023,11043071,10620426,11043087,11043119,11043132,8576743,10848477,10926359,11043524,10926382,11043534,10926387,11043535,10926408,10926411,10926415,11043564,11043571,10926436,10926463,10926467,11043615,11043628,11043629,10926488,10926494,11043658,11043661,10926517,10921544,11043699,11043710,10926562,10926569,10926578,8610896,10926645,10926649,10926676,10426505,10926684,11043849,10921713,10921714,8540726,8540727,8540728,8540729,11043908,11043925,11043973,11043981,11043983,11043994,11044009,11044045,11044156,11044178,11044179,11044181,11044189,11044203,11044246,11044290,11044291,3232027,11044298,3232055,11044337,8634301,11044343,3232091,11044370,11044397,11018421,11044444,11044460,10927318,11044469,11044481,10927360,10927380,10927384,10927394,11044549,10927404,11044582,9205356,7059588,7059647,7059650,7059664,7059666,7059667,7059668,7059674,9197652,9189669,9189670,9213851,6666103,3655468,3655490,9187456,9211530,10119747,9211813,9187830,10120067,10609540,10609541,8851721,7058092,7058152,6676228,6676231,7058193,6676239,6676240,6676241,6676242,6676246,6676247,6676252,6676253,6676254,6676255,6676256,6676257,6676259,6676260,6676262,6676268,9914327,9914328,9914329,9914330,9914331,9914332,9914333,9914334,9914335,9914336,9914337,9914338,9914339,9914340,9172148,10120381,10561563,10558683,3654115,3654168,10515163,7015065,9911651,10125821,9177727,10126156,9169987,9169991,10511828,10511837,9210190,9210206,9210210,9210227,9912435,9178228,9912436,9210253,9186300,4975174,9210329,9210366,9210453,10118681,9178565,9210572,9210607,9210609,9210663,9186693,9210702,10514644,9210841,10514827,9171110,9211124,9913369,9211162,9211188,9163189,9211226,9208365,9910572,9208404,4973282,9208491,9208650,8918308,9208661,10428179,4973720,4973753,4973768,9198314,10471247,8549956,6473497,9183369,9183391,6667490,6679741,6679743,9191706,9207998,9192101,9208175,9208281,10883639,10888678,10903693,10903694,10893756,10628267,10903801,10159949,10894136,10894143,10170624,10885030,10900032,10890190,10910360,10910361,10910362,10882504,10882505,10882506,10183571,10163968,10883134,10903141,10888238,10883251,10888272,10893340,10176677,10176678,10171882,10910904,10911226,10896313,10187574,10631251,10177890,10631500,10887073,10907258,10589246,10589247,10586714,10586715,10586751,10586755,10586781,10586897,10586909,10587008,10587009,10587063,10587093,10587099,10587106,10587368,10587369,10587407,10587468,10581500,10587502,10587503,10587510,10581578,10587609,10584640,10584641,10587679,10587810,10587859,10587881,10587944,10587961,10587962,10585033,10588049,10588075,10588078,10585161,10588163,10654235,10654239,10588199,10654280,10654284,10585269,10588273,10588288,10588311,10585330,10585344,10585360,10585362,10588386,10585393,10588393,10585409,10585422,10588437,10585477,10585478,10585479,10585480,10585481,10654550,10654557,10588501,10588569,10588613,10588617,10588620,10588624,10525150,10525151,10525600,10525601,10525602,10527924,10522406,10522407,10522408,10522409,10522412,10522413,10522414,10522415,10522416,10522417,10522418,10522419,10522420,10536666,10536668,10523008,10523009,10523010,10523011,10523012,10523013,10523014,10523015,10523016,10523017,10523018,10523019,10523020,10523021,10523022,10523023,10523024,10507810,10506965,10495916,10496161,10479200,10496211,10496264,10496267,10496440,10714787,10495260,10495275,10495291,10495299,10495305,10495334,10495339,10495347,10495350,10495871) 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'