diff options
| author | priyankabhagwat | 2017-05-25 14:42:16 +0530 |
|---|---|---|
| committer | priyankabhagwat | 2017-05-25 14:42:16 +0530 |
| commit | da82fd0f518d0d15c3cd88324b29a8cea5c5b366 (patch) | |
| tree | 7278dbfe8645294b488adbd707de1c7e21efd469 | |
| parent | 4c07eca4a8a4a012dfe4806d0514dfc7d61b1fcb (diff) | |
| download | website-docs-da82fd0f518d0d15c3cd88324b29a8cea5c5b366.tar.gz website-docs-da82fd0f518d0d15c3cd88324b29a8cea5c5b366.tar.bz2 website-docs-da82fd0f518d0d15c3cd88324b29a8cea5c5b366.zip | |
Minor changes
| -rw-r--r-- | FOSSEE/FOSSEE-dynamic-website.rst | 16 |
1 files changed, 7 insertions, 9 deletions
diff --git a/FOSSEE/FOSSEE-dynamic-website.rst b/FOSSEE/FOSSEE-dynamic-website.rst index d0d53e4..56913b1 100644 --- a/FOSSEE/FOSSEE-dynamic-website.rst +++ b/FOSSEE/FOSSEE-dynamic-website.rst @@ -343,15 +343,15 @@ Activities **BLOCK- Events** -+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ - SELECT node.title AS node\_title, node.nid AS nid, node.created AS node\_created FROM - {node} node +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 -+====================================================================================================================================================================================================================+ -+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +LIMIT 5 OFFSET 0 + |image25| @@ -373,14 +373,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 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 -+=============================================================================================================================================================================================================================================================================+ -+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ + |image27| |