We've not got anything here for you yet!
This site is new and we're not sure what you'll need help with. Please help us out by contacting us and asking us your question. In fact, contact us anyway, we're really lonely internet nerds.
View our blog archives »
SELECT `e`.*, `v`.`avg` as `avg_vote`, `v`.`count` as `vote_count`, `v`.`sum` as `vote_sum`FROM (`101_besthtml5sites_entries` e)LEFT JOIN `101_besthtml5sites_votes_temp` v ON `e`.`id` = `v`.`entry_id`WHERE `e`.`active` = '1'AND `e`.`banned` = '0'GROUP BY `e`.`id`
SELECT `e`.*, `v`.`avg` as `avg_vote`, `v`.`count` as `vote_count`, `v`.`sum` as `vote_sum`FROM (`101_besthtml5sites_entries` e)LEFT JOIN `101_besthtml5sites_votes_temp` v ON `e`.`id` = `v`.`entry_id`WHERE `e`.`active` = '1'AND `e`.`banned` = '0'GROUP BY `e`.`id`ORDER BY `e`.`created` DESCLIMIT 12
DELETE FROM 101_besthtml5sites_onlineWHERE `date` < DATE_SUB(NOW(), INTERVAL 30 SECOND)
DELETE FROM 101_besthtml5sites_onlineWHERE `ip` = '23.20.196.179'AND `agent` = 'Unidentified User Agent'
INSERT INTO 101_besthtml5sites_online (agent, ip) VALUES ('Unidentified User Agent', '23.20.196.179')
SELECT COUNT(*) AS numrows FROM 101_besthtml5sites_online
SELECT COUNT(*) AS numrowsFROM (101_besthtml5sites_online)WHERE `user_id` IS NULL