Incorrect syntax near 's'.

SELECT l_itemID, l_typeID, l_levelID, l_parentID, tx_itemName FROM d_404FriendlyNames WHERE tx_404Label = 'cscs-labourer-needed-in-shepherd's-bush-jobs-in-essex';