[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="dk" 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="dk" 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="dk" 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="dk" 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: DK

Printed: 05/03-2021

Range: last 3 months

Limit: highest 25 items

Har du spørgsmål?

Har du spørgsmål til vores produkter, priser, eller sortiment, ser vi frem til at høre fra dig.

Kontakt os: 74 82 65 65 eller info@ledon.dk