MattArch

I’m working on a solution. There seems to be a problem with it not reading the updated variable. Will update if fixed. This isn’t asking for help (just editing an overeager solution I posted)

$onlyThis;
    $pageURL = $_SERVER[REQUEST_URI];
    if (strpos($pageURL, "URL_STORE_NAME")!==false){
        $onlyThis = "WHERE store LIKE 'STORE_NAME'";
    }
    else {
       $onlyThis = "WHERE store NOT LIKE 'STORE_NAME'";
    }

    $result = $wpdb->get_results(
                    $wpdb->prepare( "
                                    SELECT *, ( $distance_unit * acos( cos( radians( %s ) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians( %s ) ) + sin( radians( %s ) ) * sin( radians( lat ) ) ) )
                                    AS distance FROM $wpdb->wpsl_stores $onlyThis
                                    $sql_part
                                    ",
                                    $placeholders
                    )
                );

As this is modifying the plugin, just remember you won’t be able to update.

That’s perfect, thanks.