Selected from Linux Selected from PHP
- Ubuntu 17.10 Install google's mod pagespeed for apache - PHP-Ubuntu-Youtube-dl simple script for converting and downloading youtube video or mp3
- Ubuntu SSH tunnel via proxy - PHP while loop with every row with a different color
- Install GoAccess Apache Log Analyzer Tool on Ubuntu 17.10 - PHP use while loop in function
- SSHFS and map folder with a proxy - PHP List Files And Folders As links
- How to connect to SSH server with a proxy - PHP Extract Text From String
➥ SELECT browser as COUNT
Added by sonik on 26-06-2018 and keywords: [ Print Article ]
SELECT browser, COUNT(browser) AS freq FROM
SELECT browser, COUNT(browser) AS freq FROM
(SELECT
CASE
WHEN useragent LIKE '%Chrome%' THEN 'Chrome'
WHEN useragent LIKE '%Safari%' THEN 'Safari'
WHEN useragent LIKE '%Firefox%' THEN 'Firefox'
WHEN useragent LIKE '%MSIE 7%' THEN 'IE7'
WHEN useragent LIKE '%MSIE 8%' THEN 'IE8'
WHEN useragent LIKE '%MSIE 9%' THEN 'IE9'
WHEN useragent LIKE '%MSIE 10%' THEN 'IE10'
WHEN useragent LIKE '%rv:11%' THEN 'IE11'
ELSE 'Other'
END browser
FROM loginhistory) AS browsers
GROUP BY browser
ORDER BY freq DESC

@All rights reserved with Copyright Webleit.info 2018 by Sonik_Blast [ Site Map ] [ RSS ] [ YouTube Mp3 Downloader and converter ]