Can you really get posts all groups but exlude just one latest publish from specific groups. Something similar to: get posts all groups, but exclude latest publish from category 2,4 and 5. PS. I am searching for wordpress query (not mysql), for instance somethng like
<?php $my_query = new WP_Query('showposts=10'); ?>
What about this:
<?php $my_query = new WP_Query('showposts=10&offset=1'); ?>
Does that meet your needs?
In MySQL, I recommend something similar to this:
SELECT * FROM posts WHERE id NOT IN (SELECT id FROM posts WHERE category IN (2,4,5) ORDER BY id DESC LIMIT 0,1)