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, I would solve this problem by installing the Term Body Class module and then editing the user profile by adding a taxonomy type field with a dictionary setting to be used as a Term Body...
Add Body Class to user page
Some tasks that I belief, deserve a bit attention in the dev meeting: PHP 8.4 support (#6777) I'd like to get it into core soon, so we have enough time to find possible side effects...
Mar 13th 2025 Weekly Meetings
AFAIK there is no option to customise the sorting of book pages:
Book child page ordering by nodeid