Yeah, so: First: you should not use query_posts. No, not even if you need ajax pagination. However, this is not your current problem. To be able to sort the “price on request” Properties to the end of the list regardless of the price-sorting, you simply need to save the “price on request” information in another … Read more
To add a date picker to your code, you should load set jQuery date picker which included in WordPress to load in the product admin page and write some custom JS code which will allow to filter the products by the dates picked. You can load all the products and then filter them with code, … Read more
Ignore posts content in the posts queries for internal linking
Not tested 100% but this might work: SELECT a.post_title, m1.meta_value AS SKU, m2.meta_value AS PRICE FROM wp_posts a LEFT JOIN wp_postmeta m1 ON a.ID = m1.post_id LEFT JOIN wp_postmeta m2 ON a.ID = m2.post_id WHERE a.post_type=”product” AND m1.meta_key=’_sku’ AND m2.meta_key=’_price’ Note that _price field corresponds to the “sale price” (if existing) so you may grab … Read more
Creating a custom WP query for a Custom Post Type
If you load your fonts using standard stylesheet enqueueing then you can add this to your functions.php file: function remove_querystrings( $src ) { $parts = explode( ‘.woff?ver’, $src ); return $parts[0]; } add_filter( ‘style_loader_src’, ‘remove_querystrings’, 15, 1 ); I haven’t tested this but I’m fairly certain it will only work if you’re adding the fonts … Read more
The Answer is: Nothing. These two snippets SHOULD return the same posts. However, there are a lot of things, that can change a query before it is executed: plugins, your own theme by a pre_get_posts Filter. So to check if it is an error in this code or some other code, you can disable all … Read more
Heavy meta query causing SQL crash
At the end I made this work by using Javascript: var currentURL = window.location.href; var prettyURL = currentURL.replace(‘?’, ”).replace(‘state=”, “‘).replace(‘&type=”, “https://wordpress.stackexchange.com/”); window.history.replaceState({}, document.title, “https://wordpress.stackexchange.com/” + prettyURL);
OK, so maybe the above wasn’t worded very well? I have since made some progress as follows: global $wpdb; $current_user = wp_get_current_user(); $uid = $current_user->ID; $fname = $current_user->first_name . ” ” . $current_user->last_name; $email = $current_user->user_email; $studentTable = $wpdb->prefix.’um_metadata’; $result = $wpdb->get_results ( “SELECT * FROM $studentTable WHERE `user_id` = $uid AND ‘um_key’ = ‘student_number’ … Read more