function get_sql_for_customer_branches()
{
    $sql = "SELECT "
        ."b.branch_code, "
        ."b.branch_ref, "
        ."b.br_name, "
        ."p.name as contact_name, "
        ."s.salesman_name, "
        ."a.description, "
        ."p.phone, "
        ."p.fax, "
        ."p.email, "
        ."t.name AS tax_group_name, "
        ."b.inactive
        FROM ".TB_PREF."cust_branch b "
        . "LEFT JOIN ".TB_PREF."crm_contacts c
            ON c.entity_id=b.branch_code AND c.type='cust_branch' AND c.action='general'
            LEFT JOIN ".TB_PREF."crm_persons p on c.person_id=p.id,"
            .TB_PREF."areas a, "
            .TB_PREF."salesman s, "
            .TB_PREF."tax_groups t
        WHERE b.tax_group_id=t.id
        AND b.area=a.area_code
        AND b.salesman=s.salesman_code
        AND b.debtor_no = ".db_escape($_POST['customer_id']);

    if (!get_post('show_inactive')) $sql .= " AND !b.inactive";
    $sql .= " GROUP BY b.branch_code ORDER BY branch_ref";

    return $sql;
}