MySql Query for WordPress

Try it like this:

$wpdb->get_var("SELECT COUNT(*) FROM $wpdb->usermeta WHERE `meta_key` = 'wp_ul_locked' AND `meta_value` = '1'");

Related Posts:

  1. How to properly insert data into custom table via plugin
  2. Searching users with WP_List_Table plugin
  3. How to write one comment and publish on every post using database or plugin?
  4. How to get number of Affected rows from wordpress dbDelta() function
  5. Display data on Word Press site posts and pages from mysql table
  6. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  7. WpDataTables – View Image Directory
  8. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  9. pagination on data fetched using SQL query
  10. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  11. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  12. How can I fetch data from another website to my wordpress website with mysql database
  13. speed up pagination for huge database
  14. Way to send multiple values for column to MySQL?
  15. How to display results from a data table with an encrypted user id?
  16. Check against server time to display SQL entries – Radio Station DJ Rotator Plugin
  17. add_action for publish_post doesn’t work
  18. WordPress Cache delete on plugin uninstall
  19. need to find duplicated meta value in custom filed and view the posts that have the same value
  20. Getting current user data with MySQL statement
  21. How to get the custom field value using SQL query
  22. WP Function does not trigger on Webhook API Call
  23. Cant create table on plugin activation
  24. How to get database connection details without longing to cpanel in WordPress?
  25. Moving a few select DB tables to a new WP instance
  26. How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?
  27. get/show Last ID
  28. how to search through plugin in wordpress cimy-user-extra-fields?
  29. PHP Creating a formula from mysql db values and db stored math operator
  30. Split Million WordPress Post’s Into Multiple Database Server
  31. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  32. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
  33. Creating 20,000 Posts or Pages using a .csv file?
  34. How to get the active theme’s slug?
  35. Bad Request (Invalid Hostname) on working server, database problem
  36. Errors while using ajax from external wordpress page
  37. shortcode doesn’t work
  38. Setting up widgets in wordpress with a unique ID for the after_title argument
  39. post expire after x days
  40. How to get all events from ‘All in one Events calender’ plugin in JSON format?
  41. cURL error 60: SSL certificate problem: unable to get local issuer certificate
  42. How to Replace Words with Hypertext Link But Ignore Previously Existed Links?
  43. Make specific products accessible only to a user role in WooCommerce
  44. Custom form action to handle data inside a plugin
  45. WP Post Template – Templates in own folder
  46. Apple push notification doesn’t work
  47. Override Plugin Script Fucnction in WordPress
  48. Conditional attributes and logic per product category
  49. Using Wishlist Member and I need to access a user’s status
  50. Subdomains with almost the same content
  51. WordPress page and plugin list using sql query
  52. Using window.onload with Ubermenu
  53. How to include this jQuery File in wordpress?
  54. Mass SQL WordPress Meta Key deletion
  55. dbDelta not adding additional columns in plugin database update
  56. Include a php file from another plugin
  57. Getting taxonomy images to display on single-post with their terms
  58. wp-mail attachment is not sent for no reason?
  59. Switch from wp-cron to a server cron job
  60. WordPress plugin: efficient way to store large data
  61. Theme Functions run a function upon activation or preview
  62. Is this plugin safe to run?
  63. Custom Plugin scripts from admin working in frontend
  64. Some error in mysql script ? Can’t working to create table
  65. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  66. get_post_meta shortcode returns empty field
  67. How to add a prefix to a WordPress post preview url?
  68. i can not access the post in custom template of my wordpress plugin
  69. How to get a specific string from a url
  70. WordPress rewrite rule depend on meta values not ids
  71. Easiest way to load/fire a handful of functions, IF checkbox is checked?
  72. How to avoid the 403 Forbidden error in a WP Plugin with Ajax and PHP
  73. Problem with wordpress has_action() function
  74. Offering a freemium plugin (a free version + paid version)
  75. How To Use htaccess to Rewrite Link Structure for a Page that is Generated Programatcially
  76. WordPress logout appends cache/all/index.php to the site_url()
  77. Change (replace) word in metabox
  78. WordPress environment not loading properly
  79. How to remove a css class for any wordpress page
  80. Creating wordpress admin page panel [Theme Option]
  81. Write mysql credentials in plugin
  82. export high ress images to pdf
  83. Autoloading a PHP class – working outside, but not inside WordPress plugin
  84. Calling an custom field from theme option at the frontend
  85. custom url with custom post
  86. Saving an array to get_options
  87. Variable passed to each() is not an array
  88. Linking Plugin Files to WP
  89. Replace Dash (-) and Underscore ( _ ) with Space
  90. How use Dynamic hyperlink on each wordpress post?
  91. How to execute init or woocommerce_init only for checkout page
  92. how to restore wordpress backup(.rar) manually?
  93. wordpress jquery is not defined because the head tag is empty
  94. Two sites one PC
  95. PHP if url extension action=discussion condition use [closed]
  96. How can I save the selected page in the dropdown after anyone clicks on Save Changes?
  97. Posts in Admin only display 1 Post instead of all Post in admin area
  98. How can I save the selected page in the dropdown after anyone clicks on Save Changes?
  99. WordPress Throwing Deprecated Errors on its own Files
  100. plugin doesn’t retrieve data from database