|SELECT tt_address.*, GROUP_CONCAT(stwl order by stwl) as stw_ma, GROUP_CONCAT(stw_firstname order by stwl) as stw_firstname, GROUP_CONCAT(stw_ma_title order by stwl SEPARATOR "|") as stw_ma_title, GROUP_CONCAT(stw_ma_uid order by stwl) as stw_ma_uid, GROUP_CONCAT((stw_ma_email) order by stwl) as stw_ma_email, GROUP_CONCAT(stwv order by stwv) as stwv_ma, GROUP_CONCAT(stwv_firstname order by stwv) as stwv_firstname, GROUP_CONCAT(stwv_ma_title order by stwv SEPARATOR "|") as stwv_ma_title, GROUP_CONCAT(stwv_ma_uid order by stwv) as stwv_ma_uid, GROUP_CONCAT((stwv_ma_email) order by stwv) as stwv_ma_email, stwl_ids, stwv_ids FROM (SELECT tt_address.*,be_users.realName as stwl,be_users.tx_stwsuprofile_first_name as stw_firstname,be_users.tx_stwsuprofile_title as stw_ma_title,be_users.uid as stw_ma_uid,be_users.email as stw_ma_email,be_users2.realName as stwv,be_users2.tx_stwsuprofile_first_name as stwv_firstname,be_users2.tx_stwsuprofile_title as stwv_ma_title,be_users2.uid as stwv_ma_uid,be_users2.email as stwv_ma_email,be_groups.tx_stwsuprofile_stwl as stwl_ids,be_groups.tx_stwsuprofile_stwv as stwv_ids FROM tt_address, tt_address_group_mm, tt_address_group, be_groups LEFT JOIN be_users on ( 1=1 AND (be_groups.tx_stwsuprofile_stwl=be_users.uid OR be_groups.tx_stwsuprofile_stwl like CONCAT("%,",be_users.uid) OR be_groups.tx_stwsuprofile_stwl like CONCAT(be_users.uid,",%") OR be_groups.tx_stwsuprofile_stwl like CONCAT("%,",be_users.uid,",%")) AND (be_users.usergroup=43 OR be_users.usergroup like CONCAT("%,",43) OR be_users.usergroup like CONCAT(43,",%") OR be_users.usergroup like CONCAT("%,",43,",%"))) LEFT JOIN be_users as be_users2 on ( 1=1 AND (be_groups.tx_stwsuprofile_stwv=be_users2.uid OR be_groups.tx_stwsuprofile_stwv like CONCAT("%,",be_users2.uid) OR be_groups.tx_stwsuprofile_stwv like CONCAT(be_users2.uid,",%") OR be_groups.tx_stwsuprofile_stwv like CONCAT("%,",be_users2.uid,",%")) AND (be_users2.usergroup=1561 OR be_users2.usergroup like CONCAT("%,",1561) OR be_users2.usergroup like CONCAT(1561,",%") OR be_users2.usergroup like CONCAT("%,",1561,",%"))) WHERE 1=1 AND tt_address.hidden = 0 AND tt_address.deleted=0 AND be_groups.hidden = 0 AND be_groups.deleted=0 AND tt_address_group.hidden = 0 AND tt_address_group.deleted=0 AND tt_address.uid=tt_address_group_mm.uid_local AND tt_address_group.uid=tt_address_group_mm.uid_foreign AND be_groups.uid = tt_address.tx_stwsuprofile_be_groups AND tt_address.uid=1042) as tt_address GROUP BY tt_address.uid ORDER BY tt_address.title||SELECT tt_address.*, GROUP_CONCAT(stwl order by stwl) as stw_ma, GROUP_CONCAT(stw_firstname order by stwl) as stw_firstname, GROUP_CONCAT(stw_ma_title order by stwl SEPARATOR "|") as stw_ma_title, GROUP_CONCAT(stw_ma_uid order by stwl) as stw_ma_uid, GROUP_CONCAT((stw_ma_email) order by stwl) as stw_ma_email, GROUP_CONCAT(stwv order by stwv) as stwv_ma, GROUP_CONCAT(stwv_firstname order by stwv) as stwv_firstname, GROUP_CONCAT(stwv_ma_title order by stwv SEPARATOR "|") as stwv_ma_title, GROUP_CONCAT(stwv_ma_uid order by stwv) as stwv_ma_uid, GROUP_CONCAT((stwv_ma_email) order by stwv) as stwv_ma_email, stwl_ids, stwv_ids FROM (SELECT tt_address.*,be_users.realName as stwl,be_users.tx_stwsuprofile_first_name as stw_firstname,be_users.tx_stwsuprofile_title as stw_ma_title,be_users.uid as stw_ma_uid,be_users.email as stw_ma_email,be_users2.realName as stwv,be_users2.tx_stwsuprofile_first_name as stwv_firstname,be_users2.tx_stwsuprofile_title as stwv_ma_title,be_users2.uid as stwv_ma_uid,be_users2.email as stwv_ma_email,be_groups.tx_stwsuprofile_stwl as stwl_ids,be_groups.tx_stwsuprofile_stwv as stwv_ids FROM tt_address, tt_address_group_mm, tt_address_group, be_groups LEFT JOIN be_users on ( 1=1 AND (be_groups.tx_stwsuprofile_stwl=be_users.uid OR be_groups.tx_stwsuprofile_stwl like CONCAT("%,",be_users.uid) OR be_groups.tx_stwsuprofile_stwl like CONCAT(be_users.uid,",%") OR be_groups.tx_stwsuprofile_stwl like CONCAT("%,",be_users.uid,",%")) AND (be_users.usergroup=43 OR be_users.usergroup like CONCAT("%,",43) OR be_users.usergroup like CONCAT(43,",%") OR be_users.usergroup like CONCAT("%,",43,",%"))) LEFT JOIN be_users as be_users2 on ( 1=1 AND (be_groups.tx_stwsuprofile_stwv=be_users2.uid OR be_groups.tx_stwsuprofile_stwv like CONCAT("%,",be_users2.uid) OR be_groups.tx_stwsuprofile_stwv like CONCAT(be_users2.uid,",%") OR be_groups.tx_stwsuprofile_stwv like CONCAT("%,",be_users2.uid,",%")) AND (be_users2.usergroup=1561 OR be_users2.usergroup like CONCAT("%,",1561) OR be_users2.usergroup like CONCAT(1561,",%") OR be_users2.usergroup like CONCAT("%,",1561,",%"))) WHERE 1=1 AND tt_address.hidden = 0 AND tt_address.deleted=0 AND be_groups.hidden = 0 AND be_groups.deleted=0 AND tt_address_group.hidden = 0 AND tt_address_group.deleted=0 AND tt_address.uid=tt_address_group_mm.uid_local AND tt_address_group.uid=tt_address_group_mm.uid_foreign AND be_groups.uid = tt_address.tx_stwsuprofile_be_groups AND tt_address.uid=1042) as tt_address GROUP BY tt_address.uid ORDER BY tt_address.title| Steinbeis Enterprises

You are here:Homepage »Transfer »Steinbeis Enterprises

Steinbeis Transfer Institute

Academy for Social Aspects and Law

Gürtelstraße 29A/30
D-10247 Berlin
Phone:	030/293309-0
Fax:	030/293309-20
E-Mail:	SU1146(keenAffallpostatkeenAffallpost)stw.de
Internet:	Homepage	http://www.akasor.de
Hohe Str. 9-13
D-04107 Leipzig
Phone:	0049(0)341-22486-61
Fax:	0049(0)341-25413-51

Management:
PD Dr. phil. habil. Gernot Barth

Dienstleistungsangebot

Mediation und Konfliktmanagement
Wissenschaftliche Begleitung und Evaluation von Projekten
Beratung
Gutachten
Vorträge und Workshops

Schwerpunktthemen

Ausbildung von Familienmediatoren
Ausbildung von Wirtschaftsmediatoren
Cross-Border-Mediation

Projektbeispiele

EU-Projekt "Civil Justice" mit italienischen Partnern, polnischen Partnern, dem CC Hannover, dem Niedersächsischen Justizministerium und dem Steinbeis-Beratungszentrum Wirtschaftsmediation, Laufzeit: 2010-2012
EU-Projekt "Cross Border Mediation" mit italienischen Partnern, polnischen Partnern, dem CC Hannover und dem Steinbeis-Beratungszentrum Wirtschaftsmediation, Laufzeit: 2009-2011
Ausbildung von Wirtschaftsmediatoren in Leipzig und Stuttgart seit 2004
Ausbildung von Familienmediatoren seit 2008

Back

Last update on 16. May, 2013 by sta(admin)

Print