_getContentsQuery() function - Documentation for SproutCMS

function _getContentsQuery()

Returns the SQL query for use by the contents list.

The query MUST NOT include a LIMIT clause.
The query MUST include a SQL_CALC_FOUND_ROWS clause.
The main table SHOULD be aliased to 'item'.

File: /sprout/Controllers/Admin/ManagedAdminController.php, line 911
Namespace: Sprout\Controllers\Admin
Class: ManagedAdminController

Usage

string $ManagedAdminController->_getContentsQuery ( string $where , string $order , array &$params );

Arguments

string $where

A where clause to use.
        Generated based on the specified refine options.

string $order
```
An order clause to use.
```

array $params (by reference)

Params to bind to the query. These will be modified to include per-record permissions

Return value

string
```
A SQL query.
```