| SELECT CONCAT('MediaWiki:',page.page_title) as gadget
FROM page
WHERE... |
10 months ago |
| SELECT CONCAT('MediaWiki:',page.page_title) as gadget
FROM page
WHERE... |
10 months ago |
| SELECT CONCAT('MediaWiki:',page.page_title) as gadget
FROM page
WHERE... |
10 months ago |
| SELECT CONCAT('MediaWiki:',page.page_title) as gadget
FROM page
WHERE... |
10 months ago |
| SELECT CONCAT('MediaWiki:Gadget-',page.page_title) as gadget
FROM page
WHERE... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT page.page_title
FROM page
WHERE page.page_namespace = 8
AND... |
10 months ago |
| SELECT *, CONCAT('MediaWiki:', REPLACE(up_property, 'gadget-', ''), '.js')... |
10 months ago |
| SELECT CONCAT('MediaWiki:', REPLACE(up_property, 'gadget-', ''), '.js') AS... |
10 months ago |
| SELECT CONCAT('MediaWiki:', REPLACE(up_property, 'gadget-', ''), '.js') AS... |
10 months ago |
| SELECT REPLACE(up_property, 'gadget-', '') AS gadget_name, COUNT(*) AS... |
10 months ago |
| SELECT REPLACE(up_property, 'gadget-', '') AS gadget_name, COUNT(*) AS... |
10 months ago |
| SELECT REPLACE(up_property, 'gadget-', '') as gadget_name, COUNT(*) AS... |
10 months ago |
| select * from user_properties_anon limit 10; |
10 months ago |
| describe user_properties_anon; |
10 months ago |
| SELECT
REPLACE(up_property, 'gadget-', '') AS gadget_name,
... |
10 months ago |
| SELECT
REPLACE(up_property, 'gadget-', '') AS gadget_name,
... |
10 months ago |
| SELECT
REPLACE(up_property, 'gadget-', '') AS gadget_name,
... |
10 months ago |
| SELECT
REPLACE(up_property, 'gadget-', '') AS gadget_name,
... |
10 months ago |
| SELECT REPLACE(up_property, 'gadget-', '') as gadget_name, COUNT(*) AS... |
10 months ago |
| SELECT replace('gadget-', '', up_property) as gadget_name, COUNT(*) AS... |
10 months ago |
| SELECT up_property as gadget_name, COUNT(*) AS active_users
FROM... |
10 months ago |
| SELECT up_property as gadget_name, COUNT(*) AS active_users
FROM... |
10 months ago |
| SELECT up_property as gadget, COUNT(*) AS users
FROM... |
10 months ago |
| SELECT up_property, COUNT(*) AS users
FROM user_properties_anon
WHERE... |
10 months ago |
| SELECT up_property, COUNT(*) as users
FROM user_properties_anon
WHERE... |
10 months ago |
| SELECT up_property, COUNT(*) as users
FROM user_properties_anon
WHERE... |
10 months ago |
| SELECT up_property, COUNT(*) as users
FROM user_properties_anon
WHERE... |
10 months ago |
| SELECT up_property, COUNT(*) as users
FROM user_properties_anon
WHERE... |
10 months ago |
| SELECT up_property, COUNT(*)
FROM user_properties_anon
WHERE up_property... |
10 months ago |
| SELECT up_property, COUNT(*)
FROM user_properties_anon
WHERE up_property... |
10 months ago |
| SELECT up_property FROM user_properties
WHERE up_property like "gadget%"; |
10 months ago |
| SELECT up_property, COUNT(*) FROM user_properties
WHERE up_property like... |
10 months ago |
| SELECT up_property, COUNT(*) FROM user_properties
WHERE up_property like... |
10 months ago |
| SELECT up_property, COUNT(*) FROM user_properties
WHERE up_property like... |
10 months ago |
| SELECT up_property, COUNT(*) FROM user_properties
WHERE up_property like... |
10 months ago |
| SELECT up_property, COUNT(*) FROM user_properties
WHERE up_property like... |
10 months ago |
| select * from user_properties where up_property like '%gadget%' limit 100; |
10 months ago |
| select * from user_properties where up_property like '%gadget%' limit 100; |
10 months ago |
| select * from user_properties where up_property = 'fancysig' limit 100; |
10 months ago |
| select * from user_properties where up_property = 'fancysig'; |
10 months ago |
| select * from user_properties where up_property = 'fancsyig'; |
10 months ago |
| select distinct up_property from user_properties; |
10 months ago |
| select * from user_properties where up_property = 'fancyig'; |
10 months ago |
| select distinct up_property from user_properties; |
10 months ago |
| describe user_properties; |
10 months ago |
| describe user_properties; |
10 months ago |
| select distinct user_property from user_properties; |
10 months ago |
| describe user_properties; |
10 months ago |
| SELECT * from user_properties
WHERE user_properties.up_value = 1
LIMIT 5; |
10 months ago |
| SELECT * from user_properties
WHERE user_properties.up_value = 1
LIMIT 5; |
10 months ago |
| SELECT * from user
WHERE user_properties.up_value = 1
LIMIT 5; |
10 months ago |
| SELECT page.page_title, COUNT(user_properties.up_value) AS active_users
FROM... |
10 months ago |
| SELECT page.page_title, COUNT(user_properties.up_value) AS active_users
FROM... |
10 months ago |
| SELECT page_title, COUNT(tl_from) AS transclusions
FROM page
LEFT JOIN... |
10 months ago |
| SELECT page_title, COUNT(tl_from) AS transclusions
FROM page
LEFT JOIN... |
10 months ago |
| SELECT page_title, COUNT(tl_from) AS transclusions
FROM page
LEFT JOIN... |
10 months ago |
| SELECT page_title, COUNT(tl_from) AS transclusions
FROM page
LEFT JOIN... |
10 months ago |
| select page_title, count(tl_from) as transclusions
from page left join... |
10 months ago |
| select page_title, count(tl_from) as transclusions
from page left join... |
10 months ago |
| select page_title, count(templatelinks) as transclusions
from page left... |
10 months ago |
| select page_title, count(templatelinks) as transclusions from page,
left... |
10 months ago |
| select page_title, count(templatelinks) as transclusions from page
left join... |
10 months ago |
| select page_title, count(templatelinks) as transclusions from page
left join... |
10 months ago |
| select page_title count(templatelinks) as transclusions from page
left join... |
10 months ago |
| select page_title count(templatelinks) as transclusions from page,
left join... |
10 months ago |
| select page_title count(templatelinks) as transclusions from page,
left join... |
10 months ago |
| select page_title count(templatelinks) as transclusions from page,
left join... |
10 months ago |
| select page_title from page, count(templatelinks) as transclusions
left join... |
10 months ago |
| select count(*) from page where page_content_model in ('javascript') and... |
10 months ago |
| select count(*) from page where page_content_model in ('javascript') and... |
10 months ago |
| select count(*) from page where page_content_model in ('javascript') and... |
10 months ago |
| select page_namespace, page_title from page
# search for pages in MediaWiki... |
10 months ago |
| select page_namespace, page_title from page
# filter javascript gadgets, css... |
10 months ago |
| select page_namespace, page_title from page
# filter javascript gadgets, css... |
10 months ago |
| select page_namespace, page_title from page
# filter javascript gadgets, css... |
10 months ago |
| select page_namespace, page_title from page
# filter javascript gadgets, css... |
10 months ago |
| select page_namespace, page_title from page
# filter javascript gadgets, css... |
10 months ago |
| select page_namespace, page_title from page
# filter javascript gadgets, css... |
10 months ago |
| select page_namespace asc, page_title from page
# filter javascript gadgets,... |
10 months ago |
| select select page_namespace asc, page_title from page
# filter javascript... |
10 months ago |
| select select page_namespace asc, page_title
from page
# filter javascript... |
10 months ago |
