Incorrect syntax near 'superbrand'.

SELECT l_itemID, l_typeID, l_levelID, l_parentID, tx_itemName FROM d_404FriendlyNames WHERE tx_404Label = 'https://www.retailjobsboard.co.uk/news/2517-supermarkets-slump-in-'superbrand'-poll';