raeno

select fund_sums.total, fund_products.name
from (
  select sum(allocation_amount) total, fund_product_id
    from transactions 
    where transactions.investor_id = 490
    group by fund_product_id
) fund_sums
left join fund_products on fund_sums.fund_product_id = fund_products.id

raeno

#!/bin/sh

### BEGIN INIT INFO
# Provides:           ahn
# Required-Start:     ahn daemon
# Required-Stop:      ahn daemon
# chkconfig:          2345 91 60
# Default-Start:      2 3 4 5
# Default-Stop:       0 1 6
# Short-Description:  Adhearsion daemon