| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page,
... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page,
... |
2 years ago |
| DESCRIBE wb_items_per_site; |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page
FROM... |
2 years ago |
| SELECT * FROM page WHERE page_title REGEXP '_' LIMIT 1 |
2 years ago |
| SELECT * FROM page WHERE page_title REGEXP '__' LIMIT 1 |
2 years ago |
| SELECT * FROM page WHERE page_title REGEXP '__' LIMIT 1 |
2 years ago |
| SELECT * FROM page WHERE page_title REGEXP '_' LIMIT 1 |
2 years ago |
| SELECT * FROM page WHERE page_title REGEXP '__' LIMIT 1 |
2 years ago |
| SELECT * FROM page WHERE page_title REGEXP '__' LIMIT 1 |
2 years ago |
| SELECT * FROM page WHERE page_title LIKE '%__%' |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%_%' LIMIT 1 |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%\_%' LIMIT 1 |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%0%' LIMIT 1 |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%u%' LIMIT 1 |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%a%' LIMIT 1 |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%_%' LIMIT 1 |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%User:%' LIMIT 1 |
2 years ago |
| SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_page LIKE '%User:%' LIMIT 1 |
2 years ago |
| SELECT * FROM wb_items_per_site WHERE ips_site_page LIKE '%0%' LIMIT 1 |
2 years ago |
| SELECT ips_site_page FROM wb_items_per_site WHERE ips_site_page LIKE '%0%' LIMIT 1 |
2 years ago |
| SELECT ips_site_page FROM wb_items_per_site WHERE ips_site_page LIKE '%_%' LIMIT 1 |
2 years ago |
| SELECT ips_site_page FROM wb_items_per_site WHERE ips_site_page LIKE '%' LIMIT 1 |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page
FROM... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page
FROM... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page
FROM... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page
FROM... |
2 years ago |
| SELECT COUNT(page_id)
FROM page
WHERE page_namespace IN (0, 14)
AND... |
2 years ago |
| SELECT *
FROM page
WHERE page_title LIKE '%Emacs%' |
2 years ago |
| SELECT *
FROM page
WHERE page_title = 'Emacs%' |
2 years ago |
| SELECT *
FROM page
WHERE page_title = '%Emacs%' |
2 years ago |
| SELECT *
FROM page
WHERE page_title = 'Foo_Fighters' |
2 years ago |
| SELECT *
FROM page
WHERE page_title LIKE 'Foo%' |
2 years ago |
| SELECT *
FROM page
WHERE page_title LIKE 'Foo' |
2 years ago |
| SELECT *
FROM page
WHERE page_title LIKE 'Firefox' |
2 years ago |
| SELECT *
FROM page
WHERE page_title LIKE 'Firefox%' |
2 years ago |
| SELECT *
FROM page
WHERE page_title LIKE 'GNU/Linux%' |
2 years ago |
| SELECT *
FROM page
WHERE page_title LIKE 'Foo%' |
2 years ago |
| SELECT *
FROM pages
WHERE pages_title LIKE 'Foo%' |
2 years ago |
| SELECT *
FROM pages
WHERE page_title LIKE 'Foo%' |
2 years ago |
| SELECT *
FROM pages
WHERE page_title LIKE 'Foo%' |
2 years ago |
| SELECT *
FROM wb_items_per_site
WHERE ips_item_id = 2009630 |
2 years ago |
| SELECT *
FROM wb_items_per_site
WHERE ips_item_id = 513 |
2 years ago |
| SELECT ips_row_id,
CONCAT('Q', ips_item_id),
ips_site_id,
... |
2 years ago |
| SELECT ips_row_id,
CONCAT('Q', ips_item_id),
ips_site_id,
... |
2 years ago |
| SELECT ips_row_id,
CONCAT('Q', ips_item_id),
ips_site_id,
... |
2 years ago |
| SELECT ips_row_id,
CONCAT('-Q', ips_item_id),
ips_site_id,
... |
2 years ago |
| SELECT *
FROM wb_items_per_site
WHERE ips_site_id = "eswiki"
LIMIT 1 |
2 years ago |
| SELECT *
FROM wb_items_per_site
LIMIT 1 |
2 years ago |
| SELECT *
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Creator:%'
LIMIT 1 |
2 years ago |
| SELECT CONCAT('-Q', ips_item_id) AS item,
ips_site_page
FROM... |
2 years ago |
| SELECT CONCAT('-Q', ips_item_id) AS item,
'Scommonswiki',
... |
2 years ago |
| SELECT * FROM querycache LIMIT 1; |
2 years ago |
| SELECT * FROM redirect LIMIT 1; |
2 years ago |
| SELECT * FROM user_properties LIMIT 1; |
2 years ago |
| SELECT * FROM log_search LIMIT 1; |
2 years ago |
| SELECT * FROM tag_summary LIMIT 1; |
2 years ago |
| SELECT * FROM templatelinks LIMIT 1; |
2 years ago |
| SELECT * FROM pagelinks LIMIT 1; |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page AS link,
... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page AS link,
... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page AS link
FROM... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page AS link
FROM... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page AS link
FROM... |
2 years ago |
| SELECT CONCAT('Q', ips_item_id) AS item,
ips_site_page AS link
FROM... |
2 years ago |
| SELECT CONCAT('-Q', ips_item_id) AS item,
CONCAT('"',... |
2 years ago |
| SELECT CONCAT('-Q', ips_item_id) AS item, 'Scommonswiki', CONCAT('"',... |
2 years ago |
| SELECT CONCAT('-Q', ips_item_id) AS item, 'Scommonswiki', CONCAT('"',... |
2 years ago |
| DESCRIBE page_props |
2 years ago |
| SELECT * FROM pagelinks LIMIT 10 |
2 years ago |
| SELECT FROM pagelinks LIMIT 10 |
2 years ago |
| DESCRIBE pagelinks |
2 years ago |
| SELECT *
FROM pagelinks
LIMIT 10 |
2 years ago |
| SELECT *
FROM pagelinks
WHERE pl_title = 'Q18968627' |
2 years ago |
| SELECT * FROM pagelinks LIMIT 100; |
2 years ago |
| SELECT * FROM pagelinks LIMIT 1; |
2 years ago |
| SELECT * FROM pagelinks; |
2 years ago |
| DESCRIBE pagelinks; |
2 years ago |
| SHOW TABLES; |
2 years ago |
