Distribution ʹΞΫηεͨ͠ IP ΞυϨεͷଟ͍ॱΛݕࡧ͢Δ SQL SELECT client_ip, x_edge_location, count(*) AS num FROM cf_log WHERE request_date = '2023-07-11' GROUP BY 1,2 ORDER BY count(*) DESC LIMIT 100;
Distribution ʹΞΫηεͨ͠ IP ΞυϨεͷଟ͍ॱΛݕࡧ͢Δ SQL SELECT client_ip, x_edge_location, count(*) AS num FROM cf_log WHERE request_date = '2023-07-11' GROUP BY 1,2 ORDER BY count(*) DESC LIMIT 100;