Untitled diff
创建于 差异永不过期
SELECT node.created AS node_created, node.nid AS nid, 'homepage:page_1' AS view_name
SELECT node.created AS node_created, node.nid AS nid, 'homepage:page_1' AS view_name
FROM
FROM
{node} node
{node} node
INNER JOIN {flagging} flagging_node ON node.nid = flagging_node.entity_id AND flagging_node.fid = '1'
INNER JOIN {flagging} flagging_node ON node.nid = flagging_node.entity_id AND flagging_node.fid = '1'
LEFT JOIN (SELECT nt0.nid AS nid, nt0.tnid AS tnid, nt0.status AS status, nt0.language AS language
LEFT JOIN (SELECT nt0.nid AS nid, nt0.tnid AS tnid, nt0.status AS status, nt0.language AS language
FROM
FROM
{node} nt0
{node} nt0
WHERE (nt0.language = 'en') ) nt0 ON node.tnid = nt0.tnid AND (node.tnid != 0)
WHERE (nt0.language = 'en') ) nt0 ON node.tnid = nt0.tnid
WHERE (( (node.status = '1') AND (node.type IN ('event', 'news')) AND( (node.tnid = '0') OR( (node.language = 'en') )OR( (node.nid = node.tnid) AND (nt0.nid IS NULL) ))))
WHERE (( (node.status = '1') AND (node.type IN ('event', 'news')) AND( (node.tnid = '0') OR( (node.language = 'en') )OR( (node.nid = node.tnid) AND (nt0.nid IS NULL) ))))
ORDER BY node_created DESC
ORDER BY node_created DESC
LIMIT 12 OFFSET 0
LIMIT 12 OFFSET 0