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
I'd like to learn more about options to handle payments in Backdrop: Ubercart and Commerce vs. standalone solutions and integrations with modules like Webform or Registration...
Backdrop Live November 2025
The accepted answer refers to Drupal and has weird formatting (missing capitalization at the beginning of paragraphs). Seems to me it was either copied from a Drupal post, or AI generated...
Ckeditor 5 click to activate
For the Dev meeting: I would like to discuss whether we should have a policy in the Forum that AI provided solutions should be attributed to AI and which model it is from. We have started...
October 16th 2025 Weekly Meetings