Portfolio

Beauty and Fashion

12

Ageless and Beautiful

The site is a spa and cosmetic surgery website whose aim is to make people look better than they ever were.Their aim to understand the beauty needs to the customer. With the help of images they have shown BEFORE and AFTER difference in the clients.....

Live URL: http://www.agelessandbeautiful.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

Pure Clinica

Pure Clinica

Just wonder how would it be for you to discuss your beauty issues with the experts from the comfort of your room or office, to get to the treatment chair without having to wait in queues for an appointment.

 

These websites provide you the platform to learn more beauty tips and to know the latest fashion trends, what's hot and what's not. The users can discuss their issues with experts and seek advise. These also act as online brochures for the beauty clinics and enlist the treatments being offered. You can easily enroll for an appointment online.

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 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `projects`22221
2DESCRIBE `project_categories`330
3DESCRIBE `project_select_categories`440
4DESCRIBE `project_urls`440
5DESCRIBE `category_descriptions`661
6SELECT `ProjectCategory`.`id`, `ProjectCategory`.`name`, `ProjectCategory`.`display_order` FROM `project_categories` AS `ProjectCategory` WHERE `ProjectCategory`.`id` = "39" 110
7SELECT `ProjectSelectCategory`.`id`, `ProjectSelectCategory`.`project_id`, `ProjectSelectCategory`.`category_id`, `ProjectSelectCategory`.`pro_cat_order` FROM `project_select_categories` AS `ProjectSelectCategory` WHERE `ProjectSelectCategory`.`category_id` = "39" 440
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 (92,21,409,448) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "39" 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 (92,21,409,448) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "39" 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` = "39" 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` = 92 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 = 92 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` = 21 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 = 21 and user_type_flag = 2 110
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` = 409 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 = 409 and user_type_flag = 2 000
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`330
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