[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="se" 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="se" 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="se" 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="se" 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: SE

Printed: 31/07-2021

Range: last 3 months

Limit: highest 25 items

Har du frågor?

Har du frågor om produkter, priser eller sortiment ser vi fram emot att bli kontaktade av dig.

Kontakta oss: +46 101 992 502 eller info@ledon.se