Percent recent changes using timeless
ActivePublic
Actions

Authored by Bawolff on Mar 28 2019, 6:56 PM.

Edit Paste
Archive Paste
View Raw File
Mute Notifications
Award Token
Flag For Later

Tags

None

Referenced Files

	F28500183: raw.txt
	Mar 28 2019, 6:56 PM

Subscribers

None

	select ifnull(up_value, 'no pref set') 'skin', (count()100)/(select count(*) from user left join user_properties on up_user =user_id and up_property = 'skin' inner join recentchanges on rc_user = user_id and rc_type <= 3 and rc_user <> 0 ) 'percent of edits' from user left join user_properties on up_user =user_id and up_property = 'skin' inner join recentchanges on rc_user = user_id and rc_type <= 3 and rc_user <> 0 group by up_value order by 2 desc ;

select ifnull(up_value, 'no pref set') 'skin', (count(*)*100)/(select count(*) from user left join user_properties on up_user =user_id and up_property = 'skin' inner join recentchanges on rc_user = user_id and rc_type <= 3 and rc_user <> 0 ) 'percent of edits' from user left join user_properties on up_user =user_id and up_property = 'skin' inner join recentchanges on rc_user = user_id and rc_type <= 3 and rc_user <> 0 group by up_value order by 2 desc ;

Event Timeline

Bawolff created this paste.Mar 28 2019, 6:56 PM

Percent recent changes using timelessActivePublicActions

Event Timeline

Percent recent changes using timeless
ActivePublic
Actions