You must use a temporary table and an alias: SELECT SQL_CALC_FOUND_ROWS * FROM meruca_posts WHERE ID NOT IN (SELECT ID FROM ( SELECT object_id as ID FROM meruca_term_relationships WHERE term_taxonomy_id IN (14) ) AS temp_object) AND post_type=”post” AND post_status IN (‘publish’,’private’) GROUP BY ID ORDER BY post_date DESC LIMIT 0, 10
The error seems to be connected to the rss url itself, if I use ‘http://seko.se/feed.rss?rssId=97‘ I can’t create new loops beneath it but if I use another url such as ‘http://www.wpbeginner.com/feed/‘ It works. My original feed works just fine in other readers so I have no idea why it does not work in wordpress.
Because I’m also storing the user IDs against each company, office and team post object as user taxonomy I can reverse the query and only include the user IDs assigned to that specific post object. A similar thing to what has been done here – http://mywebsiteadvisor.com/learning/tutorials/building-simple-groups-plugin-for-wordpress-tutorial/step-5/ Only I’ve modified it to be a bit more … Read more
After poking around for a day and half, I found a solution. There was nothing in my theme that was controlling the search result besides the form actions, which were: <!– Search Result Page –> <form action=”<?php echo home_url(“https://wordpress.stackexchange.com/”);?>” method=”get” data-javo-patch-form-for-result> <input type=”hidden” name=”post_type” value=”item”> <input type=”hidden” name=”location” value=”<?php echo $javo_query->get(‘location’);?>” data-javo-sf-location> <input type=”hidden” name=”s” … Read more
I think the problem may be with your wildcards. Because you’re trying to use Wildcards in the prepare, which takes %s, the WPDP doesn’t know the difference between the wildcard % and the placeholder %. Using this answer as reference: How to use wildcards in $wpdb queries using $wpdb->get_results & $wpdb->prepare? You’ll have to double-escape … Read more
If you want best practices of the options you listed use the user meta table. Adding a column to the users table would be the worst thing you could do – messing with table structure of default WP tables is a no-no. The other two options would fall somewhere in between – with adding your … Read more
Query to get number of posts last week
Create Indexes for Slow Queries
WordPress custom setting page – add flashing message
You need to add a tax_query parameter with a relation to do this, $args = array( ‘post_type’ => array(‘my_custom_post’, ‘another_custom_post’), ‘tax_query’ => array( ‘relation’ => ‘AND’, array( ‘taxonomy’ => ‘progression’, ‘field’ => ‘slug’, ‘terms’ => $term->slug, ), array( ‘taxonomy’ => ‘sport’, ‘field’ => ‘term_id’, ‘terms’ => array( 1, 2, 3 ), ‘operator’ => ‘IN’, ), … Read more