# Time: 110420  8:52:13
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 622227
SELECT SUM( x.billsec) AS log_c, SUM(x.billsec) AS c_s
                                        FROM `log_call` x
                                        JOIN user u ON u.user_id = x.fk_user
                                        WHERE x.fk_user != '0'
                                        AND x.calldisp = 'SUCCESS'
                                         AND (x.calltime BETWEEN '2011-03-21%' AND
                                          DATE_ADD('2011-04-19', INTERVAL 1 DAY));

# Time: 110420  9:10:30
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 626641
SELECT rtd.status, u.user_id, u.sip, u.realname, u.lastname, COUNT( d.name ) AS numb,we.*
                                FROM rt_dialer rtd
                                JOIN user u ON u.user_id = rtd.id
                                JOIN week_expecation we ON we.user_id = u.user_id
                                JOIN disposition d ON rtd.id = d.fk_user
                                WHERE d.date_s LIKE '2011-04-20%'
                                AND u.fk_call_center = '1'

                                GROUP BY d.fk_user
                                ORDER BY u.sip ASC;



# Time: 110420  9:10:30
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 626641
SELECT rtd.status, u.user_id, u.sip, u.realname, u.lastname, COUNT( d.name ) AS numb,we.*
                                FROM rt_dialer rtd
                                JOIN user u ON u.user_id = rtd.id
                                JOIN week_expecation we ON we.user_id = u.user_id
                                JOIN disposition d ON rtd.id = d.fk_user
                                WHERE d.date_s LIKE '2011-04-20%'
                                AND u.fk_call_center = '1'

                                GROUP BY d.fk_user
                                ORDER BY u.sip ASC;



# Time: 110420  9:27:35
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 626641
SELECT rtd.status, u.user_id, u.sip, u.realname, u.lastname, COUNT( d.name ) AS numb,we.*
                                FROM rt_dialer rtd
                                JOIN user u ON u.user_id = rtd.id
                                JOIN week_expecation we ON we.user_id = u.user_id
                                JOIN disposition d ON rtd.id = d.fk_user
                                WHERE d.date_s LIKE '2011-04-20%'
                                AND u.fk_call_center = '1'

                                GROUP BY d.fk_user
                                ORDER BY u.sip ASC;