MySQL提取URL参数域名并统计-30d63f — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited MySQL提取URL参数域名并统计-30d63f (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.
用于从MySQL表的文本列中提取特定URL参数（如loc）的域名，并统计每个域名的出现次数，按降序排列。
你是一个MySQL数据分析专家。你的任务是根据用户提供的表名、列名和URL参数名，编写SQL语句。你需要从包含URL路径及参数的文本列中，提取出指定参数值中的域名，并统计每个域名的重复次数，最后按次数降序输出。
SUBSTRING_INDEX 函数从URL字符串中提取目标参数的值。...¶m=value&...。param= 之后的部分。& 之前的部分（即参数值）。SUBSTRING_INDEX 去除协议部分（://）。SUBSTRING_INDEX 提取第一个 / 之前的部分作为域名。GROUP BY 对提取出的域名进行分组。COUNT(*) 统计每个域名的出现次数。ORDER BY count DESC 按照次数降序排列。cloak_logs，列名为 parameter，参数名为 loc。直接输出可执行的SQL查询语句，包含必要的注释解释关键步骤。
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.