Skip to content

Instantly share code, notes, and snippets.

@Cipa

Cipa/gist:db303f3771f782c24f2c

Created July 8, 2014 13:18
Show Gist options
  • Save Cipa/db303f3771f782c24f2c to your computer and use it in GitHub Desktop.
Save Cipa/db303f3771f782c24f2c to your computer and use it in GitHub Desktop.
Download ZIP
add an empty select option to a TV
Raw
gistfile1.txt
@SELECT '-- Select --' as pagetitle , '' AS id UNION ALL SELECT `pagetitle`, `id` FROM `[+PREFIX+]site_content` WHERE `template` IN (8, 12, 16, 17) AND `deleted` = 0 and `published` = 1 ORDER BY pagetitle ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment