a

select s.spacekey, s.spacename, c.title
FROM CONTENT c, SPACES s
where c.contenttype = 'PAGE' and c.prevver is null and c.content_status = 'current'
and c.spaceid = s.spaceid
order by c.spaceid, c.title select u.lower_user_name,u.active,d.id,d.directory_name from cwd_user u
join cwd_directory d
on u.directory_id=d.id
order by u.lower_user_name https://ektron0116.neocities.org/software/ad.zip