MySQL error in file: /engine/modules/show.full.php at line 499

Error Number: 1064

The Error returned was:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'roses ' AND category='10'' at line 1

SQL query:

SELECT title,id,alt_name,category FROM dle_post where title='Guns n' roses ' AND category='10'