RoyK

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)