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(10862015,10862017,10862019,10862022,10862025,10862027,10862028,10862030,10862034,10862035,10862036,10862038,10862040,10862044,10862046,10862048,10862050,10862051,10862052,10862053,10862054,10862055,10862057,10862060,10862063,10862066,10862099,10862172,10862176,10862177,10862179,10862183,10862185,10862187,10862189,10862190,10862192,10862193,10950721,7066142,8067914,8067916,10860315,10860323,10860340,10860342,10860363,10860463,10860531,8630187,10866376,10866379,10866383,7201375,7201376,8628265,10859282,10859294,10859300,10859301,10859308,10859309,10859310,10859311,10859312,10859318,10859327,10859330,10859331,10859332,10859333,10859334,10859335,10859336,10859337,10859338,10859346,10859347,10859350,10859352,10859353,10859355,10859356,10859365,10859369,10859370,10859371,10859390,10859394,10859403,10859405,10859407,10859408,10859409,10859410,10859411,10859412,10859413,10859415,10859417,10859420,10859422,10859424,10859426,10859427,10859428,10859448,10859449,7200714,8627357,8627358,8627359,8627360,8627361,8627362,8627363,8627377,8627378,8627379,8627380,8627381,8627382,7198347,7198348,8625382,8625383,8625384,8625390,8625399,8625401,8625402,8625403,8625404,8625411,8625412,3923519,3923537,10854219,10619240,10617106,10617112,10617134,10617144,10617147,10617160,8905897,8905898,10615140,10850584,10615652,10426356,10614093,10714140,10714141,10614734,10614746,10612191,10612412,10612421,10612423,10612431,10612433,10612434,10612440,10612442,10612465,10612468,10612473,10612474,10612506,10612518,10612519,10612521,10612524,10612528,10612532,10612533,10612540,10612541,10612542,10612544,10612546,10612547,10612551,10612553,10612558,10612565,10612567,10612571,10612572,10612580,10612581,10612595,10612600,10612601,10612603,10612604,10612611,10612612,10612614,10612618,10612619,10612632,10612662,10612663,10612670,10612675,10612685,10612697,10612725,10612731,10612732,10612755,10612825,10612832,10612835,10612842,10612843,10612844,10612849,10612850,10612851,10612852,10612853,10612854,10612856,10612886,10612888,10612889,10612890,10612893,10612894,10612895,10612896,10612897,10612898,10612900,10613513,10613514,10613562,10613662,10613664,10613673,10613682,10613683,10613685,10613691,10613694,10613708,10613709,10613710,10613716,10613717,6673518,9169356,6673563,6673639,6673640,6673642,6673644,6673645,6673646,6673761,6673762,9169773,9912264,10118275,10118276,10118277,6674315,6674319,6674320,9912359,9912371,9912372,9912373,9912378,9912381,9912404,9912405,9912406,9912407,9912408,9913327,9913328,9913329,9913333,9913335,10419382,10419383,10419385,9168670,9168692,9168694,9168696,9168699,10415789,10415790,9168871,10415822,10415877,9911165,9168962,10415886,6673474,6673476,6673477,6673486,6673494,6673495,6673496,6673497,8550043,976521,976522,976525,9167979,10468762,10888828,10890022,10890028,10885226,10885229,10885248,10885296,10885297,10885299,10885300,10885301,10885302,10885303,10885305,10887676,10887677,10887682,10887686,10887690,10887693,10887695,10887698,10887709,10885928,10885938,10647506,10413729,10413733,10413734,10413736,10413737,10413738,10413739,10413740,10413741,10413742,10413743,10413754,10413759,10413761,10413765,10413768,10413769,10413772,10413773,10413774,10413775,10413776,10413777,10413778,10413779,10413780,10413781,10413784,10413785,10413786,10413791,10413793,10413794,10413795,10413799,10413802,10413803,10413804,10413805,10413806,10413815,10413820,10413821,10413822,10413823,10413844,10413845,10413849,10413850,10413852,10413861,10413862,10413863,10413864,10413866,10413867,10413868,10413870,10413871,10413872,10413873,10413874,10413875,10413876,10413878,10413879,10413881,10413882,10413883,10413885,10413886,10413888,10413890,10413891,10413893,10413894,10413895,10413913,10413914,10409987,10489235,10489236,10489237,10489238,10489239,10489241,10489243,10489244,10489245,10489246,10414651,10414661,10414668,10414670,10414681,10414745,10414812,10482850,10482854) 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<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>