mysql query optimization

mysql query optimization