When looking at the results of a views query, I see something like this:
SELECT node.nid AS nid, node.title AS node_title, node.type AS node_type, users_node.name AS users_node_name, users_node.uid AS users_node_uid, node.status AS node_status, node.changed AS node_changed
FROM
{node} node
LEFT JOIN {users} users_node ON node.uid = users_node.uid
WHERE (( (node.status = 1 OR (node.uid = 1 AND 1 <> 0 AND 1 = 1) OR 1 = 1 OR 1 = 1 OR (node.type = 'book' AND 1 = 1) OR (node.type = 'core' AND 1 = 1) OR (node.type = 'core_release' AND 1 = 1) OR (node.type = 'docs' AND 1 = 1) OR (node.type = 'page' AND 1 = 1) OR (node.type = 'post' AND 1 = 1) OR (node.type = 'project_layout' AND 1 = 1) OR (node.type = 'project_module' AND 1 = 1) OR (node.type = 'project_release' AND 1 = 1) OR (node.type = 'project_theme' AND 1 = 1) OR (node.type = 'quote' AND 1 = 1) OR (node.type = 'sa' AND 1 = 1) OR (node.type = 'supporter' AND 1 = 1)) ))
ORDER BY node_changed DESC
LIMIT 50 OFFSET 0
But it would be much easier to read with line breaks and indentation, like this
SELECT
node.nid AS nid,
node.title AS node_title,
node.type AS node_type,
users_node.name AS users_node_name,
users_node.uid AS users_node_uid,
node.status AS node_status,
node.changed AS node_changed
FROM
{node} node
LEFT JOIN {users} users_node
ON node.uid = users_node.uid
WHERE (((
node.status = 1 OR
(node.uid = 1 AND 1 <> 0 AND 1 = 1) OR
1 = 1 OR
1 = 1 OR
(node.type = 'book' AND 1 = 1) OR
(node.type = 'core' AND 1 = 1) OR
(node.type = 'core_release' AND 1 = 1) OR
(node.type = 'docs' AND 1 = 1) OR
(node.type = 'page' AND 1 = 1) OR
(node.type = 'post' AND 1 = 1) OR
(node.type = 'project_layout' AND 1 = 1) OR
(node.type = 'project_module' AND 1 = 1) OR
(node.type = 'project_release' AND 1 = 1) OR
(node.type = 'project_theme' AND 1 = 1) OR
(node.type = 'quote' AND 1 = 1) OR
(node.type = 'sa' AND 1 = 1) OR
(node.type = 'supporter' AND 1 = 1)
)))
ORDER BY node_changed DESC
LIMIT 50 OFFSET 0
GitHub Issue #:
1590
Recent comments
Hi ian, so, in your case all the other admin pages work fine, including the status page, only admin/reports/updates fails? But you can access admin/reports? Weird... I...
Update Report thows "Access denied You are not authorized to access this page."
The File (Field) Paths module should be able to move existing files. I've not tested it, but the module description says: Retroactive updates - rename and/or move...
Moving from /files into subdirectories
Yes indeed. We are exploring a few other more costly options, but as we are a low-resource start-up, we could save a lot of money by integrating Backdrop, CiviCRM and Ubercart for our membership...
UberPOS for Backdrop?