spam.sh

#!/bin/bash

echo "" > spam.txt
for url in $(wp site list --field=url)
do
    for id in $(wp --url=$url post list --field=ID)
    do
        printf ":"
        content=$(wp --url=$url post get $id --field=content)
        if [[ $content =~ .*viagra.* ]]
            then
                echo $url >> spam.txt
                printf '[s]'
        elif [[ $content =~ .*pharma.* ]]
            then
                echo $url >> spam.txt
                printf '[s]'
        else
                printf '.'
        fi
    done
done