Finally able to find out a working solution. The inner join has to join term_taxonomy (where we find the term) to icl_translations with current language. And then from icl_translation to the origin language to get the element_id that then this element_id to term_relationships (where all the product from the origin product_cat are listed). If that … Read more
I think this could be life saver for you . This is a simple function for creating multiple loops. It retrieves a list of latest posts or posts matching criteria. <?php $posts_array = get_posts( $args ); ?> <?php $args = array( ‘numberposts’ => 5, ‘offset’ => 0, ‘category’ => , ‘orderby’ => ‘post_date’, ‘order’ => … Read more
The reason why it wasn’t working was because of my form action. I moved the code to insert data to the search results page and it added the the data to the table like I needed.
The easy way in the admin is to do a 2nd custom query using the post_id from the post object. function custom_posts_data( $posts, $query ) { global $wpdb; if ( !count( $posts ) ) return $posts; while ( $posts as $post ) { $query = “SELECT * FROM {$wpdb->prefix}my_plugin_table WHERE post_id={$post->ID}”; $results = $wpdb->get_results( $query … Read more
WP_Query to show post from a category OR custom field – Not 100% answered
Custom user query – orderby meta_key (that may not exist)
As I am new here too, I can’t comment and ask for clarification or give some suggestions, so I’ll do that here. Why do you have nested repeaters recent_documents and new_document? It appears that recent_documents always has only single row, otherwise there would be a mess. But anyway, working with what you have, you could … Read more
The way to go is apply custom filters to the WP_Query you are running. add_filter(‘posts_clauses’, function ($clauses, $query) { global $wpdb; // only run the filter for a given query // do your checks and return early if (!$query->is_main_query() || !$query->is_post_type_archive(‘tracklist’)) { return $clauses; } $clauses[‘fields’] .= “, COUNT(items.id) AS track_count”; $clauses[‘join’] .= ” LEFT … Read more
I ended up using the the_post hook to add the definitions as the posts are setup. This of course costs another trip to the database for every post but dealing with the duplicate entries proved too difficult. function add_definitions( $post ) { if ( ‘word’ != $post->post_type ) ) return; global $wpdb; $query = “SELECT … Read more
Custom SQL query slows down when using multiple OR … LIKE … in posts_where filter