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
Oh, thank you! I have also been frustrated with this, but haven't tried since switching from Gin theme.
Problem with Field image • Select existing file
I've found. The problem come with GIN THEME. I test with BASIS, and i can load multiples existing files. To be continued
Problem with Field image • Select existing file
The issue appears to occur when there is an unlimited number of images, or more than one image. That's weird. I'm doing exactly that and never had any problem with images not...
Problem with Field image • Select existing file