SQL query to retrive Template Variables

[bobray]

It sounds complicated. Can you describe the selection process in pseudo-code?