SQL query – get ids – Advanced Custom Fields / WPeC
Thanks for your help s_ha_dum, I had a look at the table structure using phpMyAdmin, ACF Plugin saves fields to the postmeta table, so sb_wpsc_meta needed to be changed to sb_postmeta. also needed to change what was being SELECT to post_id aswell as the meta_value to 1. final query; “SELECT post_id FROM sb_postmeta WHERE `meta_key` … Read more