OpenEstate-SQL Beispielanfragen

SELECT 
  a.id, a.name, i18n.translation
FROM 
  openestate_actions a, openestate_translations i18n
WHERE 
  a.id=i18n.action_id AND a.active=1 AND i18n.LANGUAGE='de'
ORDER BY
  i18n.translation ASC;

SELECT 
  t.id, t.name, i18n.translation
FROM 
  openestate_types t, openestate_translations i18n
WHERE 
  t.id=i18n.type_id AND t.active=1 AND i18n.LANGUAGE='de'
ORDER BY
  i18n.translation ASC;

SELECT 
  t.id, t.name, i18n.translation
FROM 
  openestate_types t, openestate_translations i18n
WHERE 
  t.id=i18n.type_id AND t.active=1 AND t.parent_id IS NULL AND i18n.LANGUAGE='de'
ORDER BY
  i18n.translation ASC;

SELECT 
  t.id, t.name, i18n.translation
FROM 
  openestate_types t, openestate_translations i18n
WHERE 
  t.id=i18n.type_id AND t.active=1 AND t.parent_id=1 AND i18n.LANGUAGE='de'
ORDER BY
  i18n.translation ASC;

SELECT 
  g.id, g.name, i18n.translation
FROM 
  openestate_groups g, openestate_translations i18n
WHERE 
  g.id=i18n.group_id AND g.active=1 AND i18n.LANGUAGE='de'
ORDER BY
  g.ordering ASC;

SELECT 
  a.id, a.name, i18n.translation
FROM 
  openestate_attribs a, openestate_translations i18n
WHERE 
  a.id=i18n.attrib_id AND a.active=1 AND a.group_id=1 AND i18n.LANGUAGE='de'
ORDER BY
  a.ordering ASC;