Custom Fields are normally fetched in a single query to the database, so fetching 1 or 10 isn’t going to make a lot of difference in performance of your WordPress site. The problem is with doing complex meta queries on existing custom fields; that’s when your site would see a performance hit. Obvious, isn’t it? … Read more
Try meta_value_num ‘meta_key’ => ‘metadata1’, ‘orderby’ => ‘meta_value_num’ Add these 2 parameters to $args. This does the sorting considering metadata1 as numeric
I think a good way to do what you want is hook the wp_insert_post_data filter. Here you can change the title and slug of the post before it is saved to database: add_filter( ‘wp_insert_post_data’, ‘wpse_update_post_title_and_slug’ ); function wpse_update_post_title_and_slug( $data ) { //You can make some checks here before modify the post data. //For example, limit … Read more
here is the mysql query you can use to get the result having distance less then your value. SELECT * , pm1.meta_value as latitude, pm2.meta_value as longitude , (((acos(sin(([latitude]*pi()/180)) * sin((pm1.meta_value * pi()/180)) + cos(([latitude]*pi()/180)) * cos((pm1.meta_value * pi()/180)) * cos((([longitude] – pm2.meta_value)* pi()/180))))*180/pi())*60*1.1515 ) as distance FROM wp_posts p JOIN wp_postmeta pm1 ON pm1.post_id … Read more
‘orderby’ => ‘date meta_value_num’, ‘meta_key’ => $meta_key, ‘order’ => ‘DESC’
Meta_query and numeric comparison [closed]
Including Database Generated Pages in Site Search [closed]
$songQuery = new WP_Query(‘meta_query’ => array( array( ‘key’ => ‘song-id’, ‘value’ => ‘song id value here’, ‘compare’ => ‘=’ ) )); You can use above code to query with custom field then use loop to get the contents.
For anyone who may have a similar need, I solved this the following way (on authors.php): First I get the author ID: $author = get_user_by( ‘slug’, get_query_var( ‘author_name’ ) ); // ID is accessed this way: $author_id = $author->ID; I then created a custom query: $query = ” SELECT p.* FROM $wpdb->postmeta m JOIN $wpdb->posts … Read more
The solution is: global $wpdb; $terms = get_terms(“TAXONOMY_TERM”); $count = count($terms); if ( $count > 0 ){ foreach ( $terms as $term ) { $querystr = ” SELECT count(ID) as count FROM $wpdb->posts LEFT JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) WHERE exists ( SELECT * FROM $wpdb->postmeta WHERE … Read more