diff options
| author | priyankabhagwat | 2017-05-26 10:50:37 +0530 |
|---|---|---|
| committer | priyankabhagwat | 2017-05-26 10:50:37 +0530 |
| commit | 90f9ce93eddc567d8d03bd5dd47ffc68d455a98a (patch) | |
| tree | 6ae8221b2bb84c9f8ab544b2f7e118e7ddd47617 | |
| parent | da82fd0f518d0d15c3cd88324b29a8cea5c5b366 (diff) | |
| download | website-docs-90f9ce93eddc567d8d03bd5dd47ffc68d455a98a.tar.gz website-docs-90f9ce93eddc567d8d03bd5dd47ffc68d455a98a.tar.bz2 website-docs-90f9ce93eddc567d8d03bd5dd47ffc68d455a98a.zip | |
Changed querries
| -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| |