nemobis@tools-sgebastion-07:~$ echo "SELECT dbname FROM wiki WHERE size > 1 AND is_closed = 0;" | sql meta_p | tail -n +2 | for dbname in $(cat); do links=`echo 'SELECT COUNT(*) as links from externallinks JOIN page on el_from = page_id and page_namespace = 0 and ( el_index LIKE "http://com.reuters%" OR el_index LIKE "https://com.reuters%");' | sql ${dbname} | tail -n 1` ; echo -e "${dbname}\t${links}" ; sleep 0.1s; done | tee /dev/stderr | cut -f2 | paste -sd+ | bc