Memoria

Erakunde egilea: Asociación de Padres de Niños con Cáncer de Bizkaia.
Formatua: Aldizkako argitalpena
Hizkuntza: Gaztelania
Argitaratua: [Bilbao] : Asociación de Padres de Niños con Cáncer de Bizkaia = Bizkaiko Haur Minbizidunen Gurasoen Elkartea
Lan-arloen araberako bilaketa: Gaixo kronikoak
Haurrak eta nerabeak
Gaiak:
Etiketak: Erantsi etiketa bat
Etiketarik gabe, Izan zaitez lehena erregistro honi etiketa jartzen!
Azala QR Kodea
Gorde:

Kokapena

  • Gasteiz-Gordailua
  • Katalogo zenbakia 616-006.6-053.5(047) ASO mem

Barne hartzen ditu

  • n. 2003 (2004) - n. 2004 (2005) ; n. 2009 (2010) - n. 2011 (2012)
SELECT DISTINCT TEXTO, CPY_ID_NBR FROM (SELECT SEQ_NBR_863, CLEAN_STR('n.' || ' ' || 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 = '834' 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 = '834' ) ORDER BY SEQ_NBR_863 DESC) UNION SELECT * FROM (SELECT SEQ_NBR_863, CLEAN_STR('n.' || ' ' || 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 = '834' 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 = '834' ) ORDER BY SEQ_NBR_863 DESC) UNION SELECT * FROM (SELECT SEQ_NBR_863, 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 = '834' 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 = '834' ) ORDER BY SEQ_NBR_863 DESC) WHERE ROWNUM <= 4