Controlar, seleccionar y reprimir : la depuración del profesorado de instituto en España durante el franquismo

Erakunde egilea: Instituto de la Mujer (España)
Beste egile batzuk: Grana Gil, Isabel.
Formatua: Liburua
Hizkuntza: Gaztelania
Argitaratua: Madrid : Instituto de la Mujer, 2005
Saila: Estudios ; 89.
Lan-arloen araberako bilaketa: Hezkuntza
Ogasuna
Funtzio publikoa
Gaiak:
Aurkibidea
Etiketak: Erantsi etiketa bat
Etiketarik gabe, Izan zaitez lehena erregistro honi etiketa jartzen!
Azala QR Kodea
Gorde:
Aurrebista
Aurrebista
Aurrebista
  • Aurkibidea
  • SELECT DISTINCT TEXTO, CPY_ID_NBR FROM (SELECT CLEAN_STR('' || ' ' || ENUM_1ST_LVL || ' ' || ENUM_2ND_LVL || ' ' || ENUM_3RD_LVL || ' ' || ENUM_4TH_LVL || ' ' || ENUM_5TH_LVL || ' ' || ENUM_6TH_LVL || ' ('|| chrnlgy_1st_lvl || NVL2(chrnlgy_2nd_lvl ,CONCAT(' ',chrnlgy_2nd_lvl ), '')|| NVL2(chrnlgy_3rd_lvl ,CONCAT(' ',chrnlgy_3rd_lvl ), '')|| NVL2(chrnlgy_4th_lvl ,CONCAT(' ',chrnlgy_4th_lvl ), '') || ')') AS TEXTO, CPY_ID.CPY_ID_NBR AS CPY_ID_NBR FROM SRL_ENUM_AND_CHNLGY, CPY_ID WHERE SRL_ENUM_AND_CHNLGY.CPY_ID_NBR = CPY_ID.CPY_ID_NBR AND CPY_ID.loan_prd_cde <> '7' AND CPY_ID.BIB_ITM_NBR = '2258' AND SRL_ITM_STUS_CDE = 'r' AND seq_nbr_863 NOT IN (SELECT seq_nbr_866 FROM SRL_TXT_HLDNG_STMNT_FLDS WHERE BIB_ITM_NBR = '2258' ) ORDER BY SEQ_NBR_863 DESC) UNION SELECT * FROM (SELECT CLEAN_STR('' || ' ' || ENUM_1ST_LVL || ' ' || ENUM_2ND_LVL || ' ' || ENUM_3RD_LVL || ' ' || ENUM_4TH_LVL || ' ' || ENUM_5TH_LVL || ' ' || ENUM_6TH_LVL || ' ('|| chrnlgy_1st_lvl || NVL2(chrnlgy_2nd_lvl ,CONCAT(' ',chrnlgy_2nd_lvl ), '')|| NVL2(chrnlgy_3rd_lvl ,CONCAT(' ',chrnlgy_3rd_lvl ), '')|| NVL2(chrnlgy_4th_lvl ,CONCAT(' ',chrnlgy_4th_lvl ), '') || ')') AS TEXTO, CPY_ID_NBR AS CPY_ID_NBR FROM SRL_ENUM_AND_CHNLGY WHERE BIB_ITM_NBR = '2258' AND SRL_ITM_STUS_CDE = 'r' AND NO_EXPCTD = '0' AND seq_nbr_863 NOT IN (SELECT seq_nbr_866 FROM SRL_TXT_HLDNG_STMNT_FLDS WHERE BIB_ITM_NBR = '2258' ) ORDER BY SEQ_NBR_863 DESC) UNION SELECT * FROM (SELECT CLEAN_STR(ENUM_1ST_LVL || ' ' || ENUM_2ND_LVL || ' ' || ENUM_3RD_LVL || ' ' || ENUM_4TH_LVL || ' ' || ENUM_5TH_LVL || ' ' || ENUM_6TH_LVL || ' ('|| chrnlgy_1st_lvl || NVL2(chrnlgy_2nd_lvl ,CONCAT(' ',chrnlgy_2nd_lvl ), '')|| NVL2(chrnlgy_3rd_lvl ,CONCAT(' ',chrnlgy_3rd_lvl ), '')|| NVL2(chrnlgy_4th_lvl ,CONCAT(' ',chrnlgy_4th_lvl ), '') || ')') AS TEXTO, CPY_ID_NBR AS CPY_ID_NBR FROM SRL_ENUM_AND_CHNLGY WHERE BIB_ITM_NBR = '2258' AND SRL_ITM_STUS_CDE = 'r' AND NO_EXPCTD = '1' AND seq_nbr_863 NOT IN (SELECT seq_nbr_866 FROM SRL_TXT_HLDNG_STMNT_FLDS WHERE BIB_ITM_NBR = '2258' ) ORDER BY SEQ_NBR_863 DESC) WHERE ROWNUM <= 4

    Funtsak

    Gasteiz-beheko solairuko bilera-gela

    4978 353.51(460) CON con
    Eskuragarri