$sql	=	"SELECT `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`description`, `Category`.`product_type_id`, `Category`.`product_material_id`, `Category`.`created`, `Category`.`modified`, `Product`.`id`, `Product`.`product_code`, `Product`.`name`, `Product`.`description`, `Product`.`product_type_id`, `Product`.`product_material_id`, `Product`.`size`, `Product`.`unit`, `Product`.`milliliters`, `Product`.`neck_diameter`, `Product`.`neck_height`, `Product`.`quantity`, `Product`.`weight`, `Product`.`price`, `Product`.`per`, `Product`.`shipping_price`, `Product`.`created`, `Product`.`modified` FROM `categories_products` AS `CategoriesProduct` LEFT JOIN `categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `products` AS `Product` ON (`CategoriesProduct`.`product_id` = `Product`.`id`)  WHERE `Category`.`id` IN(20,21,22,23,24,25,26,27,28,29) AND `Product`.`id` IN(4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,161,162,163,164,165,166,167,168,169,170,171,173,174,176,177,178,179,180,181,183,184,185,186,187,188,189,192,193,194,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,253,254,255,256,257)   ORDER BY `name` asc  LIMIT 80, 40"
$error	=	"1052: Column 'name' in order clause is ambiguous"
$out	=	null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 512
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 627
Model::find() - CORE/cake/libs/model/model.php, line 1795
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 994
ProductsController::category() - APP/controllers/products_controller.php, line 149
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - ROOT/cri/public_html/index.php, line 87

$id	=	"2"
$name	=	null
$conditions	=	array(
	"Category.id IN(20,21,22,23,24,25,26,27,28,29)",
	"Product.id IN(4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,161,162,163,164,165,166,167,168,169,170,171,173,174,176,177,178,179,180,181,183,184,185,186,187,188,189,192,193,194,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,253,254,255,256,257)"
)
$q	=	"SELECT
			`Product`.`id`
			FROM `products` AS `Product`
			LEFT JOIN `product_types` AS `ProductType` ON (`Product`.`product_type_id` = `ProductType`.`id`)
			LEFT JOIN `product_materials` AS `ProductMaterial` ON (`Product`.`product_material_id` = `ProductMaterial`.`id`)
			WHERE 1=1
			GROUP BY `Product`.`id`"
$categories	=	array(
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
)
)
$categoryIds	=	"20,21,22,23,24,25,26,27,28,29"
$records	=	array(
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
),
	array(
	"Product" => array()
)
)
$ids	=	"4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,161,162,163,164,165,166,167,168,169,170,171,173,174,176,177,178,179,180,181,183,184,185,186,187,188,189,192,193,194,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,253,254,255,256,257"
$data	=	false
$catId	=	null

            
            /* check images against their configurations to see if they need updating*/
            foreach($data as $product)

ProductsController::category() - APP/controllers/products_controller.php, line 171
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - ROOT/cri/public_html/index.php, line 87