Issues » List

Issues

ID	Title	Project	Target Version	Status	Last Updated	Manage
#23	Several banners on same page	PHP Classifieds	7.7	Implemented	03/05/2012	View
#24	Can't delete banner advertisers	PHP Classifieds	7.7	Implemented	03/05/2012	View
#25	Timezone error in PHP v5.3	PHP Classifieds	7.7	Implemented	02/04/2013	View
#19	Print Add	PHP Classifieds	7.7	New	03/05/2012	View
#22	Update language files	PHP Classifieds	7.7	New	03/05/2012	View
« Previous 1 23Next »

Debug

Query History (15 Queries)

SELECT id, category, name, value FROM arctic_config
SELECT p.id, p.tag, pt.name AS type_name FROM arctic_permission p JOIN arctic_permission_type pt ON pt.id = p.type_id WHERE p.default_guest = 1
SELECT id, manager_id, title, description, private, date_added FROM arctic_project ORDER BY title
SELECT id, field_id, model, name, language_category, language_phrase, title, enabled, display_order FROM arctic_issue_column WHERE enabled = 1 ORDER BY display_order
SELECT id, user_id, built_in, title, options FROM arctic_filter WHERE user_id = 0
SELECT COUNT(i.id) AS count FROM arctic_issue i JOIN arctic_project p ON p.id = i.project_id JOIN arctic_issue_status s ON s.id = i.status_id LEFT JOIN arctic_user uadd ON uadd.id = i.user_id_added LEFT JOIN arctic_user uass ON uass.id = i.user_id_assigned WHERE i.project_id IN (1) AND s.hide = 0
SELECT i.id, i.title, i.date_added, i.date_updated, p.id AS project_id, p.title AS project_title, s.title AS status_title, s.prefix AS status_prefix, s.suffix AS status_suffix, s.open AS status_open, tv.number AS version_number, uadd.id AS user_added_id, uadd.username AS user_added_username, uass.id AS user_assigned_id, uass.username AS user_assigned_username FROM arctic_issue i JOIN arctic_project p ON p.id = i.project_id JOIN arctic_issue_status s ON s.id = i.status_id LEFT JOIN arctic_user uadd ON uadd.id = i.user_id_added LEFT JOIN arctic_user uass ON uass.id = i.user_id_assigned LEFT JOIN arctic_project_version tv ON tv.id = i.version_id WHERE ((i.private = 0 AND i.project_id IN (1)) OR (i.private = 1 AND i.project_id IN (0))) AND s.hide = 0 ORDER BY s.title ASC LIMIT 20,10
SELECT v.id, v.issue_id, v.field_id, v.value, f.type FROM arctic_custom_field_value v RIGHT JOIN arctic_custom_field f ON v.field_id = f.id AND v.issue_id IN (23, 24, 25, 19, 22)
SELECT p.id, p.title FROM arctic_project p JOIN arctic_issue i ON i.project_id = p.id WHERE p.id IN (1) ORDER BY p.title
SELECT u.id, u.username FROM arctic_user u JOIN arctic_issue i ON u.id = i.user_id_added ORDER BY u.username
SELECT u.id, u.username FROM arctic_user u JOIN arctic_issue i ON u.id = i.user_id_assigned ORDER BY u.username
SELECT s.id, s.title, s.open FROM arctic_issue_status s JOIN arctic_issue i ON s.id = i.status_id ORDER BY s.title
SELECT DISTINCT s.open FROM arctic_issue_status s JOIN arctic_issue i ON i.status_id = s.id
SELECT v.id, v.number, v.project_id FROM arctic_project_version v JOIN arctic_issue i ON v.id = i.version_id WHERE v.project_id IN (1) ORDER BY v.number
SELECT id, project_id, type, title, default_value, display_order, options, required, filters FROM arctic_custom_field WHERE type IN ("Checkbox", "Dropdown") AND filters = 1 ORDER BY display_order

Statistics

Script Execution Time: 0.074 seconds

Project:	Created By:	Assigned To:
Status:	Open/Closed:	Target Version:

New Filter:
Existing Filters: