| USE commonswiki_p;
SELECT * from geo_tags
where gt_page_id=62729499 |
4 years ago |
| USE commonswiki_p;
DESCRIBE geo_tags |
4 years ago |
| USE commonswiki_p;
DESCRIBE geo_tag |
4 years ago |
| USE commonswiki_p;
SHOW tables
|
4 years ago |
| USE commonswiki_p;
SELECT *
FROM geo_tags
WHERE page_id=62729499
|
4 years ago |
| USE commonswiki_p;
DESCRIBE geo_tags
|
4 years ago |
| USE commonswiki_p;
SHOW tables
|
4 years ago |
| USE commonswiki_p;
DESCRIBE tables
|
4 years ago |
| USE commonswiki_p;
SELECT *
FROM categorylinks
LEFT JOIN image
ON cl_from =... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM categorylinks
LEFT JOIN image
ON cl_from =... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM categorylinks
LEFT JOIN image
ON cl_from =... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM categorylinks
LEFT JOIN page
ON cl_from =... |
4 years ago |
| USE commonswiki_p;
SELECT *
FROM categorylinks
LEFT JOIN page
ON cl_from =... |
4 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
LEFT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
LEFT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
LEFT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
LEFT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
LEFT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
LEFT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
LEFT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
RIGHT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
RIGHT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
RIGHT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM categorylinks
RIGHT JOIN page
ON... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM page
WHERE page_title LIKE... |
6 years ago |
| USE commonswiki_p;
SELECT page_title
FROM page
WHERE page_title LIKE... |
6 years ago |
| USE commonswiki_p;
SELECT NAME
FROM sys.Tables
|
6 years ago |
| SHOW DATABASES
|
6 years ago |
| SELECT img_name
FROM image
WHERE img_height=350 |
6 years ago |
| SELECT img_name
FROM image
WHERE img_height=350 |
6 years ago |
| SELECT cat_title
FROM category
WHERE cat_subcats>10 |
6 years ago |
| SELECT cat_title
FROM category
WHERE cat_subcats>10 |
6 years ago |
| SELECT cat_title
FROM category
WHERE cat_subcats>2 |
6 years ago |
| select top 0.1 percent * from category |
6 years ago |
| select top 0.1 percent * from category |
6 years ago |
| SELECT *
FROM CATEGORY
tablesample(1 percent) |
6 years ago |
| SELECT *
FROM CATEGORY
tablesample(0.1 percent) |
6 years ago |
| SELECT *
FROM CATEGORY
tablesample(0.1percent) |
6 years ago |
