| 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` = '50.16.17.90')
LIMIT 1 |
| INSERT INTO eqdkp_sessions (session_id, user_id, session_start, session_current, session_page, session_ip) VALUES ('211abd7605a325ce879c9161beff5684', '-1', '1369366996', '1369366996', 'viewmember.php?s=&name=Belir', '50.16.17.90') |
| 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` = 'Belir') |
| SELECT COUNT(*) FROM eqdkp_raids WHERE (raid_date BETWEEN 1366700400 AND 1369366996) |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.`raid_id` = r.`raid_id`)
AND (ra.`member_name` = 'Belir')
AND (r.`raid_date` BETWEEN 1366700400 AND 1369366996) |
| SELECT COUNT(*) FROM eqdkp_raids WHERE (raid_date BETWEEN 1364108400 AND 1369366996) |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.`raid_id` = r.`raid_id`)
AND (ra.`member_name` = 'Belir')
AND (r.`raid_date` BETWEEN 1364108400 AND 1369366996) |
| SELECT COUNT(*) FROM eqdkp_raids WHERE (raid_date BETWEEN 1361520000 AND 1369366996) |
| SELECT COUNT(*)
FROM eqdkp_raids AS r, eqdkp_raid_attendees AS ra
WHERE (ra.`raid_id` = r.`raid_id`)
AND (ra.`member_name` = 'Belir')
AND (r.`raid_date` BETWEEN 1361520000 AND 1369366996) |
| 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` = 'Belir')
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` = 'Belir')
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` = 'Belir') |
| 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` = 'Belir')
ORDER BY i.item_date DESC
LIMIT 0,100 |
| SELECT COUNT(*) FROM eqdkp_items WHERE (`item_buyer` = 'Belir') ORDER BY item_date DESC |
| SELECT adjustment_value, adjustment_date, adjustment_reason, member_name
FROM eqdkp_adjustments
WHERE (`member_name` = 'Belir')
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` = 'Belir')
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 |
