articles

WordPress - get meta data only from "published" articles

i have a dropdown with meta data from posts: <?php $metakey = 'city'; $counties = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT meta_value FROM $wpdb->postmeta AND post_status = published WHERE