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. Getting custom taxonomy from custom post type
  2. Media library – Limit images to custom post type
  3. Filter next_post_link() and previous_post_link() by meta_key?
  4. Automatically fill custom field value on post publish/update
  5. Make permalinks based on an ACF-field
  6. Create Pages from Database
  7. List events by month
  8. Use Custom Post Type as Custom Field
  9. Pull image from ACF field in a Custom Post Type
  10. Show ACF field from custom taxonomy and display on the single template
  11. Get Custom Field Values by Another Custom Field in WordPress
  12. wp_update_post based function works on existing posts, but not new posts
  13. How to Display ACF Relationship Custom Field as Link to Specific Custom Post?
  14. Show custom field from custom taxanomy term on custom post type
  15. How to create an array for a CPT post ID to use in an IF/WHILE statement
  16. Custom Post type with ACF in REST API, how do I get those values?
  17. wpdb custom post_type problem
  18. How to: Display ACF [fields] on Custom Post Types Utilising WordPress ‘Hooks’? [closed]
  19. Insert post metadata for all posts in CPT at once if metadata no existent
  20. Convert simple SQL Query to WordPress query
  21. Problem with WordPress query on page using custom fields
  22. Custom Taxonomy terms aren’t getting referenced or saved in Quick Edit or Bulk Edit, only on Single product page?
  23. WP_Query to select custom post type with Advanced Custom Fields (ACF) date
  24. Bulk Update Custom Fields for Custom Post Types
  25. ACF Values Don’t Show After Import Unless I Edit/Update Post
  26. Troubles with acf/save_post and WP_Query
  27. Query custom post type with ACF Date
  28. Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
  29. CPT archive admin menu label
  30. Order Custom Post Type by Custom Field Value
  31. Assign External Database Queries to Global Variables and Make Them Accessible
  32. Query Custom Post Type Taxonomy term with multiple parameters
  33. Custom fields (wp_post_meta) vs Custom Table for large amount of data
  34. wp_insert_post sometimes fails after API call
  35. Order post by date with ACF
  36. WebP Fallback for Inline Background Image in Style Attribute
  37. Adavnced custom fields relationship query plus query inside
  38. Proper way to display latest 5 posts grouped by post type?
  39. Recoverable Fatal Error – Object of class WP_Post could not be converted to string
  40. Querying & displaying custom post type into an existent page [closed]
  41. Custom post type showing same Post on all Pages
  42. Front end access to a SQL data repository – recommended way?
  43. Post loop count is not in order
  44. How to inherit field value from parent post into in child / sub post
  45. Update post if exist from PHP
  46. How to use single.php for creating, reading and editing Custom Posts with ACF
  47. posttype and custom fields on multisite
  48. Advanced custom fields Post Object image field not displaying in custom post type single.php
  49. How do I show a link or ‘Read More’ button on a custom field excerpt when it is less than the word limit
  50. I’m trying to create a custom version of the wp_list_authors function that includes custom post types
  51. Custom fields not showing in custom post type
  52. meta query not retrieving posts
  53. New post from database
  54. Using WP meta query to show custom post types by a start and finish date
  55. Convert Custom Taxonomy Posts to Normal Posts
  56. Advanced custom field – posted fields from custom post type
  57. Why doesnt my tag page populate with this custom post type?
  58. How to set a ‘page’ as parent of a custom post type?
  59. Custom front-end form for adding post – Category problem
  60. Create/populate Custom Posts ACF fields from external JSON file
  61. WordPress URL rewrites using Advanced Custom Field
  62. Custom Post Type and Structure Question
  63. Query posts by current ACF meta key value on single page as related posts
  64. Custom post type and custom taxonomy key lenght & query performance
  65. Show custom post type event if current day using ACF
  66. How to access repeater field of a custom field?
  67. Filter posts by their related field’s custom field
  68. If ACF Post Object post has custom taxonomy term…
  69. Changing default admin column sorting to an ACF Date Picker field
  70. Why is this function so slow?
  71. Permalink URL connection between two custom types
  72. Sql Update CPT from publish to draft and particular custom field
  73. Wrapping an unknown amount of posts inside separate HTML Containers during WP_Query loop
  74. Show specific posts with WP_Query using ACF Post object
  75. Dropwdown: Get taxonomy terms from posts that share preselected terms from 3 other taxonomies
  76. Autofill advanced custom field with user data
  77. Advanced search form with multiple custom fields
  78. Custom post type option page template
  79. Some permalinks on Apache/localhost development setup return 404’s when set to anything other than plain permalinks
  80. How to get a custom post type archive paged when using a custom field for post sorting?
  81. save_post affect creation and deletion
  82. Can’t pick up a field created with Advanced Custom Fields
  83. How to query posts by meta keys AND under specific category?
  84. using ACF datepicker to filter posts on a page
  85. how to load custom single.php?
  86. Setting a custom $query->query_vars[‘meta_key’] breaks the WordPress menu
  87. Function that get ACF fields value before saving
  88. How to query the content of a specific custom post type?
  89. Copying custom field value in to title
  90. Custom Post-type not returning the right child_of
  91. Filtering problem
  92. Register a title automatically with a relationship field
  93. ACF – Query relationship without ID
  94. ACF Relationship: Group posts by parent category term, then child [closed]
  95. Is it possible to specify a time interval (from, to) in ACF with date picker, or other custom field?
  96. Display ACF object field data using Elementor Custom Query
  97. Post object GUID adding http:/
  98. ACF Pro simple Business Directory – Requesting assistance with created Templates and associated Functions.php Coding
  99. Custom fields disappearing when a custom post type is assigned
  100. Advanced Custom Fields Custom Post Types Heirarchy