Van Cleef & Arpels Sweet Alhambra Butterfly mini Bracelet in White Gold with Tiger's Eye

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 Eye' and pd.language_id = '1' and p.master_categories_id = '162'' 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 6104 and 6124 and p.products_price = 124.4000 and pd.products_name = 'Van Cleef & Arpels Sweet Alhambra Butterfly mini Bracelet in White Gold with Tiger's Eye' and pd.language_id = '1' and p.master_categories_id = '162']