# Wordpress - AMF SQL Query help

**URL:** <https://forum.kirupa.com/t/wordpress-amf-sql-query-help/282479>\
**Category:** programming\
**Created:** [February 22, 2009, 8:37pm UTC](https://forum.kirupa.com/t/wordpress-amf-sql-query-help/282479 "2009-02-22T20:37:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dail](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@dail](https://forum.kirupa.com/u/dail)\
**Post date:** [February 22, 2009, 8:37pm UTC](https://forum.kirupa.com/t/wordpress-amf-sql-query-help/282479/1 "2009-02-22T20:37:17Z")

</div>

Hi,

Ok, I’m trying to query a wordpress install and return posts that use a particular category.

I have an SQl query that does work, when run in phpMyAdmin, but am having trouble translating it into PHP code that works with AMFPHP.

Heres the SQL

```php
SELECT p.post_title, wpr.object_id, wp_terms.name
		FROM wp_terms
		INNER JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id
		INNER JOIN wp_term_relationships wpr ON wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
		INNER JOIN wp_posts p ON p.ID = wpr.object_id
		WHERE taxonomy = "category"
		AND p.post_type = 'post'
		ORDER BY object_id
		LIMIT 0 , 30

```

**Edit - Figured it out.!**