SELECT DISTINCT b.id as book_id FROM book b JOIN book_category bc ON b.id=bc.book_id WHERE b.status='enable' AND bc.category_id = AND b.id!=175 ORDER BY RAND() DESC LIMIT 10 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 'AND b.id!=175 ORDER BY RAND() DESC LIMIT 10' at line 1