Portfolio

Document Management and Document Publishing

12

CPD

It is an Australian Government Building company provides construction, maintenance, and refurbishment services.Admin will be able to upload a word doc/pdf to a board that lists all the recent tendor posts (jobs) and attachments. Provid.....

Live URL: http://www.cpdgroup.com.au/

My Personal Files

A personal goal setting and record keeping website, Document Management system (files and folders) and membership module.All files are stored on AmazonS3 server.

kidzpen

Kidzpen is an online web application development for document publishing solution for schools to use as a repository for student work, which will allow the sharing and comparison of student work. Students will be able to share their work with othe.....

Staging Server URL: http://kidzpen.codegenies.com/
Live URL: http://www.kidzpen.com/

These are informative websites that enables the users to maintain records and save documents online. It basically acts as Documentation Management System storing all your documents over the web.

 

These are employed by companies, government bodies, universities, schools for referencing work and to access information across different dimensions. It acts as a major tool for maintaining personal records, project documentation etc.

12

MindGenies is an Internet services and solutions company with interests in website development – web application development - E-commerce applications– domain name registrations - web hosting– Live chat solution for online sales support and live customer support – Web services. MindGenies offers lucrative reseller programs and affiliate programs.
(default) 59 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `projects`22221
2DESCRIBE `project_categories`330
3DESCRIBE `project_select_categories`441
4DESCRIBE `project_urls`440
5DESCRIBE `category_descriptions`661
6SELECT `ProjectCategory`.`id`, `ProjectCategory`.`name`, `ProjectCategory`.`display_order` FROM `project_categories` AS `ProjectCategory` WHERE `ProjectCategory`.`id` = "29" 110
7SELECT `ProjectSelectCategory`.`id`, `ProjectSelectCategory`.`project_id`, `ProjectSelectCategory`.`category_id`, `ProjectSelectCategory`.`pro_cat_order` FROM `project_select_categories` AS `ProjectSelectCategory` WHERE `ProjectSelectCategory`.`category_id` = "29" 660
8SELECT COUNT(*) AS `count` FROM `projects` AS `Project` inner JOIN project_select_categories AS `PSC` ON (`PSC`.`project_id` = `Project`.`id`) WHERE `Project`.`id` IN (277,34,293,388,214,215) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "29" 110
9SELECT `Project`.*, `PSC`.`pro_cat_order`, `PSC`.`category_id` FROM `projects` AS `Project` inner JOIN project_select_categories AS `PSC` ON (`PSC`.`project_id` = `Project`.`id`) WHERE `Project`.`id` IN (277,34,293,388,214,215) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "29" ORDER BY `PSC`.`pro_cat_order` ASC, `PSC`.`id` ASC LIMIT 3330
10SELECT `CategoryDescription`.`id`, `CategoryDescription`.`catid`, `CategoryDescription`.`description`, `CategoryDescription`.`title`, `CategoryDescription`.`meta_description`, `CategoryDescription`.`meta_keyword` FROM `category_descriptions` AS `CategoryDescription` WHERE `CategoryDescription`.`catid` = "29" 110
11DESCRIBE `project_images`771
12SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`large_image`, `ProjectImage`.`thumb_image`, `ProjectImage`.`created`, `ProjectImage`.`modified`, `ProjectImage`.`status` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = 388 220
13DESCRIBE `project_users`771
14SELECT `ProjectUser`.`id`, `ProjectUser`.`user_name`, `ProjectUser`.`password`, `ProjectUser`.`url`, `ProjectUser`.`user_type`, `ProjectUser`.`project_id`, `ProjectUser`.`user_type_flag` FROM `project_users` AS `ProjectUser` WHERE project_id = 388 and user_type_flag = 2 000
15SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`large_image`, `ProjectImage`.`thumb_image`, `ProjectImage`.`created`, `ProjectImage`.`modified`, `ProjectImage`.`status` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = 214 220
16SELECT `ProjectUser`.`id`, `ProjectUser`.`user_name`, `ProjectUser`.`password`, `ProjectUser`.`url`, `ProjectUser`.`user_type`, `ProjectUser`.`project_id`, `ProjectUser`.`user_type_flag` FROM `project_users` AS `ProjectUser` WHERE project_id = 214 and user_type_flag = 2 000
17SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`large_image`, `ProjectImage`.`thumb_image`, `ProjectImage`.`created`, `ProjectImage`.`modified`, `ProjectImage`.`status` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = 215 220
18SELECT `ProjectUser`.`id`, `ProjectUser`.`user_name`, `ProjectUser`.`password`, `ProjectUser`.`url`, `ProjectUser`.`user_type`, `ProjectUser`.`project_id`, `ProjectUser`.`user_type_flag` FROM `project_users` AS `ProjectUser` WHERE project_id = 215 and user_type_flag = 2 110
19SELECT `ProjectCategory`.*, count(`PSC`.`project_id`) as totalProjects FROM `project_categories` AS `ProjectCategory` left JOIN project_select_categories AS `PSC` ON (`PSC`.`category_id` = `ProjectCategory`.`id`) WHERE 1 = 1 GROUP BY `ProjectCategory`.`id` ORDER BY `ProjectCategory`.`display_order` ASC 38380
20SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "42" 110
21SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "6" 110
22SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "2" 110
23SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "41" 110
24SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "16" 110
25SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "5" 110
26SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "3" 110
27SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "26" 110
28SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "25" 110
29SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "24" 110
30SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "23" 110
31SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "22" 110
32SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "21" 110
33SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "20" 110
34SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "27" 110
35SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "18" 110
36SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "15" 110
37SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "14" 110
38SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "13" 110
39SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "12" 110
40SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "11" 110
41SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "10" 110
42SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "8" 110
43SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "7" 110
44SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "4" 110
45SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "35" 110
46SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "37" 110
47SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "38" 110
48SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "39" 110
49SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "40" 110
50SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "28" 110
51SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "32" 110
52SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "31" 110
53SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "29" 110
54SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "30" 110
55SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "17" 110
56SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "43" 110
57SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "44" 110
58DESCRIBE `keywords`331
59SELECT `Tag`.*, count(`PST`.`project_id`) as totalProjects FROM `keywords` AS `Tag` inner JOIN project_select_keywords AS `PST` ON (`Tag`.`id` = `PST`.`keyword_id`) WHERE 1 = 1 GROUP BY `Tag`.`id` ORDER BY `Tag`.`id` ASC 26260