| Queries |
| SELECT config_name, config_value
FROM eqdkp_config |
| SELECT session_id, session_start, session_current, session_page,
session_ip
FROM eqdkp_sessions AS s
WHERE (`session_id` = '')
AND (`session_ip` = '107.21.186.38')
LIMIT 1 |
| INSERT INTO eqdkp_sessions (session_id, user_id, session_start, session_current, session_page, session_ip) VALUES ('3c4d4e9732d51a9ec5c083c249cb1820', '-1', '1369242852', '1369242852', 'viewmember.php?s=&name=Ziggzaggez', '107.21.186.38') |
| SELECT s.*, c.*
FROM eqdkp_styles AS s, eqdkp_style_config AS c
WHERE (s.`style_id` = c.`style_id`)
AND (s.`style_id` = '5') |
| SELECT auth_value, auth_default AS auth_setting
FROM eqdkp_auth_options |
| SELECT plugin_code, plugin_path, plugin_installed
FROM eqdkp_plugins
ORDER BY plugin_name |
| SELECT member_id, member_name, member_earned, member_spent, member_adjustment,
(member_earned-member_spent+member_adjustment) AS member_current,
member_firstraid, member_lastraid
FROM eqdkp_members
WHERE (`member_name` = 'Ziggzaggez') |
| SELECT COUNT(*) FROM eqdkp_raids WHERE (raid_date BETWEEN 1366614000 AND 1369242852) |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.`raid_id` = r.`raid_id`)
AND (ra.`member_name` = 'Ziggzaggez')
AND (r.`raid_date` BETWEEN 1366614000 AND 1369242852) |
| SELECT COUNT(*) FROM eqdkp_raids WHERE (raid_date BETWEEN 1364022000 AND 1369242852) |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.`raid_id` = r.`raid_id`)
AND (ra.`member_name` = 'Ziggzaggez')
AND (r.`raid_date` BETWEEN 1364022000 AND 1369242852) |
| SELECT COUNT(*) FROM eqdkp_raids WHERE (raid_date BETWEEN 1361433600 AND 1369242852) |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.`raid_id` = r.`raid_id`)
AND (ra.`member_name` = 'Ziggzaggez')
AND (r.`raid_date` BETWEEN 1361433600 AND 1369242852) |
| SELECT COUNT(*) FROM eqdkp_raids WHERE (raid_date BETWEEN 1323241952 AND 1335928426) |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.`raid_id` = r.`raid_id`)
AND (ra.`member_name` = 'Ziggzaggez')
AND (r.`raid_date` BETWEEN 1323241952 AND 1335928426) |
| SELECT r.raid_id, r.raid_name, r.raid_date, r.raid_note, r.raid_value
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.`member_name` = 'Ziggzaggez')
ORDER BY r.raid_date DESC
LIMIT 0,100 |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.`member_name` = 'Ziggzaggez') |
| SELECT i.item_id, i.item_name, i.item_value, i.item_date, i.raid_id, r.raid_name
FROM eqdkp_items AS i LEFT JOIN eqdkp_raids AS r ON r.raid_id = i.raid_id
WHERE (i.`item_buyer` = 'Ziggzaggez')
ORDER BY i.item_date DESC
LIMIT 0,100 |
| SELECT COUNT(*) FROM eqdkp_items WHERE (`item_buyer` = 'Ziggzaggez') ORDER BY item_date DESC |
| SELECT adjustment_value, adjustment_date, adjustment_reason, member_name
FROM eqdkp_adjustments
WHERE (`member_name` = 'Ziggzaggez')
OR (member_name IS NULL AND adjustment_date >= 1323241952)
ORDER BY adjustment_date DESC |
| SELECT e.event_id, r.raid_name, COUNT(ra.raid_id) AS raid_count
FROM eqdkp_events AS e, eqdkp_raid_attendees AS ra, eqdkp_raids AS r
WHERE (e.event_name = r.raid_name)
AND (r.raid_id = ra.raid_id)
AND (ra.`member_name` = 'Ziggzaggez')
AND (r.`raid_date` >= 1323241952)
GROUP BY ra.member_name, r.raid_name |
| SELECT raid_name, COUNT(raid_id) AS raid_count
FROM eqdkp_raids
WHERE (`raid_date` >= 1323241952)
GROUP BY raid_name |
