USE svwiki_p;
SELECT REPLACE(CONCAT('[[',pl_title,']]'),'_',' ') AS Artikel... |
5 years ago |
USE svwiki_p;
SELECT REPLACE(CONCAT('[[',pl_title,']]'),'_',' ') AS Artikel... |
5 years ago |
USE svwiki_p;
SELECT REPLACE(CONCAT('[[',pl_title,']]'),'_',' ') AS Artikel... |
5 years ago |
USE svwiki_p;
SELECT CONCAT('[[',pl_title,']]') AS Artikel FROM pagelinks... |
5 years ago |
USE svwiki_p;
SELECT CONCAT('[[',pl_title,']]') FROM pagelinks WHERE... |
5 years ago |
USE svwiki_p;
SELECT pl_title FROM pagelinks WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT pl_title FROM pagelinks WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT pl_title FROM pagelinks WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT pl_title FROM pagelinks (WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT pl_title FROM pagelinks WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks WHERE
pl_from = 3900774... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks JOIN page ON pl_title=page_title WHERE... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks OUTER JOIN page ON pl_title=page_title... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks FULL OUTER JOIN page ON... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks LEFT JOIN page ON pl_title=page_title... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks INNER JOIN page ON pl_title=page_title... |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks WHERE
pl_from = 3900774 AND
pl_namespace = 0 |
5 years ago |
USE svwiki_p;
SELECT * FROM pagelinks WHERE
pl_from = 3900774 |
5 years ago |
USE svwiki_p;
SELECT * FROM page WHERE
page_id = 3900774 |
5 years ago |
USE svwiki_p;
SELECT * FROM page WHERE
page_title LIKE '%Vem_är_hon' |
5 years ago |
USE svwiki_p;
SHOW tables |
6 years ago |