Powered by bcoos 2.0 | 0.025 seconds | 22 queries | SQL: 0.0037 seconds | 33 files: 195.9 KB | HTML: 5.23 KB
SELECT b.*, u.username, (SELECT count(id) FROM `bcoos_blog_comments` WHERE elementId = b.id ) as comments ,(SELECT GROUP_CONCAT(CONCAT_WS('#',name,slug) SEPARATOR '#') FROM `bcoos_blog_tags_post` p , `bcoos_blog_tags` t WHERE p.elementId = b.id AND p.tagId = t.id ) as tags FROM `bcoos_blog` b, `bcoos_users` u , `bcoos_blog_tags` t, `bcoos_blog_tags_post` p WHERE b.user_id = u.id AND (b.published = 1 OR 1 = '0' ) AND b.id = p.elementId AND p.tagId = t.id AND t.name = 'check-all' ORDER BY timestamp DESC LIMIT -5 , 5 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 '-5 , 5' at line 1