Create a new Template Variable
Go to Input Options Tab
Change Input Type to:
- Listbox (Multi-Select) - for multiple resource select
- Listbox (Single-Select) - for Single resource select
In Input Option Values type: @SELECT `pagetitle` AS `name`,`id` FROM `[[+PREFIX]]site_content` WHERE `published` = 1 AND `deleted` = 0