MariaDB [(none)]>

final = stdin.write("SELECT a.id as customer_id,a.external_id FROM billing.contracts a LEFT JOIN billing.contacts b ON a.contact_id = b.id WHERE a.status = 'active' AND b.reseller_id IS NOT NULL")
       print(final)

import paramiko
import time

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('123.369.321.1', port=22, username='root', password='')

time.sleep(5)

def execute():
       stdin, stdout, stderr = ssh.exec_command("mysql -uroot -e 'SELECT a.id as customer_id,a.external_id FROM billing.contracts a LEFT JOIN billing.contacts b ON a.contact_id = b.id WHERE a.status = 'active' AND b.reseller_id IS NOT NULL'")

execute()

<paramiko.ChannelFile from <paramiko.Channel 0 (open) window=2097152 -> <paramiko.Transport at 0xb7a6caccL (cipher aes128-ctr, 128 bits) (active; 1 open channel(s))>>>

ERROR 1054 (42S22) at line 1: Unknown column 'active' in 'where clause'

<paramiko.ChannelFile from <paramiko.Channel 0 (open) window=2097152 -> <paramiko.Transport at 0xb7a86aacL (cipher aes128-ctr, 128 bits) (active; 1 open channel(s))>>>

import paramiko
import time

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('123.369.325.1', port=22, username='root', password='')

time.sleep(5)

def execute():
	query = "SELECT a.id as customer_id,a.external_id FROM billing.contracts a LEFT JOIN billing.contacts b ON a.contact_id = b.id WHERE a.status = 'active' AND b.reseller_id IS NOT NULL"
	stdin, stdout, stderr = ssh.exec_command("mysql -uroot -e %s".format(query))
	print stdout

execute()

import paramiko
import time

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('123.369.325.1', port=22, username='root', password='')

time.sleep(5)

def execute():
	query = "SELECT a.id as customer_id,a.external_id FROM billing.contracts a LEFT JOIN billing.contacts b ON a.contact_id = b.id WHERE a.status = 'active' AND b.reseller_id IS NOT NULL"
	stdin, stdout, stderr = ssh.exec_command("mysql -uroot -e %s".format(query))
	stdout.channel.recv_exit_status()

import paramiko
import time

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('123.369.325.1', port=22, username='root', password='')

time.sleep(5)

def execute():
	query = "SELECT a.id as customer_id,a.external_id FROM billing.contracts a LEFT JOIN billing.contacts b ON a.contact_id = b.id WHERE a.status = 'active' AND b.reseller_id IS NOT NULL"
	stdin_, stdout_, stderr_ = ssh.exec_command("mysql -uroot -e %s".format(query))
	stdout_.channel.recv_exit_status()

stdin, stdout, stderr = client.exec_command('mysql -uroot -e "select a.username as DDI,c.username,b.domain from provisioning.voip_dbaliases a LEFT JOIN provisioning.voip_domains b ON a.domain_id = b.id LEFT JOIN provisioning.voip_subscribers c ON a.subscriber_id = c.id WHERE length(a.username)<12 AND a.username RLIKE '^56[2-9].+'"')

mains b ON a.domain_id = b.id LEFT JOIN provisioning.voip_subscribers c ON a.subscriber_id = c.id WHERE length(a.username)<12 AND a.username RLIKE '^56[2-9].+'"')
                                                                                                                                                                                                                                                                                                                                             ^
SyntaxError: invalid syntax

Tengo ese problema en la consulta aqui :

RLIKE '^56[2-9].+'

@MauricioContreras Osea en

RLIKE '^56[2-9].+'

import paramiko
import time

timeout = 30

client = paramiko.SSHClient()
client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
client.connect("136.339.2.1", username="root", password="")
stdin, stdout, stderr = client.exec_command('mysql -uroot -e "select a.username as DDI,c.username,b.domain from provisioning.voip_dbaliases a LEFT JOIN provisioning.voip_domains b ON a.domain_id = b.id LEFT JOIN provisioning.voip_subscribers c ON a.subscriber_id = c.id WHERE length(a.username)<12 AND a.username RLIKE '^56[2-9].+'"')

stdin, stdout, stderr = client.exec_command('mysql -uroot -e "select a.username as DDI,c.username,b.domain from provisioning.voip_dbaliases a LEFT JOIN provisioning.voip_domains b ON a.domain_id = b.id LEFT JOIN provisioning.voip_subscribers c ON a.subscriber_id = c.id WHERE length(a.username)<12 AND a.username RLIKE '^56[2-9].+'"')

@JackNavaRow

query = "select a.username as DDI,c.username,b.domain from provisioning.voip_dbaliases a LEFT JOIN provisioning.voip_domains b ON a.domain_id = b.id LEFT JOIN provisioning.voip_subscribers c ON a.subscriber_id = c.id WHERE length(a.username)<12 AND a.username RLIKE '^56[2-9].+'"
stdin, stdout, stderr = client.exec_command("mysql -uroot -e %s".format(query))

import paramiko
import time

timeout = 30

client = paramiko.SSHClient()
client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
client.connect("1236.369.325.1", username="root", password="")
query = "select a.username as DDI,c.username,b.domain from provisioning.voip_dbaliases a LEFT JOIN provisioning.voip_domains b ON a.domain_id = b.id LEFT JOIN provisioning.voip_subscribers c ON a.subscriber_id = c.id WHERE length(a.username)<12 AND a.username RLIKE '^56[2-9].+'"
stdin, stdout, stderr = client.exec_command(("mysql -u -e %s").format(query))

@abulafia Te refieres a algo asi:

stdin_, stdout_, stderr_ = ssh.exec_command("mysql -uroot -e %s".format(query))

stdin_, stdout_, stderr_ = ssh.exec_command('mysql -u root -e "{}"'.format(query))

stdin_, stdout_, stderr_ = ssh.exec_command('mysql -u root -e "%s"' % (query))