$q=mysql_query("SELECT * FROM wp_posts WHERE post_status = 'publish' AND post_type= 'post' ORDER BY ID ASC"); 
while ($rows=mysql_fetch_assoc($q) ) { 

$post_iid=$rows['ID'];

    $th = mysql_query("SELECT * FROM wp_postmeta WHERE post_id=$post_iid AND meta_key= '_wp_attached_file'") or die(mysql_error()); 
    while($r =  mysql_fetch_assoc($th)) { 
        $t = $r['meta_value']; 

        echo $t; 
    } 
}