INSERT IGNORE INTO dklog_urls (url) VALUES ('journals.lww.com/jtrauma/pages/default.aspx');

SELECT id FROM dklog_urls WHERE url='journals.lww.com/jtrauma/pages/default.aspx';

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