query
RESULTSET
query
  ABBREVIATION ADDRESS CDR_ID CITY CONFERENCES COUNTRY C_ID DEGREES DEPARTMENT_ID EMAIL FAX FNAME IMAGE NAME OBJECTIVES POBOX POSITION PROFILE PUBLICATIONS QUERYLEVEL RESEARCH SCHOOL SCHOOL_ID SCHOOL_MENUTITLE SHOWORDER TEL URL
CACHED false
EXECUTIONTIME 66
SQL SELECT CASE WHEN NL.fname + ' '+ NL.Lname like ' ' THEN NL.fname_el + ' ' +NL.Lname_el ELSE NL.fname + ' '+ NL.Lname END AS name, ( SELECT CASE WHEN p.title like '' THEN p.title_el ELSE p.title END as school FROM page p WHERE p.id=DM.school_id ) AS school, ( SELECT CASE WHEN p.menutitle like '' THEN p.menutitle_el ELSE p.menutitle END as school_menutitle FROM page p WHERE p.id=DM.school_id ) AS school_menutitle, DM.school_id, DM.department_id, DM.c_id, DM.cdr_id, DM.showorder, NL.abbreviation as abbreviation, DM.position as position, NL.url, NL.email as email, NL.tel1 as tel, CASE WHEN len(cast(NL.fname as varchar(1))) = 0 THEN NL.fname_el ELSE NL.fname END AS fname, CASE WHEN len(cast(NL.lname as varchar(1))) = 0 THEN NL.lname_el ELSE NL.lname END as objectives, NL.image, CASE WHEN len(cast(NL.degrees as varchar(1))) = 0 THEN NL.degrees_el ELSE NL.degrees END AS degrees, CASE WHEN len(cast(NL.address as varchar(1))) = 0 THEN NL.address_el ELSE NL.address END AS address, NL.pobox, (select name from easy_country WHERE name=NL.country) AS country, NL.fax as fax, NL.city as city, CASE WHEN len(cast(NL.profile as varchar(1))) = 0 THEN NL.profile_el ELSE NL.profile END AS profile, CASE WHEN len(cast(NL.publications as varchar(1))) = 0 THEN NL.publications_el ELSE NL.publications END AS publications, CASE WHEN len(cast(NL.conferences as varchar(1))) = 0 THEN NL.conferences_el ELSE NL.conferences END AS conferences, CASE WHEN len(cast(NL.research as varchar(1))) = 0 THEN NL.research_el ELSE NL.research END AS research, 1 AS querylevel FROM easy_nl_contact NL LEFT OUTER JOIN tbl_contact_department_member DM on NL.c_id = DM.c_id WHERE active=1 AND NL.c_id <> 0 AND NL.c_id=71 ORDER BY lname ASC