SELECT lcm.en AS module, lcsm.en AS submodule, lcsp.en AS subpage
FROM pages AS p
LEFT JOIN lang_content AS lcm ON ( lcm.short_name = p.module )
LEFT JOIN lang_content AS lcsm ON ( lcsm.short_name = p.submodule )
LEFT JOIN lang_content AS lcsp ON ( lcsp.short_name = p.subpage )

SET n = (SELECT COUNT(*) FROM language)
SET arraylang = (SELECT code FROM language)

BEGIN
 REPEAT WHERE lcm.arraylang = 'Cuenta'; n = n - 1;
 UNTIL n = 0 END REPEAT;
END