SELECT node_v_name, '/edzesi-lehetosegek/gyerekcsoportok/del-pest.html/' 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
Got error 28 from storage engine
/edzesi-lehetosegek/gyerekcsoportok/del-pest.html