Fix mysql error on announcements views and remove un necessary menu items.

Change a query for displaying all announcements to go on the right way.
also for creating an announcement we have a redundancy links under create content so I remove the menu item which does not work.