In Wordpress, I wish to replace the database query for any certain page having a query that retrieve all of the posts of the certain custom publish type. I attempted while using parse_query hook, however i can't have it works: the SQL I print in publish_request hook contain an= wordpress_3_posts.ID = x clause which makes the query return nothing. I question if there's a wayto do this apart from writing my very own plain SQL query.

Thx.