Die Abfrage
SELECT COUNT(DISTINCT a.media_id) total 
                                           FROM ost_media m,ost_tags2media t2m
                                           WHERE	t2m.tags2media_tag_id = '84'
                                           AND t2m.tags2media_media_id = m.media_id
                                           AND m.media_access = 'public'
                                           AND m.media_conversion_status = 'success'
                                           AND m.media_notified_status = 'legal'
                                           
lieferte folgende Fehlermeldung:
Unknown column 'a.media_id' in 'field list'