DJ-Catalog directory - Магазины, электронная коммерция, доски объявлений

     	$par =& $mainframe->getParams('com_djcatalog');
		$limit		= $par->get('limit_items');
		$limitstart	= JRequest::getVar('limitstart', 0, '', 'int');

     	$par =& $mainframe->getParams('com_djcatalog');
		$limit		= $par->get('limit_items_show');
		$limitstart	= JRequest::getVar('limitstart', 0, '', 'int');

               $query = "SELECT COUNT(*) FROM #__djcat_items WHERE (cat_id NOT IN (SELECT c.id FROM #__djcat_categories c)) OR (i.producer_id NOT IN (SELECT p.id FROM #__djcat_producer p))";

		$query = "SELECT COUNT(*) FROM #__djcat_items WHERE (cat_id NOT IN (SELECT c.id FROM #__djcat_categories c)) OR (producer_id NOT IN (SELECT p.id FROM #__djcat_producer p))";

parent_категория
-> подкатегория_1
-> подкатегория_2