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 = ""

SELECT config_value FROM es1_es_config WHERE config_key = "" AND namespace = ""

INSERT INTO es1_es_config (config_value,config_key,namespace) VALUES ("","","")

SELECT p.title,p.data,p.ref,p.language ,DATE_FORMAT(`date`,"%Y-%m-%d-%H-%i-%s-%w") AS `date` ,a.username AS author,a.id AS author_id FROM es1_ww_pages AS p LEFT OUTER JOIN es1_es_users AS a ON p.author = a.id WHERE p.title = "" AND p.history = "0" AND p.language = "" ORDER BY p.`date` DESC

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