... 'SonyEricsson') THEN 'Smartphone'
ELSE 'Other'
END VisitorBrowser
FROM
custombu_stats_visits a
GROUP BY
a.VisitorIP
ORDER BY
a.DateTimeStamp DESC) t1
GROUP BY
CONCAT(MONTH(t1.Date), ' ', ...
... N 'Smartphone'
WHEN INSTR(a.VisitorUAgent, 'Android') THEN 'Smartphone'
WHEN INSTR(a.VisitorUAgent, 'NetFront') THEN 'Smartphone'
WHEN INSTR(a.VisitorUAgent, 'SonyEricsson') THEN 'Smartphone'
ELSE 'Other'
E ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.