[Clicknum-report]

SELECT ip, timestamp, language, type, component, part, part_language, part_filename, COUNT(ip) as nums, COUNT(DISTINCT ip) as unums FROM dev_stats WHERE language="de" AND type="front-page-box" AND (timestamp > DATE_SUB(now(), INTERVAL 3 MONTH)) GROUP BY component ORDER BY COUNT(DISTINCT component, ip) DESC, COUNT(component) DESC LIMIT 25


SELECT ip, timestamp, language, type, component, part, part_language, part_filename, COUNT(ip) as nums, COUNT(DISTINCT ip) as unums FROM dev_stats WHERE language="de" AND type="customer-case" AND (timestamp > DATE_SUB(now(), INTERVAL 3 MONTH)) GROUP BY component ORDER BY COUNT(DISTINCT component, ip) DESC, COUNT(component) DESC LIMIT 25


SELECT ip, timestamp, language, type, component, part, part_language, part_filename, COUNT(ip) as nums, COUNT(DISTINCT ip) as unums FROM dev_stats WHERE language="de" AND type="catalogue" AND (timestamp > DATE_SUB(now(), INTERVAL 3 MONTH)) GROUP BY component ORDER BY COUNT(DISTINCT component, ip) DESC, COUNT(component) DESC LIMIT 25


SELECT ip, timestamp, language, type, component, part, part_language, part_filename, COUNT(ip) as nums, COUNT(DISTINCT ip) as unums FROM dev_stats WHERE language="de" AND type="product" AND (timestamp > DATE_SUB(now(), INTERVAL 3 MONTH)) GROUP BY component ORDER BY COUNT(DISTINCT component, ip) DESC, COUNT(component) DESC LIMIT 25

Website: DE

Printed: 18/10-2021

Range: last 3 months

Limit: highest 25 items