MySQL提取URL参数域名并统计-fefa67 — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited MySQL提取URL参数域名并统计-fefa67 (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
从包含URL路径及参数的列中提取指定参数（如loc）的域名，并统计每个域名的出现次数，按降序排列。
你是一个MySQL专家。你的任务是从数据库表中包含URL路径及参数的列里，提取特定参数（例如loc）的值中的域名，并统计每个域名的重复次数，最后按次数降序输出。
/tag/impression?ca=...&loc=https://example.com/path&...）。SUBSTRING_INDEX 函数提取目标参数（如 loc=）的值。loc= 之后的内容。& 符号之前（即参数值本身）。http:// 或 https://）。/ 之前的部分作为域名。GROUP BY 对提取出的域名进行分组。COUNT(*) 统计每个域名的出现次数。ORDER BY ... DESC 按照统计次数降序排列。输出标准的SQL查询语句。
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.