MySQL Error: 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-new' AND c.FULL_NAME='directory' LIMIT 1' at line 6<br> Query:
            SELECT  p.*,
                    c.ID as CAT_ID
              FROM  products as p
        INNER JOIN  store_categories as c
                ON  FIND_IN_SET(c.ID, p.CATS)
             WHERE  p.FULL_NAME='what's-new' AND c.FULL_NAME='directory' LIMIT 1