如何加入wp_posts和wp_postmeta在wordpress电子商务插件检索仅产品标题，产品描述和价格 - How to join wp_posts and wp_postmeta in wordpress ecommerce plugin retrieving only product title, product description and price?

How to join wp_posts and wp_postmeta in wordpress ecommerce plugin retrieving only product title, product description and price?

我正在使用wp-ecommerce插件为我自己的在线订购面包店(http://www.kingsbakery.mpkproducts.com/)

我不喜欢顾客下单的方式。我想要类似这样的订单(https://www.ssfamousdeli.com/order_ship.aspx)。

我在Mysql中运行一个自定义查询，我只能检索产品标题和描述。我使用以下sql语句:

<?php 
$sql = "SELECT * FROM wp_posts WHERE 
        post_type like 'wpsc_product' AND
        post_status like 'publish' 
        ORDER BY ID Asc";
$query = mysql_query($sql);
?>

我只停留在这里，因为我不知道如何连接wp_postmeta来选择价格。

请帮助。由于

<?php 
$sql = "SELECT wp_p.*, wp_pm.meta_value FROM wp_posts wp_p, wp_postmeta wp_pm WHERE 
        wp_p.post_type like 'wpsc_product' AND
        wp_p.post_status like 'publish' AND
        wp_p.ID = wp_pm.post_id
        wp_pm.key = 'Price' --This should be the meta key
        ORDER BY wp_p.ID Asc";
$query = mysql_query($sql);
?>

希望对大家有所帮助。