INSERT IGNORE INTO dklog_urls (url) VALUES ('academiclifeinem.blogspot.com');

SELECT id FROM dklog_urls WHERE url='academiclifeinem.blogspot.com';

INSERT INTO dklog_offsiteclicks (url_id, user_id, click_when) VALUES (30, 0, NOW());