gctools-outilsgc / gcconnex

			$selects = '';

		}

		if (!$options['count']) {

			$distinct = $options['distinct'] ? "DISTINCT" : "";

			$query = "SELECT $distinct e.*{$selects} FROM {$this->CONFIG->dbprefix}entities e ";

		} else {

			// note: when DISTINCT unneeded, it's slightly faster to compute COUNT(*) than GUIDs

			$count_expr = $options['distinct'] ? "DISTINCT e.guid" : "*";

			$query = "SELECT COUNT($count_expr) as total FROM {$this->CONFIG->dbprefix}entities e ";

		}

		// add joins

		foreach ($joins as $j) {

	// remove identical where clauses

	$wheres = array_unique($wheres);

	if (!$options['count']) {

		$distinct = $options['distinct'] ? "DISTINCT" : "";

		$query = "SELECT $distinct rv.* FROM {$CONFIG->dbprefix}river rv ";

	} else {

		// note: when DISTINCT unneeded, it's slightly faster to compute COUNT(*) than IDs

		$count_expr = $options['distinct'] ? "DISTINCT rv.id" : "*";

		$query = "SELECT COUNT($count_expr) as total FROM {$CONFIG->dbprefix}river rv ";

	}

	// add joins

	foreach ($joins as $j) {