Sitemap

Portfolio

Flash Usage

Eheim

This is an Ecommerce website that deals in aquarium and aquarium accessories. This website will serve wholesale, retail clients and customers who need to purchase aquarium related accessories like water filters (internal and external) and the a.....

Live URL: http://www.eheim.com/

Alexander Nubia

Alexander Nubia is a Canadian company focused on the exploration of precious and base metals in Egypt. Company assets include a wealth of industry and government leadership and feature a diversified portfolio of opportunities: Gold, Silver, Copper.....

Staging Server URL: http://alexandernubia.codegenies.net/
Live URL: http://www.alexandernubia.com/

My Gold Cam

The website is a partial Ecommerce site where the user can sell his or her gold items to the MyGoldCam company and the company will pay according to the current gold prices. The user can video chat with the company to confirm the transaction.

Staging Server URL: http://mygoldcam.codemagicians.in/
Live URL: http://mygoldcam.com/

Category

Notice (8): Undefined variable: CategoryName [APP/views/tags/projects.ctp, line 136]Code | Context                                            {
                                                $categorySlug = $common->createSlug($categoryList[$i]['ProjectCategory']['name']);
                                                if($CategoryName == $categoryList[$i]['ProjectCategory']['name'])
$___viewFn	=	"/home/mindgdg8/public_html/app/views/tags/projects.ctp"
$___dataForView	=	array(
	"keyword_name" => "Flash Usage",
	"slug_name" => "flash-usage",
	"pro_id" => "10",
	"KeywordDesc" => false,
	"ProjectArray" => array(
	array(),
	array(),
	array()
),
	"title_for_layout" => "Flash Usage",
	"meta_description" => null,
	"meta_keyword" => null
)
$loadHelpers	=	true
$cached	=	false
$loadedHelpers	=	array(
	"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/tags/projects/flash-usage/10"
HtmlHelper::$params = array
HtmlHelper::$action = "projects"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__includedScripts = array
HtmlHelper::$_scriptBlockOptions = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"Form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/tags/projects/flash-usage/10"
FormHelper::$params = array
FormHelper::$action = "projects"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"Session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "f224ae9012920fa131d64148001291a5"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1369386286
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/tags/projects/flash-usage/10"
SessionHelper::$params = array
SessionHelper::$action = "projects"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL,
	"Javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/tags/projects/flash-usage/10"
JavascriptHelper::$params = array
JavascriptHelper::$action = "projects"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"Paginator" => PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Project"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/tags/projects/flash-usage/10"
PaginatorHelper::$params = array
PaginatorHelper::$action = "projects"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object,
	"Ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/tags/projects/flash-usage/10"
AjaxHelper::$params = array
AjaxHelper::$action = "projects"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object,
	"Common" => CommonHelper
CommonHelper::$helpers = array
CommonHelper::$cacheDir = "imagecache"
CommonHelper::$base = ""
CommonHelper::$webroot = "/"
CommonHelper::$themeWeb = NULL
CommonHelper::$here = "/tags/projects/flash-usage/10"
CommonHelper::$params = array
CommonHelper::$action = "projects"
CommonHelper::$plugin = NULL
CommonHelper::$data = NULL
CommonHelper::$namedArgs = NULL
CommonHelper::$argSeparator = NULL
CommonHelper::$validationErrors = NULL
CommonHelper::$tags = array
CommonHelper::$__tainted = NULL
CommonHelper::$__cleaned = NULL
CommonHelper::$_log = NULL
CommonHelper::$Html = HtmlHelper object
)
$helpers	=	array(
	"Html",
	"Form",
	"Session",
	"Javascript",
	"Paginator",
	"Ajax",
	"Common"
)
$helperNames	=	array(
	"html",
	"form",
	"session",
	"javascript",
	"paginator",
	"ajax",
	"common"
)
$i	=	0
$common	=	CommonHelper
CommonHelper::$helpers = array
CommonHelper::$cacheDir = "imagecache"
CommonHelper::$base = ""
CommonHelper::$webroot = "/"
CommonHelper::$themeWeb = NULL
CommonHelper::$here = "/tags/projects/flash-usage/10"
CommonHelper::$params = array
CommonHelper::$action = "projects"
CommonHelper::$plugin = NULL
CommonHelper::$data = NULL
CommonHelper::$namedArgs = NULL
CommonHelper::$argSeparator = NULL
CommonHelper::$validationErrors = NULL
CommonHelper::$tags = array
CommonHelper::$__tainted = NULL
CommonHelper::$__cleaned = NULL
CommonHelper::$_log = NULL
CommonHelper::$Html = HtmlHelper object
$ajax	=	AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/tags/projects/flash-usage/10"
AjaxHelper::$params = array
AjaxHelper::$action = "projects"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$paginator	=	PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Project"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/tags/projects/flash-usage/10"
PaginatorHelper::$params = array
PaginatorHelper::$action = "projects"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/tags/projects/flash-usage/10"
JavascriptHelper::$params = array
JavascriptHelper::$action = "projects"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "f224ae9012920fa131d64148001291a5"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1369386286
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/tags/projects/flash-usage/10"
SessionHelper::$params = array
SessionHelper::$action = "projects"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/tags/projects/flash-usage/10"
FormHelper::$params = array
FormHelper::$action = "projects"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/tags/projects/flash-usage/10"
HtmlHelper::$params = array
HtmlHelper::$action = "projects"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__includedScripts = array
HtmlHelper::$_scriptBlockOptions = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$keyword_name	=	"Flash Usage"
$slug_name	=	"flash-usage"
$pro_id	=	"10"
$KeywordDesc	=	false
$ProjectArray	=	array(
	array(
	"Project" => array(),
	"ProjectSelectKeyword" => array()
),
	array(
	"Project" => array(),
	"ProjectSelectKeyword" => array()
),
	array(
	"Project" => array(),
	"ProjectSelectKeyword" => array()
)
)
$title_for_layout	=	"Flash Usage"
$meta_description	=	null
$meta_keyword	=	null
$k	=	3
$projectImageArray	=	array(
	array(
	"ProjectImage" => array()
),
	array(
	"ProjectImage" => array()
)
)
$projectSmallImage	=	"1310392593_FzZmUpWADj_thumb_16.png"
$projectBigImage	=	"1310392593_IPVAOyzFaj_large_16.png"
$projectBigImagePath	=	"http://www.codegenies.com/img/pimages/large/1310392593_IPVAOyzFaj_large_16.png"
$projectNameSlug	=	"my-gold-cam"
$projectsURL	=	array(
	array(
	"ProjectUser" => array()
)
)
$varLiveArray	=	array(
	"http://mygoldcam.com/"
)
$categoryList	=	array(
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
),
	array(
	"ProjectCategory" => array(),
	array()
)
)
$categorySlug	=	"portal-development"
include - APP/views/tags/projects.ctp, line 136
View::_render() - CORE/cake/libs/view/view.php, line 718
View::render() - CORE/cake/libs/view/view.php, line 417
Controller::render() - CORE/cake/libs/controller/controller.php, line 861
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 243
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206
require - APP/webroot/index.php, line 83
[main] - CORE/index.php, line 55

Portal Development(9)
Directory/Listing Websites(16)
Ecommerce(60)
Mobile Application(2)
Facebook Applications(9)
ASP.NET/MSSQL/Microsoft Technology(13)
CMS Sites(64)
Reseller Systems(2)
Real Estate Websites(9)
Social Networking Websites(17)
Portfolio/Showcase Websites(10)
Travel and Holiday Websites(9)
Online Booking and Scheduling(8)
Auction Sites(4)
Shopping Cart(36)
Matchmaking Websites(3)
Education Industry(12)
Health and Nutrition industry(13)
Drupal(2)
Magento(7)
Wordpress(20)
Coupon Websites(8)
Corporate Websites(33)
LAMP/Open Source(72)
Membership Websites(22)
Flash(2)
Sport Websites(4)
Beauty and Fashion(4)
Design Only(8)
Online Billing and Invoicing Applications(1)
Event Listing Websites(5)
Dating Websites(6)
Document Management and Document Publishing(6)
Restaurant Listing Websites(7)
Java(3)
Price comparison(2)
Recent Projects(6)

123

Paypal Payment Gateway, Google Maps API, Photo Gallery , SagePay Payment Gateway, Lucene/Solar Search, Facebook Connect, Flash Usage, Open Cart Shopping Cart, Cubecart Shopping Cart, Virtuemart Shopping Cart, CakePHP Framework, SMS Gateway Integration, Microsite Builders, Google Ad Manager, Ajax, Google Custom Search , Zen Cart, Iphone application, .com.au, .co.uk, Powered by MindGenies, Multi language, Android Application, Joomla, Stationery, Price comparison

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.

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `projects`	22	22	1
2	DESCRIBE `project_categories`	3	3	1
3	DESCRIBE `project_select_categories`	4	4	1
4	DESCRIBE `project_urls`	4	4	0
5	DESCRIBE `keywords`	3	3	1
6	DESCRIBE `project_select_keywords`	4	4	1
7	DESCRIBE `keywords_descriptions`	6	6	1
8	SELECT `Tag`.`id`, `Tag`.`keyword`, `Tag`.`display_order` FROM `keywords` AS `Tag` WHERE `Tag`.`id` = "10"	1	1	0
9	SELECT `ProjectSelectKeyword`.`id`, `ProjectSelectKeyword`.`project_id`, `ProjectSelectKeyword`.`keyword_id`, `ProjectSelectKeyword`.`pro_keyword_order` FROM `project_select_keywords` AS `ProjectSelectKeyword` WHERE `ProjectSelectKeyword`.`keyword_id` = "10" ORDER BY `ProjectSelectKeyword`.`pro_keyword_order` ASC	9	9	0
10	SELECT COUNT(*) AS `count` FROM `projects` AS `Project` LEFT JOIN `project_select_keywords` AS `ProjectSelectKeyword` ON (`ProjectSelectKeyword`.`keyword_id`=10 AND `ProjectSelectKeyword`.`project_id`=`Project`.`id`) WHERE `Project`.`id` IN (11,221,16,35,28,8,293,24,21) AND `Project`.`mindgenies_display_status`="1" AND status = "active"	1	1	0
11	SELECT `Project`., `ProjectSelectKeyword`. FROM `projects` AS `Project` LEFT JOIN `project_select_keywords` AS `ProjectSelectKeyword` ON (`ProjectSelectKeyword`.`keyword_id`=10 AND `ProjectSelectKeyword`.`project_id`=`Project`.`id`) WHERE `Project`.`id` IN (11,221,16,35,28,8,293,24,21) AND `Project`.`mindgenies_display_status`="1" AND status = "active" ORDER BY `ProjectSelectKeyword`.`pro_keyword_order` ASC LIMIT 3	3	3	0
12	SELECT `KeywordsDescription`.`id`, `KeywordsDescription`.`keyid`, `KeywordsDescription`.`description`, `KeywordsDescription`.`title`, `KeywordsDescription`.`meta_description`, `KeywordsDescription`.`meta_keyword` FROM `keywords_descriptions` AS `KeywordsDescription` WHERE `KeywordsDescription`.`keyid` = 10 LIMIT 1	0	0	0
13	DESCRIBE `project_images`	7	7	1
14	SELECT `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` = 8	2	2	0
15	DESCRIBE `project_users`	7	7	1
16	SELECT `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 = 8 and user_type_flag = 2	0	0	0
17	SELECT `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` = 11	2	2	0
18	SELECT `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 = 11 and user_type_flag = 2	1	1	0
19	SELECT `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` = 16	2	2	0
20	SELECT `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 = 16 and user_type_flag = 2	1	1	0
21	SELECT `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	38	38	0
22	SELECT 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"	1	1	0
23	SELECT 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"	1	1	0
24	SELECT 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"	1	1	0
25	SELECT 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"	1	1	0
26	SELECT 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"	1	1	0
27	SELECT 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"	1	1	0
28	SELECT 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"	1	1	0
29	SELECT 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"	1	1	0
30	SELECT 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"	1	1	0
31	SELECT 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"	1	1	0
32	SELECT 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"	1	1	0
33	SELECT 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"	1	1	0
34	SELECT 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"	1	1	0
35	SELECT 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"	1	1	0
36	SELECT 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"	1	1	0
37	SELECT 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"	1	1	0
38	SELECT 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"	1	1	0
39	SELECT 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"	1	1	0
40	SELECT 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"	1	1	0
41	SELECT 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"	1	1	0
42	SELECT 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"	1	1	0
43	SELECT 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"	1	1	0
44	SELECT 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"	1	1	0
45	SELECT 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"	1	1	0
46	SELECT 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"	1	1	0
47	SELECT 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"	1	1	0
48	SELECT 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"	1	1	0
49	SELECT 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"	1	1	0
50	SELECT 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"	1	1	0
51	SELECT 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"	1	1	0
52	SELECT 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"	1	1	0
53	SELECT 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"	1	1	0
54	SELECT 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"	1	1	0
55	SELECT 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"	1	1	0
56	SELECT 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"	1	1	0
57	SELECT 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"	1	1	0
58	SELECT 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"	1	1	0
59	SELECT 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"	1	1	0
60	SELECT `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	26	26	0