I have a custom query set up for a website that’s ordering the posts by the 2nd word of the post title (they are names, so it’s ordering by last names). My custom query is working perfectly in wordpress 3.7, but in 3.8 it does absolutely nothing. This is the code I wrote:<\/p>\n
function custom_get_posts($query) {\n\n\tif (is_category()) {\n\n\t\tglobal $wpdb;\n\t\tglobal $post;\n\n\t\tif(is_category(14)) {\n\n\t\t\t$querystr = "\n\t\t\tSELECT DISTINCT wposts.ID\n\t\t\tFROM $wpdb->posts wposts\n\t\t\t\tLEFT JOIN $wpdb->postmeta wpostmeta ON wposts.ID = wpostmeta.post_id\n\t\t\t\tLEFT JOIN $wpdb->term_relationships ON (wposts.ID = $wpdb->term_relationships.object_id)\n\t\t\t\tLEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)\n\t\t\tWHERE $wpdb->term_taxonomy.term_id IN ('14')\n\t\t\t\tAND wposts.post_status='publish'\n\t\t\tORDER BY SUBSTR(LTRIM(wposts.post_title), LOCATE(' ', LTRIM(wposts.post_title))) ASC\n\t\t\t";\n\n\t\t\t$pageposts = $wpdb->get_results($querystr, OBJECT);\n\n\t\t\t$pageposts_arr = array();\n\t\t\tforeach ($pageposts as $pagepost) {\n\t\t\t\tarray_push($pageposts_arr, $pagepost->ID);\n\t\t\t}\n\n\t\t\tif($query->is_main_query()) {\n\t\t\t\t$query->query_vars['post__in'] = $pageposts_arr;\n\t\t\t\t$query->query_vars['orderby'] = 'post__in';\n\t\t\t}\n\n\t\t} elseif (is_category(24)) {\n\t\t\tif($query->is_main_query()) {\n\t\t\t\t$query->query_vars['orderby'] = 'modified';\n\t\t\t}\n\t\t}\n\n\t}\n\n\treturn $query;\n}\nadd_filter('pre_get_posts', 'custom_get_posts');<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-4432042","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4432042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4432042\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4432042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}