MyWikiBiz, Author Your Legacy — Monday December 02, 2024
Jump to navigationJump to search
8 bytes added
, 14:53, 6 November 2014
mLine 6: |
Line 6: |
| | | |
| SELECT | | SELECT |
− | page_title
| + | |
| + | page_title |
| + | |
| FROM page | | FROM page |
| + | |
| JOIN categorylinks | | JOIN categorylinks |
| + | |
| ON cl_from = page_id | | ON cl_from = page_id |
| + | |
| WHERE cl_to = 'Living_people' | | WHERE cl_to = 'Living_people' |
| + | |
| AND page_is_redirect = 0 | | AND page_is_redirect = 0 |
| + | |
| AND page_namespace = 0 | | AND page_namespace = 0 |
| + | |
| AND page_random > RAND() | | AND page_random > RAND() |
| + | |
| ORDER BY page_random | | ORDER BY page_random |
| + | |
| LIMIT 500; | | LIMIT 500; |