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 'LIMIT 54, 18' at line 8(No Description) sql: SELECT p.* FROM products p WHERE p.parent_id = 0 AND hidden = 0 AND enabled = 1 AND 1 = 1 ORDER BY LIMIT 54, 18