#!/bin/bash

WIKIS=$(mysql -BN -h sql -e 'SELECT dbname FROM toolserver.wiki WHERE domain IS NOT NULL AND is_closed = 0;')

for dbname in $WIKIS;

do

        echo $dbname

        echo "

/* SLOW_OK */

SELECT CONCAT(ns_name, ':', page_title), CONCAT('$1:', iwl_title)

FROM iwlinks

JOIN page ON iwl_from = page_id

JOIN toolserver.namespacename ON dbname = '$dbname' AND ns_is_favorite AND ns_id = page_namespace

WHERE iwl_prefix = '$1'

-- " | mysql -h ${dbname/_/-}.rrdb.toolserver.org -BcN $dbname

        # mysql switches

        # -c  Prevent comment stripping, need to prevent the query killer

        # -N  No column name heading

        # -B Bare formatted / -t Table formatted / -H HTML output / -X XML output

done;