Sitemap

Portfolio

Microsite Builders

Healthline24x7

Healthline24x7(A religare company) is India's largest health-care Portal. It is a one-stop destination for in-depth and exhaustive patient centric information on healthcare. The consumer can search a comprehensive and a .....

Staging Server URL: http://religare.codegenies.com/
Live URL: http://www.healthline24x7.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" => "Microsite Builders",
	"slug_name" => "microsite-builders",
	"pro_id" => "18",
	"KeywordDesc" => false,
	"ProjectArray" => array(
	array()
),
	"title_for_layout" => "Microsite Builders",
	"meta_description" => null,
	"meta_keyword" => null
)
$loadHelpers	=	true
$cached	=	false
$loadedHelpers	=	array(
	"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/tags/projects/microsite-builders/18"
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/microsite-builders/18"
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 = 1368956864
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/tags/projects/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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 = 1368956864
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/tags/projects/microsite-builders/18"
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/microsite-builders/18"
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/microsite-builders/18"
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	=	"Microsite Builders"
$slug_name	=	"microsite-builders"
$pro_id	=	"18"
$KeywordDesc	=	false
$ProjectArray	=	array(
	array(
	"Project" => array(),
	"ProjectSelectKeyword" => array()
)
)
$title_for_layout	=	"Microsite Builders"
$meta_description	=	null
$meta_keyword	=	null
$k	=	1
$projectImageArray	=	array(
	array(
	"ProjectImage" => array()
),
	array(
	"ProjectImage" => array()
)
)
$projectSmallImage	=	"1310377490_4sUBAWjz3G_thumb_61.png"
$projectBigImage	=	"1310377490_zHf5Db7rm9_large_61.png"
$projectBigImagePath	=	"http://www.codegenies.com/img/pimages/large/1310377490_zHf5Db7rm9_large_61.png"
$projectNameSlug	=	"healthline24x7"
$projectsURL	=	array(
	array(
	"ProjectUser" => array()
)
)
$varLiveArray	=	array(
	"http://www.healthline24x7.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)

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	0
4	DESCRIBE `project_urls`	4	4	1
5	DESCRIBE `keywords`	3	3	0
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` = "18"	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` = "18" ORDER BY `ProjectSelectKeyword`.`pro_keyword_order` ASC	1	1	0
10	SELECT COUNT(*) AS `count` FROM `projects` AS `Project` LEFT JOIN `project_select_keywords` AS `ProjectSelectKeyword` ON (`ProjectSelectKeyword`.`keyword_id`=18 AND `ProjectSelectKeyword`.`project_id`=`Project`.`id`) WHERE `Project`.`id` IN (61) AND `Project`.`mindgenies_display_status`="1" AND status = "active"	1	1	1
11	SELECT `Project`., `ProjectSelectKeyword`. FROM `projects` AS `Project` LEFT JOIN `project_select_keywords` AS `ProjectSelectKeyword` ON (`ProjectSelectKeyword`.`keyword_id`=18 AND `ProjectSelectKeyword`.`project_id`=`Project`.`id`) WHERE `Project`.`id` IN (61) AND `Project`.`mindgenies_display_status`="1" AND status = "active" ORDER BY `ProjectSelectKeyword`.`pro_keyword_order` ASC LIMIT 3	1	1	1
12	SELECT `KeywordsDescription`.`id`, `KeywordsDescription`.`keyid`, `KeywordsDescription`.`description`, `KeywordsDescription`.`title`, `KeywordsDescription`.`meta_description`, `KeywordsDescription`.`meta_keyword` FROM `keywords_descriptions` AS `KeywordsDescription` WHERE `KeywordsDescription`.`keyid` = 18 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` = 61	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 = 61 and user_type_flag = 2	1	1	0
17	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
18	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
19	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
20	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
21	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
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` = "16"	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` = "5"	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` = "3"	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` = "26"	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` = "25"	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` = "24"	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` = "23"	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` = "22"	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` = "21"	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` = "20"	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` = "27"	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` = "18"	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` = "15"	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` = "14"	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` = "13"	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` = "12"	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` = "11"	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` = "10"	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` = "8"	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` = "7"	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` = "4"	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` = "35"	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` = "37"	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` = "38"	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` = "39"	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` = "40"	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` = "28"	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` = "32"	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` = "31"	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` = "29"	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` = "30"	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` = "17"	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` = "43"	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` = "44"	1	1	0
56	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