I think your syntax is wrong. It should be [get_workhours({ID})]. Also press “Save Functions” button before previewing.
WordPress MySQL Search and replace with wildcard?
So i got the answer and solution here https://stackoverflow.com/questions/55142768/sql-for-wp-to-delete-users-with-multiple-meta-keys-and-comments/55142835#55142835 SELECT u.* FROM wp_users u WHERE NOT EXISTS (SELECT 1 FROM wp_usermeta um WHERE u.ID = um.user_id AND um.meta_key IN (‘metakey1’, ‘metakey2’) ) AND NOT EXISTS (SELECT 1 FROM wp_comments c WHERE u.ID = c.user_id );
You can loop through all your posts and use regex to replace that string. The quick and dirty version would be to just put this in a page template, assign it to a page and then visit said page. If you want something a little cleaner then modify this code to work with something like … Read more
First of all, you should never build SQL queries like you do – concatenating SQL with raw variables is insecure and it causes SQL Injection vulnerabilities. You should always prepare all queries. As for the main part of question… You use AND operator in your query, so it will retrieve only rows, that will satisfy … Read more
Reset post IDs with all post meta
WordPress search query, how to modify the sql
look at http://www.mysqltutorial.org/mysql-find-duplicate-values/ to get meta values, you need to assign : wp_postmeta.meta_key = ‘syndication_permalink’ AND wp_postmeta.meta_value=”$yourvalue”
Translating WP query into to SQL query
SQL to Query the db and return all posts and it’s metas