Portfolio

CMS Sites

Home and Bargains

A CMS driven website used by a London based Media Group for promoting their clients and offers. The CMS is used to publish articles to various categories and create a database of basic online business listing that is .....

Staging Server URL: http://homebargains.codegenies.net/
Live URL: http://www.homesandbargains.co.uk/

Film Bazaar

Informative website for Indian film market, additional features for interested participants to sign up/register with the website by submitting their information. Leads database and backend for content management.

Staging Server URL: http://filmbazaartest.codegenies.com/
Live URL: http://filmbazaarindia.com/

HeberDavis Skin Clinic

An Informative website for Haber Davis Skin Clinic is one of the original and most visited cosmetic practices in Australia. This professional looking & neat corporate site is truly representative of the business & acts as an online brochur.....

Staging Server URL: http://haberskinclinic.codegenies.com/
Live URL: http://heberdavis.com.au

Content management system or CMS website development services are globally hired owing to the fact that it streamlines work process. This service is completely based on simplifying the concept of editinmg content. In order to enhance the quality of your websites content hire CMS services from a professional CMS development company. Only a professional company will provide services related to editing, deleting and updating content. With this service, you can also keep a track of content updated or edited from your website. CMS developers develop your website in such a way that it becomes user-friendly and further inculcates rich content.

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 15 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `projects`22221
2DESCRIBE `project_categories`330
3DESCRIBE `project_select_categories`440
4DESCRIBE `project_urls`441
5DESCRIBE `category_descriptions`660
6SELECT `ProjectCategory`.`id`, `ProjectCategory`.`name`, `ProjectCategory`.`display_order` FROM `project_categories` AS `ProjectCategory` WHERE `ProjectCategory`.`id` = "3" 110
7SELECT `ProjectSelectCategory`.`id`, `ProjectSelectCategory`.`project_id`, `ProjectSelectCategory`.`category_id`, `ProjectSelectCategory`.`pro_cat_order` FROM `project_select_categories` AS `ProjectSelectCategory` WHERE `ProjectSelectCategory`.`category_id` = "3" 74741
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 (11,26,193,108,7,107,196,63,351,39,42,35,48,315,28,299,23,27,30,41,266,283,57,384,51,55,4,31,65,184,281,56,386,92,21,47,29,33,110,377,378,64,272,411,422,405,417,421,117,40,419,428,427,267,250,122,355,301,13,121,445,352,302,305,446,443,435,444,450,447,304,350,25,58) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "3" 112
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 (11,26,193,108,7,107,196,63,351,39,42,35,48,315,28,299,23,27,30,41,266,283,57,384,51,55,4,31,65,184,281,56,386,92,21,47,29,33,110,377,378,64,272,411,422,405,417,421,117,40,419,428,427,267,250,122,355,301,13,121,445,352,302,305,446,443,435,444,450,447,304,350,25,58) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "3" ORDER BY `PSC`.`pro_cat_order` ASC, `PSC`.`id` ASC LIMIT 3333
10SELECT `CategoryDescription`.`id`, `CategoryDescription`.`catid`, `CategoryDescription`.`description`, `CategoryDescription`.`title`, `CategoryDescription`.`meta_description`, `CategoryDescription`.`meta_keyword` FROM `category_descriptions` AS `CategoryDescription` WHERE `CategoryDescription`.`catid` = "3" 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` = 117 221
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 = 117 and user_type_flag = 2 111
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` = 108 221
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 = 108 and user_type_flag = 2 111
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` = 21 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 = 21 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