A Database Error Occurred

Error Number: 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 Donut Factory') AND TrialURL <> '' LIMIT 0,3' at line 1

SELECT DISTINCT a.ProductName, a.TrialURL, b.p_desc45, a.ProductID FROM ss_dat_regnow as a LEFT JOIN ss_dat_articles as b ON a.ProductID = b.p_regnow_id WHERE MATCH(a.ProductName,a.ShortDesc) AGAINST('Rocknor's Donut Factory') AND TrialURL <> '' LIMIT 0,3