SELECT m.title,m.url,m.perm_view,m.witness ,t.text AS translation FROM es1_es_menus AS m LEFT OUTER JOIN es1_es_translations AS t ON t.type = "es_menu" AND t.ref = m.id AND t.language = "en-US" WHERE m.directory = "main" ORDER BY m.position,m.title

SELECT a.title,a.text,a.`type`,a.perm_view FROM es1_es_announcements AS a ORDER BY a.`type`

SELECT code,name FROM es1_es_languages

SELECT config_key,config_value FROM es1_es_config WHERE namespace = "bg"

SELECT name,color,id FROM es1_es_templates ORDER BY name ASC, color ASC

SELECT u.username,u.id FROM es1_es_sessions AS s LEFT OUTER JOIN es1_es_users AS u ON s.user = u.id WHERE namespace = "es" AND `date` > (NOW()-300) ORDER BY u.username ASC

SELECT name,link,namespace FROM es1_es_search_engines ORDER BY namespace ASC, name ASC

SELECT `codename`,`release` FROM es1_es_packages WHERE `state` = 1 ORDER BY codename ASC