Here's a list what the general Linux community prefers in each category
Server Distribution of the Year - Debian (29.35%)
Desktop Distribution of the Year - Ubuntu (28.56%)
Security/Forensic/Rescue Distribution of the Year - BackTrack (36.87%)
Mobile Distribution of the Year - Android (76.82%)
Database of the Year - MySQL (51.76%)
NoSQL Database of the Year - Cassandra (27.40%)
Office Suite of the Year - OpenOffice.org (55.74%)
Browser of the Year - Firefox (55.52%)
Desktop Environment of the Year - Gnome (45.06%)
Window Manager of the Year - Compiz (26.43%)
Messaging App of the Year - Pidgin (43.85%)
Virtualization Product of the Year - VirtualBox (59.16%)
Audio Media Player Application of the Year - Amarok (28.34%)
Audio Authoring Application of the Year - Audacity (74.58%)
Video Media Player Application of the Year - VLC (58.79%)
Video Authoring Application of the Year - FFmpeg (26.70%)
Multimedia Utility of the Year - GStreamer (31.95%)
Graphics Application of the Year - GIMP (66.98%)
Network Security Application of the Year - Wireshark (32.90%)
Host Security Application of the Year - SELinux (38.46%)
Network Monitoring Application of the Year - Nagios (61.76%)
IDE/Web Development Editor of the Year - Eclipse (24.55%)
Text Editor of the Year - vim (35.88%)
File Manager of the Year - Nautilus (31.42%)
Open Source Game of the Year - Battle for Wesnoth (22.70%)
Programming Language of the Year - Python (26.56%)
Revision Control System of the Year - git (50.56%)
Backup Application of the Year - rsync (47.42%)
Open Source CMS/Blogging platform - WordPress (45.18%)
Configuration Management Tool of the Year - Puppet (46.67%)
Open Source Web Framework of the Year - Django (33.33%)
http://www.linuxquestions.org/questions/linux-news-59/2010-linuxquestions-org-members-choice-award-winners-861440/