Cartier Angel's Wing Necklace in Yellow Gold Plated

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Wing Necklace in Yellow Gold Plated' and pd.language_id = '1' and p.maste' at line 2
in:
[SELECT p.products_image, pd.products_name, p.products_id FROM products_description pd left join products p on (p.products_id = pd.products_id) left join products_attributes m on (p.products_id = m.products_id) WHERE p.products_status = 1 and p.products_id between 701 and 721 and p.products_price = 47.9900 and pd.products_name = 'Cartier Angel's Wing Necklace in Yellow Gold Plated' and pd.language_id = '1' and p.master_categories_id = '23']