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~%' and p.products_collection_id = pcoll.products_collection_id' at line 1
in:
[SELECT DISTINCT products_collection FROM products p, products_collection pcoll WHERE `products_collection` LIKE '%~1980\\'s~%' and p.products_collection_id = pcoll.products_collection_id;]