Differences From Artifact [6fa21312cf]:
- File src/descendants.c — part of check-in [40266bf9b2] at 2023-07-16 20:47:43 on branch verify-options-cgi — Add calls to cgi_check_for_malice() on many more web pages. Log all 418 responses to the error log. (user: drh size: 21937) [more...]
To Artifact [bb63b0429b]:
- File src/descendants.c — part of check-in [9866c97b35] at 2024-06-14 00:06:10 on branch trunk — Temporary fix for a bad query plan caused by issues in SQLite. See [forum:/forumpost/6900455c28dcd3da|forum post 6900455c28dcd3da]. (user: drh size: 21938) [more...]
| ︙ | |||
245 246 247 248 249 250 251 | 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 | - + |
" FROM ancestor, plink, event"
" WHERE plink.cid=ancestor.rid"
" AND event.objid=plink.pid"
" ORDER BY mtime DESC"
" )"
" SELECT ancestor.rid FROM ancestor"
" WHERE EXISTS(SELECT 1 FROM tagxref"
|
| ︙ |