1054 - Unknown column '20asc' in 'order clause'

SELECT COUNT(*) as total FROM (select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_other_event_addresse, p.products_quantity, p.products_image, p.products_weight, p.map_lat, p.map_long, pd.products_description_short, pd.products_description, pd.products_url, p.products_model, p.shipping_term_id, p.products_featured, p.arkepzesi_lehetoseg_id, p.products_plus1, p.products_plus2, p.products_plus3, p.products_plus4, p.products_plus5, p.products_templates_id, p.disable_addtobasket, p.esemeny_helyszin_id, p.esemeny_helyszin_ids, p.products_master, p.products_free, p.products_websites, p.kontakt_email, p.products_image_pop, p.products_cim, p.products_irszam, p.products_telepules_id, p.kontakt_irszam, p.kontakt_telefon, p.kontakt_cim, p.kontakt_mobil, p.kontakt_fax, p.ossz_agy, p.ossz_szobaszam, p.kontakt_web ,p.products_list_on_date, p.products_date_available, p.map_google_level, p.products_hazszam, p.infokeresi_form from ((products_description pd, products p), products_to_categories p2c, categories c) , products_to_websites p2w where p.products_status = '1' and p.products_on_public = '1' and p.products_listing_status = '1' and p.products_date_expire > '2013-05-22' and p.products_id = p2w.products_id and p2w.websites_id = '1' and pd.language_id = '4' and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id in(196)) and p.products_templates_id not in(34,35,36,37,38,39,40) and products_master = 0 and c.categories_id = p2c.categories_id and c.categories_status = '1' and c.categories_on_public = '1' group by p.products_id order by p.rand_4%20asc) a

[SQL BUG]