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(10861287,10861288,10861289,10861290,10861291,10861292,10861293,10861294,10861295,10861296,10861297,10861298,10861299,10861300,10861301,10861302,10861303,10861304,10861305,10861306,10861307,10861308,10861309,10861310,10861311,10861312,10861313,10861314,10861315,10861316,10861317,10861318,10861319,10861320,10861321,10861322,10861323,10861324,10861325,10861326,10861327,10861328,10861329,10861330,10861331,10861332,10861333,10861334,10861335,10861336,10861337,10861338,10861339,10861340,10861341,10861342,10861343,10861344,10861345,3228996,3229137,3229138,3229139,3229140,3229142,3229143,3229145,3229146,3229147,3229148,3229149,3229150,3229151,3229152,7066173,10862514,10862515,10862516,10862517,10862518,10862519,10862520,10862521,10862522,10862523,10862524,10862525,10862526,10862527,10862528,10862529,10862530,10862531,10862532,10862533,10862534,10862535,10862536,10862537,10862538,10862539,10862540,10862541,10862542,10863085,10863086,10863087,10858223,8595172,10859570,7200283,7200633,7200634,10858193,10858194,10858195,10858196,10858197,10858198,10858199,10858200,10858201,10858202,10858203,10858204,10858205,10858206,10858207,10858208,10858209,10858210,7201168,10858211,7201169,10858212,10858213,10858214,10858215,10858216,10858217,10858218,10858219,10858220,10858221,10858222,3235779,7199391,7199392,7199393,7199394,7199395,7199396,7199397,7199398,7199399,7199400,7199401,7199402,7199403,7199404,7199405,7199406,7199407,7199408,7199409,7199410,7199411,7199412,7199413,7199414,7199415,7199416,7199417,7199509,10618300,10618301,8906780,7198048,10852367,10852368,8905366,3232905,10850240,10850241,10612054,10612055,10612056,10612057,10609328,7017377,7017378,7017379,7017380,7017383,7017384,7017389,7017390,7017391,7017392,7017395,7017396,7017397,7017398,7017401,7017402,7017403,7017404,7017405,7017406,10613353,10613354,9911827,10118252,10118253,10118254,10118416,10118417,10118566,10118567,9912723,10415255,10415256,10415257,10415258,10415259,10415260,10415261,10415262,10415263,10415264,10415265,10415266,10415267,10415268,10415269,10415270,10415271,10415272,10415273,10415274,10415275,10415276,10415277,10415278,10415279,10415280,10415281,10415282,10415283,10415284,10415285,10415286,10415287,10415288,10415289,10415290,10415291,10415292,10415293,10415294,10415295,10415296,10415297,10415298,10415299,9168378,10415300,10415301,10415302,10415303,10415304,10415305,10415306,10415307,10415308,10415309,10415310,7014230,7014231,7014232,7014233,7014234,7014235,7014236,7014237,7014238,7014239,7014240,7014241,7014242,7014243,7014244,7014245,7014246,7014247,7014248,7014249,7014250,7014251,7014252,7014253,7014254,7014255,7014256,7014257,7014258,7014259,7014260,7014261,7014262,7014263,7014264,7014265,7014266,7014267,7014268,7014269,7014270,7014271,7014272,7014273,7014274,7014275,7014276,7014277,7014278,7014279,7014280,7014281,7014282,7014283,7014284,7014285,7014286,7014287,7014288,7014289,7014290,7014291,7014292,7014293,7014294,7014295,7014296,7014297,7014298,7014299,7014300,7014301,7014302,7014303,7014304,7014305,7014306,7014307,7014308,7014309,7014310,7014311,7014312,7014313,7014314,7014315,7014316,7014317,7014318,7014319,7014320,7014321,7014322,7014323,7014324,7014325,7014326,7014327,7014328,7014329,7014330,7014331,7014332,7014333,7014334,7014335,7014336,7014337,7014338,7014339,7014340,7014341,7014342,7014343,7014344,7014345,7014346,7014347,7014348,7014349,7014350,7014351,7014352,7014353,7014354,7014355,7014356,7014357,7014358,7014359,7014360,7014361,7014362,7014363,7014364,7014365,7014366,7014367,7014368,7014369,10416638,10416639,9168764,9168875,6673338,10416150,10416151,10416152,10416153,10416154,10416155,10416156,10416157,10416158,10416159,10416160,10416161,10416162,10416163,10416164,10416165,10416166,10416167,10416168,10416169,10416170,10416171,10416172,10416173,10416174,10416175,10416176,10416177,10416178,10416179,10416180,10416181,10468843,10888580,10880255,10885733,10162052,10882309,10602138,10647478,10507893,10407601,10407602,10414008,10412764,10412765,10412766,10412767,10412768,10412769,10412770,10412771,10412772,10412773,10412774,10412775,10412776,10412777,10412778,10412779,10412780,10412781,10412782,10412783,10412784,10412785,10412786,10412787,10412788,10412789,10412790,10412791,10412792,10412793) 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'