select
COALESCE(sum(dr.NO_OF_QT),0),
ur.NO_OF_USERS, ur.NO_OF_DB, 0,
COALESCE(sum(dr.NO_OF_SM),0),
COALESCE(sum(dr.NO_OF_RPTS),0)
from DataBaseProps dr
left join DataBaseDetails db on dr.DB_ID=db.ID and db.STATUS=1
left join UserProps ur on db.OWNER_UID=ur.USER_UID
where ur.USER_UID='USER_UID'

select
COALESCE(sum(dr.NO_OF_QT),0),
0,0, 0,
COALESCE(sum(dr.NO_OF_SM),0),
COALESCE(sum(dr.NO_OF_RPTS),0)
from DataBaseProps dr
left join DataBaseDetails db on dr.DB_ID=db.ID and db.STATUS=1
left join UserProps ur on db.OWNER_UID=ur.USER_UID
where ur.USER_UID='USER_UID'

select NO_OF_USERS,NO_OF_DB from UserProps
where USER_UID='USER_UID'

desc DataBaseProps >
+-----------------+------------+------+-----+---------+-------+
| Field           | Type       | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+-------+
| DB_ID           | bigint(19) | NO   | PRI | NULL    |       |
| NO_OF_RPTS      | int(10)    | YES  |     | 0       |       |
| NO_OF_QT        | int(10)    | YES  |     | 0       |       |
| NO_OF_SM        | int(10)    | YES  |     | 0       |       |
+-----------------+------------+------+-----+---------+-------+

desc DataBaseDetails>
+-------------------+--------------+------+-----+-----------------+-------+
| Field             | Type         | Null | Key | Default         | Extra |
+-------------------+--------------+------+-----+-----------------+-------+
| ID                | bigint(19)   | NO   | PRI | NULL            |       |
| NAME              | varchar(50)  | NO   |     | NULL            |       |
| STATUS            | int(10)      | NO   |     | 1               |       |
| OWNER_UID         | bigint(19)   | NO   |     | NULL            |       |
+-------------------+--------------+------+-----+-----------------+-------+

desc UserProps>
+-----------------+------------+------+-----+---------+-------+
| Field           | Type       | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+-------+
| USER_UID        | bigint(19) | NO   | PRI | NULL    |       |
| NO_OF_DB        | int(10)    | YES  |     | 0       |       |
| NO_OF_USERS     | int(10)    | YES  |     | 0       |       |
+-----------------+------------+------+-----+---------+-------+