geocache | memory cache that is suitable for geolocation | Caching library

I'm creating a sort of geocache team building system and I'm having trouble with my query.

To collate and display the individuals against the teams I'm using GROUP_CONCAT, however when I try to include the locations (listed as markers) the individuals names are being duplicated based on the number of markers.

I have put together a SQL Fiddle to explain my workings.

Here is my query:

tldr; My attempts to overwritte the hidden field needed by server to return me a new page of geocaches failed (__EVENTTARGET attributes) , so server return me an empty page.

Ps : My original post was closed du to vote abandon, so i repost here after a the massive edit i produce on the first post.

I try to scrap some webpages which contain cache on a famous geocaching site using Scrapy 1.5.0.

Because you need an account if you want to run this code, i create a new temporary and free account on the website to make some test : dumbuser with password stackoverflow

A) The actual working part of the process :

• First, i enter the website by login page (needed to search page) : https://www.geocaching.com/account/login
• After successful login, i search item (geocaches) in some geographic places (for exemple France, Haute-Normandie).

This first search works without problem, and i have no difficulties to parse the first geocaches.

B) The problem part of the process : requesting next pages

When i try to simulate a click to go to the next page of geocaches. For example going to page 1 to page 2.

The website use ASP with synchronised state between client and server, so we need to go to page1 then page2 then page3 then etc. during the scrap in order to maintain the __VIEWSTATE variable (an hidden input) generated by server between each FORM query.

The link of each number (see the image) call a link with javascript function javascript:__doPostBack(...), which inject content into already existing hidden field before submitting the entire form.

As you can see in the __doPostBack function :

I would like to download HTML webpages from www.geocaching.com in order to scrape some information. However the webpages I want to download have two ways of being displayed depending on whether the user is logged in. The information I want to scrape is only found when the user is logged in.

In the past I have used download.file() and mapply() to download HTML files from a list of URLs (geocache_link_list) and name them using another list (geocache_name_list) like this:

I have this controller