SELECT * from watchlist_expiry wl
left join user u
on wl.user =... |
3 years ago |
SELECT * from watchlist wl
left join user u
on wl.user = u.user_id
where... |
3 years ago |
use hewiki_p;
SELECT * from watchlist wl
left join user u
on wl.user =... |
3 years ago |
use hewiki_p;
SELECT * from logging lg
left join actor ac
on lg.log_actor =... |
3 years ago |
use hewiki_p;
SELECT * from logging lg
left join actor ac
on lg.log_actor =... |
3 years ago |
use hewiki_p;
SELECT * from logging lg
left join actor ac
on lg.log_actor =... |
3 years ago |
use hewiki_p;
SELECT * from logging lg limit 10
left join actor ac
on... |
3 years ago |
use hewiki_p;
SELECT * from logging lg limit 10
left join actor ac
on... |
3 years ago |
use hewiki_p;
SELECT * from logging lg limit 10
right join actor ac
on... |
3 years ago |
use hewiki_p;
SELECT * from logging lg limit 10
right outer join actor... |
3 years ago |
use hewiki_p;
SELECT * from logging limit 10 |
3 years ago |
use hewiki_p;
SELECT * from site_stats limit 10 |
3 years ago |
use hewiki_p;
DESCRIBE site_stats; |
3 years ago |
use hewiki_p;
SELECT * from categorylinks limit 10 |
3 years ago |
use hewiki_p;
SELECT * from categorylinks |
3 years ago |
use hewiki_p;
SELECT * from category where cat_title like '%אלבומים%' order... |
3 years ago |
use hewiki_p;
SELECT * from category order by cat_pages desc limit 10 |
3 years ago |
SELECT * from category order by cat_pages desc limit 10 |
3 years ago |
SELECT * from category order by cat_pages limit 10 |
3 years ago |
SELECT * from category limit 10 order by cat_pages |
3 years ago |
SELECT * from category where cat_title like "%Azealia%" limit 10 |
3 years ago |
SELECT * from category where cat_title="Azealia_Banks" limit 10 |
3 years ago |
SELECT * from category where cat_title=Azealia_Banks limit 10 |
3 years ago |
SELECT * from category limit 10 |
3 years ago |
SELECT TOP 10 * from category |
3 years ago |