YOURLS: Your Own URL Shortener
YOURLS

Jonee Pabiania's Contact Page

Short URL: https://kontak.me/jonee

Long URL: https://kontak.me/public/userprofile.php?uid=493&hash=2[...]

Traffic statistics

Number of hits : Last 24 hours

Historical click count

Short URL created on October 11, 2015 @ 8:30 pm (about 621 days ago)

Best day

129 hits on March 31, 2014. Click for more details

Traffic location

Top 5 countries

Click for more details

Overall traffic

Traffic sources

Referrer shares

Referrers

Direct vs Referrer Traffic

Direct traffic: 6065 hits

Referrer traffic: 640 hits

Share

DB driver: pdo
SELECT `option_name`, `option_value` FROM `yourls_options` WHERE 1=1
SELECT * FROM `yourls_url` WHERE `keyword` = 'jonee'
SELECT `referrer`, COUNT(*) AS `count` FROM `yourls_log` WHERE `shorturl` = 'jonee' GROUP BY `referrer`;
SELECT `country_code`, COUNT(*) AS `count` FROM `yourls_log` WHERE `shorturl` = 'jonee' GROUP BY `country_code`;
SELECT 
		DATE_FORMAT(`click_time`, '%Y') AS `year`, 
		DATE_FORMAT(`click_time`, '%m') AS `month`, 
		DATE_FORMAT(`click_time`, '%d') AS `day`, 
		COUNT(*) AS `count` 
	FROM `yourls_log`
	WHERE `shorturl` = 'jonee'
	GROUP BY `year`, `month`, `day`;
SELECT
		DATE_FORMAT(`click_time`, '%H %p') AS `time`,
		COUNT(*) AS `count`
	FROM `yourls_log`
	WHERE `shorturl` = 'jonee' AND `click_time` > (CURRENT_TIMESTAMP - INTERVAL 1 DAY)
	GROUP BY `time`;
SELECT `option_value` FROM `yourls_options` WHERE `option_name` = 'timezone_string' LIMIT 1