nuBuilder Forum

Code: Select all

SELECT TRIM(
REPLACE(
  REPLACE(
    REPLACE(sob_all_label, "<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class='nuActionButton'>", "")
    , "<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class='nuActionButton'>", "")
  , "</span>", "")
) AS Labels
FROM `zzzzsys_object` 
GROUP BY Labels
HAVING Labels NOT IN ('_________________________', '', '?');

Code: Select all

/* Translation Stats */
SELECT trl_language
     , COUNT(*) AS translated_strings
     , (SELECT COUNT(DISTINCT trl_english) FROM `zzzzsys_translate` a)-COUNT(*) AS ToTranslate 
FROM `zzzzsys_translate` GROUP BY trl_language ORDER BY translated_strings DESC;

Code: Select all

/* Missing Strings */

/* change @lang value for each language's strings yet to be translated */
SET @lang:='French';

SELECT a.trl_english
FROM `zzzzsys_translate` a LEFT JOIN 
(SELECT b.trl_english FROM zzzzsys_translate b WHERE b.trl_language = @lang) lang
USING (trl_english)
WHERE lang.trl_english IS NULL
GROUP BY a.trl_english;