SELECT
node_v_name,
'/js/'+opts.fileBottomNavCloseImage+'/' 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
Unknown column 'opts.fileBottomNavCloseImage' in 'field list'
/js/'+opts.fileBottomNavCloseImage+'