Wordpress page query

public text v1 · immutable

#216857

·published 2006-10-23 09:54 UTC

<div id="rightcol">
<?php
 $pagepages = $wpdb->get_results("SELECT wpages.* FROM $wpdb->pages wpages, $wpdb->postmeta wpostmeta
    WHERE wpages.ID = wpostmeta.post_id AND wpostmeta.meta_key = 'tag' AND wpostmeta.meta_value = 'contactform' AND 
    wpages.post_status = 'publish' AND wpages.post_date < NOW() ORDER BY wpages.post_date DESC", OBJECT);
 ?>
</div>