mysql> explain SELECT cid,ipaddr,regseconds,secret,callername,hide_cid,briiz_number.codec,mac,serialnumber,port FROM briiz_number,sipfriends WHERE briiz = 1990002 AND briiz = name;
+--------------+--------+--------------------+---------+---------+--------------------+-------+-------------+
| table        | type   | possible_keys      | key     | key_len | ref                | rows  | Extra       |
+--------------+--------+--------------------+---------+---------+--------------------+-------+-------------+
| briiz_number | ALL    | briiz_number_briiz | NULL    |    NULL | NULL               | 14717 | Using where |
| sipfriends   | eq_ref | PRIMARY,jalla      | PRIMARY |      40 | briiz_number.briiz |     1 |             |
+--------------+--------+--------------------+---------+---------+--------------------+-------+-------------+
2 rows in set (0.00 sec)