Discovery Result

Array
(
    [0] => SELECT 
			rpms.path AS rpms_path,
			repofiles.file AS repofiles_file,
			-- repofilesnapshots.discoveries_id AS repofiles_discoveries_id,
			snapshots.snapshot AS snapshots_snapshot,
			snapshots.vendor AS snapshots_vendor,
			reposections.repoid,
			reposections.baseurl,
			reposections.mirrorlist,
			reposections.metalink,
			reposectiondownloads.literalurl,
			reposectiondownloads.results_ts,
			repomdxmls.hashid,
			repomdxmlmirrors.vendor AS mirror_vendor,
			repomdxmlmirrors.path AS mirror_path,
			mirror_snapshots.snapshot AS mirror_snapshot
		-- WE HAVE AN RPM WITH A SECTION FILE THAT WE'RE PROCESSING SO WE FIND THAT FIRST.
		FROM rpms
		JOIN repofiles ON 
			    rpms.path = 'repos/yum/common/redhat/rhel-9.0-x86_64/pgdg-redhat-repo-42.0-63.rhel9PGDG.noarch.rpm'
			AND rpms.sha256 = 'f3dc8595703b95b4b0fbf5885d24bd8aea02fc65117a6e0bd9a5ae62560aaf74'
			AND rpms.id = repofiles.rpms_id
	 		AND repofiles.file = './etc/yum.repos.d/pgdg-redhat-all.repo'
		JOIN repofilesnapshots ON 
			repofiles.id = repofilesnapshots.repofiles_id
			-- AND discoveries_id = NULL
		JOIN snapshots ON 
			rpms.vendor = snapshots.vendor
			AND repofilesnapshots.snapshots_id = snapshots.id
			AND snapshots.vendor = 'postgresql'
			-- We're actually interested in the most recent snapshot with
			-- matching repomd.xml files up to but not later than the snapshot
			-- specified.
			AND snapshots.snapshot <= 'canonical.2026-05-16T12:04:24Z.syncCrawlTree.rg_action'
			AND snapshots.snapshot like 'canonical%'
		JOIN reposections ON 
			reposections.repofiles_id = repofiles.id 
  		AND reposections.repoid = 'pgdg-rhel9-extras-testing-source'
		JOIN reposectiondownloads ON
			reposections.id = reposectiondownloads.reposections_id
			AND snapshots.id = reposectiondownloads.snapshots_id
			-- note that reposectiondownloads can be multiple when multiple attempts were 
			-- made to resolve/download repomd.xml, resulting in different literalurl values.
		JOIN repomdxmls ON
			repomdxmls.id = reposectiondownloads.repomdxmls_id
		LEFT OUTER JOIN 
			(
			repomdxmlmirrors JOIN repomdxmlmirrorsnapshots ON
				repomdxmlmirrors.id = repomdxmlmirrorsnapshots.repomdxmlmirrors_id
			JOIN snapshots mirror_snapshots ON 
				repomdxmlmirrorsnapshots.snapshots_id = mirror_snapshots.id
				AND repomdxmlmirrors.vendor = mirror_snapshots.vendor 
				-- AND mirror_snapshots.ts <= snapshots.ts 
			) ON 
			repomdxmlmirrors.repomdxmls_id = repomdxmls.id
		ORDER BY
			snapshots.ts DESC,
			mirror_snapshots.ts DESC
		LIMIT
			1
)
Called by /home/rgdev/bin/include/repomogrify.php:374