Retour : Page Principale > sommaire applications botanique > Bibliobota

---

Requêtes SQL utiles

Requête permettant d'afficher tous les articles possédant des auteurs et écris après 1970

SELECT
B_I_AUTEURS as auteur,
B_F_DATE as date,
B_I_TITRE as titre,
B_A_PAGEDEBUT as page_debut,
B_A_PAGEFIN as page_fin,
B_S_NOM as structure_editrice,
B_C_NOMCOMPLET as collection,
B_SER_SOUSTITRE as sous_serie,
B_F_TITRE as fascicule,
B_AS_LIBELLE as auteur_saisie
FROM
biblio_collection
LEFT JOIN biblio_str ON B_C_LKSTR = B_S_IDSTR, biblio_fasc, biblio_serie, biblio_article, biblio_aut_saisie, biblio_item, biblio_item_typlog, biblio_item_typphy, biblio_domaine, biblio_domaine_lier
WHERE
( B_I_TYPLOG = 1 )
AND ( B_I_TYPPHY = 2 )
AND B_I_CACHER = 0
AND ( biblio_aut_saisie.B_AS_ID = biblio_item.B_I_AUTEURSAISIE )
AND ( biblio_item.B_I_TYPPHY = biblio_item_typphy.B_IP_ID )
AND ( biblio_item.B_I_TYPLOG = biblio_item_typlog.B_IL_ID )
AND ( biblio_domaine.B_D_ID = biblio_domaine_lier.B_DL_IDDOM )
AND ( biblio_item.B_I_IDITEM = biblio_domaine_lier.B_DL_IDITEM )
AND biblio_domaine.B_D_ID =1
AND ( biblio_collection.B_C_CRAI = biblio_serie.B_SER_CRAICOLL )
AND ( biblio_serie.B_SER_CRAICOLL = biblio_fasc.B_F_CRAICOLL )
AND ( biblio_serie.B_SER_IDSERIE = biblio_fasc.B_F_CRAISERIE )
AND ( biblio_fasc.B_F_CRAICOLL = biblio_article.B_A_CRAICOLL )
AND ( biblio_fasc.B_F_CRAISERIE = biblio_article.B_A_CRAISERIE )
AND ( biblio_fasc.B_F_NUMERO = biblio_article.B_A_CRAIFASC )
AND ( biblio_item.B_I_IDITEM = biblio_article.B_A_IDART )
AND B_F_DATE >=1970 AND B_I_AUTEURS != ''
ORDER BY B_I_AUTEURS ASC, B_F_DATE DESC

Requête permettant d'afficher tous les articles d'une collection données

Ici les article de la collection : BULLSBF

SELECT
B_I_AUTEURS AS auteur,
B_F_DATE AS date,
B_I_TITRE AS titre,
B_A_PAGEDEBUT AS page_debut,
B_A_PAGEFIN AS page_fin,
B_S_NOM AS structure_editrice,
B_C_NOMCOMPLET AS collection,
B_SER_SOUSTITRE AS sous_serie,
B_F_TITRE AS fascicule,
B_AS_LIBELLE AS auteur_saisie
FROM
biblio_collection
LEFT JOIN biblio_str ON B_C_LKSTR = B_S_IDSTR, biblio_fasc, biblio_serie, biblio_article, biblio_aut_saisie, biblio_item, biblio_item_typlog, biblio_item_typphy, biblio_domaine, biblio_domaine_lier
WHERE
( B_I_TYPLOG = 1 )
AND ( B_I_TYPPHY = 2 )
AND B_I_CACHER =0
AND ( biblio_aut_saisie.B_AS_ID = biblio_item.B_I_AUTEURSAISIE )
AND ( biblio_item.B_I_TYPPHY = biblio_item_typphy.B_IP_ID )
AND ( biblio_item.B_I_TYPLOG = biblio_item_typlog.B_IL_ID )
AND ( biblio_domaine.B_D_ID = biblio_domaine_lier.B_DL_IDDOM )
AND ( biblio_item.B_I_IDITEM = biblio_domaine_lier.B_DL_IDITEM )
AND biblio_domaine.B_D_ID =1 AND ( biblio_collection.B_C_CRAI = biblio_serie.B_SER_CRAICOLL )
AND ( biblio_serie.B_SER_CRAICOLL = biblio_fasc.B_F_CRAICOLL )
AND ( biblio_serie.B_SER_IDSERIE = biblio_fasc.B_F_CRAISERIE )
AND ( biblio_fasc.B_F_CRAICOLL = biblio_article.B_A_CRAICOLL )
AND ( biblio_fasc.B_F_CRAISERIE = biblio_article.B_A_CRAISERIE )
AND ( biblio_fasc.B_F_NUMERO = biblio_article.B_A_CRAIFASC )
AND ( biblio_item.B_I_IDITEM = biblio_article.B_A_IDART )
AND B_I_AUTEURS != ''
AND (biblio_article.B_A_CRAICOLL like "BULLSBF%")
ORDER BY B_I_AUTEURS ASC, B_F_DATE DESC

---