User:SDZeroBot/Hot articles query template

{{User:SDZeroBot/Database report/Query template

|sql =

WITH base AS (SELECT rev_id, rev_timestamp

FROM revision

WHERE rev_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL ? DAY), '%Y%m%d%H%i%s')

ORDER BY rev_timestamp

LIMIT 1)

SELECT main.page_title AS Article, COUNT(main.rc_minor) AS Edits, ? As orange_threshold, ? AS red_threshold

FROM (SELECT tt.page_title, rc_minor

FROM recentchanges

JOIN (SELECT a.page_id, a.page_title

FROM categorylinks

JOIN page AS t ON t.page_id = cl_from AND t.page_namespace = 1

JOIN page AS a ON a.page_title = t.page_title AND a.page_namespace = 0

WHERE cl_to = REPLACE(?, ' ', '_')

AND a.page_latest > (SELECT rev_id FROM base)) AS tt ON rc_cur_id = tt.page_id

WHERE rc_timestamp > (SELECT rev_timestamp FROM base)

AND rc_type < 2) AS main

GROUP BY main.page_title

ORDER BY Edits DESC

LIMIT ?

|param_1_name = days

|param_1_type = number

|param_2_name = orange

|param_2_type = number

|param_3_name = red

|param_3_type = number

|param_4_name = category

|param_4_type = string

|param_5_name = limit

|param_5_type = number

|row_template = User:SDZeroBot/Hot articles query template/row

|row_template_named_params = y

|wikilinks = 2

|table_style = overflow-wrap: anywhere; border-width: 0; border-collapse: separate; border-spacing: 0 1px;

|table_class = wikitable

|silent = 1

}}

{{Database report

| extends = User:SDZeroBot/Hot articles query template

| extends_param_days = 7

| extends_param_category = WikiProject Numbers articles

| extends_param_limit = 6

| extends_param_orange = 5

| extends_param_red = 10

| interval = 1

}}