Difference between revisions of "SQL"
From Organic Design wiki
(list xmlwiki admins query) |
m |
||
| Line 18: | Line 18: | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+old_id,old_user_text+FROM+old+WHERE+old_title='Nobots'+ORDER+BY+old_timestamp+LIMIT+1; Owner-Old] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+old_id,old_user_text+FROM+old+WHERE+old_title='Nobots'+ORDER+BY+old_timestamp+LIMIT+1; Owner-Old] | ||
*[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_is_new,cur_user_text+FROM+cur+WHERE+cur_title='Nobots'; Owner-Cur] | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_is_new,cur_user_text+FROM+cur+WHERE+cur_title='Nobots'; Owner-Cur] | ||
| − | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_title+FROM+cur+WHERE+cur_title+REGEXP('^Sys:'); | + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_title+FROM+cur+WHERE+cur_title+REGEXP('^Sys:'); Sys:User articles] |
| + | *[{{SERVER}}/wiki/index.php?title=SQL&xpath:/properties/SQL:query=SELECT+cur_title+FROM+cur+WHERE+cur_title+REGEXP('^Sys:')+AND+cur_text+REGEXP('admin'); xwAdmins] | ||
