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(8630627,8630628,8630629,8630630,8630631,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,10861439,10861440,8630811,8574513,8630993,8631003,3229171,8631598,10862253,10862254,10862255,10862256,10862257,10862258,10862260,8631624,8631625,8631630,10862623,10862625,10862653,10862682,10862683,10862684,10862737,8575733,8575734,8575735,10862911,8632517,8632546,8629639,10860292,8629705,10860413,10860414,10860438,10860478,10860518,8630172,8630173,8630187,8630331,8630333,8630340,8630349,8630351,10930095,10866240,10866241,7201258,7201259,7201261,7201263,7201264,7201319,7201366,7201367,7201415,8627821,7201586,7201588,7201605,7201607,7201629,7201683,7201727,7201741,7201742,7201775,7201776,7201777,8595175,7201778,7201779,7201780,7201781,7201782,8628230,7201861,7201959,10960474,8628641,10859291,8628654,8628662,7202265,8628665,7202266,8628666,8628667,8628668,8628669,8628678,8628680,8628699,8628713,8628718,8628719,10859512,10859513,9794578,9794579,9794580,9794587,9794588,9794592,7202769,9794594,8629250,8629264,8629340,8629341,8629429,8629430,8626719,8626720,8626721,8626722,8626723,8626724,8626725,8626726,7200382,10857461,10857503,10857504,7200469,10857684,10857686,10857687,10857688,10857690,10857691,10959088,10857693,10857694,10865848,8627237,8627283,10865957,10866115,10866197,8624708,8624709,8624717,8624718,8624719,8624735,3925520,8624944,8624945,8624961,8624985,8625025,8625055,8908468,8908469,8625058,8625059,7198724,7198726,7198728,7198729,7198730,7198731,7198767,7198784,7198785,8625244,8625247,10856188,10856189,8625558,8625559,10856248,10856250,8625629,8625632,8625639,8625640,8625657,8625668,8625669,8625671,8625716,8625728,8625732,8625733,8625734,8625748,8625758,8625759,8625762,8625772,8625810,8625811,8625814,8625819,8625820,8625823,8625824,7199540,7199541,7199542,7199545,8626047,8626221,8626222,10856979,8626406,7196378,3923564,3923593,10854077,7197051,8613644,7197075,7197602,7197813,7197814,7197815,7197816,7197817,7197818,7197819,7197820,10619887,8634789,10617171,8634790,8634792,8634794,8634795,8634796,8905261,8905262,8905263,10622268,8634903,10622360,10617426,10617427,3232899,3232900,3232901,3232902,3232903,3232909,3232910,8905711,8632627,8632629,8632633,8632634,8632635,8632636,8632722,10615108,10615109,8632800,10620201,10425910,10425937,8633235,8633236,8633237,8633238,8633239,8633240,8633241,8633252,10615721,10615722,10615726,10615727,10615728,10851039,10615780,10615820,10615822,8540418,8540631,8634011,8634012,8634013,8634014,8634015,8634016,8634017,8634018,8634019,8634020,8634021,8634022,8634023,8634024,8634025,8634026,8634027,8634028,8634029,8634030,8634031,8634032,8634033,8634034,8634035,8634036,8634037,8634038,8634039,8634040,8634041,8634122,8634123,8634124,8634125,8634126,8634127,8634128,8634129,8634130,8634140,8634141,8634142,8634143,8634144,8634145,8634146,10616644,10427106,8634410,8634421,10614220,10614376,10611655,10611856,10612268,8566628,8852017,10613079,10613080,10613081,10613082,8852303,10613235,10613513,10613514,10613547,8852771,10610901,9169305,9169306,9169307,9169308,9169310,9169428,9169638,6674198,9912612,9912888,9168307,10419306,10419349,10419350,10415375,10415376,10416481,6673067,6673122,6673124,6673125,9168930,9168931,9168932,9168937,9168938,9168939,9168940,9168941,9169233,8550018,8550037,8550038,8550267,976476,10889019,10889020,10889021,10884088,10884089,10155731,10885465,10885468,10885469,10887965,10887966,10888018,10888019,10630042,10161868,10886058,10886059,10886060,10886061,10881491,10187507,10886878,10886910,10896985,10897008,10887052,10887072,10897082,10608610,10582561,10508350,10411336,10411338,10411839,10413967,10413968,10408157,10487111,10414635,10414757,10414758) 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>