نقاش ويكيبيديا:مشروع ويكي الصيانة/بدون إنترويكي (نسخة أولية)

SQL

# todo: make it by day
/*
select distinct log_title from logging 
where log_type like "delete" and log_action like "delete" 
and log_timestamp > (NOW() - INTERVAL 1 MONTH) and log_namespace = 0
limit 1000
*/

/*
select ips_item_id from wb_items_per_site
where ips_site_id like "enwiki" and ips_site_page in (
	'Vega flight VV11', 'Vega flight VV12', 'Vega flight VV10', 'Vega flight VV07', 'Vega flight VV05', 'Vega flight VV14', 'Vega flight VV09', 'Vega flight VV04', 'Vega flight VV18', 'Vega flight VV03', 'Vega flight VV08', 'Vega flight VV20', 'Vega flight VV02', 'Vega flight VV17', 'Vega flight VV06', 'Vega flight VV13', 'Vega VV10', 'Vega VV09', 'Vega VV17', 'Vega VV14', 'VV18', 'Vega VV13', 'Vega VV12', 'VV20', 'VV11', 'Vega VV11', 'VV12', 'Vega VV19', 'VV04', 'VV02', 'VV09', 'Vega VV05', 'Vega VV06', 'Vega VV08', 'VV17', 'VV08', 'VV07', 'VV19', 'Vega VV18', 'Vega VV20', 'VV14', 'Vega VV07', 'VV13', 'Vega VV02', 'VV06', 'Vega VV03', 'VV10', 'VV05', 'Awadh Behari', 'Miss Nicaragua Supranational', 'Advocate general (EU)', 'General Catalyst Partners', 'General Catalyst', 'Mark Worthington (journalist)', 'Drumchannel.com', 'DrumChannel.com', 'Finland-Kurdistan Region relations', 'Filipinos in Honduras', 'David Davidson (engineer)', 'Herbert Aldersmith', 'Melvin Harris', 'Aman Gandhi (actor)', 'Gertrud van Grest', 'Gregory Marchand', 'Nadia Najjari', 'Westlake Middle School', 'Dr. Nadia Najjari', 'Queen of the Mask', 'Ahmed Abdulhakim Al-Hemyari', 'BackRoad Gee', 'Adams, Indiana', 'Štěpánov', 'Deepak Sharma (Jailor)', 'Jay Strack', 'Raghavendra Suhas', 'Bharat Singh Kundanpur', 'Gulab Kamro', 'Heeralal Nagar', 'Joshua Schleien', 'Srushti Jayant Deshmukh', 'Gurmeet Singh Kooner', 'Indraj Singh Gurjar', 'List of Indian wushu players', 'Moshari', 'Mufassil Islam', 'Neeraj Nayar', 'Reetu Sattar', 'Sadia Khalid', 'Mahachandra Prasad Singh'
)
limit 10
*/
select * from wb_items_per_site limit 10;
/*
select ips_item_id from wb_items_per_site
where ips_site_id like "enwiki" and ips_site_page in (
	4566582, 116257598, 52253, 111724841, 116149733, 106650126, 116413063, 116054439, 1711581, 116179098, 550333, 116257338, 61467449
)
limit 10
*/
SQL

Checking query status...
