zZzzZ. — /home2/zrzvbdry/couponetive.com/wp-content/themes/savings-pro-main/inc/core

Editing: search.php

<?php
class  WPCoupon_Search{

function __construct() {
    	if ( ! is_admin()  ) {
		    add_action( 'pre_get_posts', array( $this, 'init' ) );
	    }
    }

if ( is_search() || ( isset( $_REQUEST['c_s_store'] ) && $_REQUEST['c_s_store'] != '' ) ) {

add_filter('posts_where', array($this, 'where'));
            add_filter('posts_join', array($this, 'join'));
            add_filter('posts_groupby', array($this, 'groupby'));
            if ( ! is_admin() ) {
                add_filter('posts_orderby', array($this, 'orderby'));
                add_filter('posts_distinct',  array( $this, 'distinct' ) );
            }

}
    }

return $where;
    }

function join($join){
        global $wpdb;

$join = "LEFT JOIN {$wpdb->term_relationships} AS tr ON {$wpdb->posts}.ID = tr.object_id
        LEFT JOIN {$wpdb->term_taxonomy} AS tt ON tt.term_taxonomy_id=tr.term_taxonomy_id
        LEFT JOIN {$wpdb->terms} AS t ON t.term_id = tt.term_id";

return $join;
    }

function groupby($groupby){
        global $wpdb;

$groupby = "{$wpdb->posts}.ID";

return $groupby;
    }

function orderby( $orderby ){
        global $wpdb;
        $orderby = " t.name DESC, {$wpdb->posts}.post_title ";
        return $orderby;
    }

function distinct( $distinct ){
        return $distinct;
    }

}

new WPCoupon_Search();