BRT-Search

SELECT cr_id, fromDomain, role, toDomain, path, created_by, created_at 
                        FROM ((SELECT cr_id, fromDomain, role, toDomain, path, created_by, created_at, fromDomain_reverse, toDomain_reverse
                                FROM br FORCE INDEX (idx_fromDomain_reverse)
                                WHERE fromDomain_reverse LIKE ? LIMIT 40) UNION (SELECT cr_id, fromDomain, role, toDomain, path, created_by, created_at, fromDomain_reverse, toDomain_reverse
                                FROM br FORCE INDEX (idx_toDomain_reverse)
                                WHERE toDomain_reverse LIKE ? LIMIT 40) UNION (SELECT cr_id, fromDomain, role, toDomain, path, created_by, created_at, fromDomain_reverse, toDomain_reverse
                                FROM br FORCE INDEX (idx_fromDomain_reverse)
                                WHERE fromDomain_reverse LIKE ? LIMIT 40) UNION (SELECT cr_id, fromDomain, role, toDomain, path, created_by, created_at, fromDomain_reverse, toDomain_reverse
                                FROM br FORCE INDEX (idx_toDomain_reverse)
                                WHERE toDomain_reverse LIKE ? LIMIT 40)) AS combined_results 
                        ORDER BY fromDomain_reverse DESC, toDomain_reverse DESC 
                        LIMIT 20