Error: Table 'product' is marked as crashed and should be repaired<br />Error No: 1194<br />
		SELECT c.*
		, cd.*
		#, count(p.product_id) AS `cnt`
		
		,(SELECT COUNT(parent_id) 
					FROM category 
					WHERE parent_id = c.category_id 
					AND status = '1' ) AS children 
		FROM category c 
		
		LEFT JOIN category_description cd 
		ON (c.category_id = cd.category_id) 
		
	

		#INNER JOIN product p
		#ON p.p_category_id = c.category_id
		
		
		WHERE c.parent_id = '140' 
		AND c.status = '1' 
		AND cd.language_id = '1' 
		
		HAVING (
					c.category_id IN (SELECT p_category_id FROM product WHERE status=1)
		OR children > 0
		)
		
		#GROUP BY c.category_id
		
		ORDER BY c.sort_order, cd.name