Search

Quick start

Choose a section:

Choose something to look for:

Newsletter sign up

Sign up our newsletter for occasional information about new resources and other developments

Social

Database Queries

Log in to Commtap to...

Avoid seeing ads; add pages to your "favourites" so you can come back to them easily; add or edit resources. Login to Commtap

These are database queries for finding extracting information from Commtap. This is technical and only those with server access will be able to do these - they cannot be done through the website.

Getting a list of members with email addresses from a group

List of Commtap Ambassadors:

SELECT name, mail FROM users LEFT JOIN og_uid ON users.uid=og_uid.uid WHERE nid = 963;

Lists of redirects and aliases - without those that we are probably not interested in

select * from url_alias where src not like "taxonomy/term/%" and src not like "node/%" and src not like "user/%";

select * from path_redirect where source not like "%/%";