I think I guessed how their SQL query look like ...
-
I'm looking for all the Carhartt retailers in my city.<br>
What do I so ? Go to their website and use their "Stores" pages. I enter my country "France" and city "Paris" and wait for the results...
Firs results seem okay. But then I get a store that's in Saint Denis / La Réunion...
In case you knot know, the store is exactly here : https://maps.google.com/maps?q=Rue+Marechal+Leclerc+97460+Saint+Denis+la+Reunion&hl=en&ie=UTF8&sll=37.0625,-95.677068&sspn=39.644047,86.572266&hnear=Rue+du+Mar%C3%A9chal+Leclerc,+Centre,+St+Denis,+Saint-Denis,+Reunion&t=m&z=16
There's another shop that's not in Paris either (but not that far either)
Then I looked at the stores' names...
-
Is this a cunning advert for Carhartt WIP, but worded cleverly to make it appear like it's supposed to be a WTF at first glance?
On a more serious note, surely this is just a case of multiple places sharing the same name. You know, that thing we all exacerbated with European colonialism.
Why do you have so many "Rue Marechal Leclerc" in France?
For some reason that particular entry on the Carhartt page has the postal code 97460, rather than one of your Parisian 70000 range ones. That's a bit strange.
-
The problem, in cas you didn't see it, is that they returned far away place because they had Paris in the name of the shop. They could at least limit themselve to the adress, if they can't make the match only on the city.
-
@setasensei said:
Then I looked at the stores' names...
Well, the search field is pretty clearly marked "City, Postal Code or Store Name". It's returning exactly what it should be returning.
-
@NoOneImportant said:
@setasensei said:
Then I looked at the stores' names...
Well, the search field is pretty clearly marked "City, Postal Code or Store Name". It's returning exactly what it should be returning.
My bad then.
Just felt so wrong when I saw it ...