#sHeretext#:  #sHOMEtext#     #sCattext#

SELECT id, name, category_level, category_id FROM categories WHERE category_level = 0

	#sCattext#				#sProdtext#
	SELECT category_id, status_id, security_id FROM cases WHERE ((category_id = #id#) OR (category_id IN (SELECT id FROM categories WHERE category_id = #id#)) OR (category_id IN (SELECT id FROM categories WHERE category_id IN (SELECT id FROM categories WHERE category_id = #id# ) ) )) #STATUS_LEVEL# #SECURITY_LEVEL# SELECT id, name, category_id FROM categories WHERE (category_id = #id#)  #name# (#get_inc_recordcount.recordcount#) SELECT category_id, status_id, security_id FROM cases WHERE ((category_id = #get_subcategories.id#) OR (category_id IN (SELECT id FROM categories WHERE category_id = #get_subcategories.id#))) #STATUS_LEVEL# #SECURITY_LEVEL# #get_subcategories.name# (#get_inc_recordcount2.recordcount#)