SELECT 
       t.* 
    FROM 
       tweets t, followers f 
    WHERE 
        t.author_id = f.author_id AND f.user_id = ?
    ORDER BY rand()