404 Not Found

PATH: var / www / vhosts / sandbox.dos-group.com / httpdocs / mendrisio

SELECT 
	a.ID AS userid,
	a.user_pass AS passwordhash,
	NULL AS codice_utente,
	a.user_registered AS DataCreazioneUtente,
	b.meta_value AS Nome,
	c.meta_value AS Cognome,
	a.user_email AS Email,  #a.user_email AS Email,
	d.meta_value AS Telefono,
	e.meta_value AS Stato,
	CONCAT(f.meta_value, ' - ', g.meta_value) AS Indirizzo,
	h.meta_value AS CAP,
	i.meta_value AS Citta,
	j.meta_value AS Cantone,
	'si' AS Termini_e_condizioni,
	NULL AS Indirizzo_di_spedizione_differente,
	k.meta_value AS Stato_spedizione,
	CONCAT(l.meta_value, ' - ', m.meta_value) AS Indirizzo_spedizione,
	n.meta_value AS CAP_spedizione,
	o.meta_value AS Citta_spedizione,
	p.meta_value AS Cantone_spedizione,
	NULL AS Circuito_di_pagamento,
	NULL AS Data_scadenza,
	NULL AS NumeroCarta,
	NULL AS AliasCarta,
	NULL AS titolare_carta,
	NULL AS AliasOrderId

FROM 
		`aloy85_users` a, 
		`aloy85_usermeta` b,
		`aloy85_usermeta` c,
		`aloy85_usermeta` d,
		`aloy85_usermeta` e,
		`aloy85_usermeta` f,
		`aloy85_usermeta` g,
		`aloy85_usermeta` h,
		`aloy85_usermeta` i,
		`aloy85_usermeta` j,
		`aloy85_usermeta` k,
		`aloy85_usermeta` l,
		`aloy85_usermeta` m,
		`aloy85_usermeta` n,
		`aloy85_usermeta` o,
		`aloy85_usermeta` p

WHERE 
		a.ID = b.user_id AND
		b.meta_key = 'billing_first_name' AND
		a.ID = c.user_id AND
		c.meta_key = 'billing_last_name' AND
		a.ID = d.user_id AND
		d.meta_key = 'billing_phone' AND
		a.ID = e.user_id AND 
		e.meta_key = 'billing_country' AND
		a.ID = f.user_id AND 
		f.meta_key = 'billing_address_1' AND
		a.ID = g.user_id AND 
		g.meta_key = 'billing_address_2' AND
		a.ID = h.user_id AND 
		h.meta_key = 'billing_postcode' AND
		a.ID = i.user_id AND 
		i.meta_key = 'billing_city' AND
		a.ID = j.user_id AND 
		j.meta_key = 'billing_state' AND
		a.ID = k.user_id AND 
		k.meta_key = 'shipping_country' AND
		a.ID = l.user_id AND 
		l.meta_key = 'shipping_address_1' AND
		a.ID = m.user_id AND 
		m.meta_key = 'shipping_address_2' AND
		a.ID = n.user_id AND 
		n.meta_key = 'shipping_postcode' AND
		a.ID = o.user_id AND 
		o.meta_key = 'shipping_city' AND
		a.ID = p.user_id AND 
		p.meta_key = 'shipping_state'

ORDER BY a.user_registered ASC LIMIT 0, 10;

/*SELECT 
	pm.meta_value AS user_id, 
	pm.post_id AS order_id, 
	t.aliasForDisplay AS NumeroCarta 
		FROM 
			aloy85_postmeta AS pm, 
			aloy85_posts AS p, 
			aloy85_woocommerce_postfinancecw_transactions AS t 
		WHERE 
			pm.post_id = p.ID 
			AND p.post_type = 'shop_order' 
			AND p.post_status = 'wc-completed' 
			AND pm.meta_key = '_customer_user' 
			AND pm.post_id = t.orderId 
		ORDER BY pm.meta_value ASC, pm.post_id DESC 
		LIMIT 0, 10
*/

[-] sct-p.zip [open]
[+] wp-includes
[-] wp-links-opml.php [open]
[-] .htaccess [open]
[+] wp-admin
[-] mendrisio2015db-local-180504.zip [open]
[-] humans.txt [open]
[-] licenza.html [open]
[-] todo-5.zip [open]
[+] ..
[-] wp-blog-header.php [open]
[-] readme.html [open]
[-] staging-db.zip [open]
[-] license.txt [open]
[-] xmlrpc.php [open]
[-] wp-signup.php [open]
[-] wp-config-sample.php [open]
[-] onlyinfo.php [open]
[-] wp-trackback.php [open]
[-] icon.png [open]
[-] wp-config.php [open]
[-] wp-load.php [open]
[-] wp-mail.php [open]
[-] wp-comments-post.php [open]
[-] pm-mailchimp-for-mendrisio.odt [open]
[-] .gitignore [open]
[-] tracciati.xlsx [open]
[-] wp-settings.php [open]
[-] cliente.sql [open]
[-] wp-activate.php [open]
[+] wp-content
[-] index.php [open]
[-] wp-cron.php [open]
[-] wp-login.php [open]