Confirmed users
884
edits
Paulbooker (talk | contribs) No edit summary |
Paulbooker (talk | contribs) |
||
Line 94: | Line 94: | ||
*The following views need to be rebuilt in views 2 | *The following views need to be rebuilt in views 2 | ||
**front_Userproject_1 / front_Userproject_2 | **front_Userproject_1 / front_Userproject_2 (no og_description ) | ||
*** SELECT node.nid AS nid, node.created AS node_created, og.og_description AS og_og_description FROM node node LEFT JOIN og og ON node.nid = og.nid WHERE node.status = 0 | *** SELECT node.nid AS nid, node.created AS node_created, og.og_description AS og_og_description FROM node node LEFT JOIN og og ON node.nid = og.nid WHERE node.status = 0 | ||
**front_Userproject_imageblock | **front_Userproject_imageblock (no og_description ) | ||
***SELECT node.nid AS nid, node.created AS node_created, og.og_description AS og_og_description FROM node node LEFT JOIN og og ON node.nid = og.nid WHERE node.status = 0 ORDER BY node_created ASC | ***SELECT node.nid AS nid, node.created AS node_created, og.og_description AS og_og_description FROM node node LEFT JOIN og og ON node.nid = og.nid WHERE node.status = 0 ORDER BY node_created ASC |