LOCK TABLES `hl_hitstats` WRITE, `hl_hitscounter` READ Table './softhyip_hlspro@002dtemp5/hl_hitscounter' is marked as crashed and last (automatic?) repair failed
select listing_id, date, (date = current_date()) is_today, sum(1) as hosts, sum(hits) hits from hl_hitscounter group by listing_id, date Table './softhyip_hlspro@002dtemp5/hl_hitscounter' is marked as crashed and last (automatic?) repair failed
delete from hl_hitscounter where date + interval 1 day < now() Table './softhyip_hlspro@002dtemp5/hl_hitscounter' is marked as crashed and last (automatic?) repair failed