INSERT IGNORE INTO dklog_urls (url) VALUES ('group.bmj.com/products/journals');

SELECT id FROM dklog_urls WHERE url='group.bmj.com/products/journals';

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