[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="uk" 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="uk" 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="uk" 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="uk" 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: UK

Printed: 04/03-2021

Range: last 3 months

Limit: highest 25 items

Do you have questions?

If you have any questions about our products, prices, or product range, please do not hesitate to contact us.

Contact us: +45 7482 6565 or info@ledonplay.com