Skip to content

Instantly share code, notes, and snippets.

@adamplabarge
Created October 3, 2016 20:15
Show Gist options
  • Save adamplabarge/11da680d43b3ab53fe0146a8084ac156 to your computer and use it in GitHub Desktop.
Save adamplabarge/11da680d43b3ab53fe0146a8084ac156 to your computer and use it in GitHub Desktop.
<?php
add_action('genesis_before', function() {
global $wpdb;
$post_type = 'product';
$query = "
SELECT DISTINCT($wpdb->postmeta.meta_key)
FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta
ON $wpdb->posts.ID = $wpdb->postmeta.post_id
WHERE $wpdb->posts.post_type = '%s'
AND $wpdb->postmeta.meta_key != ''
AND $wpdb->postmeta.meta_key NOT RegExp '(^[_0-9].+$)'
AND $wpdb->postmeta.meta_key NOT RegExp '(^[0-9]+$)'
";
$meta_keys = $wpdb->get_col($wpdb->prepare($query, $post_type));
dump($meta_keys);
});
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment