$show_info = $pdo("SELECT p.*, pm.*
                   FROM wp_posts p
                   JOIN wp_postmeta pm ON p.post_id = pm.meta_id
                   WHERE p.post_type = 'wpcproduct'"
                 );