$tipo="Academy_Macrofotografia";
$sql= "SELECT ID,post_date, post_title, post_excerpt, guid,meta_value FROM `wp_term_taxonomy` join wp_postmeta join wp_posts join wp_term_relationships join wp_terms where name='".$tipo."' and taxonomy='category' and wp_terms.term_id = wp_term_taxonomy.term_id and wp_term_relationships.term_taxonomy_id=wp_term_taxonomy.term_taxonomy_id and ID=object_id and meta_key='thumb' and post_id=ID order by post_date asc ";
$resulti = mysql_query($sql);
while ($resultati = mysql_fetch_array($resulti))
{
echo "“;
echo “
“.$resultati['post_title'].”
“.$resultati['post_excerpt'].”
“;
echo “
“;
}
?>

