..  include:: /Includes.rst.txt
..  _guide-function-select:

======
select
======

The :ref:`select <select>` function generates a SQL SELECT query, which
is used to read records from the database. `select` automatically checks
whether the records might be "hidden", "deleted", or if they have a "start and
end date". If `pidInList` is used (meaning a list of pages is rendered),
the function also checks if the current user is allowed to see all records.

With the help of the select function, it is possible to show the content of a
page on all pages. For example:

..  literalinclude:: _temp.leftContent.typoscript