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(8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,8630736,8630866,8630867,8630868,8630971,8630972,8631016,8631017,8631018,8631019,8631020,8631021,8631022,8631023,8631024,8631025,8631026,8631135,8621550,8631384,8631385,8631386,8631387,8631388,8631389,8631390,8631391,8631392,8631393,8631394,8631395,8631396,8631397,8631398,10871041,8631399,8631400,8631401,8631402,8631403,8631404,8631405,8631406,8631407,8631408,8631409,8631410,8631411,8631412,8631413,8631414,8631415,8631416,8631417,8631418,8631419,8631420,8631421,8631422,8631423,8631424,8631425,8631426,8631427,8631428,8631429,8631430,8631431,8631432,8631433,8631434,10874077,8631435,8631436,10874079,8631437,8631438,10874080,8631439,10874081,10874082,8631440,8631441,8631442,8631443,8631444,8631445,8631446,8631447,8631448,8631449,8631450,8631451,8631452,8631453,8631518,8631519,11041605,11041660,11041661,11041662,11041671,11041672,8631759,8631760,8631762,8622208,3230041,3230057,8632432,8632463,8632464,8632465,8632466,8632467,8632468,8632469,8632470,3230243,8632540,8629581,8629582,8629583,8629584,8629617,8629618,8629619,8629620,8629621,8629622,8629714,8629746,8629747,8629748,8629757,8629758,8629759,8629760,8629765,8629861,8629928,8629939,8630241,8630242,10962436,8630484,8630485,8630486,10939465,8630487,8630488,8630489,8630490,8627694,8627695,8627696,8627697,8627728,7201366,8627794,8627803,8627804,10842911,8627805,8627806,8627807,8627826,8627942,8627943,8627944,8627945,8627946,8627947,8627948,8627949,8627950,8627951,8627952,8628211,7201844,8628251,8628305,8628306,8628307,8628308,8628309,8628310,8628311,8628312,8628313,8628314,8628316,8628317,8628318,8628319,8628320,8628321,8628322,8628323,7201976,10986516,3899509,3899510,8628746,8628747,8628748,8628749,8628751,7202364,7202365,8628815,8628816,8628817,9794587,8629242,8629317,8629318,8629321,8629388,8629389,8629390,8629434,8629435,8629436,10868088,8629504,8629505,8629506,8629507,8629508,8629509,8629510,8629511,8629512,8629513,8629527,8629528,8629578,8629579,8629580,8626632,8626634,8626635,8626639,8626645,8626648,8626660,8626663,10997842,10997843,10865452,8626832,8627078,8627092,7071537,10842356,10943256,11037510,11037511,11037514,3238282,8624590,8624591,8624679,8625074,8625075,8625076,8625244,8625442,8625525,8625526,10856316,3236593,3236644,8625877,8625878,8625879,3236711,8625968,8625969,8625970,8625971,8625972,8625973,8626038,3236848,8626113,8626114,8626124,8626125,8626126,8626127,8626128,8626129,8626130,8626131,8626132,8626133,8626176,8626188,8626254,3237077,3237097,3237098,3237103,3237111,3237112,3237114,8626393,8626396,8626397,8626398,8612911,8612912,8612913,11046089,8555237,8624437,8624557,8624573,8634652,8634653,8634654,8634655,8634656,8634657,8634658,8634659,8634660,8634661,8634662,8634663,8634664,8634665,8634666,8634667,8634668,8634669,8541550,8634687,8905221,10622217,10622224,10622225,8634874,8634875,8634876,8634877,8634878,8634879,8634880,8634936,8634937,8634938,11045212,11045213,11045214,8632734,8632735,8632737,8632739,8632740,8632741,8632742,8632743,8632744,8632745,8632746,8632747,8632748,8632749,8632750,8632751,8632752,8632753,8632754,8632755,8632756,8632757,8632758,8632759,8632760,8632761,8632762,8632763,8632764,8632766,8632767,8632768,8632769,8632770,8632771,8632772,8632773,8632774,8632775,8632776,8632777,8632778,8632779,8632780,8632781,8632782,8632783,8632784,8632785,8632786,8632787,8632788,8632789,8632790,8632791,8632792,8632793,8632794,8632795,8632796,8632797,8632798,10620183,8632852,3230719,3230733,10848177,3230844,8633098,8633128,8633136,8633254,8633272,8633273,8633274,8633276,8633277,10848387,8633280,8633281,8633286,8633287,8633288,8633290,8633291,8633295,8633296,8633400,8633412,8633413,10616059,8633988,8633989,8634118,8634120,8634155,8634160,8634163,8634165,8634166,8634170,8634320,8634345,8634346,8634347,8634407,8634408,8634409,8634413,8634415,8634417,8634418,8634419,8634422,8634423,8634424,8634425,8634426,8634427,8634429,8634431,8634433,8634434,8634436,10616898,8541400,8541401,8541402,8853590,8853591,8853592,8853604,8853605,10122089,9214288,9211877,9211878,8566539,10610666,8853031,8853032,8849739,10513952,10513961,10513994,10513997,10513998,10513999,10514028,10514031,10514032,10514033,6672758,6672768,6672769,6672770,6672772,6672773,6672774,6672775,6672776,6672829,6672830,6672831,6672832,6672833,6672862,6672863,6672864,6672865,6672866,6672867,6672868,6672869,6672870,6672871,6672872,6672873,6672874,6672875,6672876,6672877,6672881,6672882,6672883,6672884,6672885,6672886,6672887,6672888,9190688,6666687,9190692,6666755,9199074,6473427,6473428,8917091,9167682,8550874,6474125,6474302,6474305,6474306,6474307,6474308,9168025,9208030,10883559,10883560,10883561,10883562,10883563,10883568,10883569,10883570,10883571,10883572,10883585,10883586,10883587,10883588,10883589,10883590,10883591,10883592,10883593,10883594,10883595,10883596,10883597,10883598,10893989,10882916,10883432,10626299,10626300,10626301,10631882,10568558,10608610,10583764,10583766,10583767,10583768,10583770,10583771,10583774,10583775,10583776,10583777,10583779,10583780,10583781,10583787,10583788,10583793,10583800,10583801,10583802,10583806,10583807,10583809,10583810,10583811,10583937,10583941,10584248,10584249,10584254,10584255,10584256,10584257,10584261,10584262,10584263,10584522,10584523,10584524,10584525,10584526,10584527,10584536,10584592,10567320,10521150,10520811,10520815,10520817,10540883,10520901,10520904,10520905,10520909,10539015,10422588,10424655,10424656,10424657,10420708,10507671,10411386) 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'