SELECT d.*, n.*
                  FROM fr_mnode AS n
                  LEFT JOIN fr_mdata AS d
                     ON d.mdata_node_id = n.mnode_id
                  WHERE n.mnode_left <= 209
                     AND n.mnode_right  >= 210
                     AND d.mdata_lang = "pl"
                 ORDER BY n.mnode_left ASC
Array
(
    [0] => Array
        (
            [0] => 89
            [mdata_id] => 89
            [1] => 89
            [mdata_node_id] => 89
            [2] => pl
            [mdata_lang] => pl
            [3] => Archiwum
            [mdata_name] => Archiwum
            [4] => 89
            [mnode_id] => 89
            [5] => 0
            [mnode_pid] => 0
            [6] => 205
            [mnode_left] => 205
            [7] => 502
            [mnode_right] => 502
            [8] => -1
            [mnode_access] => -1
            [9] => 0
            [mnode_visible] => 0
            [10] => 
            [mnode_redirect] => 
        )

    [1] => Array
        (
            [0] => 14
            [mdata_id] => 14
            [1] => 14
            [mdata_node_id] => 14
            [2] => pl
            [mdata_lang] => pl
            [3] => Sprzęt Car Audio
            [mdata_name] => Sprzęt Car Audio
            [4] => 14
            [mnode_id] => 14
            [5] => 89
            [mnode_pid] => 89
            [6] => 206
            [mnode_left] => 206
            [7] => 221
            [mnode_right] => 221
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

    [2] => Array
        (
            [0] => 17
            [mdata_id] => 17
            [1] => 17
            [mdata_node_id] => 17
            [2] => pl
            [mdata_lang] => pl
            [3] => Nawigacja
            [mdata_name] => Nawigacja
            [4] => 17
            [mnode_id] => 17
            [5] => 14
            [mnode_pid] => 14
            [6] => 209
            [mnode_left] => 209
            [7] => 210
            [mnode_right] => 210
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

)
Array
(
    [0] => Array
        (
            [0] => 89
            [mdata_id] => 89
            [1] => 89
            [mdata_node_id] => 89
            [2] => pl
            [mdata_lang] => pl
            [3] => Archiwum
            [mdata_name] => Archiwum
            [4] => 89
            [mnode_id] => 89
            [5] => 0
            [mnode_pid] => 0
            [6] => 205
            [mnode_left] => 205
            [7] => 502
            [mnode_right] => 502
            [8] => -1
            [mnode_access] => -1
            [9] => 0
            [mnode_visible] => 0
            [10] => 
            [mnode_redirect] => 
        )

    [1] => Array
        (
            [0] => 14
            [mdata_id] => 14
            [1] => 14
            [mdata_node_id] => 14
            [2] => pl
            [mdata_lang] => pl
            [3] => Sprzęt Car Audio
            [mdata_name] => Sprzęt Car Audio
            [4] => 14
            [mnode_id] => 14
            [5] => 89
            [mnode_pid] => 89
            [6] => 206
            [mnode_left] => 206
            [7] => 221
            [mnode_right] => 221
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

    [2] => Array
        (
            [0] => 17
            [mdata_id] => 17
            [1] => 17
            [mdata_node_id] => 17
            [2] => pl
            [mdata_lang] => pl
            [3] => Nawigacja
            [mdata_name] => Nawigacja
            [4] => 17
            [mnode_id] => 17
            [5] => 14
            [mnode_pid] => 14
            [6] => 209
            [mnode_left] => 209
            [7] => 210
            [mnode_right] => 210
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

)