SELECT c.`virtuemart_category_id` FROM `#__virtuemart_categories` as c LEFT JOIN `#__virtuemart_category_categories` as cx
			on c.`virtuemart_category_id` = cx.`category_child_id` WHERE c.`published` = 1  AND cx.`category_parent_id` IN (427)Table 'giantsfishing-com.#__virtuemart_categories' doesn't existSELECT count(p.virtuemart_product_id) AS total
			FROM `#__virtuemart_products` p
			LEFT JOIN `#__virtuemart_product_manufacturers` as pm ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
			LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
	
			WHERE pc.`virtuemart_category_id` IN (13,429,430,432,433,434,435,437,438)
			AND p.`published` = "1" Table 'giantsfishing-com.#__virtuemart_products' doesn't exist