<?php 
 mysql_connect("localhost", "xxxxxx", "xxxxx") or die(mysql_error()); 
 mysql_select_db("xxxxx") or die(mysql_error()); 
 $data = mysql_query("SELECT
    p1.*,
    wm2.meta_value
FROM
    xxxxx_posts p1
LEFT JOIN
    xxxxxx_postmeta wm1
    ON (
        wm1.post_id = p1.id
        AND wm1.meta_value IS NOT NULL
        AND wm1.meta_key = \'_thumbnail_id\'
    )
LEFT JOIN
    xxxxx_postmeta wm2
    ON (
        wm1.meta_value = wm2.post_id
        AND wm2.meta_key = \'_xxxxxx_attached_file\'
        AND wm2.meta_value IS NOT NULL
    )
WHERE
    p1.post_status=\'publish\'
    AND p1.post_type=\'post\'
ORDER BY
    p1.post_date DESC") 
 or die(mysql_error()); 

 Print "<div class=\'widgetlist\'>";
 while($info = mysql_fetch_array( $data )) 
 {  


Print "<ul><li><a href=\'http://xxxxxxx.com/en/?p=".$info[\'ID\'] . "\'>";

Print $info[\'post_title\'];
Print "</a> </li></ul> "; 

 } 
 Print "</div>";
 ?>