One-liner to retrieve the list of all etherpad-lite's pad names in the database

etherpad-lite_list_pads.sh

#!/bin/sh
mysql -u etherpad-lite -p etherpad-lite -e 'select store.key from store' \
   | grep -Eo '^pad:[^:]+' \
   | sed -e 's/pad://' \
   | sort \
   | uniq -c \
   | sort -rn \
   | awk '{if ($1!="2") {print $2 }}'