All pastes #676299 Raw Edit

Something

public text v1 · immutable
#676299 ·published 2007-08-30 22:42 UTC
rendered paste body
    SELECT 
        post.id AS post_id
    FROM 
        post, tag, post_tag
    WHERE 
        post.deleted = ? AND 
        tag.name = ? AND 
        post.id = post_tag.post_id AND 
        tag.id = post_tag.tag_id AND 
        tag.name = ? AND 
        post.id = post_tag.post_id AND 
        tag.id = post_tag.tag_id 
    ORDER BY 
        date DESC
    LIMIT 250 OFFSET 0