<?php

$link = mysql_connect('localhost', ' *****', '*****');
if (!$link) {
    die('Ошибка соединения: ' . mysql_error());
}
if (!mysql_select_db('*****')) {
    die('Ошибка выбора базы данных: ' . mysql_error());
}
$result = mysql_query('
SELECT T1.ID, T1.post_name, T1.post_title, T1.guid, T1.meta_key, T1.meta_value, T1.taxonomy, T1.NAME, T2.meta_key, T2.meta_value
FROM (

SELECT wp_posts.ID, wp_posts.post_name, wp_posts.post_title, wp_posts.guid, wp_postmeta.meta_key, wp_postmeta.meta_value, wp_term_taxonomy.taxonomy, GROUP_CONCAT( wp_terms.name ) AS NAME
FROM wp_posts, wp_postmeta, wp_term_relationships, wp_term_taxonomy, wp_terms
WHERE wp_posts.ID = wp_postmeta.post_id
AND wp_postmeta.meta_key = "duration"
AND wp_posts.post_type = "post"
AND wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
AND wp_terms.term_id = wp_term_taxonomy.term_id
AND wp_term_taxonomy.taxonomy = 'category'
AND wp_term_relationships.object_id = wp_posts.ID
GROUP BY wp_posts.post_name, wp_posts.post_title
)T1, (

SELECT post_id, meta_key, meta_value
FROM `wp_postmeta`
WHERE wp_postmeta.meta_key = "thumb"
)T2
WHERE T2.post_id = T1.ID');
if (!$result) {
    die('Ошибка выполнения запроса:' . mysql_error());
}

echo "<table width='100%' border='1'>";
echo "<tr><td>pole1</td><td>pole2</td><td>pole3</td><td>pole4</td><td>pole5</td><td>pole6</td><td>pole7</td><td>pole8</td><td>pole9</td><td>pole10</td></tr>";
while ($row=mysql_fetch_array($result)){
    $pole1=$row[0];
    $pole2=$row[1];
    $pole3=$row[2];
    $pole4=$row[3];
    $pole5=$row[4];
    $pole6=$row[5];
    $pole7=$row[6];
    $pole8=$row[7];
    $pole9=$row[8];
    $pole10=$row[9];


echo "<tr><td>pole1</td><td>pole2</td><td>pole3</td><td>pole4</td><td>pole5</td><td>pole6</td><td>pole7</td><td>pole8</td><td>pole9</td><td>pole10</td></tr>";
}
echo "</table>";

mysql_close($link);


?>

<?php
ini_set('display_errors', '1');
$i=0;

$link = mysql_connect('localhost', 'xnxxdaily_wp', 'lN0qHNY6kuLe');
//print_r($link);
if (!$link) {
    die('MYSQL ERROR: ' . mysql_error());
}
if (!mysql_select_db('xnxxdaily_wp')) {
    die('Wrong select base: ' . mysql_error());
}


$sql = mysql_query("SELECT wp_posts.ID,wp_posts.post_name as post, wp_posts.post_title as title, wp_posts.guid, wp_postmeta.meta_key,wp_postmeta.meta_value 
FROM `wp_posts`,`wp_postmeta`
 WHERE wp_posts.post_type = 'post' 
AND wp_posts.ID = wp_postmeta.post_id 
AND wp_postmeta.meta_key = 'duration' 
 ", $link);
    while ($result = mysql_fetch_array($sql))
 {
//print_r($result);
        echo $result['ID']."| ".$result['post']."| ".$result['title']."| ".$result['guid']."| ".$result['meta_key']."| ".$result['meta_value']."<br>";
    }





mysql_close($link);



?>