diff options
| -rw-r--r-- | FOSSEE/FOSSEE-dynamic-website.rst | 29 |
1 files changed, 14 insertions, 15 deletions
diff --git a/FOSSEE/FOSSEE-dynamic-website.rst b/FOSSEE/FOSSEE-dynamic-website.rst index 56913b1..a7d77fc 100644 --- a/FOSSEE/FOSSEE-dynamic-website.rst +++ b/FOSSEE/FOSSEE-dynamic-website.rst @@ -231,7 +231,7 @@ Activities **Generic Content** -**BLOCK - Footer-data Files ** +**BLOCK - Footer-data Files** **Query** @@ -252,7 +252,7 @@ Activities |image16| -**BLOCK- Sponsor Section ** +**BLOCK- Sponsor Section** **Query** @@ -343,15 +343,13 @@ Activities **BLOCK- Events** -SELECT node.title As node_\title, node.nid AS nid, node.created As node_\created -FROM -{node} node - -INNER JOIN {field\_data\_field\_tags} field\_data\_field\_tags ON node.nid = field\_data\_field\_tags.entity\_id AND (field\_data\_field\_tags.entity\_type = 'node' AND field\_data\_field\_tags.deleted = '0') | - WHERE (( (node.status = '1') AND (node.type IN ('article')) AND (field\_data\_field\_tags.field\_tags\_tid = '3') )) -ORDER BY node\_created DESC -LIMIT 5 OFFSET 0 - + SELECT node.title As node_\title, node.nid AS nid, node.created As node_\created + FROM + {node} node + INNER JOIN {field\_data\_field\_tags} field\_data\_field\_tags ON node.nid = field\_data\_field\_tags.entity\_id AND (field\_data\_field\_tags.entity\_type = 'node' AND field\_data\_field\_tags.deleted = '0') | + WHERE (( (node.status = '1') AND (node.type IN ('article')) AND (field\_data\_field\_tags.field\_tags\_tid = '3') )) + ORDER BY node\_created DESC + LIMIT 5 OFFSET 0 |image25| @@ -373,11 +371,12 @@ Team Members Query - SELECT node.nid AS nid, node.created AS node\_created, 'node' AS field\_data\_field\_team\_members\_name\_node\_entity\_type, 'node' AS field\_data\_field\_member\_designation\_node\_entity\_type, 'node' AS field\_data\_field\_projects\_node\_entity\_type -FROM {node} node + SELECT node.nid AS nid, node.created AS node\_created, 'node' AS field\_data\_field\_team\_members\_name\_node\_entity\_type, 'node' AS field\_data\_field\_member\_designation\_node\_entity\_type, 'node' AS field\_data\_field\_projects\_node\_entity\_type + FROM + {node}node LEFT JOIN {field\_data\_field\_employment\_type\_} field\_data\_field\_employment\_type\_\_value\_0 ON node.nid = field\_data\_field\_employment\_type\_\_value\_0.entity\_id AND field\_data\_field\_employment\_type\_\_value\_0.field\_employment\_type\_\_value = '0' - WHERE (( (node.status = '1') AND (node.type IN ('team\_members')) AND( (field\_data\_field\_employment\_type\_\_value\_0.field\_employment\_type\_\_value = '0') ))) -ORDER BY node\_created ASC + WHERE (( (node.status = '1') AND (node.type IN ('team\_members')) AND( (field\_data\_field\_employment\_type\_\_value\_0.field\_employment\_type\_\_value = '0') ))) + ORDER BY node\_created ASC |image27| |