SELECT
  crm_clients.`id`,
  crm_clients.`national_insurance`,
  crm_clients.`total_hmrc`,
  (SELECT
    crm_crmuseractions.title
  FROM
    dev_pfands.`crm_crmuseractions`
  WHERE crm_crmuseractions.`id` = crm_clients.`status`) AS `status`
FROM
  dev_pfands.`crm_clients`
  INNER JOIN crm_client_cheques
    ON crm_clients.id = crm_client_cheques.`client_id`
  INNER JOIN dev_pfands.`crm_payments`
    ON crm_clients.id = crm_payments.`client_id`
  INNER JOIN dev_pfands.`crm_self_assesments`
    ON crm_clients.id = crm_self_assesments.`client_id`
WHERE crm_clients.`status` = 9
  OR crm_clients.`status` = 8
  OR crm_clients.`status` = 7
  OR crm_clients.`national_insurance` != ''
  OR crm_clients.`id` != ''

sql = "SELECT crm_clients.id, crm_clients.national_insurance, crm_clients.total_hmrc _
  (SELECT _
    crm_crmuseractions.title _
   FROM _
   crm_crmuseractions _
   WHERE crm_crmuseractions.id = crm_clients.status ) AS 'status _
   FROM _
   crm_clients _
   INNER JOIN crm_client_cheques _
   ON crm_clients.id = crm_client_cheques.client_id _
   INNER JOIN crm_payments _
   ON crm_clients.id = crm_payments.client_id _
   INNER JOIN crm_self_assesments.client_id _
   WHERE crm_clients.status = 9 _
   OR crm_clients.status = 8 _
   OR crm_clients.status = 7 _
   OR crm_clients.national_insurance != '' _
   OR crm_clients.id != '' "