#!/bin/sh
#
# Prints the current newsgroups in PIMPPA
#
#

P_USER=pimppa

############################

mysql -u $P_USER --execute="USE pimppa;SELECT g_name as 'Group', area_name as 'Destination' FROM p_groups, p_areas WHERE NOT (g_flags & 1) AND g_dest=area_id ORDER BY g_name;"
