Changeset View
Changeset View
Standalone View
Standalone View
src/resultset.cpp
Show First 20 Lines • Show All 413 Lines • ▼ Show 20 Line(s) | 406 | LinkedResourcesResults AS ( | |||
---|---|---|---|---|---|
414 | 414 | | |||
415 | FROM | 415 | FROM | ||
416 | ResourceLink from_table | 416 | ResourceLink from_table | ||
417 | 417 | | |||
418 | LEFT JOIN | 418 | LEFT JOIN | ||
419 | ResourceScoreCache rsc | 419 | ResourceScoreCache rsc | ||
420 | ON from_table.targettedResource = rsc.targettedResource | 420 | ON from_table.targettedResource = rsc.targettedResource | ||
421 | AND from_table.usedActivity = rsc.usedActivity | 421 | AND from_table.usedActivity = rsc.usedActivity | ||
422 | AND rl.initiatingAgent = rsc.initiatingAgent | 422 | AND from_table.initiatingAgent = rsc.initiatingAgent | ||
423 | 423 | | |||
424 | $resourceEventJoin | 424 | $resourceEventJoin | ||
425 | 425 | | |||
426 | WHERE | 426 | WHERE | ||
427 | ($agentsFilter) | 427 | ($agentsFilter) | ||
428 | AND ($activitiesFilter) | 428 | AND ($activitiesFilter) | ||
429 | AND ($urlFilter) | 429 | AND ($urlFilter) | ||
430 | AND ($mimetypeFilter) | 430 | AND ($mimetypeFilter) | ||
▲ Show 20 Lines • Show All 157 Lines • Show Last 20 Lines |