CB9TOIIIA · April 18, 2017 12:54
diff --git a/optimization JBZoo Zoo b/optimization JBZoo Zoo
 \administrator\components\com_zoo\controllers\item.php 

 //110 line - function display

 // $select = 'a.*, EXISTS (SELECT true FROM '.ZOO_TABLE_CATEGORY_ITEM.' WHERE item_id = a.id AND category_id = 0) as frontpage';

 $select = 'a.id,a.name,a.application_id,a.type,a.alias,a.created,a.modified,a.modified_by,a.publish_up,a.publish_down,a.priority,a.hits,a.state,a.access,a.created_by,a.created_by_alias,a.searchable,a.params, EXISTS (SELECT true FROM '.ZOO_TABLE_CATEGORY_ITEM.' WHERE item_id = a.id AND category_id = 0) as frontpage';
	\administrator\components\com_zoo\controllers\item.php

	//110 line - function display

	// $select = 'a.*, EXISTS (SELECT true FROM '.ZOO_TABLE_CATEGORY_ITEM.' WHERE item_id = a.id AND category_id = 0) as frontpage';

	$select = 'a.id,a.name,a.application_id,a.type,a.alias,a.created,a.modified,a.modified_by,a.publish_up,a.publish_down,a.priority,a.hits,a.state,a.access,a.created_by,a.created_by_alias,a.searchable,a.params, EXISTS (SELECT true FROM '.ZOO_TABLE_CATEGORY_ITEM.' WHERE item_id = a.id AND category_id = 0) as frontpage';