Referer like
Request URI like
Time before
SELECT
time_stamp AS
FROM access_log al
JOIN cookies al_c
ON al.id=al_c.id
AND al_c.item='Apache'
WHERE time_stamp <= UNIX_TIMESTAMP()
AND -(-line) <
AND al.agent=
AND al.referer=
AND al.remote_host=
AND al.status=
AND al.request_uri=
AND al.time_stamp=
AND al.virtual_host=
AND al.referer LIKE
AND al.request_uri LIKE
AND al.time_stamp < UNIX_TIMESTAMP()
AND al.request_uri NOT LIKE
AND al_c.val=
ORDER BY time_stamp DESC
LIMIT 1
SELECT main.line + 1 AS
FROM access_log main
JOIN access_log al
ON al.line BETWEEN
AND main.line
ON 1 = 0
JOIN cookies main_c
ON main.id=main_c.id
AND main_c.item='Apache'
JOIN cookies al_c
ON al.id=al_c.id
AND al_c.item='Apache'
WHERE 1=1
AND main.line >=
AND al.line >=
AND al.agent=
AND al.referer=
AND al.remote_host=
AND al.status=
AND al.request_uri=
AND al.time_stamp=
AND al.virtual_host=
AND al.referer LIKE
AND al.request_uri LIKE
AND al.time_stamp < UNIX_TIMESTAMP()
AND al.request_uri NOT LIKE
AND al_c.val=
AND main.agent=
AND main.referer=
AND main.remote_host=
AND main.status=
AND main.request_uri=
AND main.time_stamp=
AND main.virtual_host=
AND main.referer LIKE
AND main.request_uri LIKE
AND main.time_stamp < UNIX_TIMESTAMP()
AND main.request_uri NOT LIKE
AND main_c.val=
GROUP BY main.line
HAVING MOD(COUNT(1), 20) = 0
ORDER BY main.line DESC
SELECT
al.remote_host AS ,
FROM_UNIXTIME(al.time_stamp) AS ,
al.request_method AS ,
al.request_uri AS ,
al.status AS ,
al.bytes_sent AS ,
al.referer AS ,
al.agent AS ,
c.val AS ,
al.id AS ,
al.child_pid AS ,
al.cookie AS ,
al.machine_id AS ,
al.request_file AS ,
al.remote_logname AS ,
al.remote_user AS ,
al.request_duration AS ,
al.request_line AS ,
al.request_protocol AS ,
al.request_time AS ,
al.request_args AS ,
al.server_port AS ,
al.ssl_cipher AS ,
al.ssl_keysize AS ,
al.ssl_maxkeysize AS ,
al.time_stamp AS ,
al.virtual_host AS ,
al.line AS
FROM access_log al
LEFT
JOIN cookies c
ON al.id=c.id
AND c.item='Apache'
WHERE 1=1
AND al.agent=
AND al.referer=
AND al.remote_host=
AND al.status=
AND al.request_uri=
AND al.time_stamp=
AND al.virtual_host=
AND al.referer LIKE
AND al.request_uri LIKE
AND al.time_stamp < UNIX_TIMESTAMP()
AND c.val=
AND al.request_uri NOT LIKE
AND al.line <
ORDER BY al.line DESC
LIMIT 20