Translations: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
<pre>SELECT
The result set from this query should be at least 1269
<pre>
SELECT
translation.keyvalue,
translation.keyvalue,
translation.translation
translation.translation
Line 10: Line 12:
translation.translation ASC
translation.translation ASC
</pre>
</pre>
Note: This query is in 5.x format
[[Category:NoPublic]]
[[Category:NoPublic]]
[[Category:SQL Queries]]

Revision as of 16:06, 12 February 2014

The result set from this query should be at least 1269

SELECT
translation.keyvalue,
translation.translation
FROM
translation
WHERE
translation.language =  'en'
ORDER BY
translation.keyvalue ASC,
translation.translation ASC

Note: This query is in 5.x format