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` = 'product_discount_option' AND meta_value = 1"

Related Posts:

  1. Filter by custom field in custom post type on admin page
  2. Filtering a WP_Query meta_query by numeric values isn’t working
  3. Populate a ACF Select Dropdown from Custom Post Type
  4. Filter a custom field based on selection of another custom field (ACF) [closed]
  5. WordPress Search documentation: how to improve search query using taxonomy terms, custom meta fields?
  6. Meta Query “IN” doesn’t work with ACF checkbox filter
  7. Retrieve a specific field from taxonomy term through advanced custom fields [closed]
  8. Count custom post types with a specific meta value
  9. How do I write this SQL statement for Posts written in last 24 hours?
  10. Change message given when deleting post from custom post type
  11. Building an Advanced Search (text, tags, category, custom fields) – Getting the wrong SQL query
  12. Display posts if a custom field value is equal to another custom field value
  13. ACF Upload Image in repeater from front-end with custom form? – add_post_meta()
  14. Query to change custom post type with specific category
  15. Calculating Bayesian average for custom post type
  16. Query Custom Post Types by date (custom field) range
  17. ACF simple text field value not showing
  18. Post Object Filter by Custom Field, not title (ACF)
  19. Rewrite WordPress URL to show CPT meta field data
  20. Custom Post type and Custom Field WP_Query
  21. Display multiple custom post types and sort them chronological by one of their fields
  22. Adding custom tables to WordPress
  23. Multiple ACF Repeaters within a Custom Post Type
  24. How to change post featured image using a custom field of category?
  25. Custom fields vs. Custom post types for a Portfolio Website
  26. Add custom ID to CPT posts only create not update
  27. WP_Query order by custom field, then randomly order some of results
  28. How to render a custom post type template with custom fields using shortcode
  29. How to query WordPress posts bycustom field with a max characters’ length
  30. Function causing the loop display posting more (empty)
  31. The loop seems stuck to a single (now deleted) post
  32. Custom Post Types vs. Advanced Custom Fields (with Repeater Field add-on)
  33. Specific routing for CPT
  34. How To Import CPT With Only Few TEXT ACF Fields From Front End?
  35. Advanced custom field boolean value in custom post type
  36. Why would social icon badges disappear after adding a custom post type?
  37. ACF repeater field usage
  38. Navigate posts with different post type that are in the same categories
  39. List of users that clicked a ‘Join’ button at single post
  40. set_query_params using custom params defined in functions file?
  41. Custome fields not displayed
  42. How to define the template for custom posts?
  43. Batch Extract Date from post title and put into ACF custom field
  44. Query entries from custom post type in an ACF flexible content field
  45. How do I get_the_postID() for a custom post that uses ACF repeater field?
  46. How to export custom post type with ACF to individual file with automation?
  47. Custom post types, disable fields
  48. ACF Relationship Posts how to show additional content
  49. Limit search field to just search a custom post type with custom fields
  50. $wpdb is queried but results don’t show
  51. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  52. How can i show ACF in post excerpts
  53. Fetch data of 2 relational Custom Post in WordPress
  54. count & sum the value of custom field of the author post in dynamic posts
  55. Grouping custom wordpress post types by acf value
  56. Set Post Private if no linked Post Objects (ACF)
  57. Show in an entry a Custom Post Type associated to a post
  58. Orderby custom fields is not working
  59. Display a Custom Post Type with Advanced Custom Fields on Homepage
  60. Filter result of Custom Post Type using meta_query with ACF
  61. How to display posts with plugin (advanced custom fields) field groups?
  62. WordPress – display relationship between blog posts and custom posts
  63. Same custom post type with different ACF
  64. Custom sorting in post columns by ACF Pro Select Field
  65. Load info from customposttype into template page
  66. Subpages URLs for Custom Post Type
  67. Custom post type not pulling CSS
  68. ACF meta_key and meta_value break loop
  69. search results to show individual ACF fields from inside custom posts
  70. Videos Post Type with Custom Filters
  71. How to show link to product in custom fields?
  72. In the admin, how can you list thumbnails instead of titles for a custom post type?
  73. Use output of wp_dropdown_categories($args)
  74. Looping through image object using ACF and CPT UI [SOLVED]
  75. Values show up in custom home page but not in custom post pages
  76. Display related post content and custom field content
  77. WordPress page not showing up – replaced with last 10 posts?
  78. Custom permalink rewrite rules – how do I fix this?
  79. Best way to have one product in both rental and sale parent category
  80. How do I display specific custom posts, and how do I edit a post’s singular page?
  81. Post that populates itself (almost) automatically using data from imported excel file
  82. Showing custom post user wise with different color in wordpress
  83. Submit and edit font end custom post type
  84. How to make a custom search template for custom taxonomy?
  85. How to load custom post type plugin after acf options page (or get settings from there another way)?
  86. Custom post order when using OR relation
  87. Filter Content on all Post Types
  88. Advanced Custom Fields – Add Field to Specific Page [closed]
  89. $post breaking container loop
  90. Collection of fields in a single post
  91. Problem with a query in custom posts
  92. Multiple while loops not functioning [closed]
  93. WooCommerce – Complete Order when an action occurs
  94. WordPress Loop trouble with ACF [closed]
  95. using a template for more then 1 page
  96. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  97. Retrieve a post with its ACF repeater fields in wordpress
  98. Good practical way to do loop within loop to show child custom type using a template code
  99. Two custom post type relations
  100. selecting custom post types and taxonomies for hub page listing blocks