mysql> SELECT * from navigation_item WHERE navigation_item.navigation = 1 AND  navigation_item.parent = 2;
+----+------------+--------+-----------+-------+----------------------+
| id | navigation | parent | link_text | local | URI                  |
+----+------------+--------+-----------+-------+----------------------+
|  4 |          1 |      2 | Login     |     0 | index.php?site=login |
+----+------------+--------+-----------+-------+----------------------+
1 row in set (0.00 sec)