SELECT
                        node_v_name,
                        '/edzesi-lehetosegek/gyerekcsoportok/gyomro/' AS url
                  FROM
                        nodes
                 GROUP BY node_v_name
                 HAVING url LIKE CONCAT(node_v_name,'/%')
              ORDER BY
                        LENGTH(node_v_name) DESC
                LIMIT   1
            <br>Can't create/write to file '/tmp/#sql_48c_0.MYI' (Errcode: 28)<br>/edzesi-lehetosegek/gyerekcsoportok/gyomro