Issues » List
Issues
ID  |
Title | Project | Target Version | Status | Last Updated | Manage |
|---|---|---|---|---|---|---|
| #1 | Extra fields - Speed improvements | PHP Classifieds | 7.6 | Implemented | 01/05/2009 | View |
| #2 | Rewrite of code to new css and template system | PHP Classifieds | 7.6 | Implemented | 01/05/2009 | View |
| #3 | SEO optimize | PHP Classifieds | 7.6 | Implemented | 01/05/2009 | View |
| #4 | Remove html-tables used for styling content | PHP Classifieds | 7.6 | Implemented | 01/05/2009 | View |
| #5 | W3C validation of all public pages | PHP Classifieds | 7.6 | Implemented | 01/09/2009 | View |
| #6 | Email notifications after approval only | PHP Classifieds | 7.6 | Implemented | 31/05/2009 | View |
| #7 | Content Management System | PHP Classifieds | 7.6 | Implemented | 21/05/2009 | View |
| #8 | Added option to add users from Admin Area | PHP Classifieds | 7.6 | Implemented | 21/05/2009 | View |
| #9 | Added option to add Ads from Admin Area | PHP Classifieds | 7.6 | Implemented | 26/05/2009 | View |
| #10 | New bannerprogram w. Flash | PHP Classifieds | 7.6 | Implemented | 01/06/2009 | View |
| « Previous123Next » | ||||||
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 i.id ASC LIMIT 0,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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
- 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.035 seconds