Help me with a sample of records from another blog.

[rosemadder]

I'd like to remove from the other blog all the footage and certain values of the arbitrary fields and the miniature of the record. How do you even do that?

This type

[Рубрика]
    [миниатюра записи] [название и линк] [дата записи] [произвольное значение] [произвольное значение]
    ...
[Рубрика]

...

It's clear that through wpdb, but what would SELECT look like? I don't want to come out of a few queries, but I don't know what to do.

[emran]

To meet this challenge by one SELECT The request is sufficient to use the normal http://www.k-press.ru/cs/2009/3/join/join.asp#ID0EHLAC ♪

This is an example of a sample of the name, date of publication and contents of the particular logic from the WordPress database. As soon as I say, this request was not chosen for use on this CMS website at the time. That's why. $wpdb It doesn't appear.

SELECT `post_title`,`post_date`, `post_content` FROM `wp_terms` AS `t1`
INNER JOIN `wp_term_taxonomy` AS `t2` ON t1.term_id=t2.term_id
INNER JOIN `wp_term_relationships`AS t3 ON t2.term_taxonomy_id=t3.term_taxonomy_id
INNER JOIN `wp_posts` AS t4 ON t4.ID=t3.object_id
WHERE t2.taxonomy='category' AND t1.term_id=1;

Besides, I think this example will be very clear about the substance of the decision and you will be able to refine it for your purpose.

Just in case, http://codex.wordpress.org/Database_Description the description of BDE-Press in official documentation.