SELECT
	COUNT('x') AS C 
FROM 
	b_iblock B
	INNER JOIN b_lang L ON B.LID=L.LID
	INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
	LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND  FP0.CODE='ADDRESS_UR'
	LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND  FP1.CODE='SITE'
	LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND  FP2.CODE='COMP_EMAIL'
	LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND  FP3.CODE='COMP_PHONE'
	LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND  FP4.CODE='LAST_NAME'
	LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND  FP5.CODE='FIRST_NAME'
	LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND  FP6.CODE='MIDDLE_NAME'
	LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND  FP7.CODE='POSITION'
	LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND  FP8.CODE='EMAIL'
	LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND  FP9.CODE='PHONE'
	LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND  FP10.CODE='INTERESTS'
	LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND  FP11.CODE='POO'
	LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID = B.ID AND  FP12.CODE='IP'
	LEFT JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID = B.ID AND  FP13.CODE='STATUS'
	INNER JOIN b_iblock_property FP14 ON FP14.IBLOCK_ID = B.ID AND  FP14.CODE='CLUSTER'
	LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV4 ON FPV4.IBLOCK_PROPERTY_ID = FP4.ID AND FPV4.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV5 ON FPV5.IBLOCK_PROPERTY_ID = FP5.ID AND FPV5.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV6 ON FPV6.IBLOCK_PROPERTY_ID = FP6.ID AND FPV6.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV7 ON FPV7.IBLOCK_PROPERTY_ID = FP7.ID AND FPV7.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV8 ON FPV8.IBLOCK_PROPERTY_ID = FP8.ID AND FPV8.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV9 ON FPV9.IBLOCK_PROPERTY_ID = FP9.ID AND FPV9.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV10 ON FPV10.IBLOCK_PROPERTY_ID = FP10.ID AND FPV10.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV11 ON FPV11.IBLOCK_PROPERTY_ID = FP11.ID AND FPV11.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV12 ON FPV12.IBLOCK_PROPERTY_ID = FP12.ID AND FPV12.IBLOCK_ELEMENT_ID = BE.ID
	LEFT JOIN b_iblock_element_property FPV13 ON FPV13.IBLOCK_PROPERTY_ID = FP13.ID AND FPV13.IBLOCK_ELEMENT_ID = BE.ID
	INNER JOIN b_iblock_element_property FPV14 ON FPV14.IBLOCK_PROPERTY_ID = FP14.ID AND FPV14.IBLOCK_ELEMENT_ID = BE.ID
WHERE 1=1 
	AND (

		((((BE.IBLOCK_ID = '47'))))
		AND ((((FPV14.VALUE_NUM = '156972'))))
	)
	AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))