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. Getting custom taxonomy from custom post type
  3. Media library – Limit images to custom post type
  4. Filter next_post_link() and previous_post_link() by meta_key?
  5. importing third party json feed as custom post type [closed]
  6. how to get posts by custom post type then display Custom fields?
  7. Filtering a WP_Query meta_query by numeric values isn’t working
  8. Populate a ACF Select Dropdown from Custom Post Type
  9. Display related post content and custom field content
  10. How can I save a Custom Post Title and Slug with a Custom Field?
  11. WordPress page not showing up – replaced with last 10 posts?
  12. Custom permalink rewrite rules – how do I fix this?
  13. Custom Field as Custom Post type element class
  14. Extracting Post ID and passing through as an attribute in a shortcode
  15. Best way to have one product in both rental and sale parent category
  16. How do I display specific custom posts, and how do I edit a post’s singular page?
  17. Post that populates itself (almost) automatically using data from imported excel file
  18. Populate custom post type/custom fields from an external database
  19. Fixed custom fields depending on posttype/category
  20. Automatically convert standard posts with custom fields to custom post types
  21. Showing custom post user wise with different color in wordpress
  22. Submit and edit font end custom post type
  23. Group/list/sort custom post type posts by date in tabs from acf datepicker field
  24. How to make a custom search template for custom taxonomy?
  25. Making my custom column sortable
  26. Grouping and paging CPT events by month with custom field date
  27. Can’t pick up a field created with Advanced Custom Fields
  28. How to load custom post type plugin after acf options page (or get settings from there another way)?
  29. Custom post order when using OR relation
  30. Custom post tag images not displaying with ACF
  31. Filter Content on all Post Types
  32. Get month and day from a Date Picker custom field
  33. Advanced Custom Fields – Add Field to Specific Page [closed]
  34. How to query posts by meta keys AND under specific category?
  35. $post breaking container loop
  36. using ACF datepicker to filter posts on a page
  37. Get post id of permalink for a specific custom post type?
  38. how to load custom single.php?
  39. Setting a custom $query->query_vars[‘meta_key’] breaks the WordPress menu
  40. Function that get ACF fields value before saving
  41. Collection of fields in a single post
  42. Modifying and Displaying URL’s in a Post Template using parse_url
  43. If you’re calling a dynamic css inline style does that div have to be in the loop?
  44. How to query the content of a specific custom post type?
  45. If i have custom post type with 5 custom fields do i have to create a new loop to reference each one?
  46. Custom post type adding additional markup
  47. Advanced Custom Fields: query posts filtered by multiple field values
  48. Copying custom field value in to title
  49. Custom Post-type not returning the right child_of
  50. Problem with a query in custom posts
  51. Filtering problem
  52. Multiple while loops not functioning [closed]
  53. How to show animal lineage/pedigree in WordPress?
  54. Custom Post Type Loop breaking php
  55. Register a title automatically with a relationship field
  56. Styling first post using Advanced Custom Fields
  57. WooCommerce – Complete Order when an action occurs
  58. ACF – Query relationship without ID
  59. ACF Relationship: Group posts by parent category term, then child [closed]
  60. ACF Field to set Publish Date – Post Duplication upon Update
  61. Getting ACF relationship field information
  62. WordPress Loop trouble with ACF [closed]
  63. using a template for more then 1 page
  64. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  65. Retrieve a post with its ACF repeater fields in wordpress
  66. Good practical way to do loop within loop to show child custom type using a template code
  67. How to I add count of custom posts listed in a post as a prefix to its title
  68. Is it possible to specify a time interval (from, to) in ACF with date picker, or other custom field?
  69. Why custom search engine only searches in post titles of custom posts?
  70. Filter page ID outside the loop and order
  71. Elementor Custom Query to get Posts by ACF (Post Object Field
  72. Display ACF object field data using Elementor Custom Query
  73. Assign a tag to custom post type using a query
  74. Custom taxonomy meta fields
  75. Create WP multisites as a custom post type
  76. WordPress WP_Query Sort by 2 dates – custom fields
  77. Post object GUID adding http:/
  78. Two custom post type relations
  79. Custom Sort Order for Custom Post Type Taxonomy
  80. Display custom post type attached media file sizes
  81. selecting custom post types and taxonomies for hub page listing blocks
  82. WordPress post objects in one parent post object
  83. Meta query with ACF relationship field
  84. Made a Custom Post Type using ACF. Via the dashboard I cannot see the view button to see the post
  85. Creating a Single Instance Custom Post Type with Limited Module Options using ACF and WPGraphQL
  86. Code output help please! WordPress> ACF > Relationship > Post Object
  87. ACF Pro simple Business Directory – Requesting assistance with created Templates and associated Functions.php Coding
  88. How can I filter records in a custom post type list in the admin based on the ACF field in the post that contains the current user?
  89. WordPress custom post type -> query and sort by custom field with multiple values, then published date
  90. WordPress duplicating posts from single loop
  91. Use Custom Field to Display Post Loop
  92. Query custom fields with three dates – start and end does not work
  93. Custom fields disappearing when a custom post type is assigned
  94. How to automatically update ACF field value every year?
  95. displaying ACF Repeater Fields in Backend sorted by a subfield
  96. Advanced Custom Fields Custom Post Types Heirarchy
  97. Generate Post Title From ACF Fields on Custom Post Type
  98. How do I add a filter to my custom post type archive page?
  99. How to Dynamically Filter Custom Post Types by Taxonomy Based on URL in Elementor Pro and ACF?
  100. ACF – Updating all posts of CPT when a custom field from options page is updated
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)