Business Relations Search
SELECT cr_id, fromDomain, role, toDomain, path, created_by, created_at
FROM (SELECT cr_id, fromDomain, role, toDomain, path, created_by, created_at FROM br USE INDEX (idx_path_toDomain, idx_path) WHERE LOWER(path) LIKE LOWER(?) AND (fromDomain_reverse LIKE ? OR toDomain_reverse LIKE ?)) AS path_results
ORDER BY cr_id DESC
LIMIT 20
Array
(
[0] => /team/%
[1] => ude.drof%
[2] => ude.drof%
)
3 Parameter4,141.212 msford.edu/team/and20
| ID | From Domain | Role | To Domain | Path | Created |
|---|---|---|---|---|---|
| 6777582 | web.stanford.edu | >>isReferenceFrom | polarizationresearchlab.org | /team/ | 2025-10-14 14:17:50 |
| 6777576 | politicalscience.stanford.edu | >>isReferenceFrom | polarizationresearchlab.org | /team/ | 2025-10-14 14:17:49 |
| 6777574 | ldd.people.stanford.edu | >>isReferenceFrom | polarizationresearchlab.org | /team/ | 2025-10-14 14:17:48 |
| 6777573 | gsb.stanford.edu | >>isReferenceFrom | polarizationresearchlab.org | /team/ | 2025-10-14 14:17:48 |