*************************** 7. row ***************************
     Id: 45199
   User: root
   Host: localhost
     db: DOTW
Command: Query
   Time: 0
  State: Sending data
   Info: SELECT distinct AllotmentType,b.AllotmentCode as AlloCode, 
                                                        (select sum(c.Rooms) from tbl_Ho
*************************** 8. row ***************************
     Id: 45200
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist


killing 45199
[root@DotwConnect KILL_SLLEPING_SELECT]#