You would need to join the content table on the spaces table, based on the spaceid in both columns, something like this:
SELECT title, contentid FROM content WHERE spaceid = (SELECT spaceid FROM spaces WHERE spacekey = 'yourspacename') ORDER BY 1;
SELECT C.title, C.contentid FROM content C INNER JOIN spaces S ON C.spaceid = S.spaceid ORDER BY title;
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG