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(10870262,10930264,10870312,10870343,9214719,10870384,10870385,10870386,10870405,10870411,10870412,10870441,10861535,7076284,9214960,10940103,3228986,7068744,7068778,7068788,8631486,8631489,7068847,8631495,8631501,8631505,10846808,8631944,10862851,10863047,8632515,7074878,8632548,8632549,8632550,8632551,8632552,8632553,8632554,8632555,8632556,8632557,8632558,10844794,10844798,9214301,10870141,10870152,10870181,7067910,10870205,10870219,10858873,10859050,7202212,10843762,3899606,8628785,10960828,7073435,10974482,10844586,10844587,10844594,8557945,10959183,7200784,7201053,8555905,3925438,10839943,10839944,7070091,10941816,10942038,8626403,8612782,8612783,8612784,8612785,8612786,10837727,11045710,11045711,11045712,7196369,7196370,7196371,11046051,8554361,8613421,8613441,8613445,11007328,11007332,11007333,11007388,11007389,11007413,11007416,11007418,11007419,11046561,11007782,11007783,11007784,11007788,11007789,8555214,8614217,8614218,8614219,10852232,10852645,10852646,10852675,10617796,8542284,10993467,10993468,10993469,10993470,10993471,10993472,8632825,8632836,8632843,10615230,10850824,10850825,10965306,10965307,8540637,8540643,10992346,10992347,10992365,9915523,8853309,10559361,10559389,8568261,8568278,7019443,7019444,7019445,7019446,7019447,7019448,7019545,7019546,7019547,7019548,7019549,10714374,7019550,7019551,7019552,7019553,7019554,7019555,7019556,10122156,10122174,10122179,10122248,10122249,10122250,10122251,7019823,7019824,7019825,7019826,7019827,7019828,7019829,7019830,7019831,7019832,7019833,7019834,7019835,7019836,7019837,7019838,7019839,7019840,7019841,7019842,10611995,10611997,7057504,10612004,9211820,9914349,9196519,9196528,9196582,9196590,9196599,10613342,10558620,9196863,9196924,9196925,10515166,10515167,10515168,9911599,9209576,10117901,9186068,9186073,9186099,9186111,9186145,9194411,9186444,9186445,9186615,9186640,9186641,9186642,9186643,9186747,9186860,7024613,7024614,7024615,7024616,7024617,7024618,7024619,7024620,7014053,7014054,10415429,10417458,8918229,10416604,4973689,4973699,4973703,4973715,4973716,4973717,4973727,10463005,10463006,10463007,10463008,10463009,10463010,10463011,10463012,10463013,9182492,4971945,10123556,10123557,10123558,10903703,10903718,10903737,10903744,10628308,10628403,10174980,10908990,10175054,10175091,10175092,10155560,10170655,10170656,10879847,10879906,10879910,10172233,10172234,10172243,10172391,10631623,10631624,10601272,10601273,10601274,10601275,10649520,10591403,10591404,10553332,10531448,10531449,10531450,10531451,10531452,10531554,10523677,10541677,10541678,10541679,10539875,10539876,10539877,10532002,10532003,10532015,10530055,10530056,10530073,10530074,10530075,10532211,10532212,10532213,10532214,10524253,10530354,10530355,10532357,10532358,10532359,10532360,10532361,10532362,10532363,10530535,10530536,10528742,10538748,10538749,10530755,10528756,10530756,10530757,10530758,10530759,10530760,10530775,10530776,10530777,10530778,10530779,10524931,10524932,10524933,10524934,10524935,10524936,10524937,10533055,10533056,10422052,10422131,10422147,10422148,10422161,10425203,10413405,10488176,10488177,10488187,10413551,10408046,10408047,10408810,10715297,10409072,10409073) 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>