Informes

From wiki pixelame.net

[edit] Links by day

total noticias:

SELECT COUNT(*),DAY(`link_date`),MONTH(`link_date`),WEEKDAY(`link_date`)
FROM `links`
GROUP BY DAY(`link_date`),MONTH(`link_date`),YEAR(`link_date`)
ORDER BY YEAR(`link_date`) DESC,MONTH(`link_date`) DESC,DAY(`link_date`) DESC

votos anonimos:

SELECT COUNT(*),DAY(`vote_date`),MONTH(`vote_date`),WEEKDAY(`vote_date`)
FROM `votes`
WHERE
`vote_type`='links' AND
`vote_user_id`='0'
GROUP BY DAY(`vote_date`),MONTH(`vote_date`),YEAR(`vote_date`)
ORDER BY MONTH(`vote_date`) DESC,DAY(`vote_date`) DESC