X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=examples%2Fconsole.pl;h=277c5c2dd1fc1abd66f1e0e7f70538f4bcda8b80;hb=bb54fcb44cb8362f47b6b1f5c26427b4204d0caa;hp=61e5dee5a41960c5aa9fd48e7ac0ced7a3dea1f4;hpb=820bb1f5b8926c8c8c4c34ed99c057abfb8fe105;p=scpubgit%2FQ-Branch.git

diff --git a/examples/console.pl b/examples/console.pl
index 61e5dee..277c5c2 100644
--- a/examples/console.pl
+++ b/examples/console.pl
@@ -23,6 +23,7 @@ my @sql = (
    'SAVEPOINT station',
    'ROLLBACK TO SAVEPOINT station',
    'RELEASE SAVEPOINT station',
+   "SELECT COUNT( * ) FROM message_children me WHERE( ( me.phone_number NOT IN ( SELECT message_child.phone_number FROM blocked_destinations me JOIN message_children_status reason ON reason.id = me.reason_id JOIN message_children message_child ON message_child.id = reason.message_child_id) AND ( ( me.api_id IS NULL ) ) ) )"
 );
 
 print "\n\n'" . $sqlat->format($_) . "'\n" for @sql;