All pastes #967991 Raw Edit

Stuff

public sql v1 · immutable
·published 2008-04-02 19:32 UTC
rendered paste body
SELECT p.*, t.*, u.user_id, u.username FROM phpbb3_posts p JOIN phpbb3_topics t JOIN phpbb3_users u      ON p.topic_id = t.topic_id      AND u.user_id = p.poster_id      ORDER BY p.post_id DESC LIMIT 9;