eventespresso / event-espresso-core

		$select_parts = array();

		//loop through registration stati to do parts for each status.

		foreach ( EEM_Registration::reg_status_array() as $STS_ID => $STS_code ) {

			if ( $STS_ID === EEM_Registration::status_id_incomplete ) {

				continue;

			}

			$select_parts[] = "COUNT($STS_code.REG_ID) as $STS_ID";

			$join_parts[] = "$registration_table AS $STS_code ON $STS_code.REG_date = dates.REG_date AND $STS_code.STS_ID = '$STS_ID'";

		}

		//setup the selects

		$select .= implode(', ', $select_parts );

		$select_parts = array();

		//loop through registration stati to do parts for each status.

		foreach ( EEM_Registration::reg_status_array() as $STS_ID => $STS_code ) {

			if ( $STS_ID === EEM_Registration::status_id_incomplete ) {

				continue;

			}

			$select_parts[] = "COUNT($STS_code.REG_ID) as $STS_ID";

			$join_parts[] = "$registration_table AS $STS_code ON $STS_code.EVT_ID = dates.EVT_ID AND $STS_code.STS_ID = '$STS_ID' AND $STS_code.REG_date = dates.REG_date";

		}

		//setup the selects

		$select .= implode( ', ', $select_parts );